joins are on columns , what you are trying to do is where condition
On Thu, Jul 19, 2012 at 5:25 AM, Raihan Jamal wrote:
> Something like this will work in Hive?
>
> *ON ((UNIX_TIMESTAMP(testingtable1.created_time) -
> (prod_and_ts.timestamps / 1000)) / 60* 1000 <= 15 minutes)*
>
>
>
>
> *Raihan
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 wrote:
> This is the CREATED_TIME *`2012-07-17 00:00:22`* and this is the
> Co
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_T
