Thanks Vijay, Yes it worked. Can you also take a look into one of my other
post subject title *TOP 10.*
*Raihan Jamal*
On Tue, Jul 10, 2012 at 1:41 PM, Vijay wrote:
> to_date(from_unixtime(cast(timestamps as int)))
>
> On Tue, Jul 10, 2012 at 1:33 PM, Raihan Jamal
> wrote:
> > I need only
to_date(from_unixtime(cast(timestamps as int)))
On Tue, Jul 10, 2012 at 1:33 PM, Raihan Jamal wrote:
> I need only the date not the hours and second, so that is the reason I was
> using to_date and from_unxitime() take int as parameter and timestamps is a
> string in this case.
>
>
>
>
> Raihan J
I need only the date not the hours and second, so that is the reason I was
using to_date and from_unxitime() take int as parameter and timestamps is a
string in this case.
*Raihan Jamal*
On Tue, Jul 10, 2012 at 1:28 PM, Vijay wrote:
> You need to use from_unixtime()
>
> On Tue, Jul 10, 201
You need to use from_unixtime()
On Tue, Jul 10, 2012 at 1:01 PM, Raihan Jamal wrote:
> Here timestamps is a string and I always get NULL in the second column when
> I try to get date out of the timestamp. Anything wrong I am doing?
>
>
> select A.timestamps, to_date(A.timestamps) from
> (select u
Here timestamps is a string and I always get NULL in the second column when
I try to get date out of the timestamp. Anything wrong I am doing?
*
*
*
*
select A.timestamps, to_date(A.timestamps) from
(select user_id, prod_and_ts.product_id as product_id,
prod_and_ts.timestamps as timestamps from tes
Yup that worked for me. I figure that out after reading the docs, INNER
JOIN means JOIN in HiveQL.
*Raihan Jamal*
On Mon, Jul 9, 2012 at 2:48 PM, Roberto Sanabria wrote:
> Did you try just using "join" instead of "inner join"?
>
>
> On Mon, Jul 9, 2012 at 11:42 AM, Raihan Jamal wrote:
>
>>
Did you try just using "join" instead of "inner join"?
On Mon, Jul 9, 2012 at 11:42 AM, Raihan Jamal wrote:
> I wrote this query but everytime I get the below error.
>
> select * from (select t2.buyer_id, t2.item_id, t2.created_time as
> created_time, subq.user_id, subq.product_id, subq.time
I wrote this query but everytime I get the below error.
select * from (select t2.buyer_id, t2.item_id, t2.created_time as
created_time, subq.user_id, subq.product_id, subq.timestamps as timestamps
from
(select user_id, prod_and_ts.product_id as product_id,
prod_and_ts.timestamps as tim