drill-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Aman Sinha (JIRA)" <j...@apache.org>
Subject [jira] [Resolved] (DRILL-2179) better handle column called 'Timestamp'
Date Wed, 25 Feb 2015 00:15:05 GMT

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

Mime
View raw message