Grokbase Groups Hive user March 2010
FAQ
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

Search Discussions

  • Sonal Goyal at Mar 8, 2010 at 9:55 am
    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 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

Related Discussions

Discussion Navigation
viewthread | post
Discussion Overview
groupuser @
categorieshive, hadoop
postedMar 8, '10 at 9:33a
activeMar 8, '10 at 9:55a
posts2
users2
websitehive.apache.org

2 users in discussion

Prakash sejwani: 1 post Sonal Goyal: 1 post

People

Translate

site design / logo © 2021 Grokbase