Details
-
Bug
-
Status: Closed
-
Major
-
Resolution: Fixed
-
2.0.0
-
None
-
None
Description
an example rewrite for q28 of tpcds is
(select LP as B1_LP ,CNT as B1_CNT,CNTD as B1_CNTD
from (select sum(xc0) / sum(xc1) as LP, sum(xc1) as CNT, count(1) as CNTD from (select sum(ss_list_price) as xc0, count(ss_list_price) as xc1 from store_sales where
ss_list_price is not null and ss_quantity between 0 and 5
and (ss_list_price between 11 and 11+10
or ss_coupon_amt between 460 and 460+1000
or ss_wholesale_cost between 14 and 14+20)
group by ss_list_price) ss0) ss1) B1
Attachments
Attachments
Issue Links
- causes
-
HIVE-23954 count(*) with count(distinct) gives wrong results with hive.optimize.countdistinct=true
- Patch Available
- links to