Sanjeet Malhotra created PHOENIX-7754:
-----------------------------------------
Summary: Improve test coverage for using =ANY(?) instead of IN list
Key: PHOENIX-7754
URL: https://issues.apache.org/jira/browse/PHOENIX-7754
Project: Phoenix
Issue Type: Improvement
Reporter: Sanjeet Malhotra
PHOENIX-7659 added optimization to generate point lookups when =ANY(?) is used
instead of IN List. This was to optimize on query parsing time. In our internal
perf testing we have seen great improvements in parsing time i.e. at least 50%
for queries doing 1000/8000 lookups in a single query.
Before wider adoption we can improve the test coverage to cover following cases:
* Use in Upsert/Deletes in their query phase.
* When array has duplicate elements or out of order elements i.e. elements not
in sorted order. Skip Scan filter expects non overlapping sorted key ranges.
* While we have an IT for skip scan but we can add one more for range scan.
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
