Shortened: b = foreach (group a by (col1, col2, col3)) generate FLATTEN(group), COUNT_STAR(a); On Dec 27, 2012 11:31 AM, "Jonathan Coveney" <jcove...@gmail.com> wrote:
> 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 <abhishek.dod...@gmail.com> > > > 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 > > >
