Thanks for the reply. Sent from my iPhone
On Dec 27, 2012, at 3:14 PM, Russell Jurney <[email protected]> wrote: > Shortened: > > b = foreach (group a by (col1, col2, col3)) generate FLATTEN(group), > COUNT_STAR(a); > On Dec 27, 2012 11:31 AM, "Jonathan Coveney" <[email protected]> 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 <[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 >>
