drill-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Will Ochandarena (JIRA)" <j...@apache.org>
Subject [jira] [Created] (DRILL-2179) better handle column called 'Timestamp'
Date Fri, 06 Feb 2015 22:39:35 GMT
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
Was expecting one of:
    "UNION" ...
    "INTERSECT" ...
    "EXCEPT" ...
    "ORDER" ...

This message was sent by Atlassian JIRA

View raw message