You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@drill.apache.org by "Jacques Nadeau (JIRA)" <ji...@apache.org> on 2015/01/04 22:29:45 UTC
[jira] [Commented] (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:comment-tabpanel&focusedCommentId=14264042#comment-14264042 ]
Jacques Nadeau commented on DRILL-1532:
---------------------------------------
The newest version of Calcite supports this functionality. We need to upgrade and should get this for free (or cheaply)
> 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
> Reporter: Norris Lee
> Assignee: Jinfeng Ni
> Fix For: 0.9.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)