Support Questions
Find answers, ask questions, and share your expertise

Count distinct not allowed in Analytical function in Impala

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

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