You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@drill.apache.org by "Jinfeng Ni (JIRA)" <ji...@apache.org> on 2015/04/13 19:12:12 UTC

[jira] [Updated] (DRILL-1532) Query fails when specifying schema name with column name

     [ https://issues.apache.org/jira/browse/DRILL-1532?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Jinfeng Ni updated DRILL-1532:
------------------------------
    Fix Version/s:     (was: 0.9.0)
                   1.0.0

> Query fails when specifying schema name with column name
> --------------------------------------------------------
>
>                 Key: DRILL-1532
>                 URL: https://issues.apache.org/jira/browse/DRILL-1532
>             Project: Apache Drill
>          Issue Type: Improvement
>          Components: SQL Parser
>            Reporter: Norris Lee
>            Assignee: Jinfeng Ni
>             Fix For: 1.0.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)