[
https://issues.apache.org/jira/browse/PHOENIX-3350?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15553551#comment-15553551
]
Eric Lomore commented on PHOENIX-3350:
--------------------------------------
[~jamestaylor] it seems PHOENIX-3355 that you made replaces this. Shall I close
this?
> Enable utility 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
>
> Some functions such as TO_DATE & TO_CHAR 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)
