[HIVE-20744] Use SQL constraints to improve join reordering algorithm - ASF JIRA

XML

Word

Printable

JSON

Details

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

Description

Till now, it was all based on stats stored for the base tables and their columns. Now the optimizer can rely on constraints. Hence, this patch is for the join reordering costing to use constraints, and if it does not find any, rely on old code path.

Attachments

- Sort By Name
- Sort By Date
- Ascending
- Descending

HIVE-20744.01.patch
24/Oct/18 17:47
33 kB
jcamachorodriguez
HIVE-20744.02.patch
30/Oct/18 20:57
36 kB
jcamachorodriguez
HIVE-20744.03.patch
06/Nov/18 05:13
36 kB
jcamachorodriguez
HIVE-20744.04.patch
06/Nov/18 05:28
356 kB
jcamachorodriguez
HIVE-20744.05.patch
07/Nov/18 00:50
433 kB
jcamachorodriguez
HIVE-20744.06.patch
11/Nov/18 02:32
433 kB
jcamachorodriguez
HIVE-20744.06.patch
10/Nov/18 19:29
433 kB
jcamachorodriguez
HIVE-20744.07.patch
11/Nov/18 04:27
433 kB
jcamachorodriguez
HIVE-20744.patch
24/Oct/18 17:44
218 kB
jcamachorodriguez

Issue Links

is blocked by

HIVE-20718 Add perf cli driver with constraints

Closed

is related to

HIVE-23973 Use SQL constraints to improve join reordering algorithm (III)

Closed

links to

RB link

Activity

People

Assignee:: Jesús Camacho Rodríguez

Reporter:: Jesús Camacho Rodríguez

Votes:: 0 Vote for this issue

Watchers:: 2 Start watching this issue

Dates

Created:: 14/Oct/18 16:03

Updated:: 27/Feb/24 22:23

Resolved:: 11/Nov/18 06:03