[HIVE-11573] PointLookupOptimizer can be pessimistic at a low nDV - ASF JIRA

XML

Word

Printable

JSON

Details

Type: Bug
Status: Closed
Priority: Major
Resolution: Fixed
Affects Version/s: 2.0.0
Fix Version/s: 2.0.0
Component/s: None
Labels:
None

Release Note:
Provide configurable limits to the PointLookupOptimizer

Description

The PointLookupOptimizer can turn off some of the optimizations due to its use of tuple IN() clauses.

Limit the application of the optimizer for very low nDV cases and extract the sub-clause as a pre-condition during runtime, to trigger the simple column predicate index lookups.

Attachments

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

HIVE-11573.6.patch
26/Aug/15 20:24
108 kB
Gopal Vijayaraghavan
HIVE-11573.5.patch
24/Aug/15 09:42
106 kB
jcamachorodriguez
HIVE-11573.4.patch
22/Aug/15 00:28
40 kB
Gopal Vijayaraghavan
HIVE-11573.3.patch
21/Aug/15 04:41
37 kB
Gopal Vijayaraghavan
HIVE-11573.2.patch
19/Aug/15 08:54
8 kB
Gopal Vijayaraghavan
HIVE-11573.1.patch
19/Aug/15 08:17
8 kB
Gopal Vijayaraghavan

Issue Links

is related to

HIVE-11634 Support partition pruning for IN(STRUCT(partcol, nonpartcol..)...)

Closed

HIVE-11698 Add additional test for PointLookupOptimizer

Closed

HIVE-11726 Pushed IN predicates to the metastore

Closed

HIVE-11461 Transform flat AND/OR into IN struct clause

Closed

Activity

People

Assignee:: Gopal Vijayaraghavan

Reporter:: Gopal Vijayaraghavan

Votes:: 0 Vote for this issue

Watchers:: 3 Start watching this issue

Dates

Created:: 15/Aug/15 06:16

Updated:: 27/Feb/24 22:23

Resolved:: 27/Aug/15 07:52