Exactly. Thanks for finding it out. It helps a lot.
On Thu, Sep 26, 2013 at 1:55 PM, Dennis Chan <de...@denkc.com> wrote: > Those timestamps are in milliseconds, where your conditions are using > seconds. > > > On 9/26/13 1:50 PM, Gary Zhao wrote: > > Looks it worked. > > select eventtime from firstlaunchafterdownload where ds=20130926 and > eventtime*-1 < 1390204000*-1 and countrycode = 'US' limit 3; > > Total MapReduce CPU Time Spent: 850 msec > OK > 1380153600548 > 1380153622387 > 1380153641000 > > > On Thu, Sep 26, 2013 at 12:21 PM, j.barrett Strausser < > j.barrett.straus...@gmail.com> wrote: > >> What is the result if you invert them? Meaning multiply by negative 1. >> >> >> On Thu, Sep 26, 2013 at 3:01 PM, Gary Zhao <garyz...@gmail.com> wrote: >> >>> 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 <the...@hortonworks.com>wrote: >>> >>>> Can you shares some examples of what does not work ? >>>> >>>> >>>> On Thu, Sep 26, 2013 at 11:34 AM, Gary Zhao <garyz...@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. >>>> >>> >>> >> >> >> -- >> >> >> https://github.com/bearrito >> @deepbearrito >> > > >
