Sanjeet Malhotra created PHOENIX-7766:
-----------------------------------------
Summary: Generate point lookups while using IS NULL on trailing PK
columns
Key: PHOENIX-7766
URL: https://issues.apache.org/jira/browse/PHOENIX-7766
Project: Phoenix
Issue Type: Improvement
Reporter: Sanjeet Malhotra
Assignee: Sanjeet Malhotra
Currently, Phoenix explicitly prevents generating point lookups if a query has
WHERE clause such that there is IS NULL condition on trailing PK columns.
The proposal in this Jira is to generate point lookups for above case. This
will especially be useful for cases when a new nullable PK column is added to a
table and because of addition of new PK columns earlier single point lookups
and multi point lookups regress to range and skip scan. The proposal will help
prevent such regression.
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
