tim robertson 2009-07-03, 21:11
-Re: many terms in group by
Amr Awadallah 2009-07-04, 07:03
> select a,b,c,d,e,f,g,h,i,count(*) from table x group by
yes, should work, please try it and let us know.
tim robertson wrote:
> Hi all,
> I have several MapReduce jobs that are basically doing counts with
> group by on tab delimited files.
> Getting tired of writing the same thing over again for each report I
> am thinking of trying Hive for this.
> Does Hive work ok with 9 or so terms in the group by?
> (e.g. it is happy concatenating the fields to make the key to emit
> from the map so it can do the count is a reduce and complete in one
> mapreduce job)
> I'm meaning the equivalent of:
> select a,b,c,d,e,f,g,h,i,count(*) from table x group by a,b,c,d,e,f,g,h,i;
> Many thanks,
tim robertson 2009-07-04, 07:17