This Query works  in CDH5 but fails in CDH6:

         select

           contentid,

           parse_url(refer, 'HOST') as domain,

           ndv(uuid) uv

           from domain_logs and keywords is null group by contentid, domain
  having uv > 3;


ERROR: AnalysisException: Could not resolve column/field reference: 'uv'



Impala Version: Server version: impalad version 3.2.0-cdh6.2.0 RELEASE
(build edc19942b4debdbfd485fbd26098eef435003f5d)



How to write this SQL in impala 3.2?

Reply via email to