Home | About | Sematext search-lucene.com search-hadoop.com
 Search Hadoop and all its subprojects:

Switch to Threaded View
Hive, mail # user - Why "<" doesn't work?


Copy link to this message
-
Re: Why "<" doesn't work?
j.barrett Strausser 2013-09-26, 19:21
What is the result if you invert them? Meaning multiply by negative 1.
On Thu, Sep 26, 2013 at 3:01 PM, Gary Zhao <[EMAIL PROTECTED]> 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 <[EMAIL PROTECTED]>wrote:
>
>> Can you shares some examples of what does not work ?
>>
>>
>> On Thu, Sep 26, 2013 at 11:34 AM, Gary Zhao <[EMAIL PROTECTED]> 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