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 <mailto: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
<mailto: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 <mailto: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 <mailto: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
