jiang13021 created SPARK-42552:
----------------------------------
Summary: Got ParseException when run sql: "SELECT 1 UNION SELECT
1;"
Key: SPARK-42552
URL: https://issues.apache.org/jira/browse/SPARK-42552
Project: Spark
Issue Type: Bug
Components: SQL
Affects Versions: 3.2.3
Environment: Scala version 2.12.15 (OpenJDK 64-Bit Server VM, Java
1.8.0_345)
Spark version 3.2.3-SNAPSHOT
Reporter: jiang13021
Fix For: 3.2.3
When I run sql
{code:java}
scala> spark.sql("SELECT 1 UNION SELECT 1;") {code}
I get ParseException:
{code:java}
org.apache.spark.sql.catalyst.parser.ParseException:
mismatched input 'SELECT' expecting {<EOF>, ';'}(line 1, pos 15)== SQL ==
SELECT 1 UNION SELECT 1;
---------------^^^ at
org.apache.spark.sql.catalyst.parser.ParseException.withCommand(ParseDriver.scala:266)
at
org.apache.spark.sql.catalyst.parser.AbstractSqlParser.parse(ParseDriver.scala:127)
at
org.apache.spark.sql.execution.SparkSqlParser.parse(SparkSqlParser.scala:51)
at
org.apache.spark.sql.catalyst.parser.AbstractSqlParser.parsePlan(ParseDriver.scala:77)
at org.apache.spark.sql.SparkSession.$anonfun$sql$2(SparkSession.scala:616)
at
org.apache.spark.sql.catalyst.QueryPlanningTracker.measurePhase(QueryPlanningTracker.scala:111)
at org.apache.spark.sql.SparkSession.$anonfun$sql$1(SparkSession.scala:616)
at org.apache.spark.sql.SparkSession.withActive(SparkSession.scala:775)
at org.apache.spark.sql.SparkSession.sql(SparkSession.scala:613)
... 47 elided
{code}
If I run with parentheses , it works well
{code:java}
scala> spark.sql("(SELECT 1) UNION (SELECT 1);")
res4: org.apache.spark.sql.DataFrame = [1: int]{code}
This should be a bug
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
