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 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 my query:* > > *SELECT ** > *FROM account a, timezone g* > *WHERE* > *a.create_date BETWEEN g.start_date AND g.end_date ;* > > =====-----=====-----===== > Notice: The information contained in this e-mail > message and/or attachments to it may contain > confidential or privileged information. If you are > not the intended recipient, any dissemination, use, > review, distribution, printing or copying of the > information contained in this e-mail message > and/or attachments to it are strictly prohibited. If > you have received this communication in error, > please notify us by reply e-mail or telephone and > immediately and permanently delete the message > and any attachments. Thank you > >
