[
https://issues.apache.org/jira/browse/DRILL-2179?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Aman Sinha resolved DRILL-2179.
-------------------------------
Resolution: Duplicate
Fix Version/s: 1.0.0
Assignee: Sean Hsuan-Yi Chu (was: Aman Sinha)
> better handle column called 'Timestamp'
> ---------------------------------------
>
> Key: DRILL-2179
> URL: https://issues.apache.org/jira/browse/DRILL-2179
> Project: Apache Drill
> Issue Type: Bug
> Components: SQL Parser
> Affects Versions: 0.7.0
> Reporter: Will Ochandarena
> Assignee: Sean Hsuan-Yi Chu
> Priority: Minor
> Fix For: 1.0.0
>
>
> When querying a JSON file with a key called 'Timestamp' (select timestamp
> from <file>), Drill throws a non-intuitive error message (below). It works
> when backticking. Ideally the parser would look for keys called 'Timestamp'
> before erroring out. If that can't be done, a better error should be printed.
> jdbc:drill:zk=local> select Timestamp, Operation from dfs.`/...json`;
> Query failed: Query failed: Failure parsing SQL. Encountered "Timestamp ," at
> line 1, column 8.
> Was expecting one of:
> "UNION" ...
> "INTERSECT" ...
> "EXCEPT" ...
> "ORDER" ...
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
