You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@calcite.apache.org by "Soumyakanti Das (Jira)" <ji...@apache.org> on 2024/09/25 22:13:00 UTC

[jira] [Created] (CALCITE-6597) Add more standard functions in SqlDialect::BUILT_IN_OPERATORS_LIST

Soumyakanti Das created CALCITE-6597:
----------------------------------------

             Summary: Add more standard functions in SqlDialect::BUILT_IN_OPERATORS_LIST
                 Key: CALCITE-6597
                 URL: https://issues.apache.org/jira/browse/CALCITE-6597
             Project: Calcite
          Issue Type: Improvement
          Components: core
            Reporter: Soumyakanti Das


The BUILT_IN_OPERATORS_LIST in SqlDialect, along with functions present in the method supportsFunction, contains a list of "white-listed" functions, which is missing common functions like "UPPER" and "LOWER". This can hinder pushdown of a Filter node containing these functions to JDBC storage handler, as can be seen in this Hive Jira: https://issues.apache.org/jira/browse/HIVE-27080

Although this can be handled in Hive, I believe we should add as many common and standard functions as possible in Calcite.



--
This message was sent by Atlassian Jira
(v8.20.10#820010)