Uploaded image for project: 'Spark'
  1. Spark
  2. SPARK-37947

Cannot use <func>_outer generators in a lateral view

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Resolved
    • Minor
    • Resolution: Fixed
    • 3.3.0
    • 3.3.0
    • SQL
    • None

    Description

      This works:

      select * from values 1, 2 lateral view outer explode(array()) as b;
      

      But this does not work:

      select * from values 1, 2 lateral view explode_outer(array()) as b;
      

      It produces the error:

      Error in query: Column 'b' does not exist. Did you mean one of the following? [col1]; line 1 pos 26;
      

      Similarly, this works:

      select * from values 1, 2
      lateral view outer inline(array(struct(1, 2, 3))) as b, c, d;
      

      But this does not:

      select * from values 1, 2
      lateral view inline_outer(array(struct(1, 2, 3))) as b, c, d;
      

      It produces the error:

      Error in query: Column 'b' does not exist. Did you mean one of the following? [col1]; line 2 pos 0;
      

      Attachments

        Activity

          People

            bersprockets Bruce Robbins
            bersprockets Bruce Robbins
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: