Or just select * with a limit as a check that your records are indeed
all < 1390218015
On 9/26/13 12:21 PM, j.barrett Strausser 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
