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