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


Copy link to this message
-
Group by with count
abhishek 2012-12-26, 19:06
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
+
Jonathan Coveney 2012-12-27, 19:31
+
Russell Jurney 2012-12-27, 20:14
+
abhishek 2012-12-27, 20:36
+
abhishek 2012-12-27, 20:36