CODEWITHSUNDEEP
apachehive
Naveen
Naveen

Reputation: 115

Inequality join in hive

I know hive doesn't support inequal joins and can you please help me to get another solution for the below.

select * from A a join B b on a.id=b.id and

a.date < b.date.

Thanks Inadvance.

Upvotes: 2

Views: 3099

Answers (1)

Aditya
Aditya

Reputation: 2415

In-equal join support not yet available , but how about:

select * from A a join B b on a.id=b.id where  
a.date < b.date;

Upvotes: 1

Related Questions