I am using hdp 184.108.40.206-40.
I am trying to run following command.
select count(distinct a21.company_code) WJXBFS1 from dim_investment a21;.
After ran query expected output is 1. But it is giving 0.
Tried with follwoing properties.
Hi @Ashnee Sharma,
can you please try by setting "hive.groupby.skewindata=true" to make randomized shuffle before reduce.
In any case the following syntax should produce the accurate result
select count(1) from ( select a21.company_code from dim_investment a21 group by a21.company_code) aa
inner group by ensure that there should be a mapper executed before counting the distinct rows.