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

Support LATERAL TABLE

        Details

        • Type: New Feature
        • Status: Closed
        • Priority: Major
        • Resolution: Fixed
        • Affects Version/s: None
        • Fix Version/s: 1.9.0
        • Component/s: core
        • Labels:
          None

          Description

          SELECT MyTable.*, t.s  FROM MyTable, LATERAL TABLE(split(MyTable.a)) AS t(s)

          will throw “Encountered "LATERAL TABLE" at line 1, column 38.” exception.

          We should support LATERAL TABLE , and allow table function to see earlier tables in the FROM clause.

            Issue Links

            relates to

            Bug - A problem which impairs or prevents the functions of the product. CALCITE-1356 Release Calcite 1.9.0

            • Major - Major loss of function.
            • Closed

              Activity

              Ascending order - Click to sort in descending order
              Hide
              Permalink
              julianhyde Julian Hyde added a comment -

              Probably fairly straightforward to implement, maybe only the parser needs to be changed.

              Show
              julianhyde Julian Hyde added a comment - Probably fairly straightforward to implement, maybe only the parser needs to be changed.
              Hide
              Permalink
              jark Jark Wu added a comment -

              Hi, Julian, it's a little more complex. After change the parser, the validator will go into unpredictable error.

              Show
              jark Jark Wu added a comment - Hi, Julian, it's a little more complex. After change the parser, the validator will go into unpredictable error.
              Hide
              Permalink
              julianhyde Julian Hyde added a comment -

              OK, you're right; and maybe SqlToRelConverter will have problems too. When you start on this, could you add some test cases to SqlParserTest, SqlValidatorTest, SqlToRelConverterTest, share the branch you are working on, and maybe I can help.

              Show
              julianhyde Julian Hyde added a comment - OK, you're right; and maybe SqlToRelConverter will have problems too. When you start on this, could you add some test cases to SqlParserTest , SqlValidatorTest , SqlToRelConverterTest , share the branch you are working on, and maybe I can help.
              Hide
              Permalink
              julianhyde Julian Hyde added a comment -

              Fixed in http://git-wip-us.apache.org/repos/asf/calcite/commit/71df67c9. Thanks for the PR, Jark Wu!

              Show
              julianhyde Julian Hyde added a comment - Fixed in http://git-wip-us.apache.org/repos/asf/calcite/commit/71df67c9 . Thanks for the PR, Jark Wu !
              Hide
              Permalink
              jcamachorodriguez Jesus Camacho Rodriguez added a comment -

              Resolved in release 1.9.0 (2016-09-22)

              Show
              jcamachorodriguez Jesus Camacho Rodriguez added a comment - Resolved in release 1.9.0 (2016-09-22)

                People

                • Assignee:
                  julianhyde Julian Hyde
                  Reporter:
                  jark Jark Wu
                • Votes:
                  0 Vote for this issue
                  Watchers:
                  3 Start watching this issue

                  Dates

                  • Created:
                    Updated:
                    Resolved:

                    Development