[
https://issues.apache.org/jira/browse/SPARK-37519?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Apache Spark reassigned SPARK-37519:
------------------------------------
Assignee: Apache Spark
> Support Relation With LateralView
> ---------------------------------
>
> Key: SPARK-37519
> URL: https://issues.apache.org/jira/browse/SPARK-37519
> Project: Spark
> Issue Type: Improvement
> Components: SQL
> Affects Versions: 3.1.2
> Reporter: Tongwei
> Assignee: Apache Spark
> Priority: Major
>
> {code:java}
> CREATE TABLE person (id INT, name STRING, age INT, class INT, address STRING);
> INSERT INTO person VALUES
> (100, 'John', 30, 1, 'Street 1'),
> (200, 'Mary', NULL, 1, 'Street 2'),
> (300, 'Mike', 80, 3, 'Street 3'),
> (400, 'Dan', 50, 4, 'Street 4');
> SELECT *
> FROM person AS P1
> LATERAL VIEW EXPLODE(ARRAY(30, 60)) CC1 AS C_AGE1
> LEFT JOIN person P2
> LATERAL VIEW EXPLODE(ARRAY(50)) CC2 AS C_AGE2 ON P1.ID = P2.ID AND
> CC1.C_AGE1=P2.AGE;
> {code}
> {code:java}
> Error msg:
> LEFT JOIN person P2 ^^^ LATERAL VIEW EXPLODE(ARRAY(50)) CC2 AS C_AGE2 ON
> P1.ID = P2.ID AND CC1.C_AGE1=P2.AGE
> .........
> at java.lang.Thread.run(Thread.java:748) Caused by:
> org.apache.spark.sql.catalyst.parser.ParseException: mismatched input 'LEFT'
> expecting {<EOF>, ';'}(line 4, pos 0) {code}
--
This message was sent by Atlassian Jira
(v8.20.1#820001)
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
