[
https://issues.apache.org/jira/browse/PHOENIX-3265?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15546346#comment-15546346
]
James Taylor commented on PHOENIX-3265:
---------------------------------------
How about this? {{SELECT k1 FROM t WHERE "DATE" >= to_date('2013-01-01')}}
Note that when you double quote an identifier, it becomes case sensitive, so
you'll need to match case with the way it was named in the CREATE TABLE
statement.
> Surround columns named date with double quotes
> ----------------------------------------------
>
> Key: PHOENIX-3265
> URL: https://issues.apache.org/jira/browse/PHOENIX-3265
> Project: Phoenix
> Issue Type: Sub-task
> Reporter: James Taylor
> Assignee: Eric Lomore
>
> In Phoenix {{date}} is not a reserved word, but perhaps in Calcite it is? If
> that's the case, we should surround occurrences of columns named {{date}} in
> double quotes to prevent the parser error.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
