Inequality join in hive

Question

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.

Answer 1

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;