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

          Activity

          Hide
          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
          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
          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
          julianhyde Julian Hyde added a comment -
          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
          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