Uploaded image for project: 'Calcite'
  1. Calcite
  2. CALCITE-356

Allow column references of the form schema.table.column

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Minor
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: 1.0.0-incubating
    • Component/s: None
    • Labels:
      None

      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

          Activity

          Hide
          julianhyde Julian Hyde added a comment -

          Closing now that 1.0.0-incubating has been released.

          Show
          julianhyde Julian Hyde added a comment - Closing now that 1.0.0-incubating has been released.
          Show
          julianhyde Julian Hyde added a comment - Fixed in http://git-wip-us.apache.org/repos/asf/incubator-calcite/commit/6c88546e .
          Hide
          julianhyde Julian Hyde added a comment -

          Note that schema-qualified table names were illegal in SQL-92, but became legal in SQL:1999. (SQL:2003 Part 2 Section 6.6 Syntax Rule 8.b.vi.)

          Show
          julianhyde Julian Hyde added a comment - Note that schema-qualified table names were illegal in SQL-92, but became legal in SQL:1999. (SQL:2003 Part 2 Section 6.6 Syntax Rule 8.b.vi.)

            People

            • Assignee:
              julianhyde Julian Hyde
              Reporter:
              julianhyde Julian Hyde
            • Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved:

                Development