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)