You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@spark.apache.org by "Apache Spark (Jira)" <ji...@apache.org> on 2021/12/03 03:36:00 UTC
[jira] [Assigned] (SPARK-37519) Support Relation With LateralView
[ https://issues.apache.org/jira/browse/SPARK-37519?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Apache Spark reassigned SPARK-37519:
------------------------------------
Assignee: (was: 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
> 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: issues-unsubscribe@spark.apache.org
For additional commands, e-mail: issues-help@spark.apache.org