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

["Will Ochandarena (JIRA)" <ji...@apache.org>]

Will Ochandarena created DRILL-2179:
---------------------------------------

             Summary: 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: Aman Sinha
            Priority: Minor


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)