Home | About | Sematext search-lucene.com search-hadoop.com
NEW: Monitor These Apps!
elasticsearch, apache solr, apache hbase, hadoop, redis, casssandra, amazon cloudwatch, mysql, memcached, apache kafka, apache zookeeper, apache storm, ubuntu, centOS, red hat, debian, puppet labs, java, senseiDB
 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?
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
NEW: Monitor These Apps!
elasticsearch, apache solr, apache hbase, hadoop, redis, casssandra, amazon cloudwatch, mysql, memcached, apache kafka, apache zookeeper, apache storm, ubuntu, centOS, red hat, debian, puppet labs, java, senseiDB