hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Bejoy Ks <>
Subject Re: Hive and joins
Date Wed, 08 Aug 2012 11:55:34 GMT
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.

Bejoy KS

 From: "Raghunath, Ranjith" <>
To: "''" <> 
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?

View raw message