Support Questions
Find answers, ask questions, and share your expertise
Announcements
Check out our newest addition to the community, the Cloudera Innovation Accelerator group hub.

Count distinct not allowed in Analytical function in Impala

Explorer

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

Guru
Hi Nick,

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

Cheers