Reply
Highlighted
New Contributor
Posts: 1
Registered: ‎11-04-2018

Count distinct not allowed in Analytical function in Impala

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.

Cloudera Employee
Posts: 430
Registered: ‎03-23-2015

Re: Count distinct not allowed in Analytical function in Impala

Hi Nick,

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

Cheers
Announcements