does hive support non equality join?

[glen <cn...@126.com>]

from cwiki, the answer is no. it seems supported after some test.
by the way, is there any better doc for hive?

Re: does hive support non equality join?

[Gopal Vijayaraghavan <go...@apache.org>]

> 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