[ https://issues.apache.org/jira/browse/SPARK-37947?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17477424#comment-17477424 ]
Apache Spark commented on SPARK-37947: -------------------------------------- User 'bersprockets' has created a pull request for this issue: https://github.com/apache/spark/pull/35232 > 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 > Priority: Minor > > 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