Re: need help to write a query that does same as BETWEEN operator

2012-10-12 Thread Bejoy KS
Original Message- From: Praveenkumar Ch Date: Fri, 12 Oct 2012 12:10:19 To: Reply-To: user@hive.apache.org Subject: Fw: need help to write a query that does same as BETWEEN operator Hi I am new to hive and we have a requirement for converting terra-data queries to hive queries. So i wa

Re: Fw: need help to write a query that does same as BETWEEN operator

2012-10-12 Thread suneel hadoop
Hi Praveen, It should work the version which I'm using is 0.9.0 Thanks, Suneel On Friday, 12 October 2012, Praveenkumar Ch wrote: > Hi I am new to hive and we have a requirement for converting terra-data > queries to hive queries. So i was successful converting them.. so far. > but now i have

Re: Fw: need help to write a query that does same as BETWEEN operator

2012-10-12 Thread MiaoMiao
You familiar with SQL? I'm sure this manual will help. https://cwiki.apache.org/Hive/ On Fri, Oct 12, 2012 at 2:40 PM, Praveenkumar Ch wrote: > Hi I am new to hive and we have a requirement for converting terra-data > queries to hive queries. So i was successful converting them.. so far. > b

Fw: need help to write a query that does same as BETWEEN operator

2012-10-11 Thread Praveenkumar Ch
Hi I am new to hive and we have a requirement for converting terra-data queries to hive queries. So i was successful converting them.. so far. but now i have a teradata query that has BETWEEN operator in it, i don't know how to convert using hive equi-joins.. can someone help me?? here is