ing to crack this problem for hours.
From: matt.tuc...@disney.com
To: user@hive.apache.org
Date: Wed, 28 Mar 2012 14:46:59 -0400
Subject: RE: Help in aggregating comma separated values
Are you sure that the values in the ID column are the same? If it’s a string
datatype, do you have any spaces
sney.com>
> To: user@hive.apache.org<mailto:user@hive.apache.org>
> Date: Wed, 28 Mar 2012 14:25:43 -0400
> Subject: RE: Help in aggregating comma separated values
>
> Hi,
>
> The values column needs to be split across multiple rows, so you can then
> aggregate them. Tr
ues, ",")) values_tbl as value
> GROUP BY id, value
>
>
>
> Matt Tucker
>
> -Original Message-
> From: Saurabh S [mailto:saurab...@live.com]
> Sent: Wednesday, March 28, 2012 2:21 PM
> To: user@hive.apache.org
> Subject: Help in aggregating comma separate
Saurabh S [mailto:saurab...@live.com]
Sent: Wednesday, March 28, 2012 2:21 PM
To: user@hive.apache.org
Subject: Help in aggregating comma separated values
Hello,
How do I get count from a list of comma separated values? For the lack of
better wording, here is an example:
Suppose there is a tabl
Hello,
How do I get count from a list of comma separated values? For the lack of
better wording, here is an example:
Suppose there is a table with two columns, id (integers) and values (string) in
the following fashion.
id values
1 10,20,30
2 20,30
2 20
3 20,30,40
3 40,20,30
