>
>
>
>
>
>
> And after the Case you will have :
>
> Column A
>
> COLUMN B
>
> Temp.n
>
> 1
>
>
>
> 1
>
> 2
>
>
>
> 1
>
> 5
>
>
>
> 1
>
> 4
>
>
>
> 1
>
> 1
>
>
>
> 1
>
ala, Chandra Reddy [mailto:chandra.bog...@gs.com]
Sent: Thursday, January 09, 2014 7:17 AM
To: 'user@hive.apache.org'
Subject: RE: merge columns and count no of records
Or Is it good idea to get data into shell variable/file and doing processing.
Or using a pig script to do?
hive -e 's
, January 08, 2014 5:49 PM
To: 'user@hive.apache.org'
Subject: merge columns and count no of records
Hi,
My requirement is to merge ( not concat ) two columns and count number of
distinct records. I can use self-join on column A and column B and can count
number of records.
But looks n
Hi,
My requirement is to merge ( not concat ) two columns and count number of
distinct records. I can use self-join on column A and column B and can count
number of records.
But looks not optimal way of doing. Is there any better way to do.
Ex: Original table
Column A
COLUMN B
1
2
2
3
5
