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 2014/07/25 20:13:38 UTC
[jira] [Created] (OPTIQ-356) Does not support query of the form
SELECT `schema`.`table`.* FROM `schema`.table`
Julian Hyde created OPTIQ-356:
---------------------------------
Summary: Does not support query of the form SELECT `schema`.`table`.* FROM `schema`.table`
Key: OPTIQ-356
URL: https://issues.apache.org/jira/browse/OPTIQ-356
Project: Optiq
Issue Type: Bug
Reporter: Julian Hyde
Assignee: Julian Hyde
Priority: Minor
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.2#6252)