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

            relates to

            Sub-task - The sub-task of the issue CALCITE-497 Support optional qualifier for column name references

            • Major - Major loss of function.
            • Closed

            Bug - A problem which impairs or prevents the functions of the product. CALCITE-881 Allow schema.table.column references in GROUP BY

            • Major - Major loss of function.
            • Closed

              Activity

              Ascending order - Click to sort in descending order
              Hide
              Permalink
              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.)
              Hide
              Permalink
              julianhyde Julian Hyde added a comment -

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

              Show
              julianhyde Julian Hyde added a comment - Fixed in http://git-wip-us.apache.org/repos/asf/incubator-calcite/commit/6c88546e .
              Hide
              Permalink
              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.

                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