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)