You are viewing a plain text version of this content. The canonical link for it is here.

Posted to user@pig.apache.org by abhishek <ab...@gmail.com> on 2012/12/26 20:06:12 UTC

Group by with count

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

Re: Group by with count

Posted by abhishek <ab...@gmail.com>.

Thanks for the reply.

Sent from my iPhone

On Dec 27, 2012, at 3:14 PM, Russell Jurney <ru...@gmail.com> 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" <jc...@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 <ab...@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
>>

Re: Group by with count

Posted by Russell Jurney <ru...@gmail.com>.

Shortened:

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

Re: Group by with count

Posted by abhishek <ab...@gmail.com>.

Thanks for the reply , I got it

Sent from my iPhone

On Dec 27, 2012, at 2:31 PM, Jonathan Coveney <jc...@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 <ab...@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
>>

Re: Group by with count

Posted by Jonathan Coveney <jc...@gmail.com>.

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 <ab...@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
>