org.scalatest.exceptions.TestFailedException: Failed to execute query using catalyst: Error: execute, tree: Exchange rangepartitioning(s#153582 ASC NULLS FIRST, rn#153573 DESC NULLS LAST, 5) +- *(2) Project [s#153582, rn#153573] +- Window [row_number() windowspecdefinition(d#153580, dec#153584 ASC NULLS FIRST, specifiedwindowframe(RowFrame, unboundedpreceding$(), currentrow$())) AS rn#153573], [d#153580], [dec#153584 ASC NULLS FIRST] +- *(1) Sort [d#153580 ASC NULLS FIRST, dec#153584 ASC NULLS FIRST], false, 0 +- Exchange hashpartitioning(d#153580, 5) +- Scan hive default.over1k [s#153582, d#153580, dec#153584], HiveTableRelation `default`.`over1k`, org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe, [t#153575, si#153576, i#153577, b#153578L, f#153579, d#153580, bo#153581, s#153582, ts#153583, dec#153584, bin#153585] org.apache.spark.sql.catalyst.errors.package$TreeNodeException: execute, tree: Exchange rangepartitioning(s#153582 ASC NULLS FIRST, rn#153573 DESC NULLS LAST, 5) +- *(2) Project [s#153582, rn#153573] +- Window [row_number() windowspecdefinition(d#153580, dec#153584 ASC NULLS FIRST, specifiedwindowframe(RowFrame, unboundedpreceding$(), currentrow$())) AS rn#153573], [d#153580], [dec#153584 ASC NULLS FIRST] +- *(1) Sort [d#153580 ASC NULLS FIRST, dec#153584 ASC NULLS FIRST], false, 0 +- Exchange hashpartitioning(d#153580, 5) +- Scan hive default.over1k [s#153582, d#153580, dec#153584], HiveTableRelation `default`.`over1k`, org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe, [t#153575, si#153576, i#153577, b#153578L, f#153579, d#153580, bo#153581, s#153582, ts#153583, dec#153584, bin#153585] at org.apache.spark.sql.catalyst.errors.package$.attachTree(package.scala:56) at org.apache.spark.sql.execution.exchange.ShuffleExchangeExec.doExecute(ShuffleExchangeExec.scala:119) at org.apache.spark.sql.execution.SparkPlan$$anonfun$execute$1.apply(SparkPlan.scala:131) at org.apache.spark.sql.execution.SparkPlan$$anonfun$execute$1.apply(SparkPlan.scala:127) at org.apache.spark.sql.execution.SparkPlan$$anonfun$executeQuery$1.apply(SparkPlan.scala:155) at org.apache.spark.rdd.RDDOperationScope$.withScope(RDDOperationScope.scala:151) at org.apache.spark.sql.execution.SparkPlan.executeQuery(SparkPlan.scala:152) at org.apache.spark.sql.execution.SparkPlan.execute(SparkPlan.scala:127) at org.apache.spark.sql.execution.InputAdapter.inputRDDs(WholeStageCodegenExec.scala:374) at org.apache.spark.sql.execution.SortExec.inputRDDs(SortExec.scala:121) at org.apache.spark.sql.execution.WholeStageCodegenExec.doExecute(WholeStageCodegenExec.scala:610) at org.apache.spark.sql.execution.SparkPlan$$anonfun$execute$1.apply(SparkPlan.scala:131) at org.apache.spark.sql.execution.SparkPlan$$anonfun$execute$1.apply(SparkPlan.scala:127) at org.apache.spark.sql.execution.SparkPlan$$anonfun$executeQuery$1.apply(SparkPlan.scala:155) at org.apache.spark.rdd.RDDOperationScope$.withScope(RDDOperationScope.scala:151) at org.apache.spark.sql.execution.SparkPlan.executeQuery(SparkPlan.scala:152) at org.apache.spark.sql.execution.SparkPlan.execute(SparkPlan.scala:127) at org.apache.spark.sql.execution.SparkPlan.getByteArrayRdd(SparkPlan.scala:247) at org.apache.spark.sql.execution.SparkPlan.executeCollect(SparkPlan.scala:294) at org.apache.spark.sql.execution.SparkPlan.executeCollectPublic(SparkPlan.scala:324) at org.apache.spark.sql.execution.QueryExecution.hiveResultString(QueryExecution.scala:121) at org.apache.spark.sql.hive.execution.HiveComparisonTest$$anonfun$createQueryTest$6$$anonfun$25$$anonfun$getResult$1$1.apply(HiveComparisonTest.scala:348) at org.apache.spark.sql.hive.execution.HiveComparisonTest$$anonfun$createQueryTest$6$$anonfun$25$$anonfun$getResult$1$1.apply(HiveComparisonTest.scala:348) at org.apache.spark.sql.execution.SQLExecution$$anonfun$withNewExecutionId$1.apply(SQLExecution.scala:78) at org.apache.spark.sql.execution.SQLExecution$.withSQLConfPropagated(SQLExecution.scala:125) at org.apache.spark.sql.execution.SQLExecution$.withNewExecutionId(SQLExecution.scala:73) at org.apache.spark.sql.hive.execution.HiveComparisonTest$$anonfun$createQueryTest$6$$anonfun$25.getResult$1(HiveComparisonTest.scala:348) at org.apache.spark.sql.hive.execution.HiveComparisonTest$$anonfun$createQueryTest$6$$anonfun$25.apply(HiveComparisonTest.scala:350) at org.apache.spark.sql.hive.execution.HiveComparisonTest$$anonfun$createQueryTest$6$$anonfun$25.apply(HiveComparisonTest.scala:345) at scala.collection.TraversableLike$$anonfun$map$1.apply(TraversableLike.scala:234) at scala.collection.TraversableLike$$anonfun$map$1.apply(TraversableLike.scala:234) at scala.collection.mutable.ResizableArray$class.foreach(ResizableArray.scala:59) at scala.collection.mutable.ArrayBuffer.foreach(ArrayBuffer.scala:48) at scala.collection.TraversableLike$class.map(TraversableLike.scala:234) at scala.collection.AbstractTraversable.map(Traversable.scala:104) at org.apache.spark.sql.hive.execution.HiveComparisonTest$$anonfun$createQueryTest$6.doTest$1(HiveComparisonTest.scala:345) at org.apache.spark.sql.hive.execution.HiveComparisonTest$$anonfun$createQueryTest$6.apply(HiveComparisonTest.scala:462) 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:186) at org.apache.spark.SparkFunSuite.withFixture(SparkFunSuite.scala:103) at org.scalatest.FunSuiteLike$class.invokeWithFixture$1(FunSuiteLike.scala:183) at org.scalatest.FunSuiteLike$$anonfun$runTest$1.apply(FunSuiteLike.scala:196) at org.scalatest.FunSuiteLike$$anonfun$runTest$1.apply(FunSuiteLike.scala:196) at org.scalatest.SuperEngine.runTestImpl(Engine.scala:289) at org.scalatest.FunSuiteLike$class.runTest(FunSuiteLike.scala:196) at org.apache.spark.sql.hive.execution.HiveWindowFunctionQuerySuite.org$scalatest$BeforeAndAfter$$super$runTest(HiveWindowFunctionQuerySuite.scala:35) at org.scalatest.BeforeAndAfter$class.runTest(BeforeAndAfter.scala:203) at org.apache.spark.sql.hive.execution.HiveWindowFunctionQuerySuite.runTest(HiveWindowFunctionQuerySuite.scala:35) at org.scalatest.FunSuiteLike$$anonfun$runTests$1.apply(FunSuiteLike.scala:229) at org.scalatest.FunSuiteLike$$anonfun$runTests$1.apply(FunSuiteLike.scala:229) at org.scalatest.SuperEngine$$anonfun$traverseSubNodes$1$1.apply(Engine.scala:396) at org.scalatest.SuperEngine$$anonfun$traverseSubNodes$1$1.apply(Engine.scala:384) at scala.collection.immutable.List.foreach(List.scala:392) at org.scalatest.SuperEngine.traverseSubNodes$1(Engine.scala:384) at org.scalatest.SuperEngine.org$scalatest$SuperEngine$$runTestsInBranch(Engine.scala:379) at org.scalatest.SuperEngine.runTestsImpl(Engine.scala:461) at org.scalatest.FunSuiteLike$class.runTests(FunSuiteLike.scala:229) at org.scalatest.FunSuite.runTests(FunSuite.scala:1560) at org.scalatest.Suite$class.run(Suite.scala:1147) at org.scalatest.FunSuite.org$scalatest$FunSuiteLike$$super$run(FunSuite.scala:1560) at org.scalatest.FunSuiteLike$$anonfun$run$1.apply(FunSuiteLike.scala:233) at org.scalatest.FunSuiteLike$$anonfun$run$1.apply(FunSuiteLike.scala:233) at org.scalatest.SuperEngine.runImpl(Engine.scala:521) at org.scalatest.FunSuiteLike$class.run(FunSuiteLike.scala:233) at org.apache.spark.SparkFunSuite.org$scalatest$BeforeAndAfterAll$$super$run(SparkFunSuite.scala:52) at org.scalatest.BeforeAndAfterAll$class.liftedTree1$1(BeforeAndAfterAll.scala:213) at org.scalatest.BeforeAndAfterAll$class.run(BeforeAndAfterAll.scala:210) at org.apache.spark.sql.hive.execution.HiveWindowFunctionQuerySuite.org$scalatest$BeforeAndAfter$$super$run(HiveWindowFunctionQuerySuite.scala:35) at org.scalatest.BeforeAndAfter$class.run(BeforeAndAfter.scala:258) at org.apache.spark.sql.hive.execution.HiveWindowFunctionQuerySuite.run(HiveWindowFunctionQuerySuite.scala:35) at org.scalatest.tools.Framework.org$scalatest$tools$Framework$$runSuite(Framework.scala:314) at org.scalatest.tools.Framework$ScalaTestTask.execute(Framework.scala:480) 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:1149) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) at java.lang.Thread.run(Thread.java:748) Caused by: org.apache.spark.sql.catalyst.errors.package$TreeNodeException: execute, tree: Exchange hashpartitioning(d#153580, 5) +- Scan hive default.over1k [s#153582, d#153580, dec#153584], HiveTableRelation `default`.`over1k`, org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe, [t#153575, si#153576, i#153577, b#153578L, f#153579, d#153580, bo#153581, s#153582, ts#153583, dec#153584, bin#153585] at org.apache.spark.sql.catalyst.errors.package$.attachTree(package.scala:56) at org.apache.spark.sql.execution.exchange.ShuffleExchangeExec.doExecute(ShuffleExchangeExec.scala:119) at org.apache.spark.sql.execution.SparkPlan$$anonfun$execute$1.apply(SparkPlan.scala:131) at org.apache.spark.sql.execution.SparkPlan$$anonfun$execute$1.apply(SparkPlan.scala:127) at org.apache.spark.sql.execution.SparkPlan$$anonfun$executeQuery$1.apply(SparkPlan.scala:155) at org.apache.spark.rdd.RDDOperationScope$.withScope(RDDOperationScope.scala:151) at org.apache.spark.sql.execution.SparkPlan.executeQuery(SparkPlan.scala:152) at org.apache.spark.sql.execution.SparkPlan.execute(SparkPlan.scala:127) at org.apache.spark.sql.execution.InputAdapter.inputRDDs(WholeStageCodegenExec.scala:374) at org.apache.spark.sql.execution.SortExec.inputRDDs(SortExec.scala:121) at org.apache.spark.sql.execution.WholeStageCodegenExec.doExecute(WholeStageCodegenExec.scala:610) at org.apache.spark.sql.execution.SparkPlan$$anonfun$execute$1.apply(SparkPlan.scala:131) at org.apache.spark.sql.execution.SparkPlan$$anonfun$execute$1.apply(SparkPlan.scala:127) at org.apache.spark.sql.execution.SparkPlan$$anonfun$executeQuery$1.apply(SparkPlan.scala:155) at org.apache.spark.rdd.RDDOperationScope$.withScope(RDDOperationScope.scala:151) at org.apache.spark.sql.execution.SparkPlan.executeQuery(SparkPlan.scala:152) at org.apache.spark.sql.execution.SparkPlan.execute(SparkPlan.scala:127) at org.apache.spark.sql.execution.window.WindowExec.doExecute(WindowExec.scala:302) at org.apache.spark.sql.execution.SparkPlan$$anonfun$execute$1.apply(SparkPlan.scala:131) at org.apache.spark.sql.execution.SparkPlan$$anonfun$execute$1.apply(SparkPlan.scala:127) at org.apache.spark.sql.execution.SparkPlan$$anonfun$executeQuery$1.apply(SparkPlan.scala:155) at org.apache.spark.rdd.RDDOperationScope$.withScope(RDDOperationScope.scala:151) at org.apache.spark.sql.execution.SparkPlan.executeQuery(SparkPlan.scala:152) at org.apache.spark.sql.execution.SparkPlan.execute(SparkPlan.scala:127) at org.apache.spark.sql.execution.InputAdapter.inputRDDs(WholeStageCodegenExec.scala:374) at org.apache.spark.sql.execution.ProjectExec.inputRDDs(basicPhysicalOperators.scala:41) at org.apache.spark.sql.execution.WholeStageCodegenExec.doExecute(WholeStageCodegenExec.scala:610) at org.apache.spark.sql.execution.SparkPlan$$anonfun$execute$1.apply(SparkPlan.scala:131) at org.apache.spark.sql.execution.SparkPlan$$anonfun$execute$1.apply(SparkPlan.scala:127) at org.apache.spark.sql.execution.SparkPlan$$anonfun$executeQuery$1.apply(SparkPlan.scala:155) at org.apache.spark.rdd.RDDOperationScope$.withScope(RDDOperationScope.scala:151) at org.apache.spark.sql.execution.SparkPlan.executeQuery(SparkPlan.scala:152) at org.apache.spark.sql.execution.SparkPlan.execute(SparkPlan.scala:127) at org.apache.spark.sql.execution.exchange.ShuffleExchangeExec.prepareShuffleDependency(ShuffleExchangeExec.scala:92) at org.apache.spark.sql.execution.exchange.ShuffleExchangeExec$$anonfun$doExecute$1.apply(ShuffleExchangeExec.scala:128) at org.apache.spark.sql.execution.exchange.ShuffleExchangeExec$$anonfun$doExecute$1.apply(ShuffleExchangeExec.scala:119) at org.apache.spark.sql.catalyst.errors.package$.attachTree(package.scala:52) ... 80 more Caused by: java.lang.IllegalStateException: Cannot call methods on a stopped SparkContext. This stopped SparkContext was created at: org.apache.spark.sql.hive.execution.HiveComparisonTest$$anonfun$createQueryTest$6.apply(HiveComparisonTest.scala:456) org.scalatest.OutcomeOf$class.outcomeOf(OutcomeOf.scala:85) org.scalatest.OutcomeOf$.outcomeOf(OutcomeOf.scala:104) org.scalatest.Transformer.apply(Transformer.scala:22) org.scalatest.Transformer.apply(Transformer.scala:20) org.scalatest.FunSuiteLike$$anon$1.apply(FunSuiteLike.scala:186) org.apache.spark.SparkFunSuite.withFixture(SparkFunSuite.scala:103) org.scalatest.FunSuiteLike$class.invokeWithFixture$1(FunSuiteLike.scala:183) org.scalatest.FunSuiteLike$$anonfun$runTest$1.apply(FunSuiteLike.scala:196) org.scalatest.FunSuiteLike$$anonfun$runTest$1.apply(FunSuiteLike.scala:196) org.scalatest.SuperEngine.runTestImpl(Engine.scala:289) org.scalatest.FunSuiteLike$class.runTest(FunSuiteLike.scala:196) org.scalatest.FunSuite.runTest(FunSuite.scala:1560) org.scalatest.FunSuiteLike$$anonfun$runTests$1.apply(FunSuiteLike.scala:229) org.scalatest.FunSuiteLike$$anonfun$runTests$1.apply(FunSuiteLike.scala:229) org.scalatest.SuperEngine$$anonfun$traverseSubNodes$1$1.apply(Engine.scala:396) org.scalatest.SuperEngine$$anonfun$traverseSubNodes$1$1.apply(Engine.scala:384) scala.collection.immutable.List.foreach(List.scala:392) org.scalatest.SuperEngine.traverseSubNodes$1(Engine.scala:384) org.scalatest.SuperEngine.org$scalatest$SuperEngine$$runTestsInBranch(Engine.scala:379) The currently active SparkContext was created at: (No active SparkContext.) at org.apache.spark.SparkContext.assertNotStopped(SparkContext.scala:100) at org.apache.spark.SparkContext.broadcast(SparkContext.scala:1492) at org.apache.spark.sql.hive.HadoopTableReader.<init>(TableReader.scala:89) at org.apache.spark.sql.hive.execution.HiveTableScanExec.org$apache$spark$sql$hive$execution$HiveTableScanExec$$hadoopReader$lzycompute(HiveTableScanExec.scala:105) at org.apache.spark.sql.hive.execution.HiveTableScanExec.org$apache$spark$sql$hive$execution$HiveTableScanExec$$hadoopReader(HiveTableScanExec.scala:105) at org.apache.spark.sql.hive.execution.HiveTableScanExec$$anonfun$10.apply(HiveTableScanExec.scala:188) at org.apache.spark.sql.hive.execution.HiveTableScanExec$$anonfun$10.apply(HiveTableScanExec.scala:188) at org.apache.spark.util.Utils$.withDummyCallSite(Utils.scala:2457) at org.apache.spark.sql.hive.execution.HiveTableScanExec.doExecute(HiveTableScanExec.scala:187) at org.apache.spark.sql.execution.SparkPlan$$anonfun$execute$1.apply(SparkPlan.scala:131) at org.apache.spark.sql.execution.SparkPlan$$anonfun$execute$1.apply(SparkPlan.scala:127) at org.apache.spark.sql.execution.SparkPlan$$anonfun$executeQuery$1.apply(SparkPlan.scala:155) at org.apache.spark.rdd.RDDOperationScope$.withScope(RDDOperationScope.scala:151) at org.apache.spark.sql.execution.SparkPlan.executeQuery(SparkPlan.scala:152) at org.apache.spark.sql.execution.SparkPlan.execute(SparkPlan.scala:127) at org.apache.spark.sql.execution.exchange.ShuffleExchangeExec.prepareShuffleDependency(ShuffleExchangeExec.scala:92) at org.apache.spark.sql.execution.exchange.ShuffleExchangeExec$$anonfun$doExecute$1.apply(ShuffleExchangeExec.scala:128) at org.apache.spark.sql.execution.exchange.ShuffleExchangeExec$$anonfun$doExecute$1.apply(ShuffleExchangeExec.scala:119) at org.apache.spark.sql.catalyst.errors.package$.attachTree(package.scala:52) ... 116 more select s, row_number() over (partition by d order by dec) rn from over1k order by s, rn desc == Parsed Logical Plan == 'Sort ['s ASC NULLS FIRST, 'rn DESC NULLS LAST], true +- 'Project ['s, 'row_number() windowspecdefinition('d, 'dec ASC NULLS FIRST, unspecifiedframe$()) AS rn#153573] +- 'UnresolvedRelation `over1k` == Analyzed Logical Plan == s: string, rn: int Sort [s#153582 ASC NULLS FIRST, rn#153573 DESC NULLS LAST], true +- Project [s#153582, rn#153573] +- Project [s#153582, d#153580, dec#153584, rn#153573, rn#153573] +- Window [row_number() windowspecdefinition(d#153580, dec#153584 ASC NULLS FIRST, specifiedwindowframe(RowFrame, unboundedpreceding$(), currentrow$())) AS rn#153573], [d#153580], [dec#153584 ASC NULLS FIRST] +- Project [s#153582, d#153580, dec#153584] +- SubqueryAlias `default`.`over1k` +- HiveTableRelation `default`.`over1k`, org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe, [t#153575, si#153576, i#153577, b#153578L, f#153579, d#153580, bo#153581, s#153582, ts#153583, dec#153584, bin#153585] == Optimized Logical Plan == Sort [s#153582 ASC NULLS FIRST, rn#153573 DESC NULLS LAST], true +- Project [s#153582, rn#153573] +- Window [row_number() windowspecdefinition(d#153580, dec#153584 ASC NULLS FIRST, specifiedwindowframe(RowFrame, unboundedpreceding$(), currentrow$())) AS rn#153573], [d#153580], [dec#153584 ASC NULLS FIRST] +- Project [s#153582, d#153580, dec#153584] +- HiveTableRelation `default`.`over1k`, org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe, [t#153575, si#153576, i#153577, b#153578L, f#153579, d#153580, bo#153581, s#153582, ts#153583, dec#153584, bin#153585] == Physical Plan == *(3) Sort [s#153582 ASC NULLS FIRST, rn#153573 DESC NULLS LAST], true, 0 +- Exchange rangepartitioning(s#153582 ASC NULLS FIRST, rn#153573 DESC NULLS LAST, 5) +- *(2) Project [s#153582, rn#153573] +- Window [row_number() windowspecdefinition(d#153580, dec#153584 ASC NULLS FIRST, specifiedwindowframe(RowFrame, unboundedpreceding$(), currentrow$())) AS rn#153573], [d#153580], [dec#153584 ASC NULLS FIRST] +- *(1) Sort [d#153580 ASC NULLS FIRST, dec#153584 ASC NULLS FIRST], false, 0 +- Exchange hashpartitioning(d#153580, 5) +- Scan hive default.over1k [s#153582, d#153580, dec#153584], HiveTableRelation `default`.`over1k`, org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe, [t#153575, si#153576, i#153577, b#153578L, f#153579, d#153580, bo#153581, s#153582, ts#153583, dec#153584, bin#153585] == HIVE - 1049 row(s) == 1 1 1 alice allen 2 alice allen 1 alice allen 1 alice brown 1 alice carson 1 alice davidson 1 alice falkner 1 alice garcia 1 alice hernandez 2 alice hernandez 1 alice johnson 2 alice king 1 alice king 1 alice king 1 alice laertes 1 alice laertes 1 alice miller 1 alice nixon 1 alice nixon 1 alice nixon 1 alice ovid 1 alice polk 3 alice quirinius 1 alice quirinius 1 alice robinson 1 alice robinson 1 alice steinbeck 1 alice steinbeck 1 alice steinbeck 1 alice underhill 2 alice van buren 1 alice xylophone 1 alice xylophone 1 alice xylophone 1 alice zipper 1 alice zipper 1 alice zipper 1 bob brown 1 bob brown 1 bob brown 1 bob carson 1 bob davidson 1 bob davidson 1 bob davidson 1 bob ellison 2 bob ellison 1 bob ellison 1 bob ellison 1 bob falkner 1 bob garcia 1 bob garcia 1 bob garcia 1 bob garcia 1 bob garcia 1 bob hernandez 1 bob ichabod 1 bob king 2 bob king 1 bob king 1 bob laertes 2 bob laertes 1 bob miller 1 bob ovid 1 bob ovid 1 bob ovid 1 bob ovid 1 bob polk 1 bob quirinius 1 bob steinbeck 1 bob van buren 1 bob white 1 bob white 1 bob xylophone 1 bob xylophone 1 bob young 1 bob zipper 2 bob zipper 1 bob zipper 1 calvin allen 1 calvin brown 2 calvin brown 1 calvin brown 1 calvin carson 2 calvin davidson 2 calvin davidson 1 calvin ellison 1 calvin falkner 1 calvin falkner 1 calvin falkner 1 calvin falkner 1 calvin falkner 1 calvin falkner 1 calvin garcia 1 calvin hernandez 2 calvin johnson 1 calvin laertes 1 calvin laertes 1 calvin nixon 3 calvin nixon 1 calvin nixon 1 calvin ovid 1 calvin ovid 1 calvin ovid 1 calvin ovid 1 calvin polk 1 calvin quirinius 1 calvin quirinius 1 calvin robinson 2 calvin steinbeck 1 calvin steinbeck 1 calvin steinbeck 1 calvin thompson 1 calvin thompson 1 calvin underhill 1 calvin van buren 1 calvin van buren 1 calvin white 1 calvin white 1 calvin xylophone 2 calvin xylophone 1 calvin xylophone 1 calvin young 1 calvin young 1 calvin zipper 1 calvin zipper 1 david allen 1 david allen 1 david brown 1 david brown 1 david davidson 1 david davidson 1 david davidson 1 david davidson 1 david ellison 1 david ellison 1 david ellison 1 david hernandez 1 david ichabod 1 david ichabod 1 david laertes 1 david nixon 1 david ovid 1 david ovid 1 david quirinius 1 david quirinius 1 david quirinius 1 david robinson 1 david robinson 1 david thompson 3 david underhill 1 david underhill 1 david underhill 1 david van buren 1 david van buren 1 david white 1 david xylophone 1 david xylophone 1 david xylophone 1 david young 1 david young 1 ethan allen 1 ethan brown 2 ethan brown 2 ethan brown 1 ethan brown 1 ethan brown 1 ethan brown 1 ethan carson 1 ethan ellison 1 ethan ellison 1 ethan falkner 3 ethan falkner 1 ethan garcia 1 ethan hernandez 1 ethan johnson 1 ethan king 1 ethan laertes 1 ethan laertes 1 ethan laertes 1 ethan laertes 1 ethan laertes 1 ethan laertes 1 ethan laertes 1 ethan miller 2 ethan nixon 1 ethan ovid 1 ethan polk 2 ethan polk 1 ethan polk 1 ethan polk 1 ethan quirinius 1 ethan quirinius 1 ethan quirinius 1 ethan robinson 1 ethan robinson 1 ethan underhill 1 ethan van buren 2 ethan white 1 ethan white 1 ethan xylophone 1 ethan zipper 1 ethan zipper 1 fred davidson 1 fred davidson 1 fred davidson 1 fred ellison 1 fred ellison 1 fred ellison 1 fred falkner 2 fred falkner 1 fred falkner 1 fred hernandez 1 fred ichabod 1 fred ichabod 1 fred johnson 1 fred king 2 fred king 1 fred laertes 1 fred miller 1 fred nixon 2 fred nixon 1 fred nixon 1 fred nixon 1 fred polk 1 fred polk 1 fred polk 1 fred polk 1 fred quirinius 1 fred quirinius 1 fred robinson 1 fred steinbeck 1 fred steinbeck 1 fred steinbeck 1 fred underhill 1 fred van buren 1 fred van buren 1 fred van buren 1 fred van buren 1 fred white 1 fred young 3 fred young 1 fred zipper 1 gabriella allen 1 gabriella allen 1 gabriella brown 2 gabriella brown 1 gabriella carson 1 gabriella davidson 1 gabriella ellison 1 gabriella ellison 1 gabriella falkner 1 gabriella falkner 1 gabriella falkner 1 gabriella garcia 1 gabriella hernandez 1 gabriella hernandez 1 gabriella ichabod 1 gabriella ichabod 1 gabriella ichabod 1 gabriella ichabod 1 gabriella ichabod 1 gabriella king 1 gabriella king 1 gabriella laertes 1 gabriella miller 1 gabriella ovid 1 gabriella ovid 1 gabriella polk 1 gabriella polk 1 gabriella steinbeck 1 gabriella steinbeck 1 gabriella thompson 1 gabriella thompson 1 gabriella thompson 1 gabriella van buren 2 gabriella van buren 1 gabriella white 1 gabriella young 1 gabriella young 1 gabriella zipper 1 gabriella zipper 1 holly allen 1 holly brown 1 holly brown 1 holly falkner 1 holly hernandez 1 holly hernandez 1 holly hernandez 1 holly hernandez 1 holly ichabod 1 holly ichabod 1 holly ichabod 1 holly johnson 2 holly johnson 1 holly johnson 1 holly king 1 holly king 1 holly laertes 1 holly miller 1 holly nixon 1 holly nixon 1 holly polk 2 holly polk 1 holly robinson 2 holly thompson 1 holly thompson 1 holly thompson 1 holly underhill 1 holly underhill 1 holly underhill 1 holly underhill 1 holly van buren 1 holly white 1 holly white 1 holly xylophone 1 holly young 1 holly young 1 holly zipper 1 holly zipper 1 irene allen 1 irene brown 1 irene brown 1 irene brown 1 irene carson 1 irene ellison 1 irene ellison 1 irene falkner 1 irene falkner 1 irene garcia 1 irene garcia 1 irene garcia 1 irene ichabod 1 irene ichabod 1 irene johnson 2 irene laertes 1 irene laertes 1 irene laertes 1 irene miller 2 irene nixon 1 irene nixon 1 irene nixon 1 irene ovid 1 irene ovid 1 irene ovid 1 irene polk 1 irene polk 1 irene polk 1 irene polk 1 irene polk 1 irene quirinius 1 irene quirinius 1 irene quirinius 1 irene robinson 1 irene steinbeck 1 irene thompson 2 irene underhill 2 irene underhill 1 irene van buren 1 irene van buren 1 irene xylophone 1 jessica brown 2 jessica carson 1 jessica carson 1 jessica carson 1 jessica davidson 2 jessica davidson 1 jessica davidson 1 jessica davidson 1 jessica ellison 2 jessica ellison 1 jessica falkner 1 jessica garcia 1 jessica garcia 1 jessica ichabod 1 jessica johnson 1 jessica johnson 1 jessica miller 1 jessica nixon 1 jessica nixon 1 jessica ovid 2 jessica ovid 1 jessica polk 1 jessica quirinius 1 jessica quirinius 1 jessica quirinius 1 jessica quirinius 1 jessica robinson 1 jessica thompson 1 jessica thompson 1 jessica underhill 1 jessica underhill 1 jessica underhill 1 jessica van buren 1 jessica white 2 jessica white 1 jessica white 1 jessica white 1 jessica white 1 jessica xylophone 1 jessica young 1 jessica young 1 jessica zipper 1 jessica zipper 1 jessica zipper 1 katie allen 1 katie brown 1 katie davidson 1 katie ellison 1 katie ellison 1 katie falkner 1 katie garcia 1 katie garcia 1 katie hernandez 1 katie ichabod 2 katie ichabod 1 katie ichabod 1 katie king 1 katie king 1 katie king 1 katie miller 1 katie miller 1 katie nixon 1 katie ovid 1 katie polk 1 katie polk 1 katie robinson 1 katie van buren 2 katie van buren 1 katie white 1 katie white 1 katie xylophone 1 katie young 1 katie young 1 katie young 1 katie zipper 1 katie zipper 1 luke allen 2 luke allen 1 luke allen 1 luke allen 1 luke allen 1 luke brown 2 luke davidson 1 luke davidson 1 luke ellison 1 luke ellison 1 luke ellison 1 luke falkner 2 luke falkner 1 luke garcia 1 luke garcia 1 luke ichabod 1 luke ichabod 1 luke johnson 1 luke johnson 1 luke johnson 1 luke laertes 1 luke laertes 1 luke laertes 1 luke laertes 1 luke laertes 1 luke miller 2 luke ovid 2 luke ovid 1 luke polk 1 luke polk 1 luke quirinius 1 luke robinson 1 luke robinson 1 luke thompson 1 luke underhill 1 luke underhill 1 luke underhill 1 luke van buren 2 luke white 1 luke xylophone 1 luke zipper 1 mike allen 2 mike brown 1 mike carson 1 mike carson 1 mike carson 1 mike davidson 1 mike davidson 1 mike ellison 2 mike ellison 1 mike ellison 1 mike ellison 1 mike ellison 1 mike falkner 1 mike garcia 1 mike garcia 1 mike garcia 1 mike hernandez 1 mike hernandez 1 mike ichabod 1 mike king 2 mike king 1 mike king 1 mike king 1 mike king 1 mike king 1 mike miller 1 mike nixon 2 mike nixon 1 mike polk 2 mike polk 1 mike polk 1 mike quirinius 1 mike steinbeck 1 mike steinbeck 1 mike steinbeck 1 mike steinbeck 1 mike van buren 2 mike van buren 1 mike white 1 mike white 1 mike white 1 mike white 1 mike young 1 mike young 1 mike young 1 mike zipper 1 mike zipper 1 mike zipper 1 nick allen 1 nick allen 1 nick brown 1 nick davidson 1 nick ellison 2 nick ellison 1 nick falkner 1 nick falkner 1 nick garcia 1 nick garcia 1 nick garcia 1 nick ichabod 1 nick ichabod 1 nick ichabod 1 nick johnson 1 nick johnson 1 nick laertes 1 nick miller 1 nick nixon 1 nick ovid 1 nick polk 2 nick quirinius 2 nick quirinius 1 nick robinson 1 nick robinson 1 nick steinbeck 1 nick thompson 2 nick underhill 1 nick van buren 1 nick xylophone 1 nick young 1 nick young 1 nick zipper 2 nick zipper 1 oscar allen 1 oscar brown 1 oscar carson 1 oscar carson 1 oscar carson 1 oscar carson 1 oscar carson 1 oscar davidson 1 oscar ellison 2 oscar ellison 2 oscar falkner 1 oscar garcia 1 oscar hernandez 1 oscar hernandez 1 oscar ichabod 2 oscar ichabod 1 oscar ichabod 1 oscar ichabod 1 oscar johnson 2 oscar johnson 1 oscar king 1 oscar king 1 oscar king 1 oscar laertes 1 oscar laertes 1 oscar laertes 1 oscar laertes 1 oscar nixon 1 oscar ovid 1 oscar ovid 1 oscar ovid 1 oscar polk 1 oscar polk 1 oscar quirinius 2 oscar quirinius 2 oscar quirinius 1 oscar quirinius 1 oscar robinson 2 oscar robinson 1 oscar robinson 1 oscar robinson 1 oscar steinbeck 1 oscar thompson 1 oscar thompson 1 oscar thompson 1 oscar thompson 1 oscar underhill 1 oscar van buren 1 oscar van buren 1 oscar van buren 1 oscar white 1 oscar white 1 oscar white 1 oscar white 1 oscar xylophone 2 oscar xylophone 1 oscar xylophone 1 oscar zipper 2 oscar zipper 1 oscar zipper 1 priscilla brown 2 priscilla brown 1 priscilla brown 1 priscilla carson 2 priscilla carson 1 priscilla carson 1 priscilla ichabod 2 priscilla ichabod 1 priscilla johnson 1 priscilla johnson 1 priscilla johnson 1 priscilla johnson 1 priscilla johnson 1 priscilla king 1 priscilla nixon 2 priscilla nixon 2 priscilla ovid 2 priscilla ovid 1 priscilla polk 1 priscilla quirinius 1 priscilla thompson 1 priscilla underhill 1 priscilla underhill 1 priscilla van buren 2 priscilla van buren 1 priscilla van buren 1 priscilla white 1 priscilla xylophone 1 priscilla xylophone 1 priscilla xylophone 1 priscilla young 1 priscilla young 1 priscilla zipper 1 priscilla zipper 1 quinn allen 1 quinn allen 1 quinn brown 1 quinn brown 1 quinn brown 1 quinn davidson 2 quinn davidson 1 quinn davidson 1 quinn davidson 1 quinn ellison 1 quinn ellison 1 quinn garcia 1 quinn garcia 1 quinn garcia 1 quinn garcia 1 quinn ichabod 1 quinn king 1 quinn king 1 quinn laertes 1 quinn laertes 1 quinn laertes 1 quinn nixon 2 quinn ovid 1 quinn quirinius 1 quinn robinson 2 quinn steinbeck 1 quinn steinbeck 1 quinn thompson 1 quinn thompson 1 quinn underhill 2 quinn underhill 1 quinn underhill 1 quinn van buren 1 quinn young 2 quinn zipper 1 quinn zipper 1 rachel allen 1 rachel allen 1 rachel brown 3 rachel brown 1 rachel brown 1 rachel brown 1 rachel brown 1 rachel carson 2 rachel carson 1 rachel davidson 1 rachel ellison 1 rachel falkner 1 rachel falkner 1 rachel falkner 1 rachel falkner 1 rachel johnson 1 rachel king 2 rachel king 1 rachel laertes 1 rachel laertes 1 rachel ovid 1 rachel ovid 1 rachel polk 1 rachel quirinius 1 rachel robinson 1 rachel robinson 1 rachel robinson 1 rachel thompson 1 rachel thompson 1 rachel thompson 1 rachel underhill 1 rachel white 1 rachel white 1 rachel young 1 rachel zipper 1 rachel zipper 1 sarah carson 1 sarah carson 1 sarah carson 1 sarah ellison 1 sarah falkner 1 sarah falkner 1 sarah garcia 1 sarah garcia 1 sarah garcia 1 sarah ichabod 1 sarah ichabod 1 sarah johnson 1 sarah johnson 1 sarah johnson 1 sarah johnson 1 sarah king 1 sarah king 1 sarah miller 1 sarah ovid 1 sarah robinson 1 sarah robinson 1 sarah steinbeck 1 sarah white 1 sarah white 1 sarah xylophone 1 sarah young 1 sarah zipper 1 tom brown 1 tom brown 1 tom carson 1 tom carson 1 tom carson 1 tom davidson 1 tom ellison 1 tom ellison 1 tom ellison 1 tom falkner 1 tom falkner 1 tom hernandez 1 tom hernandez 1 tom ichabod 1 tom johnson 1 tom johnson 1 tom king 1 tom laertes 2 tom laertes 1 tom miller 2 tom miller 1 tom miller 1 tom nixon 2 tom ovid 1 tom polk 1 tom polk 1 tom quirinius 1 tom quirinius 1 tom robinson 1 tom robinson 1 tom robinson 1 tom robinson 1 tom steinbeck 3 tom van buren 1 tom van buren 1 tom van buren 1 tom white 2 tom young 1 tom young 1 tom zipper 3 ulysses brown 1 ulysses carson 4 ulysses carson 1 ulysses carson 1 ulysses carson 1 ulysses davidson 2 ulysses ellison 1 ulysses garcia 1 ulysses hernandez 1 ulysses hernandez 1 ulysses hernandez 1 ulysses ichabod 1 ulysses ichabod 1 ulysses johnson 2 ulysses king 1 ulysses laertes 2 ulysses laertes 1 ulysses laertes 1 ulysses miller 1 ulysses miller 1 ulysses nixon 1 ulysses ovid 1 ulysses polk 1 ulysses polk 1 ulysses polk 1 ulysses polk 1 ulysses quirinius 1 ulysses robinson 1 ulysses steinbeck 1 ulysses steinbeck 1 ulysses thompson 1 ulysses underhill 2 ulysses underhill 1 ulysses underhill 1 ulysses underhill 1 ulysses underhill 1 ulysses underhill 1 ulysses underhill 1 ulysses van buren 1 ulysses white 1 ulysses white 1 ulysses xylophone 2 ulysses xylophone 1 ulysses xylophone 1 ulysses young 2 ulysses young 1 ulysses young 1 victor allen 1 victor allen 1 victor brown 1 victor brown 1 victor brown 1 victor brown 1 victor davidson 1 victor davidson 1 victor davidson 1 victor ellison 2 victor ellison 1 victor hernandez 1 victor hernandez 1 victor hernandez 1 victor hernandez 1 victor hernandez 1 victor johnson 2 victor johnson 1 victor johnson 1 victor king 1 victor king 1 victor laertes 1 victor laertes 1 victor miller 1 victor nixon 1 victor nixon 1 victor ovid 2 victor polk 2 victor quirinius 1 victor quirinius 1 victor robinson 2 victor robinson 1 victor steinbeck 2 victor steinbeck 1 victor steinbeck 1 victor thompson 1 victor van buren 1 victor van buren 1 victor white 2 victor white 1 victor xylophone 1 victor xylophone 1 victor xylophone 1 victor xylophone 1 victor xylophone 1 victor young 1 victor zipper 1 wendy allen 1 wendy allen 1 wendy allen 1 wendy brown 1 wendy brown 1 wendy ellison 1 wendy ellison 1 wendy falkner 2 wendy falkner 1 wendy falkner 1 wendy garcia 2 wendy garcia 1 wendy garcia 1 wendy garcia 1 wendy hernandez 1 wendy ichabod 1 wendy king 1 wendy king 1 wendy king 1 wendy laertes 1 wendy laertes 1 wendy laertes 1 wendy miller 1 wendy miller 1 wendy nixon 1 wendy nixon 1 wendy ovid 1 wendy ovid 1 wendy polk 2 wendy polk 1 wendy quirinius 1 wendy quirinius 1 wendy robinson 2 wendy robinson 1 wendy robinson 1 wendy steinbeck 1 wendy thompson 2 wendy thompson 1 wendy underhill 2 wendy underhill 1 wendy underhill 1 wendy van buren 1 wendy van buren 1 wendy white 1 wendy xylophone 1 wendy xylophone 1 wendy young 1 wendy young 1 xavier allen 1 xavier allen 1 xavier allen 1 xavier brown 1 xavier brown 1 xavier brown 1 xavier carson 1 xavier carson 1 xavier davidson 1 xavier davidson 1 xavier davidson 1 xavier ellison 1 xavier ellison 1 xavier garcia 1 xavier hernandez 1 xavier hernandez 1 xavier hernandez 1 xavier ichabod 1 xavier ichabod 1 xavier johnson 1 xavier johnson 1 xavier king 1 xavier king 1 xavier laertes 1 xavier ovid 2 xavier polk 1 xavier polk 1 xavier polk 1 xavier polk 1 xavier quirinius 2 xavier quirinius 2 xavier quirinius 1 xavier quirinius 1 xavier thompson 1 xavier underhill 1 xavier white 2 xavier white 1 xavier xylophone 1 xavier zipper 1 yuri allen 1 yuri allen 1 yuri brown 1 yuri brown 1 yuri carson 1 yuri carson 1 yuri ellison 1 yuri ellison 1 yuri falkner 1 yuri falkner 1 yuri garcia 1 yuri hernandez 1 yuri johnson 1 yuri johnson 1 yuri johnson 1 yuri king 2 yuri laertes 1 yuri laertes 1 yuri nixon 1 yuri nixon 1 yuri polk 1 yuri polk 1 yuri polk 1 yuri quirinius 1 yuri quirinius 1 yuri quirinius 1 yuri steinbeck 1 yuri steinbeck 1 yuri thompson 1 yuri underhill 1 yuri underhill 1 yuri white 1 yuri xylophone 1 zach allen 1 zach brown 2 zach brown 1 zach brown 1 zach brown 1 zach brown 1 zach carson 2 zach ellison 1 zach falkner 1 zach falkner 1 zach garcia 2 zach garcia 1 zach garcia 1 zach garcia 1 zach ichabod 1 zach ichabod 1 zach king 2 zach king 1 zach king 1 zach miller 1 zach miller 1 zach miller 1 zach ovid 1 zach ovid 1 zach ovid 1 zach ovid 1 zach quirinius 1 zach robinson 1 zach steinbeck 1 zach steinbeck 1 zach thompson 2 zach thompson 1 zach underhill 1 zach white 1 zach xylophone 2 zach xylophone 1 zach young 1 zach zipper 1 zach zipper 1 zach zipper 1
sbt.ForkMain$ForkError: org.scalatest.exceptions.TestFailedException:
Failed to execute query using catalyst:
Error: execute, tree:
Exchange rangepartitioning(s#153582 ASC NULLS FIRST, rn#153573 DESC NULLS LAST, 5)
+- *(2) Project [s#153582, rn#153573]
+- Window [row_number() windowspecdefinition(d#153580, dec#153584 ASC NULLS FIRST, specifiedwindowframe(RowFrame, unboundedpreceding$(), currentrow$())) AS rn#153573], [d#153580], [dec#153584 ASC NULLS FIRST]
+- *(1) Sort [d#153580 ASC NULLS FIRST, dec#153584 ASC NULLS FIRST], false, 0
+- Exchange hashpartitioning(d#153580, 5)
+- Scan hive default.over1k [s#153582, d#153580, dec#153584], HiveTableRelation `default`.`over1k`, org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe, [t#153575, si#153576, i#153577, b#153578L, f#153579, d#153580, bo#153581, s#153582, ts#153583, dec#153584, bin#153585]
org.apache.spark.sql.catalyst.errors.package$TreeNodeException: execute, tree:
Exchange rangepartitioning(s#153582 ASC NULLS FIRST, rn#153573 DESC NULLS LAST, 5)
+- *(2) Project [s#153582, rn#153573]
+- Window [row_number() windowspecdefinition(d#153580, dec#153584 ASC NULLS FIRST, specifiedwindowframe(RowFrame, unboundedpreceding$(), currentrow$())) AS rn#153573], [d#153580], [dec#153584 ASC NULLS FIRST]
+- *(1) Sort [d#153580 ASC NULLS FIRST, dec#153584 ASC NULLS FIRST], false, 0
+- Exchange hashpartitioning(d#153580, 5)
+- Scan hive default.over1k [s#153582, d#153580, dec#153584], HiveTableRelation `default`.`over1k`, org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe, [t#153575, si#153576, i#153577, b#153578L, f#153579, d#153580, bo#153581, s#153582, ts#153583, dec#153584, bin#153585]
at org.apache.spark.sql.catalyst.errors.package$.attachTree(package.scala:56)
at org.apache.spark.sql.execution.exchange.ShuffleExchangeExec.doExecute(ShuffleExchangeExec.scala:119)
at org.apache.spark.sql.execution.SparkPlan$$anonfun$execute$1.apply(SparkPlan.scala:131)
at org.apache.spark.sql.execution.SparkPlan$$anonfun$execute$1.apply(SparkPlan.scala:127)
at org.apache.spark.sql.execution.SparkPlan$$anonfun$executeQuery$1.apply(SparkPlan.scala:155)
at org.apache.spark.rdd.RDDOperationScope$.withScope(RDDOperationScope.scala:151)
at org.apache.spark.sql.execution.SparkPlan.executeQuery(SparkPlan.scala:152)
at org.apache.spark.sql.execution.SparkPlan.execute(SparkPlan.scala:127)
at org.apache.spark.sql.execution.InputAdapter.inputRDDs(WholeStageCodegenExec.scala:374)
at org.apache.spark.sql.execution.SortExec.inputRDDs(SortExec.scala:121)
at org.apache.spark.sql.execution.WholeStageCodegenExec.doExecute(WholeStageCodegenExec.scala:610)
at org.apache.spark.sql.execution.SparkPlan$$anonfun$execute$1.apply(SparkPlan.scala:131)
at org.apache.spark.sql.execution.SparkPlan$$anonfun$execute$1.apply(SparkPlan.scala:127)
at org.apache.spark.sql.execution.SparkPlan$$anonfun$executeQuery$1.apply(SparkPlan.scala:155)
at org.apache.spark.rdd.RDDOperationScope$.withScope(RDDOperationScope.scala:151)
at org.apache.spark.sql.execution.SparkPlan.executeQuery(SparkPlan.scala:152)
at org.apache.spark.sql.execution.SparkPlan.execute(SparkPlan.scala:127)
at org.apache.spark.sql.execution.SparkPlan.getByteArrayRdd(SparkPlan.scala:247)
at org.apache.spark.sql.execution.SparkPlan.executeCollect(SparkPlan.scala:294)
at org.apache.spark.sql.execution.SparkPlan.executeCollectPublic(SparkPlan.scala:324)
at org.apache.spark.sql.execution.QueryExecution.hiveResultString(QueryExecution.scala:121)
at org.apache.spark.sql.hive.execution.HiveComparisonTest$$anonfun$createQueryTest$6$$anonfun$25$$anonfun$getResult$1$1.apply(HiveComparisonTest.scala:348)
at org.apache.spark.sql.hive.execution.HiveComparisonTest$$anonfun$createQueryTest$6$$anonfun$25$$anonfun$getResult$1$1.apply(HiveComparisonTest.scala:348)
at org.apache.spark.sql.execution.SQLExecution$$anonfun$withNewExecutionId$1.apply(SQLExecution.scala:78)
at org.apache.spark.sql.execution.SQLExecution$.withSQLConfPropagated(SQLExecution.scala:125)
at org.apache.spark.sql.execution.SQLExecution$.withNewExecutionId(SQLExecution.scala:73)
at org.apache.spark.sql.hive.execution.HiveComparisonTest$$anonfun$createQueryTest$6$$anonfun$25.getResult$1(HiveComparisonTest.scala:348)
at org.apache.spark.sql.hive.execution.HiveComparisonTest$$anonfun$createQueryTest$6$$anonfun$25.apply(HiveComparisonTest.scala:350)
at org.apache.spark.sql.hive.execution.HiveComparisonTest$$anonfun$createQueryTest$6$$anonfun$25.apply(HiveComparisonTest.scala:345)
at scala.collection.TraversableLike$$anonfun$map$1.apply(TraversableLike.scala:234)
at scala.collection.TraversableLike$$anonfun$map$1.apply(TraversableLike.scala:234)
at scala.collection.mutable.ResizableArray$class.foreach(ResizableArray.scala:59)
at scala.collection.mutable.ArrayBuffer.foreach(ArrayBuffer.scala:48)
at scala.collection.TraversableLike$class.map(TraversableLike.scala:234)
at scala.collection.AbstractTraversable.map(Traversable.scala:104)
at org.apache.spark.sql.hive.execution.HiveComparisonTest$$anonfun$createQueryTest$6.doTest$1(HiveComparisonTest.scala:345)
at org.apache.spark.sql.hive.execution.HiveComparisonTest$$anonfun$createQueryTest$6.apply(HiveComparisonTest.scala:462)
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:186)
at org.apache.spark.SparkFunSuite.withFixture(SparkFunSuite.scala:103)
at org.scalatest.FunSuiteLike$class.invokeWithFixture$1(FunSuiteLike.scala:183)
at org.scalatest.FunSuiteLike$$anonfun$runTest$1.apply(FunSuiteLike.scala:196)
at org.scalatest.FunSuiteLike$$anonfun$runTest$1.apply(FunSuiteLike.scala:196)
at org.scalatest.SuperEngine.runTestImpl(Engine.scala:289)
at org.scalatest.FunSuiteLike$class.runTest(FunSuiteLike.scala:196)
at org.apache.spark.sql.hive.execution.HiveWindowFunctionQuerySuite.org$scalatest$BeforeAndAfter$$super$runTest(HiveWindowFunctionQuerySuite.scala:35)
at org.scalatest.BeforeAndAfter$class.runTest(BeforeAndAfter.scala:203)
at org.apache.spark.sql.hive.execution.HiveWindowFunctionQuerySuite.runTest(HiveWindowFunctionQuerySuite.scala:35)
at org.scalatest.FunSuiteLike$$anonfun$runTests$1.apply(FunSuiteLike.scala:229)
at org.scalatest.FunSuiteLike$$anonfun$runTests$1.apply(FunSuiteLike.scala:229)
at org.scalatest.SuperEngine$$anonfun$traverseSubNodes$1$1.apply(Engine.scala:396)
at org.scalatest.SuperEngine$$anonfun$traverseSubNodes$1$1.apply(Engine.scala:384)
at scala.collection.immutable.List.foreach(List.scala:392)
at org.scalatest.SuperEngine.traverseSubNodes$1(Engine.scala:384)
at org.scalatest.SuperEngine.org$scalatest$SuperEngine$$runTestsInBranch(Engine.scala:379)
at org.scalatest.SuperEngine.runTestsImpl(Engine.scala:461)
at org.scalatest.FunSuiteLike$class.runTests(FunSuiteLike.scala:229)
at org.scalatest.FunSuite.runTests(FunSuite.scala:1560)
at org.scalatest.Suite$class.run(Suite.scala:1147)
at org.scalatest.FunSuite.org$scalatest$FunSuiteLike$$super$run(FunSuite.scala:1560)
at org.scalatest.FunSuiteLike$$anonfun$run$1.apply(FunSuiteLike.scala:233)
at org.scalatest.FunSuiteLike$$anonfun$run$1.apply(FunSuiteLike.scala:233)
at org.scalatest.SuperEngine.runImpl(Engine.scala:521)
at org.scalatest.FunSuiteLike$class.run(FunSuiteLike.scala:233)
at org.apache.spark.SparkFunSuite.org$scalatest$BeforeAndAfterAll$$super$run(SparkFunSuite.scala:52)
at org.scalatest.BeforeAndAfterAll$class.liftedTree1$1(BeforeAndAfterAll.scala:213)
at org.scalatest.BeforeAndAfterAll$class.run(BeforeAndAfterAll.scala:210)
at org.apache.spark.sql.hive.execution.HiveWindowFunctionQuerySuite.org$scalatest$BeforeAndAfter$$super$run(HiveWindowFunctionQuerySuite.scala:35)
at org.scalatest.BeforeAndAfter$class.run(BeforeAndAfter.scala:258)
at org.apache.spark.sql.hive.execution.HiveWindowFunctionQuerySuite.run(HiveWindowFunctionQuerySuite.scala:35)
at org.scalatest.tools.Framework.org$scalatest$tools$Framework$$runSuite(Framework.scala:314)
at org.scalatest.tools.Framework$ScalaTestTask.execute(Framework.scala:480)
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:1149)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
at java.lang.Thread.run(Thread.java:748)
Caused by: org.apache.spark.sql.catalyst.errors.package$TreeNodeException: execute, tree:
Exchange hashpartitioning(d#153580, 5)
+- Scan hive default.over1k [s#153582, d#153580, dec#153584], HiveTableRelation `default`.`over1k`, org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe, [t#153575, si#153576, i#153577, b#153578L, f#153579, d#153580, bo#153581, s#153582, ts#153583, dec#153584, bin#153585]
at org.apache.spark.sql.catalyst.errors.package$.attachTree(package.scala:56)
at org.apache.spark.sql.execution.exchange.ShuffleExchangeExec.doExecute(ShuffleExchangeExec.scala:119)
at org.apache.spark.sql.execution.SparkPlan$$anonfun$execute$1.apply(SparkPlan.scala:131)
at org.apache.spark.sql.execution.SparkPlan$$anonfun$execute$1.apply(SparkPlan.scala:127)
at org.apache.spark.sql.execution.SparkPlan$$anonfun$executeQuery$1.apply(SparkPlan.scala:155)
at org.apache.spark.rdd.RDDOperationScope$.withScope(RDDOperationScope.scala:151)
at org.apache.spark.sql.execution.SparkPlan.executeQuery(SparkPlan.scala:152)
at org.apache.spark.sql.execution.SparkPlan.execute(SparkPlan.scala:127)
at org.apache.spark.sql.execution.InputAdapter.inputRDDs(WholeStageCodegenExec.scala:374)
at org.apache.spark.sql.execution.SortExec.inputRDDs(SortExec.scala:121)
at org.apache.spark.sql.execution.WholeStageCodegenExec.doExecute(WholeStageCodegenExec.scala:610)
at org.apache.spark.sql.execution.SparkPlan$$anonfun$execute$1.apply(SparkPlan.scala:131)
at org.apache.spark.sql.execution.SparkPlan$$anonfun$execute$1.apply(SparkPlan.scala:127)
at org.apache.spark.sql.execution.SparkPlan$$anonfun$executeQuery$1.apply(SparkPlan.scala:155)
at org.apache.spark.rdd.RDDOperationScope$.withScope(RDDOperationScope.scala:151)
at org.apache.spark.sql.execution.SparkPlan.executeQuery(SparkPlan.scala:152)
at org.apache.spark.sql.execution.SparkPlan.execute(SparkPlan.scala:127)
at org.apache.spark.sql.execution.window.WindowExec.doExecute(WindowExec.scala:302)
at org.apache.spark.sql.execution.SparkPlan$$anonfun$execute$1.apply(SparkPlan.scala:131)
at org.apache.spark.sql.execution.SparkPlan$$anonfun$execute$1.apply(SparkPlan.scala:127)
at org.apache.spark.sql.execution.SparkPlan$$anonfun$executeQuery$1.apply(SparkPlan.scala:155)
at org.apache.spark.rdd.RDDOperationScope$.withScope(RDDOperationScope.scala:151)
at org.apache.spark.sql.execution.SparkPlan.executeQuery(SparkPlan.scala:152)
at org.apache.spark.sql.execution.SparkPlan.execute(SparkPlan.scala:127)
at org.apache.spark.sql.execution.InputAdapter.inputRDDs(WholeStageCodegenExec.scala:374)
at org.apache.spark.sql.execution.ProjectExec.inputRDDs(basicPhysicalOperators.scala:41)
at org.apache.spark.sql.execution.WholeStageCodegenExec.doExecute(WholeStageCodegenExec.scala:610)
at org.apache.spark.sql.execution.SparkPlan$$anonfun$execute$1.apply(SparkPlan.scala:131)
at org.apache.spark.sql.execution.SparkPlan$$anonfun$execute$1.apply(SparkPlan.scala:127)
at org.apache.spark.sql.execution.SparkPlan$$anonfun$executeQuery$1.apply(SparkPlan.scala:155)
at org.apache.spark.rdd.RDDOperationScope$.withScope(RDDOperationScope.scala:151)
at org.apache.spark.sql.execution.SparkPlan.executeQuery(SparkPlan.scala:152)
at org.apache.spark.sql.execution.SparkPlan.execute(SparkPlan.scala:127)
at org.apache.spark.sql.execution.exchange.ShuffleExchangeExec.prepareShuffleDependency(ShuffleExchangeExec.scala:92)
at org.apache.spark.sql.execution.exchange.ShuffleExchangeExec$$anonfun$doExecute$1.apply(ShuffleExchangeExec.scala:128)
at org.apache.spark.sql.execution.exchange.ShuffleExchangeExec$$anonfun$doExecute$1.apply(ShuffleExchangeExec.scala:119)
at org.apache.spark.sql.catalyst.errors.package$.attachTree(package.scala:52)
... 80 more
Caused by: java.lang.IllegalStateException: Cannot call methods on a stopped SparkContext.
This stopped SparkContext was created at:
org.apache.spark.sql.hive.execution.HiveComparisonTest$$anonfun$createQueryTest$6.apply(HiveComparisonTest.scala:456)
org.scalatest.OutcomeOf$class.outcomeOf(OutcomeOf.scala:85)
org.scalatest.OutcomeOf$.outcomeOf(OutcomeOf.scala:104)
org.scalatest.Transformer.apply(Transformer.scala:22)
org.scalatest.Transformer.apply(Transformer.scala:20)
org.scalatest.FunSuiteLike$$anon$1.apply(FunSuiteLike.scala:186)
org.apache.spark.SparkFunSuite.withFixture(SparkFunSuite.scala:103)
org.scalatest.FunSuiteLike$class.invokeWithFixture$1(FunSuiteLike.scala:183)
org.scalatest.FunSuiteLike$$anonfun$runTest$1.apply(FunSuiteLike.scala:196)
org.scalatest.FunSuiteLike$$anonfun$runTest$1.apply(FunSuiteLike.scala:196)
org.scalatest.SuperEngine.runTestImpl(Engine.scala:289)
org.scalatest.FunSuiteLike$class.runTest(FunSuiteLike.scala:196)
org.scalatest.FunSuite.runTest(FunSuite.scala:1560)
org.scalatest.FunSuiteLike$$anonfun$runTests$1.apply(FunSuiteLike.scala:229)
org.scalatest.FunSuiteLike$$anonfun$runTests$1.apply(FunSuiteLike.scala:229)
org.scalatest.SuperEngine$$anonfun$traverseSubNodes$1$1.apply(Engine.scala:396)
org.scalatest.SuperEngine$$anonfun$traverseSubNodes$1$1.apply(Engine.scala:384)
scala.collection.immutable.List.foreach(List.scala:392)
org.scalatest.SuperEngine.traverseSubNodes$1(Engine.scala:384)
org.scalatest.SuperEngine.org$scalatest$SuperEngine$$runTestsInBranch(Engine.scala:379)
The currently active SparkContext was created at:
(No active SparkContext.)
at org.apache.spark.SparkContext.assertNotStopped(SparkContext.scala:100)
at org.apache.spark.SparkContext.broadcast(SparkContext.scala:1492)
at org.apache.spark.sql.hive.HadoopTableReader.<init>(TableReader.scala:89)
at org.apache.spark.sql.hive.execution.HiveTableScanExec.org$apache$spark$sql$hive$execution$HiveTableScanExec$$hadoopReader$lzycompute(HiveTableScanExec.scala:105)
at org.apache.spark.sql.hive.execution.HiveTableScanExec.org$apache$spark$sql$hive$execution$HiveTableScanExec$$hadoopReader(HiveTableScanExec.scala:105)
at org.apache.spark.sql.hive.execution.HiveTableScanExec$$anonfun$10.apply(HiveTableScanExec.scala:188)
at org.apache.spark.sql.hive.execution.HiveTableScanExec$$anonfun$10.apply(HiveTableScanExec.scala:188)
at org.apache.spark.util.Utils$.withDummyCallSite(Utils.scala:2457)
at org.apache.spark.sql.hive.execution.HiveTableScanExec.doExecute(HiveTableScanExec.scala:187)
at org.apache.spark.sql.execution.SparkPlan$$anonfun$execute$1.apply(SparkPlan.scala:131)
at org.apache.spark.sql.execution.SparkPlan$$anonfun$execute$1.apply(SparkPlan.scala:127)
at org.apache.spark.sql.execution.SparkPlan$$anonfun$executeQuery$1.apply(SparkPlan.scala:155)
at org.apache.spark.rdd.RDDOperationScope$.withScope(RDDOperationScope.scala:151)
at org.apache.spark.sql.execution.SparkPlan.executeQuery(SparkPlan.scala:152)
at org.apache.spark.sql.execution.SparkPlan.execute(SparkPlan.scala:127)
at org.apache.spark.sql.execution.exchange.ShuffleExchangeExec.prepareShuffleDependency(ShuffleExchangeExec.scala:92)
at org.apache.spark.sql.execution.exchange.ShuffleExchangeExec$$anonfun$doExecute$1.apply(ShuffleExchangeExec.scala:128)
at org.apache.spark.sql.execution.exchange.ShuffleExchangeExec$$anonfun$doExecute$1.apply(ShuffleExchangeExec.scala:119)
at org.apache.spark.sql.catalyst.errors.package$.attachTree(package.scala:52)
... 116 more
select s, row_number() over (partition by d order by dec) rn from over1k
order by s, rn desc
== Parsed Logical Plan ==
'Sort ['s ASC NULLS FIRST, 'rn DESC NULLS LAST], true
+- 'Project ['s, 'row_number() windowspecdefinition('d, 'dec ASC NULLS FIRST, unspecifiedframe$()) AS rn#153573]
+- 'UnresolvedRelation `over1k`
== Analyzed Logical Plan ==
s: string, rn: int
Sort [s#153582 ASC NULLS FIRST, rn#153573 DESC NULLS LAST], true
+- Project [s#153582, rn#153573]
+- Project [s#153582, d#153580, dec#153584, rn#153573, rn#153573]
+- Window [row_number() windowspecdefinition(d#153580, dec#153584 ASC NULLS FIRST, specifiedwindowframe(RowFrame, unboundedpreceding$(), currentrow$())) AS rn#153573], [d#153580], [dec#153584 ASC NULLS FIRST]
+- Project [s#153582, d#153580, dec#153584]
+- SubqueryAlias `default`.`over1k`
+- HiveTableRelation `default`.`over1k`, org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe, [t#153575, si#153576, i#153577, b#153578L, f#153579, d#153580, bo#153581, s#153582, ts#153583, dec#153584, bin#153585]
== Optimized Logical Plan ==
Sort [s#153582 ASC NULLS FIRST, rn#153573 DESC NULLS LAST], true
+- Project [s#153582, rn#153573]
+- Window [row_number() windowspecdefinition(d#153580, dec#153584 ASC NULLS FIRST, specifiedwindowframe(RowFrame, unboundedpreceding$(), currentrow$())) AS rn#153573], [d#153580], [dec#153584 ASC NULLS FIRST]
+- Project [s#153582, d#153580, dec#153584]
+- HiveTableRelation `default`.`over1k`, org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe, [t#153575, si#153576, i#153577, b#153578L, f#153579, d#153580, bo#153581, s#153582, ts#153583, dec#153584, bin#153585]
== Physical Plan ==
*(3) Sort [s#153582 ASC NULLS FIRST, rn#153573 DESC NULLS LAST], true, 0
+- Exchange rangepartitioning(s#153582 ASC NULLS FIRST, rn#153573 DESC NULLS LAST, 5)
+- *(2) Project [s#153582, rn#153573]
+- Window [row_number() windowspecdefinition(d#153580, dec#153584 ASC NULLS FIRST, specifiedwindowframe(RowFrame, unboundedpreceding$(), currentrow$())) AS rn#153573], [d#153580], [dec#153584 ASC NULLS FIRST]
+- *(1) Sort [d#153580 ASC NULLS FIRST, dec#153584 ASC NULLS FIRST], false, 0
+- Exchange hashpartitioning(d#153580, 5)
+- Scan hive default.over1k [s#153582, d#153580, dec#153584], HiveTableRelation `default`.`over1k`, org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe, [t#153575, si#153576, i#153577, b#153578L, f#153579, d#153580, bo#153581, s#153582, ts#153583, dec#153584, bin#153585]
== HIVE - 1049 row(s) ==
1
1
1
alice allen 2
alice allen 1
alice allen 1
alice brown 1
alice carson 1
alice davidson 1
alice falkner 1
alice garcia 1
alice hernandez 2
alice hernandez 1
alice johnson 2
alice king 1
alice king 1
alice king 1
alice laertes 1
alice laertes 1
alice miller 1
alice nixon 1
alice nixon 1
alice nixon 1
alice ovid 1
alice polk 3
alice quirinius 1
alice quirinius 1
alice robinson 1
alice robinson 1
alice steinbeck 1
alice steinbeck 1
alice steinbeck 1
alice underhill 2
alice van buren 1
alice xylophone 1
alice xylophone 1
alice xylophone 1
alice zipper 1
alice zipper 1
alice zipper 1
bob brown 1
bob brown 1
bob brown 1
bob carson 1
bob davidson 1
bob davidson 1
bob davidson 1
bob ellison 2
bob ellison 1
bob ellison 1
bob ellison 1
bob falkner 1
bob garcia 1
bob garcia 1
bob garcia 1
bob garcia 1
bob garcia 1
bob hernandez 1
bob ichabod 1
bob king 2
bob king 1
bob king 1
bob laertes 2
bob laertes 1
bob miller 1
bob ovid 1
bob ovid 1
bob ovid 1
bob ovid 1
bob polk 1
bob quirinius 1
bob steinbeck 1
bob van buren 1
bob white 1
bob white 1
bob xylophone 1
bob xylophone 1
bob young 1
bob zipper 2
bob zipper 1
bob zipper 1
calvin allen 1
calvin brown 2
calvin brown 1
calvin brown 1
calvin carson 2
calvin davidson 2
calvin davidson 1
calvin ellison 1
calvin falkner 1
calvin falkner 1
calvin falkner 1
calvin falkner 1
calvin falkner 1
calvin falkner 1
calvin garcia 1
calvin hernandez 2
calvin johnson 1
calvin laertes 1
calvin laertes 1
calvin nixon 3
calvin nixon 1
calvin nixon 1
calvin ovid 1
calvin ovid 1
calvin ovid 1
calvin ovid 1
calvin polk 1
calvin quirinius 1
calvin quirinius 1
calvin robinson 2
calvin steinbeck 1
calvin steinbeck 1
calvin steinbeck 1
calvin thompson 1
calvin thompson 1
calvin underhill 1
calvin van buren 1
calvin van buren 1
calvin white 1
calvin white 1
calvin xylophone 2
calvin xylophone 1
calvin xylophone 1
calvin young 1
calvin young 1
calvin zipper 1
calvin zipper 1
david allen 1
david allen 1
david brown 1
david brown 1
david davidson 1
david davidson 1
david davidson 1
david davidson 1
david ellison 1
david ellison 1
david ellison 1
david hernandez 1
david ichabod 1
david ichabod 1
david laertes 1
david nixon 1
david ovid 1
david ovid 1
david quirinius 1
david quirinius 1
david quirinius 1
david robinson 1
david robinson 1
david thompson 3
david underhill 1
david underhill 1
david underhill 1
david van buren 1
david van buren 1
david white 1
david xylophone 1
david xylophone 1
david xylophone 1
david young 1
david young 1
ethan allen 1
ethan brown 2
ethan brown 2
ethan brown 1
ethan brown 1
ethan brown 1
ethan brown 1
ethan carson 1
ethan ellison 1
ethan ellison 1
ethan falkner 3
ethan falkner 1
ethan garcia 1
ethan hernandez 1
ethan johnson 1
ethan king 1
ethan laertes 1
ethan laertes 1
ethan laertes 1
ethan laertes 1
ethan laertes 1
ethan laertes 1
ethan laertes 1
ethan miller 2
ethan nixon 1
ethan ovid 1
ethan polk 2
ethan polk 1
ethan polk 1
ethan polk 1
ethan quirinius 1
ethan quirinius 1
ethan quirinius 1
ethan robinson 1
ethan robinson 1
ethan underhill 1
ethan van buren 2
ethan white 1
ethan white 1
ethan xylophone 1
ethan zipper 1
ethan zipper 1
fred davidson 1
fred davidson 1
fred davidson 1
fred ellison 1
fred ellison 1
fred ellison 1
fred falkner 2
fred falkner 1
fred falkner 1
fred hernandez 1
fred ichabod 1
fred ichabod 1
fred johnson 1
fred king 2
fred king 1
fred laertes 1
fred miller 1
fred nixon 2
fred nixon 1
fred nixon 1
fred nixon 1
fred polk 1
fred polk 1
fred polk 1
fred polk 1
fred quirinius 1
fred quirinius 1
fred robinson 1
fred steinbeck 1
fred steinbeck 1
fred steinbeck 1
fred underhill 1
fred van buren 1
fred van buren 1
fred van buren 1
fred van buren 1
fred white 1
fred young 3
fred young 1
fred zipper 1
gabriella allen 1
gabriella allen 1
gabriella brown 2
gabriella brown 1
gabriella carson 1
gabriella davidson 1
gabriella ellison 1
gabriella ellison 1
gabriella falkner 1
gabriella falkner 1
gabriella falkner 1
gabriella garcia 1
gabriella hernandez 1
gabriella hernandez 1
gabriella ichabod 1
gabriella ichabod 1
gabriella ichabod 1
gabriella ichabod 1
gabriella ichabod 1
gabriella king 1
gabriella king 1
gabriella laertes 1
gabriella miller 1
gabriella ovid 1
gabriella ovid 1
gabriella polk 1
gabriella polk 1
gabriella steinbeck 1
gabriella steinbeck 1
gabriella thompson 1
gabriella thompson 1
gabriella thompson 1
gabriella van buren 2
gabriella van buren 1
gabriella white 1
gabriella young 1
gabriella young 1
gabriella zipper 1
gabriella zipper 1
holly allen 1
holly brown 1
holly brown 1
holly falkner 1
holly hernandez 1
holly hernandez 1
holly hernandez 1
holly hernandez 1
holly ichabod 1
holly ichabod 1
holly ichabod 1
holly johnson 2
holly johnson 1
holly johnson 1
holly king 1
holly king 1
holly laertes 1
holly miller 1
holly nixon 1
holly nixon 1
holly polk 2
holly polk 1
holly robinson 2
holly thompson 1
holly thompson 1
holly thompson 1
holly underhill 1
holly underhill 1
holly underhill 1
holly underhill 1
holly van buren 1
holly white 1
holly white 1
holly xylophone 1
holly young 1
holly young 1
holly zipper 1
holly zipper 1
irene allen 1
irene brown 1
irene brown 1
irene brown 1
irene carson 1
irene ellison 1
irene ellison 1
irene falkner 1
irene falkner 1
irene garcia 1
irene garcia 1
irene garcia 1
irene ichabod 1
irene ichabod 1
irene johnson 2
irene laertes 1
irene laertes 1
irene laertes 1
irene miller 2
irene nixon 1
irene nixon 1
irene nixon 1
irene ovid 1
irene ovid 1
irene ovid 1
irene polk 1
irene polk 1
irene polk 1
irene polk 1
irene polk 1
irene quirinius 1
irene quirinius 1
irene quirinius 1
irene robinson 1
irene steinbeck 1
irene thompson 2
irene underhill 2
irene underhill 1
irene van buren 1
irene van buren 1
irene xylophone 1
jessica brown 2
jessica carson 1
jessica carson 1
jessica carson 1
jessica davidson 2
jessica davidson 1
jessica davidson 1
jessica davidson 1
jessica ellison 2
jessica ellison 1
jessica falkner 1
jessica garcia 1
jessica garcia 1
jessica ichabod 1
jessica johnson 1
jessica johnson 1
jessica miller 1
jessica nixon 1
jessica nixon 1
jessica ovid 2
jessica ovid 1
jessica polk 1
jessica quirinius 1
jessica quirinius 1
jessica quirinius 1
jessica quirinius 1
jessica robinson 1
jessica thompson 1
jessica thompson 1
jessica underhill 1
jessica underhill 1
jessica underhill 1
jessica van buren 1
jessica white 2
jessica white 1
jessica white 1
jessica white 1
jessica white 1
jessica xylophone 1
jessica young 1
jessica young 1
jessica zipper 1
jessica zipper 1
jessica zipper 1
katie allen 1
katie brown 1
katie davidson 1
katie ellison 1
katie ellison 1
katie falkner 1
katie garcia 1
katie garcia 1
katie hernandez 1
katie ichabod 2
katie ichabod 1
katie ichabod 1
katie king 1
katie king 1
katie king 1
katie miller 1
katie miller 1
katie nixon 1
katie ovid 1
katie polk 1
katie polk 1
katie robinson 1
katie van buren 2
katie van buren 1
katie white 1
katie white 1
katie xylophone 1
katie young 1
katie young 1
katie young 1
katie zipper 1
katie zipper 1
luke allen 2
luke allen 1
luke allen 1
luke allen 1
luke allen 1
luke brown 2
luke davidson 1
luke davidson 1
luke ellison 1
luke ellison 1
luke ellison 1
luke falkner 2
luke falkner 1
luke garcia 1
luke garcia 1
luke ichabod 1
luke ichabod 1
luke johnson 1
luke johnson 1
luke johnson 1
luke laertes 1
luke laertes 1
luke laertes 1
luke laertes 1
luke laertes 1
luke miller 2
luke ovid 2
luke ovid 1
luke polk 1
luke polk 1
luke quirinius 1
luke robinson 1
luke robinson 1
luke thompson 1
luke underhill 1
luke underhill 1
luke underhill 1
luke van buren 2
luke white 1
luke xylophone 1
luke zipper 1
mike allen 2
mike brown 1
mike carson 1
mike carson 1
mike carson 1
mike davidson 1
mike davidson 1
mike ellison 2
mike ellison 1
mike ellison 1
mike ellison 1
mike ellison 1
mike falkner 1
mike garcia 1
mike garcia 1
mike garcia 1
mike hernandez 1
mike hernandez 1
mike ichabod 1
mike king 2
mike king 1
mike king 1
mike king 1
mike king 1
mike king 1
mike miller 1
mike nixon 2
mike nixon 1
mike polk 2
mike polk 1
mike polk 1
mike quirinius 1
mike steinbeck 1
mike steinbeck 1
mike steinbeck 1
mike steinbeck 1
mike van buren 2
mike van buren 1
mike white 1
mike white 1
mike white 1
mike white 1
mike young 1
mike young 1
mike young 1
mike zipper 1
mike zipper 1
mike zipper 1
nick allen 1
nick allen 1
nick brown 1
nick davidson 1
nick ellison 2
nick ellison 1
nick falkner 1
nick falkner 1
nick garcia 1
nick garcia 1
nick garcia 1
nick ichabod 1
nick ichabod 1
nick ichabod 1
nick johnson 1
nick johnson 1
nick laertes 1
nick miller 1
nick nixon 1
nick ovid 1
nick polk 2
nick quirinius 2
nick quirinius 1
nick robinson 1
nick robinson 1
nick steinbeck 1
nick thompson 2
nick underhill 1
nick van buren 1
nick xylophone 1
nick young 1
nick young 1
nick zipper 2
nick zipper 1
oscar allen 1
oscar brown 1
oscar carson 1
oscar carson 1
oscar carson 1
oscar carson 1
oscar carson 1
oscar davidson 1
oscar ellison 2
oscar ellison 2
oscar falkner 1
oscar garcia 1
oscar hernandez 1
oscar hernandez 1
oscar ichabod 2
oscar ichabod 1
oscar ichabod 1
oscar ichabod 1
oscar johnson 2
oscar johnson 1
oscar king 1
oscar king 1
oscar king 1
oscar laertes 1
oscar laertes 1
oscar laertes 1
oscar laertes 1
oscar nixon 1
oscar ovid 1
oscar ovid 1
oscar ovid 1
oscar polk 1
oscar polk 1
oscar quirinius 2
oscar quirinius 2
oscar quirinius 1
oscar quirinius 1
oscar robinson 2
oscar robinson 1
oscar robinson 1
oscar robinson 1
oscar steinbeck 1
oscar thompson 1
oscar thompson 1
oscar thompson 1
oscar thompson 1
oscar underhill 1
oscar van buren 1
oscar van buren 1
oscar van buren 1
oscar white 1
oscar white 1
oscar white 1
oscar white 1
oscar xylophone 2
oscar xylophone 1
oscar xylophone 1
oscar zipper 2
oscar zipper 1
oscar zipper 1
priscilla brown 2
priscilla brown 1
priscilla brown 1
priscilla carson 2
priscilla carson 1
priscilla carson 1
priscilla ichabod 2
priscilla ichabod 1
priscilla johnson 1
priscilla johnson 1
priscilla johnson 1
priscilla johnson 1
priscilla johnson 1
priscilla king 1
priscilla nixon 2
priscilla nixon 2
priscilla ovid 2
priscilla ovid 1
priscilla polk 1
priscilla quirinius 1
priscilla thompson 1
priscilla underhill 1
priscilla underhill 1
priscilla van buren 2
priscilla van buren 1
priscilla van buren 1
priscilla white 1
priscilla xylophone 1
priscilla xylophone 1
priscilla xylophone 1
priscilla young 1
priscilla young 1
priscilla zipper 1
priscilla zipper 1
quinn allen 1
quinn allen 1
quinn brown 1
quinn brown 1
quinn brown 1
quinn davidson 2
quinn davidson 1
quinn davidson 1
quinn davidson 1
quinn ellison 1
quinn ellison 1
quinn garcia 1
quinn garcia 1
quinn garcia 1
quinn garcia 1
quinn ichabod 1
quinn king 1
quinn king 1
quinn laertes 1
quinn laertes 1
quinn laertes 1
quinn nixon 2
quinn ovid 1
quinn quirinius 1
quinn robinson 2
quinn steinbeck 1
quinn steinbeck 1
quinn thompson 1
quinn thompson 1
quinn underhill 2
quinn underhill 1
quinn underhill 1
quinn van buren 1
quinn young 2
quinn zipper 1
quinn zipper 1
rachel allen 1
rachel allen 1
rachel brown 3
rachel brown 1
rachel brown 1
rachel brown 1
rachel brown 1
rachel carson 2
rachel carson 1
rachel davidson 1
rachel ellison 1
rachel falkner 1
rachel falkner 1
rachel falkner 1
rachel falkner 1
rachel johnson 1
rachel king 2
rachel king 1
rachel laertes 1
rachel laertes 1
rachel ovid 1
rachel ovid 1
rachel polk 1
rachel quirinius 1
rachel robinson 1
rachel robinson 1
rachel robinson 1
rachel thompson 1
rachel thompson 1
rachel thompson 1
rachel underhill 1
rachel white 1
rachel white 1
rachel young 1
rachel zipper 1
rachel zipper 1
sarah carson 1
sarah carson 1
sarah carson 1
sarah ellison 1
sarah falkner 1
sarah falkner 1
sarah garcia 1
sarah garcia 1
sarah garcia 1
sarah ichabod 1
sarah ichabod 1
sarah johnson 1
sarah johnson 1
sarah johnson 1
sarah johnson 1
sarah king 1
sarah king 1
sarah miller 1
sarah ovid 1
sarah robinson 1
sarah robinson 1
sarah steinbeck 1
sarah white 1
sarah white 1
sarah xylophone 1
sarah young 1
sarah zipper 1
tom brown 1
tom brown 1
tom carson 1
tom carson 1
tom carson 1
tom davidson 1
tom ellison 1
tom ellison 1
tom ellison 1
tom falkner 1
tom falkner 1
tom hernandez 1
tom hernandez 1
tom ichabod 1
tom johnson 1
tom johnson 1
tom king 1
tom laertes 2
tom laertes 1
tom miller 2
tom miller 1
tom miller 1
tom nixon 2
tom ovid 1
tom polk 1
tom polk 1
tom quirinius 1
tom quirinius 1
tom robinson 1
tom robinson 1
tom robinson 1
tom robinson 1
tom steinbeck 3
tom van buren 1
tom van buren 1
tom van buren 1
tom white 2
tom young 1
tom young 1
tom zipper 3
ulysses brown 1
ulysses carson 4
ulysses carson 1
ulysses carson 1
ulysses carson 1
ulysses davidson 2
ulysses ellison 1
ulysses garcia 1
ulysses hernandez 1
ulysses hernandez 1
ulysses hernandez 1
ulysses ichabod 1
ulysses ichabod 1
ulysses johnson 2
ulysses king 1
ulysses laertes 2
ulysses laertes 1
ulysses laertes 1
ulysses miller 1
ulysses miller 1
ulysses nixon 1
ulysses ovid 1
ulysses polk 1
ulysses polk 1
ulysses polk 1
ulysses polk 1
ulysses quirinius 1
ulysses robinson 1
ulysses steinbeck 1
ulysses steinbeck 1
ulysses thompson 1
ulysses underhill 2
ulysses underhill 1
ulysses underhill 1
ulysses underhill 1
ulysses underhill 1
ulysses underhill 1
ulysses underhill 1
ulysses van buren 1
ulysses white 1
ulysses white 1
ulysses xylophone 2
ulysses xylophone 1
ulysses xylophone 1
ulysses young 2
ulysses young 1
ulysses young 1
victor allen 1
victor allen 1
victor brown 1
victor brown 1
victor brown 1
victor brown 1
victor davidson 1
victor davidson 1
victor davidson 1
victor ellison 2
victor ellison 1
victor hernandez 1
victor hernandez 1
victor hernandez 1
victor hernandez 1
victor hernandez 1
victor johnson 2
victor johnson 1
victor johnson 1
victor king 1
victor king 1
victor laertes 1
victor laertes 1
victor miller 1
victor nixon 1
victor nixon 1
victor ovid 2
victor polk 2
victor quirinius 1
victor quirinius 1
victor robinson 2
victor robinson 1
victor steinbeck 2
victor steinbeck 1
victor steinbeck 1
victor thompson 1
victor van buren 1
victor van buren 1
victor white 2
victor white 1
victor xylophone 1
victor xylophone 1
victor xylophone 1
victor xylophone 1
victor xylophone 1
victor young 1
victor zipper 1
wendy allen 1
wendy allen 1
wendy allen 1
wendy brown 1
wendy brown 1
wendy ellison 1
wendy ellison 1
wendy falkner 2
wendy falkner 1
wendy falkner 1
wendy garcia 2
wendy garcia 1
wendy garcia 1
wendy garcia 1
wendy hernandez 1
wendy ichabod 1
wendy king 1
wendy king 1
wendy king 1
wendy laertes 1
wendy laertes 1
wendy laertes 1
wendy miller 1
wendy miller 1
wendy nixon 1
wendy nixon 1
wendy ovid 1
wendy ovid 1
wendy polk 2
wendy polk 1
wendy quirinius 1
wendy quirinius 1
wendy robinson 2
wendy robinson 1
wendy robinson 1
wendy steinbeck 1
wendy thompson 2
wendy thompson 1
wendy underhill 2
wendy underhill 1
wendy underhill 1
wendy van buren 1
wendy van buren 1
wendy white 1
wendy xylophone 1
wendy xylophone 1
wendy young 1
wendy young 1
xavier allen 1
xavier allen 1
xavier allen 1
xavier brown 1
xavier brown 1
xavier brown 1
xavier carson 1
xavier carson 1
xavier davidson 1
xavier davidson 1
xavier davidson 1
xavier ellison 1
xavier ellison 1
xavier garcia 1
xavier hernandez 1
xavier hernandez 1
xavier hernandez 1
xavier ichabod 1
xavier ichabod 1
xavier johnson 1
xavier johnson 1
xavier king 1
xavier king 1
xavier laertes 1
xavier ovid 2
xavier polk 1
xavier polk 1
xavier polk 1
xavier polk 1
xavier quirinius 2
xavier quirinius 2
xavier quirinius 1
xavier quirinius 1
xavier thompson 1
xavier underhill 1
xavier white 2
xavier white 1
xavier xylophone 1
xavier zipper 1
yuri allen 1
yuri allen 1
yuri brown 1
yuri brown 1
yuri carson 1
yuri carson 1
yuri ellison 1
yuri ellison 1
yuri falkner 1
yuri falkner 1
yuri garcia 1
yuri hernandez 1
yuri johnson 1
yuri johnson 1
yuri johnson 1
yuri king 2
yuri laertes 1
yuri laertes 1
yuri nixon 1
yuri nixon 1
yuri polk 1
yuri polk 1
yuri polk 1
yuri quirinius 1
yuri quirinius 1
yuri quirinius 1
yuri steinbeck 1
yuri steinbeck 1
yuri thompson 1
yuri underhill 1
yuri underhill 1
yuri white 1
yuri xylophone 1
zach allen 1
zach brown 2
zach brown 1
zach brown 1
zach brown 1
zach brown 1
zach carson 2
zach ellison 1
zach falkner 1
zach falkner 1
zach garcia 2
zach garcia 1
zach garcia 1
zach garcia 1
zach ichabod 1
zach ichabod 1
zach king 2
zach king 1
zach king 1
zach miller 1
zach miller 1
zach miller 1
zach ovid 1
zach ovid 1
zach ovid 1
zach ovid 1
zach quirinius 1
zach robinson 1
zach steinbeck 1
zach steinbeck 1
zach thompson 2
zach thompson 1
zach underhill 1
zach white 1
zach xylophone 2
zach xylophone 1
zach young 1
zach zipper 1
zach zipper 1
zach zipper 1
at org.scalatest.Assertions$class.newAssertionFailedException(Assertions.scala:528)
at org.scalatest.FunSuite.newAssertionFailedException(FunSuite.scala:1560)
at org.scalatest.Assertions$class.fail(Assertions.scala:1089)
at org.scalatest.FunSuite.fail(FunSuite.scala:1560)
at org.apache.spark.sql.hive.execution.HiveComparisonTest$$anonfun$createQueryTest$6$$anonfun$25.apply(HiveComparisonTest.scala:363)
at org.apache.spark.sql.hive.execution.HiveComparisonTest$$anonfun$createQueryTest$6$$anonfun$25.apply(HiveComparisonTest.scala:345)
at scala.collection.TraversableLike$$anonfun$map$1.apply(TraversableLike.scala:234)
at scala.collection.TraversableLike$$anonfun$map$1.apply(TraversableLike.scala:234)
at scala.collection.mutable.ResizableArray$class.foreach(ResizableArray.scala:59)
at scala.collection.mutable.ArrayBuffer.foreach(ArrayBuffer.scala:48)
at scala.collection.TraversableLike$class.map(TraversableLike.scala:234)
at scala.collection.AbstractTraversable.map(Traversable.scala:104)
at org.apache.spark.sql.hive.execution.HiveComparisonTest$$anonfun$createQueryTest$6.doTest$1(HiveComparisonTest.scala:345)
at org.apache.spark.sql.hive.execution.HiveComparisonTest$$anonfun$createQueryTest$6.apply(HiveComparisonTest.scala:462)
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:186)
at org.apache.spark.SparkFunSuite.withFixture(SparkFunSuite.scala:103)
at org.scalatest.FunSuiteLike$class.invokeWithFixture$1(FunSuiteLike.scala:183)
at org.scalatest.FunSuiteLike$$anonfun$runTest$1.apply(FunSuiteLike.scala:196)
at org.scalatest.FunSuiteLike$$anonfun$runTest$1.apply(FunSuiteLike.scala:196)
at org.scalatest.SuperEngine.runTestImpl(Engine.scala:289)
at org.scalatest.FunSuiteLike$class.runTest(FunSuiteLike.scala:196)
at org.apache.spark.sql.hive.execution.HiveWindowFunctionQuerySuite.org$scalatest$BeforeAndAfter$$super$runTest(HiveWindowFunctionQuerySuite.scala:35)
at org.scalatest.BeforeAndAfter$class.runTest(BeforeAndAfter.scala:203)
at org.apache.spark.sql.hive.execution.HiveWindowFunctionQuerySuite.runTest(HiveWindowFunctionQuerySuite.scala:35)
at org.scalatest.FunSuiteLike$$anonfun$runTests$1.apply(FunSuiteLike.scala:229)
at org.scalatest.FunSuiteLike$$anonfun$runTests$1.apply(FunSuiteLike.scala:229)
at org.scalatest.SuperEngine$$anonfun$traverseSubNodes$1$1.apply(Engine.scala:396)
at org.scalatest.SuperEngine$$anonfun$traverseSubNodes$1$1.apply(Engine.scala:384)
at scala.collection.immutable.List.foreach(List.scala:392)
at org.scalatest.SuperEngine.traverseSubNodes$1(Engine.scala:384)
at org.scalatest.SuperEngine.org$scalatest$SuperEngine$$runTestsInBranch(Engine.scala:379)
at org.scalatest.SuperEngine.runTestsImpl(Engine.scala:461)
at org.scalatest.FunSuiteLike$class.runTests(FunSuiteLike.scala:229)
at org.scalatest.FunSuite.runTests(FunSuite.scala:1560)
at org.scalatest.Suite$class.run(Suite.scala:1147)
at org.scalatest.FunSuite.org$scalatest$FunSuiteLike$$super$run(FunSuite.scala:1560)
at org.scalatest.FunSuiteLike$$anonfun$run$1.apply(FunSuiteLike.scala:233)
at org.scalatest.FunSuiteLike$$anonfun$run$1.apply(FunSuiteLike.scala:233)
at org.scalatest.SuperEngine.runImpl(Engine.scala:521)
at org.scalatest.FunSuiteLike$class.run(FunSuiteLike.scala:233)
at org.apache.spark.SparkFunSuite.org$scalatest$BeforeAndAfterAll$$super$run(SparkFunSuite.scala:52)
at org.scalatest.BeforeAndAfterAll$class.liftedTree1$1(BeforeAndAfterAll.scala:213)
at org.scalatest.BeforeAndAfterAll$class.run(BeforeAndAfterAll.scala:210)
at org.apache.spark.sql.hive.execution.HiveWindowFunctionQuerySuite.org$scalatest$BeforeAndAfter$$super$run(HiveWindowFunctionQuerySuite.scala:35)
at org.scalatest.BeforeAndAfter$class.run(BeforeAndAfter.scala:258)
at org.apache.spark.sql.hive.execution.HiveWindowFunctionQuerySuite.run(HiveWindowFunctionQuerySuite.scala:35)
at org.scalatest.tools.Framework.org$scalatest$tools$Framework$$runSuite(Framework.scala:314)
at org.scalatest.tools.Framework$ScalaTestTask.execute(Framework.scala:480)
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:1149)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
at java.lang.Thread.run(Thread.java:748)