Eric Lomore created PHOENIX-3350:
------------------------------------
Summary: Enable support for utility functions
Key: PHOENIX-3350
URL: https://issues.apache.org/jira/browse/PHOENIX-3350
Project: Phoenix
Issue Type: Sub-task
Reporter: 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.
{{code}}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(){{code}}
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)
