question Re: hive select distinct count error in Support Questions

hive select distinct count error

Sample01 — Mon, 01 Mar 2021 21:51:56 GMT

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

Re: hive select distinct count error

Venkateshmr — Tue, 02 Mar 2021 03:57:57 GMT

Try with below query and share the output,

select count (distinct id) from hive_table_tbs;

Re: hive select distinct count error

Sample01 — Tue, 02 Mar 2021 09:21:58 GMT

Thank you. I query run fine.

select count (distinct id) from hive_table_tbs;

output:

1092

Re: hive select distinct count error

Venkateshmr — Tue, 02 Mar 2021 09:32:58 GMT

Welcome @

Re: hive select distinct count error

Bender — Tue, 23 Mar 2021 14:09:41 GMT

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.