[jira] [Resolved] (DRILL-2179) better handle column called 'Timestamp'

["Aman Sinha (JIRA)" <ji...@apache.org>]

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