[jira] [Assigned] (SPARK-37947) Cannot use _outer generators in a lateral view

["Wenchen Fan (Jira)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/SPARK-37947?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Wenchen Fan reassigned SPARK-37947:
-----------------------------------

    Assignee: Bruce Robbins

> 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
>
> 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-unsubscribe@spark.apache.org
For additional commands, e-mail: issues-help@spark.apache.org