Home | About | Sematext search-lucene.com search-hadoop.com
 Search Hadoop and all its subprojects:

Switch to Plain View
Pig, mail # user - Group by with count


+
abhishek 2012-12-26, 19:06
Copy link to this message
-
Re: Group by with count
Jonathan Coveney 2012-12-27, 19:31
a = load 'tab1' as (col1, col2, col3);
b = group a by (col1, col2, col3);
c = foreach b generate FLATTEN(group), COUNT_STAR(a);
2012/12/26 abhishek <[EMAIL PROTECTED]>

> Hi all,
>
> How can I achieve above hive query in pig
>
> Create table x as select y.col1,y.col2,y.col3,count(*) as count from tab1
> y group by y.col1,y.col2,y.col3
>
> Regards
> Abhishek
>
+
Russell Jurney 2012-12-27, 20:14
+
abhishek 2012-12-27, 20:36
+
abhishek 2012-12-27, 20:36