[
https://issues.apache.org/jira/browse/DRILL-1532?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Norris Lee updated DRILL-1532:
------------------------------
Description:
When the schema name is specified in the column names, the query fails with a
table not found error.
{code}
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)
{code}
was:
When the table name is specified in the column names, the query fails with a
table not found error.
{code}
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)
{code}
> Query fails when specifying table name with column name
> -------------------------------------------------------
>
> Key: DRILL-1532
> URL: https://issues.apache.org/jira/browse/DRILL-1532
> Project: Apache Drill
> Issue Type: Bug
> Reporter: Norris Lee
> Fix For: 0.7.0
>
>
> When the schema name is specified in the column names, the query fails with a
> table not found error.
> {code}
> 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)
> {code}
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
