title: Inequality join in hive
body: <p>I know hive doesn't support inequal joins and can you please help me to get another solution for the below.</p>
  
  <p>select * from A a join B b on a.id=b.id and </p>
  
  <p>a.date &lt; b.date.</p>
  
  <p>Thanks Inadvance.</p>