[jira] [Assigned] (PHOENIX-3350) Enable support for utility functions

["Eric Lomore (JIRA)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/PHOENIX-3350?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Eric Lomore reassigned PHOENIX-3350:
------------------------------------

    Assignee: Eric Lomore

> 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
>            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)