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 >> Difference between timestamp is 15 minutes


Copy link to this message
-
Re: Difference between timestamp is 15 minutes
joins are on columns , what you are trying to do is where condition

On Thu, Jul 19, 2012 at 5:25 AM, Raihan Jamal <[EMAIL PROTECTED]> wrote:

> Something like this will work in Hive?
>
> *ON ((UNIX_TIMESTAMP(testingtable1.created_time) -
> (prod_and_ts.timestamps / 1000)) / 60* 1000 <= 15 minutes)*
>
>
>
>
> *Raihan Jamal*
>
>
>
> On Wed, Jul 18, 2012 at 4:48 PM, Raihan Jamal <[EMAIL PROTECTED]>wrote:
>
>> This is the CREATED_TIME *`2012-07-17 00:00:22`* and this is the
>> Corresponding Timestamp *`1342508427000`*. Here timestamp is *5 seconds*more than the
>> *`CREATED_TIME`*. I need to see below scenario
>>
>> Currently I have a query, in which I am joining on created_time and
>> timestamp like this-
>>
>> ON (UNIX_TIMESTAMP(testingtable1.created_time) = (prod_and_ts.timestamps
>> / 1000))
>>
>>
>> So in above case, it will not match as timestamp is 5 seconds more than
>> created_time. But I need if the difference between either of the two is
>> within 15 minutes then I need to match it.
>>
>> So I need something like this-
>>
>> ON (UNIX_TIMESTAMP(testingtable1.created_time) - (prod_and_ts.timestamps
>> / 1000) = 15 minutes)
>>
>>
>>  How I can do the above case if difference between timestamps is within
>> 15 minutes then data will get matched by the above `ON clause`
>>
>>
>>
>> *Raihan Jamal*
>>
>>
>
--
Nitin Pawar
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