hive select distinct count error

[#1]

HI, 

I am running a select distinct count on a column, am getting the below error. can you please help me.

select distinct count (id) from hive_table_tbs;

error message

Error while compiling statement: FAILED: SemanticException [Error 10128]: line 1:16 Not yet supported place for UDAF 'count'

Thank You

[#2 · Accepted solution]

Try with below query and share the output,

select count (distinct id) from hive_table_tbs;

[#3]

Thank you. I query run fine. 

select count (distinct id) from hive_table_tbs;

output:

1092

[#4]

Welcome @

[#5]

Please find here the Apache Hive tutorial and more information on selecting distinct values under the Aggregations section.

For more on the Apache Hive content roadmap, please refer to our documentation.