[
https://issues.apache.org/jira/browse/SPARK-37947?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Wenchen Fan resolved SPARK-37947.
---------------------------------
Fix Version/s: 3.3.0
Resolution: Fixed
Issue resolved by pull request 35232
[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
> Assignee: Bruce Robbins
> Priority: Minor
> Fix For: 3.3.0
>
>
> 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
