Re: does hive support non equality join?

2015-11-13 Thread Gopal Vijayaraghavan
> from cwiki, the answer is no. it seems supported after some test. The old syntax doesn't support it, but the new one does. select count(1) from table1, table2 where table1.x < table2.x; That said, that query won't run very fast unless one of the tables is tiny. Cheers, Gopal

does hive support non equality join?

2015-11-13 Thread glen
from cwiki, the answer is no. it seems supported after some test. by the way, is there any better doc for hive?