[HIVE-22074] Slow compilation due to IN to OR transformation - ASF JIRA

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: Logical Optimizer
Labels:
- pull-request-available

Target Version/s:

4.0.0

Description

Currently Hive transform IN expressions to OR to apply various CBO rules. This incur significant performance hit if IN consist of large number of expressions.
It is better to not transform IN expressions to OR in such cases because overall benefit of various optimizations/transformations is unrealized due to the compilation overhead

Attachments

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

HIVE-22074.1.patch
01/Aug/19 21:42
9 kB
Vineet Garg
HIVE-22074.2.patch
02/Aug/19 21:09
9 kB
Vineet Garg
HIVE-22074.3.patch
05/Aug/19 19:46
9 kB
Vineet Garg
HIVE-22074.4.patch
06/Aug/19 23:29
19 kB
Vineet Garg
HIVE-22074.5.patch
19/Aug/19 22:09
19 kB
Vineet Garg
HIVE-22074.6.patch
22/Aug/19 17:59
19 kB
Vineet Garg

Issue Links

links to

GitHub Pull Request #746

Activity

People

Assignee:: Vineet Garg

Reporter:: Vineet Garg

Votes:: 0 Vote for this issue

Watchers:: 3 Start watching this issue

Dates

Created:: 01/Aug/19 21:41

Updated:: 27/Feb/24 22:23

Resolved:: 23/Aug/19 20:26

Time Tracking

Estimated:

Not Specified

Remaining:

Logged:

1.5h