Home | About | Sematext search-lucene.com search-hadoop.com
NEW: Monitor These Apps!
elasticsearch, apache solr, apache hbase, hadoop, redis, casssandra, amazon cloudwatch, mysql, memcached, apache kafka, apache zookeeper, apache storm, ubuntu, centOS, red hat, debian, puppet labs, java, senseiDB
 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
NEW: Monitor These Apps!
elasticsearch, apache solr, apache hbase, hadoop, redis, casssandra, amazon cloudwatch, mysql, memcached, apache kafka, apache zookeeper, apache storm, ubuntu, centOS, red hat, debian, puppet labs, java, senseiDB