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
