nizarhejazi opened a new issue, #9218: URL: https://github.com/apache/pinot/issues/9218
- Supports **COALESCE** transform. - Supports **IS DISTINCT FROM** operator. - Supports **IS NOT DISTINCT FROM** operator. Note: **IS DISTINCT FROM** is a transform function that can be rewritten as the following: ``` a IS DISTINCT FROM b -- equivalent to -- ((a <> b OR a IS NULL OR b IS NULL) AND NOT (a IS NULL AND b IS NULL)) ``` Nevertheless, it is a good idea to support these operators for two reasons: 1. To compute the end result more efficiently. 2. To simplify SQL query. 4. Presto supports it too. -- 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.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
