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

["Sean Hsuan-Yi Chu (JIRA)" <ji...@apache.org>]

    [ 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 commented on DRILL-1532:
------------------------------------------

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)