You are viewing a plain text version of this content. The canonical link for it is here.

Posted to user@hive.apache.org by prakash sejwani <pr...@gmail.com> on 2010/03/08 10:32:44 UTC

Relational operator in hive

Hi all,
       I have a query below
      SELECT ip,dt,month,year FROM ac_log WHERE ac_log.month == 1 AND
ac_log.year == 2010;
   when i run this query i get empty result out of it. Basically i want to
extract the data from a table whose month is 1 and year is 2010.

Can anybody help me with this query

thanks,
prakash

Re: Relational operator in hive

Posted by Sonal Goyal <so...@gmail.com>.

Shouldnt there be a single = in the query? ac_log.month = 1..?
Thanks and Regards,
Sonal

On Mon, Mar 8, 2010 at 3:02 PM, prakash sejwani <pr...@gmail.com>wrote:

> Hi all,
>        I have a query below
>       SELECT ip,dt,month,year FROM ac_log WHERE ac_log.month == 1 AND
> ac_log.year == 2010;
>    when i run this query i get empty result out of it. Basically i want to
> extract the data from a table whose month is 1 and year is 2010.
>
> Can anybody help me with this query
>
> thanks,
> prakash
>
>