|
|
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
+
abhishek 2012-12-26, 19:06
-
Re: Group by with count
Jonathan Coveney 2012-12-27, 19:31
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
>
+
Jonathan Coveney 2012-12-27, 19:31
-
Re: Group by with count
Russell Jurney 2012-12-27, 20:14
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
> >
>
+
Russell Jurney 2012-12-27, 20:14
-
Re: Group by with count
abhishek 2012-12-27, 20:36
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
>>
+
abhishek 2012-12-27, 20:36
-
Re: Group by with count
abhishek 2012-12-27, 20:36
Thanks for the reply , I got it
Sent from my iPhone
On Dec 27, 2012, at 2:31 PM, 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
>>
+
abhishek 2012-12-27, 20:36
|
|
