hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Richard <codemon...@163.com>
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.


thanks.
Richard
Mime
View raw message