hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From suneel hadoop <suneel.bigd...@gmail.com>
Subject Re: Fw: need help to write a query that does same as BETWEEN operator
Date Fri, 12 Oct 2012 07:18:39 GMT
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
>
>

Mime
View raw message