hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Manoj Bharadwaj <manoj.bharad...@gmail.com>
Subject Count (Distinct Case When...)
Date Fri, 12 Sep 2014 18:25:48 GMT
Hello World!

I'm not able to do the below in Hive. Is this a limitation?

*Count (Distinct Case When Col2 is not null then Col1 else End) as Count1*

This give me the same result as:
*Count (Distinct Col1) as Count2*

NB: There are significant cases where *Col2* is null

I couldn't find any support on the web for this - hence the question to the
group. Links/reading material appreciated

Thanks!
Manoj

Mime
View raw message