clintropolis opened a new pull request, #15451:
URL: https://github.com/apache/druid/pull/15451
### Description
Updates `ARRAY_OVERLAP` to use the same `ArrayContainsElement` filter added
in #15366 when filtering ARRAY typed columns so that it can also use indexes
like `ARRAY_CONTAINS`.
For query:
```sql
SELECT string1, long1 FROM foo WHERE ARRAY_OVERLAP("multi-string3",
ARRAY[100, 200]) GROUP BY 1,2
```
```
Benchmark (query) (rowsPerSegment) (schema)
(vectorize) Mode Cnt Score Error Units
SqlExpressionBenchmark.querySql 39 5000000 auto
false avgt 5 5119.577 ± 13.764 ms/op
```
After:
```
Benchmark (query) (rowsPerSegment) (schema)
(vectorize) Mode Cnt Score Error Units
SqlExpressionBenchmark.querySql 39 5000000 auto
false avgt 5 149.264 ± 1.216 ms/op
```
<hr>
This PR has:
- [x] been self-reviewed.
- [x] added comments explaining the "why" and the intent of the code
wherever would not be obvious for an unfamiliar reader.
- [x] added unit tests or modified existing tests to cover new code paths,
ensuring the threshold for [code
coverage](https://github.com/apache/druid/blob/master/dev/code-review/code-coverage.md)
is met.
- [x] been tested in a test Druid cluster.
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: [email protected]
For queries about this service, please contact Infrastructure at:
[email protected]
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
