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 >
