ary 26, 2012 3:24 AM
To: user@hive.apache.org
Subject: Last value for a column
Dear all,
I am struggling with a Hive query where I am trying to get the last value for a
column.
Let say I have a table T with three columns: user_id, time, colour and I want
to know for each user_id what is its last c
the approach and code.
Sincerely, Ameet
From: "mdefoinplatel@orange.com"
To: "user@hive.apache.org"
Sent: Thursday, January 26, 2012 6:23 AM
Subject: Last value for a column
Dear all,
I am struggling with a Hive query where I
at 3:23 AM, wrote:
> Dear all,
>
> I am struggling with a Hive query where I am trying to get the last value
> for a column.
>
> ** **
>
> Let say I have a table T with three columns: user_id, time, colour and I
> want to know for each user_id what is its last colour v
Dear all,
I am struggling with a Hive query where I am trying to get the last value for a
column.
Let say I have a table T with three columns: user_id, time, colour and I want
to know for each user_id what is its last colour value.
At the moment I am using the following (naïve) query:
SELECT
