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 <praveenkumar...@tcs.com> 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
