[HIVE-20292] Bad join ordering in tpcds query93 with primary constraint defined - ASF JIRA

Log work

Agile Board

Rank to Top

Rank to Bottom

Bulk Copy Attachments

Bulk Move Attachments

Voters

Watch issue

Watchers

Create sub-task

Convert to sub-task

Move

Link

Clone

Labels

Update Comment Author

Replace String in Comment

Update Comment Visibility

Delete Comments

XML

Word

Printable

JSON

Details

Type: Improvement
Status: Closed
Priority: Major
Resolution: Fixed
Affects Version/s: None
Fix Version/s: 4.0.0-alpha-1
Component/s: Query Planning
Labels:
None

Target Version/s:

4.0.0

Description

Query 93 has join (including outer) b/w store_sales, store_return and reason. Without constraints store_return is joined with reason and then with store_sales.
But if a primary key is added on store_return (alter table store_returns add constraint tpcds_pk_sr primary key (sr_item_sk, sr_ticket_number) disable novalidate rely) join order becomes ((store_sales, store_return), reason) which is very inefficient.