hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Gary Zhao <garyz...@gmail.com>
Subject Re: Why "<" doesn't work?
Date Thu, 26 Sep 2013 19:01:16 GMT
For example,

select COUNT(*) from firstlaunchafterdownload where ds=20130926 and
eventtime > 1380204000 *and eventtime < 1390218015 *and countrycode='US';

Total MapReduce CPU Time Spent: 3 seconds 490 msec
OK

 select COUNT(*) from firstlaunchafterdownload where ds=20130926 and
eventtime > 1380204000 and  countrycode='US';
Total MapReduce CPU Time Spent: 3 seconds 860 msec
OK
32581

eventtime  is  bigint and I'm pretty sure all records are < 1390218015.


Thanks
Gary



On Thu, Sep 26, 2013 at 11:54 AM, Thejas Nair <thejas@hortonworks.com>wrote:

> Can you shares some examples of what does not work ?
>
>
> On Thu, Sep 26, 2013 at 11:34 AM, Gary Zhao <garyzhao@gmail.com> wrote:
> > Hello
> >
> > I found something strange. I tried a few queries, in WHERE
> >
> > 1. ">" works, returns expected results
> > 2. ">" and "<" doesn't work, returns 0 result
> > 3. "<" doesn't work, return 0 result
> > 4. BETWEEN, syntax error
> >
> > Basically, I want to find records between to time stamps that are epoch
> unix
> > timestamps. Is there anything I did wrong?
> >
> > Thanks
> > Gary
> >
>
> --
> CONFIDENTIALITY NOTICE
> NOTICE: This message is intended for the use of the individual or entity to
> which it is addressed and may contain information that is confidential,
> privileged and exempt from disclosure under applicable law. If the reader
> of this message is not the intended recipient, you are hereby notified that
> any printing, copying, dissemination, distribution, disclosure or
> forwarding of this communication is strictly prohibited. If you have
> received this communication in error, please contact the sender immediately
> and delete it from your system. Thank You.
>

Mime
View raw message