hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Gary Zhao <garyz...@gmail.com>
Subject Re: Why "<" doesn't work?
Date Thu, 26 Sep 2013 20:48:45 GMT
select event from firstlaunchafterdownload where ds=20130926 and eventtime
> 1380204000 and  countrycode = 'US' limit 3;

Total MapReduce CPU Time Spent: 900 msec
OK
1380153600548
1380153622387
1380153641000


On Thu, Sep 26, 2013 at 1:07 PM, Dennis Chan <denkc@denkc.com> wrote:

>  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 <garyzhao@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 <thejas@hortonworks.com>wrote:
>>
>>> Can you shares some examples of what does not work ?
>>>
>>>
>>> On Thu, Sep 26, 2013 at 11:34 AM, Gary Zhao <garyzhao@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
>
>
>

Mime
View raw message