Home | About | Sematext search-lucene.com search-hadoop.com
 Search Hadoop and all its subprojects:

Switch to Plain View
Hive >> mail # user >> many terms in group by


+
tim robertson 2009-07-03, 21:11
Copy link to this message
-
Re: many terms in group by
> 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;

yes, should work, please try it and let us know.

-- amr

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
>
+
tim robertson 2009-07-04, 07:17