hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Richard <>
Subject histogram_numeric find the most frequent value
Date Wed, 16 Oct 2013 11:09:21 GMT
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.

View raw message