[DRILL-1532] Query fails when specifying schema name with column name

• Type: Bug
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Fix Version/s: Future
• Component/s: SQL Parser
• Assignee: Unassigned
• Reporter: Norris Lee
• Created: 13/Oct/14 17:37
• Updated: 01/Oct/15 16:36

Description

When the schema name is specified in the column names, the query fails with a table not found error.

 
0: jdbc:drill:zk=localhost:5181> SELECT `hive43.default`.double_table.keycolumn, `hive43.default`.double_table.column1 FROM `hive43.default`.double_table;
Query failed: Failure while parsing sql. Table 'hive43.default' not found [010fac69-c747-41f8-b5ec-274428c78a73]

Error: exception while executing query: Failure while trying to get next result batch. (state=,code=0)

Issue Links

• is duplicated by: DRILL-1196 Does not support query of the form SELECT `schema`.`table`.* FROM `schema`.table`
• requires: DRILL-1384 Rebase Drill on Calcite v1.0