org.scalatest.exceptions.TestFailedException: Results do not match for query: Timezone: sun.util.calendar.ZoneInfo[id="America/Los_Angeles",offset=-28800000,dstSavings=3600000,useDaylight=true,transitions=185,lastRule=java.util.SimpleTimeZone[id=America/Los_Angeles,offset=-28800000,dstSavings=3600000,useDaylight=true,startYear=0,startMode=3,startMonth=2,startDay=8,startDayOfWeek=1,startTime=7200000,startTimeMode=0,endMode=3,endMonth=10,endDay=1,endDayOfWeek=1,endTime=7200000,endTimeMode=0]] Timezone Env: == Parsed Logical Plan == 'Project ['val] +- 'Filter ('Year = 2012) +- 'UnresolvedRelation `tbl10562` == Analyzed Logical Plan == val: string Project [val#158354] +- Filter (Year#158355 = 2012) +- SubqueryAlias tbl10562 +- Relation[val#158354,Year#158355] parquet == Optimized Logical Plan == Project [val#158354] +- Filter (isnotnull(Year#158355) && (Year#158355 = 2012)) +- Relation[val#158354,Year#158355] parquet == Physical Plan == *Project [val#158354] +- *FileScan parquet default.tbl10562[val#158354,Year#158355] Batched: true, Format: ParquetFormat, Location: PrunedInMemoryFileIndex[], PartitionCount: 0, PartitionFilters: [isnotnull(Year#158355), (Year#158355 = 2012)], PushedFilters: [], ReadSchema: struct<val:string> == Results == == Results == !== Correct Answer - 1 == == Spark Answer - 0 == ![a]
sbt.ForkMain$ForkError: org.scalatest.exceptions.TestFailedException:
Results do not match for query:
Timezone: sun.util.calendar.ZoneInfo[id="America/Los_Angeles",offset=-28800000,dstSavings=3600000,useDaylight=true,transitions=185,lastRule=java.util.SimpleTimeZone[id=America/Los_Angeles,offset=-28800000,dstSavings=3600000,useDaylight=true,startYear=0,startMode=3,startMonth=2,startDay=8,startDayOfWeek=1,startTime=7200000,startTimeMode=0,endMode=3,endMonth=10,endDay=1,endDayOfWeek=1,endTime=7200000,endTimeMode=0]]
Timezone Env:
== Parsed Logical Plan ==
'Project ['val]
+- 'Filter ('Year = 2012)
+- 'UnresolvedRelation `tbl10562`
== Analyzed Logical Plan ==
val: string
Project [val#158354]
+- Filter (Year#158355 = 2012)
+- SubqueryAlias tbl10562
+- Relation[val#158354,Year#158355] parquet
== Optimized Logical Plan ==
Project [val#158354]
+- Filter (isnotnull(Year#158355) && (Year#158355 = 2012))
+- Relation[val#158354,Year#158355] parquet
== Physical Plan ==
*Project [val#158354]
+- *FileScan parquet default.tbl10562[val#158354,Year#158355] Batched: true, Format: ParquetFormat, Location: PrunedInMemoryFileIndex[], PartitionCount: 0, PartitionFilters: [isnotnull(Year#158355), (Year#158355 = 2012)], PushedFilters: [], ReadSchema: struct<val:string>
== Results ==
== Results ==
!== Correct Answer - 1 == == Spark Answer - 0 ==
![a]
at org.scalatest.Assertions$class.newAssertionFailedException(Assertions.scala:495)
at org.scalatest.FunSuite.newAssertionFailedException(FunSuite.scala:1555)
at org.scalatest.Assertions$class.fail(Assertions.scala:1328)
at org.scalatest.FunSuite.fail(FunSuite.scala:1555)
at org.apache.spark.sql.QueryTest.checkAnswer(QueryTest.scala:173)
at org.apache.spark.sql.QueryTest.checkAnswer(QueryTest.scala:179)
at org.apache.spark.sql.hive.execution.SQLQuerySuite$$anonfun$78$$anonfun$apply$mcV$sp$24.apply$mcV$sp(SQLQuerySuite.scala:1581)
at org.apache.spark.sql.test.SQLTestUtils$class.withTable(SQLTestUtils.scala:168)
at org.apache.spark.sql.hive.execution.SQLQuerySuite.withTable(SQLQuerySuite.scala:67)
at org.apache.spark.sql.hive.execution.SQLQuerySuite$$anonfun$78.apply$mcV$sp(SQLQuerySuite.scala:1573)
at org.apache.spark.sql.hive.execution.SQLQuerySuite$$anonfun$78.apply(SQLQuerySuite.scala:1573)
at org.apache.spark.sql.hive.execution.SQLQuerySuite$$anonfun$78.apply(SQLQuerySuite.scala:1573)
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:68)
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:31)
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:31)
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:266)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
at java.lang.Thread.run(Thread.java:745)