[
https://issues.apache.org/jira/browse/PHOENIX-3350?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Eric Lomore updated PHOENIX-3350:
---------------------------------
Summary: Enable UDF functions for SELECT queries (was: Enable support for
utility functions)
> Enable UDF functions for SELECT queries
> ---------------------------------------
>
> Key: PHOENIX-3350
> URL: https://issues.apache.org/jira/browse/PHOENIX-3350
> Project: Phoenix
> Issue Type: Sub-task
> Reporter: Eric Lomore
> Assignee: Eric Lomore
>
> Functions such as TO_DATE, TO_CHAR, and CURRENT_DATE are breaking in SELECT
> statements. These functions do however work in DDL statements such as create
> view.
> {{"SELECT * FROM t WHERE k1 = TO_DATE(TO_CHAR(CURRENT_DATE())"}}
> org.apache.calcite.sql.validate.SqlValidatorException: No match found for
> function signature TO_DATE()
> But once wrapped in a DDL statement, it executes fine:
> {{"CREATE VIEW v AS SELECT * FROM t WHERE k1 =
> TO_DATE(TO_CHAR(CURRENT_DATE())}}
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
