Bruce Robbins created SPARK-37947: ------------------------------------- Summary: Cannot use <func>_outer generators in a lateral view Key: SPARK-37947 URL: https://issues.apache.org/jira/browse/SPARK-37947 Project: Spark Issue Type: Bug Components: SQL Affects Versions: 3.3.0 Reporter: Bruce Robbins
This works: {noformat} select * from values 1, 2 lateral view outer explode(array()) as b; {noformat} But this does not work: {noformat} select * from values 1, 2 lateral view explode_outer(array()) as b; {noformat} It produces the error: {noformat} Error in query: Column 'b' does not exist. Did you mean one of the following? [col1]; line 1 pos 26; {noformat} Similarly, this works: {noformat} select * from values 1, 2 lateral view outer inline(array(struct(1, 2, 3))) as b, c, d; {noformat} But this does not: {noformat} select * from values 1, 2 lateral view inline_outer(array(struct(1, 2, 3))) as b, c, d; {noformat} It produces the error: {noformat} Error in query: Column 'b' does not exist. Did you mean one of the following? [col1]; line 2 pos 0; {noformat} -- This message was sent by Atlassian Jira (v8.20.1#820001) --------------------------------------------------------------------- To unsubscribe, e-mail: issues-unsubscr...@spark.apache.org For additional commands, e-mail: issues-h...@spark.apache.org