reply to myself:
juse use ndv(uuid), not using alias
select
contentid,
parse_url(refer, 'HOST') as domain,
ndv(uuid) as uv
from domain_logs and keywords is null group by contentid, domain
having ndv(uuid) > 3;
On Sun, May 19, 2019 at 12:14 AM Darren Hoo <[email protected]> wrote:
> 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?
>
