[
https://issues.apache.org/jira/browse/DRILL-1532?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14592811#comment-14592811
]
Sean Hsuan-Yi Chu edited comment on DRILL-1532 at 6/19/15 12:47 AM:
--------------------------------------------------------------------
Had a discussion with [~amansinha100]:
The problem with Drill is that this type of name can also be used for
{color:red}Map{color} element.
e.g select x.y.z could mean that the top level map is x, which contains a
nested field y which contains a nested field z.
So, how do we distinguish such names from the
{color:red}schema.table.column{color} type of names ?
was (Author: seanhychu):
Had a discussion with [~amansinha100]:
The problem with Drill is that this type of name can also be used for
{color:red}Map{color} element.
e.g select x.y.z could mean that the top level map is x, which contains a
nested field y which contains a nested field z. So, how do we distinguish
such names from the schema.table.column type of names ?
> 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: Bug
> Components: SQL Parser
> Reporter: Norris Lee
> Assignee: Sean Hsuan-Yi Chu
> Fix For: 1.1.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)
