[
https://issues.apache.org/jira/browse/PHOENIX-3265?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15546325#comment-15546325
]
Eric Lomore edited comment on PHOENIX-3265 at 10/4/16 7:04 PM:
---------------------------------------------------------------
An interrelated issue is the following SQL select satement failing:
{{"SELECT k1 FROM t WHERE date >= to_date('2013-01-01')";}}
Caused by: org.apache.phoenix.calcite.parser.ParseException: Encountered "date
>="
Was expecting one of...
.
.
"DATE" ...
"DATE" <QUOTED_STRING> ...
was (Author: lomoree):
An interrelated issue is the following SQL select satement failing:
{{"SELECT k1 FROM t WHERE date >= to_date('2013-01-01')";}}
Recognition of "data >=" is failing.
> 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)
