Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

Count distinct not allowed in Analytical function in Impala

Highlighted

Count distinct not allowed in Analytical function in Impala

New Contributor

SELECT COUNT(DISTINCT cust_n) OVER(PARTITION BY ord_id,ord_d) cusp_cnt FROM table1;

 

-- Not working in Impala. Is there any way to overcome the issue.

1 REPLY 1

Re: Count distinct not allowed in Analytical function in Impala

Guru
Hi Nick,

Can you please share what do you mean by not working? Error messages would be helpful here.

Cheers