You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@pinot.apache.org by GitBox <gi...@apache.org> on 2022/02/25 17:47:32 UTC
[GitHub] [pinot] lakshmanan-v opened a new issue #8251: Add COALESCE or NULL value functions
lakshmanan-v opened a new issue #8251:
URL: https://github.com/apache/pinot/issues/8251
This is done in a bunch of ways by different databases: https://www.w3schools.com/sql/sql_isnull.asp
It would be nice if pinot can support this capability. Right now this can only be done using CASE statement.
`CASE when expr([cols]) is 'null' THEN fallback_value ELSE expr([cols]) END`
--
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-unsubscribe@pinot.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@pinot.apache.org
For additional commands, e-mail: commits-help@pinot.apache.org
[GitHub] [pinot] Jackie-Jiang commented on issue #8251: Add COALESCE or NULL value functions
Posted by GitBox <gi...@apache.org>.
Jackie-Jiang commented on issue #8251:
URL: https://github.com/apache/pinot/issues/8251#issuecomment-1051342611
This can be modeled as a scalar function (or transform function for better performance)
--
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-unsubscribe@pinot.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@pinot.apache.org
For additional commands, e-mail: commits-help@pinot.apache.org
[GitHub] [pinot] KKcorps commented on issue #8251: Add COALESCE or NULL value functions
Posted by GitBox <gi...@apache.org>.
KKcorps commented on issue #8251:
URL: https://github.com/apache/pinot/issues/8251#issuecomment-1053626775
@Jackie-Jiang This is also a requirement to support Tableau completely from our end. Is there a way we can implement this?
Currentl, `WHERE column IS NULL` is supported when we set `nullHandlingEnabled` to `true`. But `CASE WHEN col IS NULL THEN a ELSE b` throws parsing exception.
--
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-unsubscribe@pinot.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@pinot.apache.org
For additional commands, e-mail: commits-help@pinot.apache.org