org.scalatest.exceptions.TestFailedException: Failed to execute converted SQL string or got wrong answer: # Converted SQL query string: SELECT `u_1`.`id` FROM (((SELECT `parquet_t0`.`id` FROM `default`.`parquet_t0`) UNION ALL (SELECT `parquet_t0`.`id` FROM `default`.`parquet_t0`)) UNION ALL (SELECT `parquet_t0`.`id` FROM `default`.`parquet_t0`)) AS u_1 # Original HiveQL query string: SELECT id FROM parquet_t0 UNION ALL SELECT id FROM parquet_t0 UNION ALL SELECT id FROM parquet_t0 # Resolved query plan: Project [id#155980L] +- SubqueryAlias u_1 +- Union :- Union : :- Project [id#155980L] : : +- SubqueryAlias parquet_t0 : : +- Relation[id#155980L] ParquetRelation : +- Project [id#155980L] : +- SubqueryAlias parquet_t0 : +- Relation[id#155980L] ParquetRelation +- Project [id#155980L] +- SubqueryAlias parquet_t0 +- Relation[id#155980L] ParquetRelation
sbt.ForkMain$ForkError: org.scalatest.exceptions.TestFailedException: Failed to execute converted SQL string or got wrong answer:
# Converted SQL query string:
SELECT `u_1`.`id` FROM (((SELECT `parquet_t0`.`id` FROM `default`.`parquet_t0`) UNION ALL (SELECT `parquet_t0`.`id` FROM `default`.`parquet_t0`)) UNION ALL (SELECT `parquet_t0`.`id` FROM `default`.`parquet_t0`)) AS u_1
# Original HiveQL query string:
SELECT id FROM parquet_t0
UNION ALL SELECT id FROM parquet_t0
UNION ALL SELECT id FROM parquet_t0
# Resolved query plan:
Project [id#155980L]
+- SubqueryAlias u_1
+- Union
:- Union
: :- Project [id#155980L]
: : +- SubqueryAlias parquet_t0
: : +- Relation[id#155980L] ParquetRelation
: +- Project [id#155980L]
: +- SubqueryAlias parquet_t0
: +- Relation[id#155980L] ParquetRelation
+- Project [id#155980L]
+- SubqueryAlias parquet_t0
+- Relation[id#155980L] ParquetRelation
at org.scalatest.Assertions$class.newAssertionFailedException(Assertions.scala:496)
at org.scalatest.FunSuite.newAssertionFailedException(FunSuite.scala:1555)
at org.scalatest.Assertions$class.fail(Assertions.scala:1348)
at org.scalatest.FunSuite.fail(FunSuite.scala:1555)
at org.apache.spark.sql.hive.LogicalPlanToSQLSuite.org$apache$spark$sql$hive$LogicalPlanToSQLSuite$$checkHiveQl(LogicalPlanToSQLSuite.scala:76)
at org.apache.spark.sql.hive.LogicalPlanToSQLSuite$$anonfun$9.apply$mcV$sp(LogicalPlanToSQLSuite.scala:134)
at org.apache.spark.sql.hive.LogicalPlanToSQLSuite$$anonfun$9.apply(LogicalPlanToSQLSuite.scala:134)
at org.apache.spark.sql.hive.LogicalPlanToSQLSuite$$anonfun$9.apply(LogicalPlanToSQLSuite.scala:134)
at org.scalatest.Transformer$$anonfun$apply$1.apply$mcV$sp(Transformer.scala:22)
at org.scalatest.OutcomeOf$class.outcomeOf(OutcomeOf.scala:85)
at org.scalatest.OutcomeOf$.outcomeOf(OutcomeOf.scala:104)
at org.scalatest.Transformer.apply(Transformer.scala:22)
at org.scalatest.Transformer.apply(Transformer.scala:20)
at org.scalatest.FunSuiteLike$$anon$1.apply(FunSuiteLike.scala:166)
at org.apache.spark.SparkFunSuite.withFixture(SparkFunSuite.scala:54)
at org.scalatest.FunSuiteLike$class.invokeWithFixture$1(FunSuiteLike.scala:163)
at org.scalatest.FunSuiteLike$$anonfun$runTest$1.apply(FunSuiteLike.scala:175)
at org.scalatest.FunSuiteLike$$anonfun$runTest$1.apply(FunSuiteLike.scala:175)
at org.scalatest.SuperEngine.runTestImpl(Engine.scala:306)
at org.scalatest.FunSuiteLike$class.runTest(FunSuiteLike.scala:175)
at org.scalatest.FunSuite.runTest(FunSuite.scala:1555)
at org.scalatest.FunSuiteLike$$anonfun$runTests$1.apply(FunSuiteLike.scala:208)
at org.scalatest.FunSuiteLike$$anonfun$runTests$1.apply(FunSuiteLike.scala:208)
at org.scalatest.SuperEngine$$anonfun$traverseSubNodes$1$1.apply(Engine.scala:413)
at org.scalatest.SuperEngine$$anonfun$traverseSubNodes$1$1.apply(Engine.scala:401)
at scala.collection.immutable.List.foreach(List.scala:381)
at org.scalatest.SuperEngine.traverseSubNodes$1(Engine.scala:401)
at org.scalatest.SuperEngine.org$scalatest$SuperEngine$$runTestsInBranch(Engine.scala:396)
at org.scalatest.SuperEngine.runTestsImpl(Engine.scala:483)
at org.scalatest.FunSuiteLike$class.runTests(FunSuiteLike.scala:208)
at org.scalatest.FunSuite.runTests(FunSuite.scala:1555)
at org.scalatest.Suite$class.run(Suite.scala:1424)
at org.scalatest.FunSuite.org$scalatest$FunSuiteLike$$super$run(FunSuite.scala:1555)
at org.scalatest.FunSuiteLike$$anonfun$run$1.apply(FunSuiteLike.scala:212)
at org.scalatest.FunSuiteLike$$anonfun$run$1.apply(FunSuiteLike.scala:212)
at org.scalatest.SuperEngine.runImpl(Engine.scala:545)
at org.scalatest.FunSuiteLike$class.run(FunSuiteLike.scala:212)
at org.apache.spark.SparkFunSuite.org$scalatest$BeforeAndAfterAll$$super$run(SparkFunSuite.scala:26)
at org.scalatest.BeforeAndAfterAll$class.liftedTree1$1(BeforeAndAfterAll.scala:257)
at org.scalatest.BeforeAndAfterAll$class.run(BeforeAndAfterAll.scala:256)
at org.apache.spark.SparkFunSuite.run(SparkFunSuite.scala:26)
at org.scalatest.tools.Framework.org$scalatest$tools$Framework$$runSuite(Framework.scala:357)
at org.scalatest.tools.Framework$ScalaTestTask.execute(Framework.scala:502)
at sbt.ForkMain$Run$2.call(ForkMain.java:296)
at sbt.ForkMain$Run$2.call(ForkMain.java:286)
at java.util.concurrent.FutureTask.run(FutureTask.java:262)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
at java.lang.Thread.run(Thread.java:745)
Caused by: sbt.ForkMain$ForkError: org.apache.spark.sql.AnalysisException: MismatchedTokenException(29!=324)
line 1:152 mismatched input 'ALL' expecting ) near 'UNION' in from source
; line 1 pos 152
at org.apache.spark.sql.catalyst.parser.ParseErrorReporter.throwError(ParseDriver.scala:158)
at org.apache.spark.sql.catalyst.parser.ParseErrorReporter.throwError(ParseDriver.scala:147)
at org.apache.spark.sql.catalyst.parser.ParseDriver$.parse(ParseDriver.scala:95)
at org.apache.spark.sql.catalyst.parser.ParseDriver$.parsePlan(ParseDriver.scala:32)
at org.apache.spark.sql.hive.HiveQl.parsePlan(HiveQl.scala:229)
at org.apache.spark.sql.SQLContext.parseSql(SQLContext.scala:211)
at org.apache.spark.sql.hive.HiveContext.org$apache$spark$sql$hive$HiveContext$$super$parseSql(HiveContext.scala:320)
at org.apache.spark.sql.hive.HiveContext$$anonfun$parseSql$1.apply(HiveContext.scala:320)
at org.apache.spark.sql.hive.HiveContext$$anonfun$parseSql$1.apply(HiveContext.scala:320)
at org.apache.spark.sql.hive.client.HiveClientImpl$$anonfun$withHiveState$1.apply(HiveClientImpl.scala:222)
at org.apache.spark.sql.hive.client.HiveClientImpl.liftedTree1$1(HiveClientImpl.scala:169)
at org.apache.spark.sql.hive.client.HiveClientImpl.retryLocked(HiveClientImpl.scala:168)
at org.apache.spark.sql.hive.client.HiveClientImpl.withHiveState(HiveClientImpl.scala:211)
at org.apache.spark.sql.hive.HiveContext.parseSql(HiveContext.scala:319)
at org.apache.spark.sql.SQLContext.sql(SQLContext.scala:799)
at org.apache.spark.sql.test.SQLTestUtils$$anonfun$sql$1.apply(SQLTestUtils.scala:56)
at org.apache.spark.sql.test.SQLTestUtils$$anonfun$sql$1.apply(SQLTestUtils.scala:56)
at org.apache.spark.sql.hive.LogicalPlanToSQLSuite$$anonfun$org$apache$spark$sql$hive$LogicalPlanToSQLSuite$$checkHiveQl$1.apply(LogicalPlanToSQLSuite.scala:74)
at org.apache.spark.sql.hive.LogicalPlanToSQLSuite$$anonfun$org$apache$spark$sql$hive$LogicalPlanToSQLSuite$$checkHiveQl$1.apply(LogicalPlanToSQLSuite.scala:74)
at org.apache.spark.sql.QueryTest.checkAnswer(QueryTest.scala:127)
at org.apache.spark.sql.QueryTest.checkAnswer(QueryTest.scala:153)
at org.apache.spark.sql.hive.LogicalPlanToSQLSuite.org$apache$spark$sql$hive$LogicalPlanToSQLSuite$$checkHiveQl(LogicalPlanToSQLSuite.scala:74)
... 44 more