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 21:21:04 GMT
Exactly. Thanks for finding it out. It helps a lot.


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

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