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)
