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. >
