hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Gopal Vijayaraghavan <gop...@apache.org>
Subject Re: does hive support non equality join?
Date Sat, 14 Nov 2015 07:12:47 GMT

> 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







Mime
View raw message