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 >
