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

Switch to Threaded View
Hive, mail # user - histogram_numeric find the most frequent value


Copy link to this message
-
histogram_numeric find the most frequent value
Richard 2013-10-16, 11:09
I want to find the most frequent value of a column, I noticed histogram_numerc,
but I cannot specify the bin boundary. The result is not what I want.
take an example as follows,  I want something like
select gid, most_frequent(category) from mytable group by gid.
where category is a column with descritized values.
thanks.
Richard