You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@calcite.apache.org by "Julian Hyde (JIRA)" <ji...@apache.org> on 2015/01/01 17:50:13 UTC

[jira] [Resolved] (CALCITE-356) Allow column references of the form schema.table.column

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

Julian Hyde resolved CALCITE-356.
---------------------------------
       Resolution: Fixed
    Fix Version/s: 1.0.0-incubating

Fixed in http://git-wip-us.apache.org/repos/asf/incubator-calcite/commit/6c88546e.

> Allow column references of the form schema.table.column
> -------------------------------------------------------
>
>                 Key: CALCITE-356
>                 URL: https://issues.apache.org/jira/browse/CALCITE-356
>             Project: Calcite
>          Issue Type: Bug
>            Reporter: Julian Hyde
>            Assignee: Julian Hyde
>            Priority: Minor
>             Fix For: 1.0.0-incubating
>
>
> See https://issues.apache.org/jira/browse/DRILL-1196.
> Query of the form Select `schema`.`table`.* from `schema`.table` returns an error from the parser. This affects loading data to TIBCO Spotfire BI tool.
> {code}
> SELECT  `hive43.default`.`bella_table`.* FROM  `hive43.default`.`bella_table`;
> SqlParseException:[ Encountered ". *" at line 1, column 39.
> Was expecting one of:
>    "FROM" ...
>    "," ...
>    "AS" ...
>    <IDENTIFIER> ...
>    <QUOTED_IDENTIFIER> ...
>    <BACK_QUOTED_IDENTIFIER> ...
>    <BRACKET_QUOTED_IDENTIFIER> ...
>    <UNICODE_QUOTED_IDENTIFIER> ...
>    "NOT" ...
>    "IN" ...
>    "BETWEEN" ...
>    "LIKE" ...
>    "SIMILAR" ...
>    "=" ...
>    ">" ...
>    "<" ...
>    "<=" ...
>    ">=" ...
>    "<>" ...
>    "+" ...
>    "-" ...
>    "*" ...
>    "/" ...
>    "||" ...
>    "AND" ...
>    "OR" ...
>    "IS" ...
>    "MEMBER" ...
>    "SUBMULTISET" ...
>    "MULTISET" ...
>    "[" ...
>    "." <IDENTIFIER> ...
>    "." <QUOTED_IDENTIFIER> ...
>    "." <BACK_QUOTED_IDENTIFIER> ...
>    "." <BRACKET_QUOTED_IDENTIFIER> ...
>    "." <UNICODE_QUOTED_IDENTIFIER> ...
>    "(" ...
>     ]"
> {code}



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)