[
https://issues.apache.org/jira/browse/SPARK-37519?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Tongwei updated SPARK-37519:
----------------------------
Description:
{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}
was:
{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}
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)
> 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-unsubscr...@spark.apache.org
For additional commands, e-mail: issues-h...@spark.apache.org
