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
<[EMAIL PROTECTED]> 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
> 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