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

        Attachments

          Issue Links

            Activity

              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: