[DRILL-2179] better handle column called 'Timestamp'

• Type: Bug
• Status: Resolved
• Priority: Minor
• Resolution: Duplicate
• Affects Version/s: 0.7.0
• Fix Version/s: 1.0.0
• Component/s: SQL Parser
• Assignee: Sean Hsuan-Yi Chu
• Reporter: Will Ochandarena
• Created: 06/Feb/15 22:39
• Updated: 25/Feb/15 00:14
• Resolved: 25/Feb/15 00:14

Description

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" ...

Issue Links

• duplicates: DRILL-1938 Fix error message when reserved words are used in query.