Re: Hive and joins

2012-08-08 Thread Raghunath, Ranjith
@hive.apache.org Subject: Re: Hive and joins Hi Ranjith BETWEEN a and b, you can implement as >=a , <=b . Since that is not equality you cannot use that in ON clause you need to move it to WHERE condition in your query. Regards, Bejoy KS From: "Raghunath, R

Re: Hive and joins

2012-08-08 Thread Bejoy Ks
'user@hive.apache.org'" Sent: Wednesday, August 8, 2012 8:39 AM Subject: Hive and joins Since Hive (0.7.1) only supports equi-based join how are people using it for joins employing the between clause? Thanks, Ranjith     

Hive and joins

2012-08-07 Thread Raghunath, Ranjith
Since Hive (0.7.1) only supports equi-based join how are people using it for joins employing the between clause? Thanks, Ranjith