Details
-
Bug
-
Status: Closed
-
Major
-
Resolution: Fixed
-
2.2.0
-
None
-
None
Description
Following query with count(distinct) generates different result than expected on hive master:
select count(distinct ss_ticket_number), count(distinct ss_sold_date_sk) from store_sales;
Expected output generated using postgres:
select count(distinct ss_ticket_number), count(distinct ss_sold_date_sk) from store_sales; count | count --------+------- 240000 | 1823 (1 row)
Actual output
240000 1824
Attachments
Attachments
Issue Links
- links to