Thanks Bejoy. What if those values a,b are not static and are housed in a table. Much like a type 2 dimension. Is the current solution still to put it in the where clause?
Thanks, Ranjith From: Bejoy Ks [mailto:bejoy...@yahoo.com] Sent: Wednesday, August 08, 2012 06:55 AM To: user@hive.apache.org <user@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, Ranjith" <ranjith.raghuna...@usaa.com> To: "'user@hive.apache.org'" <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
