[CALCITE-356] Allow column references of the form schema.table.column

• Type: Bug
• Status: Closed
• Priority: Minor
• Resolution: Fixed
• Fix Version/s: 1.0.0-incubating
• Assignee: Julian Hyde
• Reporter: Julian Hyde
• Created: 25/Jul/14 18:13
• Updated: 09/Sep/15 16:39
• Resolved: 01/Jan/15 16:49

Description

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.

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> ...
   "(" ...
    ]"

Issue Links

• relates to: CALCITE-497 Support optional qualifier for column name references
• relates to: CALCITE-881 Allow schema.table.column references in GROUP BY