You could do it using Pivot table in MS Excel. It's under the Insert tab, first
option on the left.
Richin
-Original Message-
From: Jain Richin (Nokia-LC/Boston)
Sent: Thursday, August 09, 2012 4:16 PM
To: user@hive.apache.org
Subject: RE: Converting rows into dynamic colums in
Subject: Re: Converting rows into dynamic colums in Hive
R is another programming language geared to statistical analysis. It has some
features that make it easy to write this sort of data manipulation.
http://www.r-project.org/
Here's a sample R function that does something similar to wha
On Wed, Aug 8, 2012 at 8:58 PM, wrote:
> John,
>
> What is R?
>
> -Original Message-
> From: ext John Meagher [mailto:john.meag...@gmail.com]
> Sent: Wednesday, August 08, 2012 4:34 PM
> To: user@hive.apache.org
> Subject: Re: Converting rows into dynamic colum
John,
What is R?
-Original Message-
From: ext John Meagher [mailto:john.meag...@gmail.com]
Sent: Wednesday, August 08, 2012 4:34 PM
To: user@hive.apache.org
Subject: Re: Converting rows into dynamic colums in Hive
I don't think having dynamic columns is possible in Hive. I'
t; To: user@hive.apache.org
> Subject: Re: Converting rows into dynamic colums in Hive
>
>
>
> you should be able to do this in hive using a group by on alpha and then
> using a combination of the max and if statement... something on the
> following lines
>
> select alpha,
@hive.apache.org
Subject: Re: Converting rows into dynamic colums in Hive
you should be able to do this in hive using a group by on alpha and then using
a combination of the max and if statement... something on the following lines
select alpha, max(abc), max(pqr), ...
(
select alpha, if (beta
you should be able to do this in hive using a group by on alpha and then
using a combination of the max and if statement... something on the
following lines
select alpha, max(abc), max(pqr), ...
(
select alpha, if (beta == 'abc', Gamma, NULL) as abc, if (beta == 'pqr',
Gamma, NUL) as pqr,
@hive.apache.org
Subject: Converting rows into dynamic colums in Hive
Hi All,
One of my Query output looks like-
AlphaBeta Gamma
123 xyz 1.0
123 abc 0.5
123
Hi All,
One of my Query output looks like-
AlphaBeta Gamma
123 xyz 1.0
123 abc 0.5
123 pqr 1.3
123
