KKcorps opened a new pull request #8264:
URL: https://github.com/apache/pinot/pull/8264
This PR addresses the issue #8251 . Currently, Pinot supports `IS NULL`
syntax in filter expressions such as `WHERE` clause. But it doesn't support as
part of SELECT expressions such as `CASE WHEN col IS NULL THEN a ELSE b`
The PR adds support for such expressions by utilising the
`NullValueVectorReader` to get the docIds which are null.
The implementation has two requirements/limitations -
* `nullHandlingEnabled` should be set to `true` since native NULL values
are not supported in Pinot and requires a null value bitmap index.
* Only column names can be provided as the first argument for expressions.
The support for functions is still not there.
e.g. `colA IS NULL` is supported but `LOWER(colA) IS NULL` is not supported.
Currently Pending -
* Unit Tests
* Documentation
--
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: commits-unsubscr...@pinot.apache.org
For queries about this service, please contact Infrastructure at:
us...@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscr...@pinot.apache.org
For additional commands, e-mail: commits-h...@pinot.apache.org
