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

Discussion Posts

Follow ups

Related Discussions

Discussion Navigation
viewthread | post
posts ‹ prev | 1 of 2 | next ›
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