[jira] [Assigned] (IMPALA-15526) tpcds-unmodified q78 joins cs_item_sk to itself instead of ss_item_sk

["Zoltán Borók-Nagy (Jira)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/IMPALA-15526?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Zoltán Borók-Nagy reassigned IMPALA-15526:
------------------------------------------

    Assignee: Zoltán Borók-Nagy

> tpcds-unmodified q78 joins cs_item_sk to itself instead of ss_item_sk
> ---------------------------------------------------------------------
>
>                 Key: IMPALA-15526
>                 URL: https://issues.apache.org/jira/browse/IMPALA-15526
>             Project: IMPALA
>          Issue Type: Bug
>          Components: Infrastructure, Test
>            Reporter: Zoltán Borók-Nagy
>            Assignee: Zoltán Borók-Nagy
>            Priority: Major
>              Labels: performance
>
> testdata/workloads/tpcds-unmodified/queries/tpcds-q78.test:49 (master 1f34ea915e) has:
> {code:sql}
> left join cs on (cs_sold_year=ss_sold_year and cs_item_sk=cs_item_sk and cs_customer_sk=ss_customer_sk)
> {code}
> The TPC-DS specification, and the tpcds and tpcds_partitioned copies of the query, use cs_item_sk=ss_item_sk.
> With the typo, the cs join matches on (year, customer) only, so it becomes many-to-many, and the planner gives the self-equality the default 0.1 selectivity. Results differ from the specification query, and performance numbers from this workload are not comparable with other engines or published TPC-DS results. Since tpcds-unmodified is the workload used for performance tests, the fix also changes baseline numbers.
> Fix: replace cs_item_sk=cs_item_sk with cs_item_sk=ss_item_sk.



--
This message was sent by Atlassian Jira
(v8.20.10#820010)

---------------------------------------------------------------------
To unsubscribe, e-mail: issues-all-unsubscribe@impala.apache.org
For additional commands, e-mail: issues-all-help@impala.apache.org