Can hive sql do the same job like this?

[Neil Xu]

In oracle,

select a.str1,
          b.str2
from ( select str1 from table1) a,
     ( select str2 from  table2) b
where instr(a.str1,a.str2) > 0

I know that 'from a, b' is not supported in hive, but table1 and table2 have
no common keys, if 'join' is used, it will be a FULL OUTER JOIN,
when table1 and table2 have large number of tuples, the task will probably
fail

so, is there any better way to do the job? Thanks in advance


Neil