[
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: [email protected]
For additional commands, e-mail: [email protected]
