&#010;Failed to execute query using catalyst:&#010;Error: execute, tree:&#010;Exchange rangepartitioning(s#204183 ASC NULLS FIRST, rn#204174 DESC NULLS LAST, 5), true, [id=#151594]&#010;+- *(2) Project [s#204183, rn#204174]&#010; +- Window [row_number() windowspecdefinition(d#204181, dec#204185 ASC NULLS FIRST, specifiedwindowframe(RowFrame, unboundedpreceding$(), currentrow$())) AS rn#204174], [knownfloatingpointnormalized(normalizenanandzero(d#204181))], [dec#204185 ASC NULLS FIRST]&#010; +- *(1) Sort [knownfloatingpointnormalized(normalizenanandzero(d#204181)) ASC NULLS FIRST, dec#204185 ASC NULLS FIRST], false, 0&#010; +- Exchange hashpartitioning(knownfloatingpointnormalized(normalizenanandzero(d#204181)), 5), true, [id=#151580]&#010; +- Scan hive default.over1k [s#204183, d#204181, dec#204185], HiveTableRelation `default`.`over1k`, org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe, [t#204176, si#204177, i#204178, b#204179L, f#204180, d#204181, bo#204182, s#204183, ts#204184, dec#204185, bin#204186]&#010;&#010;org.apache.spark.sql.catalyst.errors.package$TreeNodeException: execute, tree:&#010;Exchange rangepartitioning(s#204183 ASC NULLS FIRST, rn#204174 DESC NULLS LAST, 5), true, [id=#151594]&#010;+- *(2) Project [s#204183, rn#204174]&#010; +- Window [row_number() windowspecdefinition(d#204181, dec#204185 ASC NULLS FIRST, specifiedwindowframe(RowFrame, unboundedpreceding$(), currentrow$())) AS rn#204174], [knownfloatingpointnormalized(normalizenanandzero(d#204181))], [dec#204185 ASC NULLS FIRST]&#010; +- *(1) Sort [knownfloatingpointnormalized(normalizenanandzero(d#204181)) ASC NULLS FIRST, dec#204185 ASC NULLS FIRST], false, 0&#010; +- Exchange hashpartitioning(knownfloatingpointnormalized(normalizenanandzero(d#204181)), 5), true, [id=#151580]&#010; +- Scan hive default.over1k [s#204183, d#204181, dec#204185], HiveTableRelation `default`.`over1k`, org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe, [t#204176, si#204177, i#204178, b#204179L, f#204180, d#204181, bo#204182, s#204183, ts#204184, dec#204185, bin#204186]&#010;&#010; at org.apache.spark.sql.catalyst.errors.package$.attachTree(package.scala:56)&#010; at org.apache.spark.sql.execution.exchange.ShuffleExchangeExec.doExecute(ShuffleExchangeExec.scala:90)&#010; at org.apache.spark.sql.execution.SparkPlan.$anonfun$execute$1(SparkPlan.scala:189)&#010; at org.apache.spark.sql.execution.SparkPlan.$anonfun$executeQuery$1(SparkPlan.scala:227)&#010; at org.apache.spark.rdd.RDDOperationScope$.withScope(RDDOperationScope.scala:151)&#010; at org.apache.spark.sql.execution.SparkPlan.executeQuery(SparkPlan.scala:224)&#010; at org.apache.spark.sql.execution.SparkPlan.execute(SparkPlan.scala:185)&#010; at org.apache.spark.sql.execution.InputAdapter.inputRDD(WholeStageCodegenExec.scala:524)&#010; at org.apache.spark.sql.execution.InputRDDCodegen.inputRDDs(WholeStageCodegenExec.scala:452)&#010; at org.apache.spark.sql.execution.InputRDDCodegen.inputRDDs$(WholeStageCodegenExec.scala:451)&#010; at org.apache.spark.sql.execution.InputAdapter.inputRDDs(WholeStageCodegenExec.scala:495)&#010; at org.apache.spark.sql.execution.SortExec.inputRDDs(SortExec.scala:124)&#010; at org.apache.spark.sql.execution.WholeStageCodegenExec.doExecute(WholeStageCodegenExec.scala:717)&#010; at org.apache.spark.sql.execution.SparkPlan.$anonfun$execute$1(SparkPlan.scala:189)&#010; at org.apache.spark.sql.execution.SparkPlan.$anonfun$executeQuery$1(SparkPlan.scala:227)&#010; at org.apache.spark.rdd.RDDOperationScope$.withScope(RDDOperationScope.scala:151)&#010; at org.apache.spark.sql.execution.SparkPlan.executeQuery(SparkPlan.scala:224)&#010; at org.apache.spark.sql.execution.SparkPlan.execute(SparkPlan.scala:185)&#010; at org.apache.spark.sql.execution.SparkPlan.getByteArrayRdd(SparkPlan.scala:329)&#010; at org.apache.spark.sql.execution.SparkPlan.executeCollect(SparkPlan.scala:378)&#010; at org.apache.spark.sql.execution.SparkPlan.executeCollectPublic(SparkPlan.scala:408)&#010; at org.apache.spark.sql.execution.HiveResult$.hiveResultString(HiveResult.scala:52)&#010; at org.apache.spark.sql.hive.execution.HiveComparisonTest.$anonfun$createQueryTest$32(HiveComparisonTest.scala:351)&#010; at org.apache.spark.sql.execution.SQLExecution$.$anonfun$withNewExecutionId$4(SQLExecution.scala:100)&#010; at org.apache.spark.sql.execution.SQLExecution$.withSQLConfPropagated(SQLExecution.scala:160)&#010; at org.apache.spark.sql.execution.SQLExecution$.withNewExecutionId(SQLExecution.scala:87)&#010; at org.apache.spark.sql.hive.execution.HiveComparisonTest.getResult$1(HiveComparisonTest.scala:351)&#010; at org.apache.spark.sql.hive.execution.HiveComparisonTest.$anonfun$createQueryTest$31(HiveComparisonTest.scala:353)&#010; at scala.collection.TraversableLike.$anonfun$map$1(TraversableLike.scala:237)&#010; at scala.collection.mutable.ResizableArray.foreach(ResizableArray.scala:62)&#010; at scala.collection.mutable.ResizableArray.foreach$(ResizableArray.scala:55)&#010; at scala.collection.mutable.ArrayBuffer.foreach(ArrayBuffer.scala:49)&#010; at scala.collection.TraversableLike.map(TraversableLike.scala:237)&#010; at scala.collection.TraversableLike.map$(TraversableLike.scala:230)&#010; at scala.collection.AbstractTraversable.map(Traversable.scala:108)&#010; at org.apache.spark.sql.hive.execution.HiveComparisonTest.doTest$1(HiveComparisonTest.scala:347)&#010; at org.apache.spark.sql.hive.execution.HiveComparisonTest.$anonfun$createQueryTest$10(HiveComparisonTest.scala:467)&#010; at org.scalatest.OutcomeOf.outcomeOf(OutcomeOf.scala:85)&#010; at org.scalatest.OutcomeOf.outcomeOf$(OutcomeOf.scala:83)&#010; at org.scalatest.OutcomeOf$.outcomeOf(OutcomeOf.scala:104)&#010; at org.scalatest.Transformer.apply(Transformer.scala:22)&#010; at org.scalatest.Transformer.apply(Transformer.scala:20)&#010; at org.scalatest.FunSuiteLike$$anon$1.apply(FunSuiteLike.scala:186)&#010; at org.apache.spark.SparkFunSuite.withFixture(SparkFunSuite.scala:149)&#010; at org.scalatest.FunSuiteLike.invokeWithFixture$1(FunSuiteLike.scala:184)&#010; at org.scalatest.FunSuiteLike.$anonfun$runTest$1(FunSuiteLike.scala:196)&#010; at org.scalatest.SuperEngine.runTestImpl(Engine.scala:289)&#010; at org.scalatest.FunSuiteLike.runTest(FunSuiteLike.scala:196)&#010; at org.scalatest.FunSuiteLike.runTest$(FunSuiteLike.scala:178)&#010; at org.apache.spark.SparkFunSuite.org$scalatest$BeforeAndAfterEach$$super$runTest(SparkFunSuite.scala:56)&#010; at org.scalatest.BeforeAndAfterEach.runTest(BeforeAndAfterEach.scala:221)&#010; at org.scalatest.BeforeAndAfterEach.runTest$(BeforeAndAfterEach.scala:214)&#010; at org.apache.spark.sql.hive.execution.HiveWindowFunctionQuerySuite.org$scalatest$BeforeAndAfter$$super$runTest(HiveWindowFunctionQuerySuite.scala:35)&#010; at org.scalatest.BeforeAndAfter.runTest(BeforeAndAfter.scala:203)&#010; at org.scalatest.BeforeAndAfter.runTest$(BeforeAndAfter.scala:192)&#010; at org.apache.spark.sql.hive.execution.HiveWindowFunctionQuerySuite.runTest(HiveWindowFunctionQuerySuite.scala:35)&#010; at org.scalatest.FunSuiteLike.$anonfun$runTests$1(FunSuiteLike.scala:229)&#010; at org.scalatest.SuperEngine.$anonfun$runTestsInBranch$1(Engine.scala:396)&#010; at scala.collection.immutable.List.foreach(List.scala:392)&#010; at org.scalatest.SuperEngine.traverseSubNodes$1(Engine.scala:384)&#010; at org.scalatest.SuperEngine.runTestsInBranch(Engine.scala:379)&#010; at org.scalatest.SuperEngine.runTestsImpl(Engine.scala:461)&#010; at org.scalatest.FunSuiteLike.runTests(FunSuiteLike.scala:229)&#010; at org.scalatest.FunSuiteLike.runTests$(FunSuiteLike.scala:228)&#010; at org.scalatest.FunSuite.runTests(FunSuite.scala:1560)&#010; at org.scalatest.Suite.run(Suite.scala:1147)&#010; at org.scalatest.Suite.run$(Suite.scala:1129)&#010; at org.scalatest.FunSuite.org$scalatest$FunSuiteLike$$super$run(FunSuite.scala:1560)&#010; at org.scalatest.FunSuiteLike.$anonfun$run$1(FunSuiteLike.scala:233)&#010; at org.scalatest.SuperEngine.runImpl(Engine.scala:521)&#010; at org.scalatest.FunSuiteLike.run(FunSuiteLike.scala:233)&#010; at org.scalatest.FunSuiteLike.run$(FunSuiteLike.scala:232)&#010; at org.apache.spark.SparkFunSuite.org$scalatest$BeforeAndAfterAll$$super$run(SparkFunSuite.scala:56)&#010; at org.scalatest.BeforeAndAfterAll.liftedTree1$1(BeforeAndAfterAll.scala:213)&#010; at org.scalatest.BeforeAndAfterAll.run(BeforeAndAfterAll.scala:210)&#010; at org.scalatest.BeforeAndAfterAll.run$(BeforeAndAfterAll.scala:208)&#010; at org.apache.spark.sql.hive.execution.HiveWindowFunctionQuerySuite.org$scalatest$BeforeAndAfter$$super$run(HiveWindowFunctionQuerySuite.scala:35)&#010; at org.scalatest.BeforeAndAfter.run(BeforeAndAfter.scala:258)&#010; at org.scalatest.BeforeAndAfter.run$(BeforeAndAfter.scala:256)&#010; at org.apache.spark.sql.hive.execution.HiveWindowFunctionQuerySuite.run(HiveWindowFunctionQuerySuite.scala:35)&#010; at org.scalatest.Suite.callExecuteOnSuite$1(Suite.scala:1210)&#010; at org.scalatest.Suite.$anonfun$runNestedSuites$1(Suite.scala:1257)&#010; at scala.collection.IndexedSeqOptimized.foreach(IndexedSeqOptimized.scala:36)&#010; at scala.collection.IndexedSeqOptimized.foreach$(IndexedSeqOptimized.scala:33)&#010; at scala.collection.mutable.ArrayOps$ofRef.foreach(ArrayOps.scala:198)&#010; at org.scalatest.Suite.runNestedSuites(Suite.scala:1255)&#010; at org.scalatest.Suite.runNestedSuites$(Suite.scala:1189)&#010; at org.scalatest.tools.DiscoverySuite.runNestedSuites(DiscoverySuite.scala:30)&#010; at org.scalatest.Suite.run(Suite.scala:1144)&#010; at org.scalatest.Suite.run$(Suite.scala:1129)&#010; at org.scalatest.tools.DiscoverySuite.run(DiscoverySuite.scala:30)&#010; at org.scalatest.tools.SuiteRunner.run(SuiteRunner.scala:45)&#010; at org.scalatest.tools.Runner$.$anonfun$doRunRunRunDaDoRunRun$13(Runner.scala:1346)&#010; at org.scalatest.tools.Runner$.$anonfun$doRunRunRunDaDoRunRun$13$adapted(Runner.scala:1340)&#010; at scala.collection.immutable.List.foreach(List.scala:392)&#010; at org.scalatest.tools.Runner$.doRunRunRunDaDoRunRun(Runner.scala:1340)&#010; at org.scalatest.tools.Runner$.$anonfun$runOptionallyWithPassFailReporter$24(Runner.scala:1031)&#010; at org.scalatest.tools.Runner$.$anonfun$runOptionallyWithPassFailReporter$24$adapted(Runner.scala:1010)&#010; at org.scalatest.tools.Runner$.withClassLoaderAndDispatchReporter(Runner.scala:1506)&#010; at org.scalatest.tools.Runner$.runOptionallyWithPassFailReporter(Runner.scala:1010)&#010; at org.scalatest.tools.Runner$.main(Runner.scala:827)&#010; at org.scalatest.tools.Runner.main(Runner.scala)&#010;Caused by: org.apache.spark.sql.catalyst.errors.package$TreeNodeException: execute, tree:&#010;Exchange hashpartitioning(knownfloatingpointnormalized(normalizenanandzero(d#204181)), 5), true, [id=#151580]&#010;+- Scan hive default.over1k [s#204183, d#204181, dec#204185], HiveTableRelation `default`.`over1k`, org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe, [t#204176, si#204177, i#204178, b#204179L, f#204180, d#204181, bo#204182, s#204183, ts#204184, dec#204185, bin#204186]&#010;&#010; at org.apache.spark.sql.catalyst.errors.package$.attachTree(package.scala:56)&#010; at org.apache.spark.sql.execution.exchange.ShuffleExchangeExec.doExecute(ShuffleExchangeExec.scala:90)&#010; at org.apache.spark.sql.execution.SparkPlan.$anonfun$execute$1(SparkPlan.scala:189)&#010; at org.apache.spark.sql.execution.SparkPlan.$anonfun$executeQuery$1(SparkPlan.scala:227)&#010; at org.apache.spark.rdd.RDDOperationScope$.withScope(RDDOperationScope.scala:151)&#010; at org.apache.spark.sql.execution.SparkPlan.executeQuery(SparkPlan.scala:224)&#010; at org.apache.spark.sql.execution.SparkPlan.execute(SparkPlan.scala:185)&#010; at org.apache.spark.sql.execution.InputAdapter.inputRDD(WholeStageCodegenExec.scala:524)&#010; at org.apache.spark.sql.execution.InputRDDCodegen.inputRDDs(WholeStageCodegenExec.scala:452)&#010; at org.apache.spark.sql.execution.InputRDDCodegen.inputRDDs$(WholeStageCodegenExec.scala:451)&#010; at org.apache.spark.sql.execution.InputAdapter.inputRDDs(WholeStageCodegenExec.scala:495)&#010; at org.apache.spark.sql.execution.SortExec.inputRDDs(SortExec.scala:124)&#010; at org.apache.spark.sql.execution.WholeStageCodegenExec.doExecute(WholeStageCodegenExec.scala:717)&#010; at org.apache.spark.sql.execution.SparkPlan.$anonfun$execute$1(SparkPlan.scala:189)&#010; at org.apache.spark.sql.execution.SparkPlan.$anonfun$executeQuery$1(SparkPlan.scala:227)&#010; at org.apache.spark.rdd.RDDOperationScope$.withScope(RDDOperationScope.scala:151)&#010; at org.apache.spark.sql.execution.SparkPlan.executeQuery(SparkPlan.scala:224)&#010; at org.apache.spark.sql.execution.SparkPlan.execute(SparkPlan.scala:185)&#010; at org.apache.spark.sql.execution.window.WindowExec.doExecute(WindowExec.scala:115)&#010; at org.apache.spark.sql.execution.SparkPlan.$anonfun$execute$1(SparkPlan.scala:189)&#010; at org.apache.spark.sql.execution.SparkPlan.$anonfun$executeQuery$1(SparkPlan.scala:227)&#010; at org.apache.spark.rdd.RDDOperationScope$.withScope(RDDOperationScope.scala:151)&#010; at org.apache.spark.sql.execution.SparkPlan.executeQuery(SparkPlan.scala:224)&#010; at org.apache.spark.sql.execution.SparkPlan.execute(SparkPlan.scala:185)&#010; at org.apache.spark.sql.execution.InputAdapter.inputRDD(WholeStageCodegenExec.scala:524)&#010; at org.apache.spark.sql.execution.InputRDDCodegen.inputRDDs(WholeStageCodegenExec.scala:452)&#010; at org.apache.spark.sql.execution.InputRDDCodegen.inputRDDs$(WholeStageCodegenExec.scala:451)&#010; at org.apache.spark.sql.execution.InputAdapter.inputRDDs(WholeStageCodegenExec.scala:495)&#010; at org.apache.spark.sql.execution.ProjectExec.inputRDDs(basicPhysicalOperators.scala:45)&#010; at org.apache.spark.sql.execution.WholeStageCodegenExec.doExecute(WholeStageCodegenExec.scala:717)&#010; at org.apache.spark.sql.execution.SparkPlan.$anonfun$execute$1(SparkPlan.scala:189)&#010; at org.apache.spark.sql.execution.SparkPlan.$anonfun$executeQuery$1(SparkPlan.scala:227)&#010; at org.apache.spark.rdd.RDDOperationScope$.withScope(RDDOperationScope.scala:151)&#010; at org.apache.spark.sql.execution.SparkPlan.executeQuery(SparkPlan.scala:224)&#010; at org.apache.spark.sql.execution.SparkPlan.execute(SparkPlan.scala:185)&#010; at org.apache.spark.sql.execution.exchange.ShuffleExchangeExec.inputRDD$lzycompute(ShuffleExchangeExec.scala:64)&#010; at org.apache.spark.sql.execution.exchange.ShuffleExchangeExec.inputRDD(ShuffleExchangeExec.scala:64)&#010; at org.apache.spark.sql.execution.exchange.ShuffleExchangeExec.shuffleDependency$lzycompute(ShuffleExchangeExec.scala:74)&#010; at org.apache.spark.sql.execution.exchange.ShuffleExchangeExec.shuffleDependency(ShuffleExchangeExec.scala:72)&#010; at org.apache.spark.sql.execution.exchange.ShuffleExchangeExec.createShuffledRDD(ShuffleExchangeExec.scala:82)&#010; at org.apache.spark.sql.execution.exchange.ShuffleExchangeExec.$anonfun$doExecute$1(ShuffleExchangeExec.scala:93)&#010; at org.apache.spark.sql.catalyst.errors.package$.attachTree(package.scala:52)&#010; ... 101 more&#010;Caused by: java.lang.IllegalStateException: Cannot call methods on a stopped SparkContext.&#010;This stopped SparkContext was created at:&#010;&#010;org.apache.spark.sql.hive.StatisticsSuite.<init>(StatisticsSuite.scala:46)&#010;sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)&#010;sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)&#010;sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)&#010;java.lang.reflect.Constructor.newInstance(Constructor.java:423)&#010;java.lang.Class.newInstance(Class.java:442)&#010;org.scalatest.tools.DiscoverySuite$.getSuiteInstance(DiscoverySuite.scala:66)&#010;org.scalatest.tools.DiscoverySuite.$anonfun$nestedSuites$1(DiscoverySuite.scala:38)&#010;scala.collection.TraversableLike.$anonfun$map$1(TraversableLike.scala:237)&#010;scala.collection.Iterator.foreach(Iterator.scala:941)&#010;scala.collection.Iterator.foreach$(Iterator.scala:941)&#010;scala.collection.AbstractIterator.foreach(Iterator.scala:1429)&#010;scala.collection.IterableLike.foreach(IterableLike.scala:74)&#010;scala.collection.IterableLike.foreach$(IterableLike.scala:73)&#010;scala.collection.AbstractIterable.foreach(Iterable.scala:56)&#010;scala.collection.TraversableLike.map(TraversableLike.scala:237)&#010;scala.collection.TraversableLike.map$(TraversableLike.scala:230)&#010;scala.collection.AbstractTraversable.map(Traversable.scala:108)&#010;org.scalatest.tools.DiscoverySuite.<init>(DiscoverySuite.scala:37)&#010;org.scalatest.tools.Runner$.genDiscoSuites$1(Runner.scala:1165)&#010;&#010;The currently active SparkContext was created at:&#010;&#010;(No active SparkContext.)&#010; &#010; at org.apache.spark.SparkContext.assertNotStopped(SparkContext.scala:109)&#010; at org.apache.spark.SparkContext.broadcast(SparkContext.scala:1466)&#010; at org.apache.spark.sql.hive.HadoopTableReader.<init>(TableReader.scala:90)&#010; at org.apache.spark.sql.hive.execution.HiveTableScanExec.hadoopReader$lzycompute(HiveTableScanExec.scala:110)&#010; at org.apache.spark.sql.hive.execution.HiveTableScanExec.hadoopReader(HiveTableScanExec.scala:105)&#010; at org.apache.spark.sql.hive.execution.HiveTableScanExec.$anonfun$doExecute$1(HiveTableScanExec.scala:188)&#010; at org.apache.spark.util.Utils$.withDummyCallSite(Utils.scala:2488)&#010; at org.apache.spark.sql.hive.execution.HiveTableScanExec.doExecute(HiveTableScanExec.scala:188)&#010; at org.apache.spark.sql.execution.SparkPlan.$anonfun$execute$1(SparkPlan.scala:189)&#010; at org.apache.spark.sql.execution.SparkPlan.$anonfun$executeQuery$1(SparkPlan.scala:227)&#010; at org.apache.spark.rdd.RDDOperationScope$.withScope(RDDOperationScope.scala:151)&#010; at org.apache.spark.sql.execution.SparkPlan.executeQuery(SparkPlan.scala:224)&#010; at org.apache.spark.sql.execution.SparkPlan.execute(SparkPlan.scala:185)&#010; at org.apache.spark.sql.execution.exchange.ShuffleExchangeExec.inputRDD$lzycompute(ShuffleExchangeExec.scala:64)&#010; at org.apache.spark.sql.execution.exchange.ShuffleExchangeExec.inputRDD(ShuffleExchangeExec.scala:64)&#010; at org.apache.spark.sql.execution.exchange.ShuffleExchangeExec.shuffleDependency$lzycompute(ShuffleExchangeExec.scala:74)&#010; at org.apache.spark.sql.execution.exchange.ShuffleExchangeExec.shuffleDependency(ShuffleExchangeExec.scala:72)&#010; at org.apache.spark.sql.execution.exchange.ShuffleExchangeExec.createShuffledRDD(ShuffleExchangeExec.scala:82)&#010; at org.apache.spark.sql.execution.exchange.ShuffleExchangeExec.$anonfun$doExecute$1(ShuffleExchangeExec.scala:93)&#010; at org.apache.spark.sql.catalyst.errors.package$.attachTree(package.scala:52)&#010; ... 142 more&#010;&#010;select s, row_number() over (partition by d order by dec) rn from over1k&#010;order by s, rn desc&#010;== Parsed Logical Plan ==&#010;'Sort ['s ASC NULLS FIRST, 'rn DESC NULLS LAST], true&#010;+- 'Project ['s, 'row_number() windowspecdefinition('d, 'dec ASC NULLS FIRST, unspecifiedframe$()) AS rn#204174]&#010; +- 'UnresolvedRelation [over1k]&#010;&#010;== Analyzed Logical Plan ==&#010;s: string, rn: int&#010;Sort [s#204183 ASC NULLS FIRST, rn#204174 DESC NULLS LAST], true&#010;+- Project [s#204183, rn#204174]&#010; +- Project [s#204183, d#204181, dec#204185, rn#204174, rn#204174]&#010; +- Window [row_number() windowspecdefinition(d#204181, dec#204185 ASC NULLS FIRST, specifiedwindowframe(RowFrame, unboundedpreceding$(), currentrow$())) AS rn#204174], [d#204181], [dec#204185 ASC NULLS FIRST]&#010; +- Project [s#204183, d#204181, dec#204185]&#010; +- SubqueryAlias `default`.`over1k`&#010; +- HiveTableRelation `default`.`over1k`, org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe, [t#204176, si#204177, i#204178, b#204179L, f#204180, d#204181, bo#204182, s#204183, ts#204184, dec#204185, bin#204186]&#010;&#010;== Optimized Logical Plan ==&#010;Sort [s#204183 ASC NULLS FIRST, rn#204174 DESC NULLS LAST], true&#010;+- Project [s#204183, rn#204174]&#010; +- Window [row_number() windowspecdefinition(d#204181, dec#204185 ASC NULLS FIRST, specifiedwindowframe(RowFrame, unboundedpreceding$(), currentrow$())) AS rn#204174], [knownfloatingpointnormalized(normalizenanandzero(d#204181))], [dec#204185 ASC NULLS FIRST]&#010; +- Project [s#204183, d#204181, dec#204185]&#010; +- HiveTableRelation `default`.`over1k`, org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe, [t#204176, si#204177, i#204178, b#204179L, f#204180, d#204181, bo#204182, s#204183, ts#204184, dec#204185, bin#204186]&#010;&#010;== Physical Plan ==&#010;*(3) Sort [s#204183 ASC NULLS FIRST, rn#204174 DESC NULLS LAST], true, 0&#010;+- Exchange rangepartitioning(s#204183 ASC NULLS FIRST, rn#204174 DESC NULLS LAST, 5), true, [id=#151594]&#010; +- *(2) Project [s#204183, rn#204174]&#010; +- Window [row_number() windowspecdefinition(d#204181, dec#204185 ASC NULLS FIRST, specifiedwindowframe(RowFrame, unboundedpreceding$(), currentrow$())) AS rn#204174], [knownfloatingpointnormalized(normalizenanandzero(d#204181))], [dec#204185 ASC NULLS FIRST]&#010; +- *(1) Sort [knownfloatingpointnormalized(normalizenanandzero(d#204181)) ASC NULLS FIRST, dec#204185 ASC NULLS FIRST], false, 0&#010; +- Exchange hashpartitioning(knownfloatingpointnormalized(normalizenanandzero(d#204181)), 5), true, [id=#151580]&#010; +- Scan hive default.over1k [s#204183, d#204181, dec#204185], HiveTableRelation `default`.`over1k`, org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe, [t#204176, si#204177, i#204178, b#204179L, f#204180, d#204181, bo#204182, s#204183, ts#204184, dec#204185, bin#204186]&#010;&#010;== HIVE - 1049 row(s) ==&#010; 1&#010; 1&#010; 1&#010;alice allen 2&#010;alice allen 1&#010;alice allen 1&#010;alice brown 1&#010;alice carson 1&#010;alice davidson 1&#010;alice falkner 1&#010;alice garcia 1&#010;alice hernandez 2&#010;alice hernandez 1&#010;alice johnson 2&#010;alice king 1&#010;alice king 1&#010;alice king 1&#010;alice laertes 1&#010;alice laertes 1&#010;alice miller 1&#010;alice nixon 1&#010;alice nixon 1&#010;alice nixon 1&#010;alice ovid 1&#010;alice polk 3&#010;alice quirinius 1&#010;alice quirinius 1&#010;alice robinson 1&#010;alice robinson 1&#010;alice steinbeck 1&#010;alice steinbeck 1&#010;alice steinbeck 1&#010;alice underhill 2&#010;alice van buren 1&#010;alice xylophone 1&#010;alice xylophone 1&#010;alice xylophone 1&#010;alice zipper 1&#010;alice zipper 1&#010;alice zipper 1&#010;bob brown 1&#010;bob brown 1&#010;bob brown 1&#010;bob carson 1&#010;bob davidson 1&#010;bob davidson 1&#010;bob davidson 1&#010;bob ellison 2&#010;bob ellison 1&#010;bob ellison 1&#010;bob ellison 1&#010;bob falkner 1&#010;bob garcia 1&#010;bob garcia 1&#010;bob garcia 1&#010;bob garcia 1&#010;bob garcia 1&#010;bob hernandez 1&#010;bob ichabod 1&#010;bob king 2&#010;bob king 1&#010;bob king 1&#010;bob laertes 2&#010;bob laertes 1&#010;bob miller 1&#010;bob ovid 1&#010;bob ovid 1&#010;bob ovid 1&#010;bob ovid 1&#010;bob polk 1&#010;bob quirinius 1&#010;bob steinbeck 1&#010;bob van buren 1&#010;bob white 1&#010;bob white 1&#010;bob xylophone 1&#010;bob xylophone 1&#010;bob young 1&#010;bob zipper 2&#010;bob zipper 1&#010;bob zipper 1&#010;calvin allen 1&#010;calvin brown 2&#010;calvin brown 1&#010;calvin brown 1&#010;calvin carson 2&#010;calvin davidson 2&#010;calvin davidson 1&#010;calvin ellison 1&#010;calvin falkner 1&#010;calvin falkner 1&#010;calvin falkner 1&#010;calvin falkner 1&#010;calvin falkner 1&#010;calvin falkner 1&#010;calvin garcia 1&#010;calvin hernandez 2&#010;calvin johnson 1&#010;calvin laertes 1&#010;calvin laertes 1&#010;calvin nixon 3&#010;calvin nixon 1&#010;calvin nixon 1&#010;calvin ovid 1&#010;calvin ovid 1&#010;calvin ovid 1&#010;calvin ovid 1&#010;calvin polk 1&#010;calvin quirinius 1&#010;calvin quirinius 1&#010;calvin robinson 2&#010;calvin steinbeck 1&#010;calvin steinbeck 1&#010;calvin steinbeck 1&#010;calvin thompson 1&#010;calvin thompson 1&#010;calvin underhill 1&#010;calvin van buren 1&#010;calvin van buren 1&#010;calvin white 1&#010;calvin white 1&#010;calvin xylophone 2&#010;calvin xylophone 1&#010;calvin xylophone 1&#010;calvin young 1&#010;calvin young 1&#010;calvin zipper 1&#010;calvin zipper 1&#010;david allen 1&#010;david allen 1&#010;david brown 1&#010;david brown 1&#010;david davidson 1&#010;david davidson 1&#010;david davidson 1&#010;david davidson 1&#010;david ellison 1&#010;david ellison 1&#010;david ellison 1&#010;david hernandez 1&#010;david ichabod 1&#010;david ichabod 1&#010;david laertes 1&#010;david nixon 1&#010;david ovid 1&#010;david ovid 1&#010;david quirinius 1&#010;david quirinius 1&#010;david quirinius 1&#010;david robinson 1&#010;david robinson 1&#010;david thompson 3&#010;david underhill 1&#010;david underhill 1&#010;david underhill 1&#010;david van buren 1&#010;david van buren 1&#010;david white 1&#010;david xylophone 1&#010;david xylophone 1&#010;david xylophone 1&#010;david young 1&#010;david young 1&#010;ethan allen 1&#010;ethan brown 2&#010;ethan brown 2&#010;ethan brown 1&#010;ethan brown 1&#010;ethan brown 1&#010;ethan brown 1&#010;ethan carson 1&#010;ethan ellison 1&#010;ethan ellison 1&#010;ethan falkner 3&#010;ethan falkner 1&#010;ethan garcia 1&#010;ethan hernandez 1&#010;ethan johnson 1&#010;ethan king 1&#010;ethan laertes 1&#010;ethan laertes 1&#010;ethan laertes 1&#010;ethan laertes 1&#010;ethan laertes 1&#010;ethan laertes 1&#010;ethan laertes 1&#010;ethan miller 2&#010;ethan nixon 1&#010;ethan ovid 1&#010;ethan polk 2&#010;ethan polk 1&#010;ethan polk 1&#010;ethan polk 1&#010;ethan quirinius 1&#010;ethan quirinius 1&#010;ethan quirinius 1&#010;ethan robinson 1&#010;ethan robinson 1&#010;ethan underhill 1&#010;ethan van buren 2&#010;ethan white 1&#010;ethan white 1&#010;ethan xylophone 1&#010;ethan zipper 1&#010;ethan zipper 1&#010;fred davidson 1&#010;fred davidson 1&#010;fred davidson 1&#010;fred ellison 1&#010;fred ellison 1&#010;fred ellison 1&#010;fred falkner 2&#010;fred falkner 1&#010;fred falkner 1&#010;fred hernandez 1&#010;fred ichabod 1&#010;fred ichabod 1&#010;fred johnson 1&#010;fred king 2&#010;fred king 1&#010;fred laertes 1&#010;fred miller 1&#010;fred nixon 2&#010;fred nixon 1&#010;fred nixon 1&#010;fred nixon 1&#010;fred polk 1&#010;fred polk 1&#010;fred polk 1&#010;fred polk 1&#010;fred quirinius 1&#010;fred quirinius 1&#010;fred robinson 1&#010;fred steinbeck 1&#010;fred steinbeck 1&#010;fred steinbeck 1&#010;fred underhill 1&#010;fred van buren 1&#010;fred van buren 1&#010;fred van buren 1&#010;fred van buren 1&#010;fred white 1&#010;fred young 3&#010;fred young 1&#010;fred zipper 1&#010;gabriella allen 1&#010;gabriella allen 1&#010;gabriella brown 2&#010;gabriella brown 1&#010;gabriella carson 1&#010;gabriella davidson 1&#010;gabriella ellison 1&#010;gabriella ellison 1&#010;gabriella falkner 1&#010;gabriella falkner 1&#010;gabriella falkner 1&#010;gabriella garcia 1&#010;gabriella hernandez 1&#010;gabriella hernandez 1&#010;gabriella ichabod 1&#010;gabriella ichabod 1&#010;gabriella ichabod 1&#010;gabriella ichabod 1&#010;gabriella ichabod 1&#010;gabriella king 1&#010;gabriella king 1&#010;gabriella laertes 1&#010;gabriella miller 1&#010;gabriella ovid 1&#010;gabriella ovid 1&#010;gabriella polk 1&#010;gabriella polk 1&#010;gabriella steinbeck 1&#010;gabriella steinbeck 1&#010;gabriella thompson 1&#010;gabriella thompson 1&#010;gabriella thompson 1&#010;gabriella van buren 2&#010;gabriella van buren 1&#010;gabriella white 1&#010;gabriella young 1&#010;gabriella young 1&#010;gabriella zipper 1&#010;gabriella zipper 1&#010;holly allen 1&#010;holly brown 1&#010;holly brown 1&#010;holly falkner 1&#010;holly hernandez 1&#010;holly hernandez 1&#010;holly hernandez 1&#010;holly hernandez 1&#010;holly ichabod 1&#010;holly ichabod 1&#010;holly ichabod 1&#010;holly johnson 2&#010;holly johnson 1&#010;holly johnson 1&#010;holly king 1&#010;holly king 1&#010;holly laertes 1&#010;holly miller 1&#010;holly nixon 1&#010;holly nixon 1&#010;holly polk 2&#010;holly polk 1&#010;holly robinson 2&#010;holly thompson 1&#010;holly thompson 1&#010;holly thompson 1&#010;holly underhill 1&#010;holly underhill 1&#010;holly underhill 1&#010;holly underhill 1&#010;holly van buren 1&#010;holly white 1&#010;holly white 1&#010;holly xylophone 1&#010;holly young 1&#010;holly young 1&#010;holly zipper 1&#010;holly zipper 1&#010;irene allen 1&#010;irene brown 1&#010;irene brown 1&#010;irene brown 1&#010;irene carson 1&#010;irene ellison 1&#010;irene ellison 1&#010;irene falkner 1&#010;irene falkner 1&#010;irene garcia 1&#010;irene garcia 1&#010;irene garcia 1&#010;irene ichabod 1&#010;irene ichabod 1&#010;irene johnson 2&#010;irene laertes 1&#010;irene laertes 1&#010;irene laertes 1&#010;irene miller 2&#010;irene nixon 1&#010;irene nixon 1&#010;irene nixon 1&#010;irene ovid 1&#010;irene ovid 1&#010;irene ovid 1&#010;irene polk 1&#010;irene polk 1&#010;irene polk 1&#010;irene polk 1&#010;irene polk 1&#010;irene quirinius 1&#010;irene quirinius 1&#010;irene quirinius 1&#010;irene robinson 1&#010;irene steinbeck 1&#010;irene thompson 2&#010;irene underhill 2&#010;irene underhill 1&#010;irene van buren 1&#010;irene van buren 1&#010;irene xylophone 1&#010;jessica brown 2&#010;jessica carson 1&#010;jessica carson 1&#010;jessica carson 1&#010;jessica davidson 2&#010;jessica davidson 1&#010;jessica davidson 1&#010;jessica davidson 1&#010;jessica ellison 2&#010;jessica ellison 1&#010;jessica falkner 1&#010;jessica garcia 1&#010;jessica garcia 1&#010;jessica ichabod 1&#010;jessica johnson 1&#010;jessica johnson 1&#010;jessica miller 1&#010;jessica nixon 1&#010;jessica nixon 1&#010;jessica ovid 2&#010;jessica ovid 1&#010;jessica polk 1&#010;jessica quirinius 1&#010;jessica quirinius 1&#010;jessica quirinius 1&#010;jessica quirinius 1&#010;jessica robinson 1&#010;jessica thompson 1&#010;jessica thompson 1&#010;jessica underhill 1&#010;jessica underhill 1&#010;jessica underhill 1&#010;jessica van buren 1&#010;jessica white 2&#010;jessica white 1&#010;jessica white 1&#010;jessica white 1&#010;jessica white 1&#010;jessica xylophone 1&#010;jessica young 1&#010;jessica young 1&#010;jessica zipper 1&#010;jessica zipper 1&#010;jessica zipper 1&#010;katie allen 1&#010;katie brown 1&#010;katie davidson 1&#010;katie ellison 1&#010;katie ellison 1&#010;katie falkner 1&#010;katie garcia 1&#010;katie garcia 1&#010;katie hernandez 1&#010;katie ichabod 2&#010;katie ichabod 1&#010;katie ichabod 1&#010;katie king 1&#010;katie king 1&#010;katie king 1&#010;katie miller 1&#010;katie miller 1&#010;katie nixon 1&#010;katie ovid 1&#010;katie polk 1&#010;katie polk 1&#010;katie robinson 1&#010;katie van buren 2&#010;katie van buren 1&#010;katie white 1&#010;katie white 1&#010;katie xylophone 1&#010;katie young 1&#010;katie young 1&#010;katie young 1&#010;katie zipper 1&#010;katie zipper 1&#010;luke allen 2&#010;luke allen 1&#010;luke allen 1&#010;luke allen 1&#010;luke allen 1&#010;luke brown 2&#010;luke davidson 1&#010;luke davidson 1&#010;luke ellison 1&#010;luke ellison 1&#010;luke ellison 1&#010;luke falkner 2&#010;luke falkner 1&#010;luke garcia 1&#010;luke garcia 1&#010;luke ichabod 1&#010;luke ichabod 1&#010;luke johnson 1&#010;luke johnson 1&#010;luke johnson 1&#010;luke laertes 1&#010;luke laertes 1&#010;luke laertes 1&#010;luke laertes 1&#010;luke laertes 1&#010;luke miller 2&#010;luke ovid 2&#010;luke ovid 1&#010;luke polk 1&#010;luke polk 1&#010;luke quirinius 1&#010;luke robinson 1&#010;luke robinson 1&#010;luke thompson 1&#010;luke underhill 1&#010;luke underhill 1&#010;luke underhill 1&#010;luke van buren 2&#010;luke white 1&#010;luke xylophone 1&#010;luke zipper 1&#010;mike allen 2&#010;mike brown 1&#010;mike carson 1&#010;mike carson 1&#010;mike carson 1&#010;mike davidson 1&#010;mike davidson 1&#010;mike ellison 2&#010;mike ellison 1&#010;mike ellison 1&#010;mike ellison 1&#010;mike ellison 1&#010;mike falkner 1&#010;mike garcia 1&#010;mike garcia 1&#010;mike garcia 1&#010;mike hernandez 1&#010;mike hernandez 1&#010;mike ichabod 1&#010;mike king 2&#010;mike king 1&#010;mike king 1&#010;mike king 1&#010;mike king 1&#010;mike king 1&#010;mike miller 1&#010;mike nixon 2&#010;mike nixon 1&#010;mike polk 2&#010;mike polk 1&#010;mike polk 1&#010;mike quirinius 1&#010;mike steinbeck 1&#010;mike steinbeck 1&#010;mike steinbeck 1&#010;mike steinbeck 1&#010;mike van buren 2&#010;mike van buren 1&#010;mike white 1&#010;mike white 1&#010;mike white 1&#010;mike white 1&#010;mike young 1&#010;mike young 1&#010;mike young 1&#010;mike zipper 1&#010;mike zipper 1&#010;mike zipper 1&#010;nick allen 1&#010;nick allen 1&#010;nick brown 1&#010;nick davidson 1&#010;nick ellison 2&#010;nick ellison 1&#010;nick falkner 1&#010;nick falkner 1&#010;nick garcia 1&#010;nick garcia 1&#010;nick garcia 1&#010;nick ichabod 1&#010;nick ichabod 1&#010;nick ichabod 1&#010;nick johnson 1&#010;nick johnson 1&#010;nick laertes 1&#010;nick miller 1&#010;nick nixon 1&#010;nick ovid 1&#010;nick polk 2&#010;nick quirinius 2&#010;nick quirinius 1&#010;nick robinson 1&#010;nick robinson 1&#010;nick steinbeck 1&#010;nick thompson 2&#010;nick underhill 1&#010;nick van buren 1&#010;nick xylophone 1&#010;nick young 1&#010;nick young 1&#010;nick zipper 2&#010;nick zipper 1&#010;oscar allen 1&#010;oscar brown 1&#010;oscar carson 1&#010;oscar carson 1&#010;oscar carson 1&#010;oscar carson 1&#010;oscar carson 1&#010;oscar davidson 1&#010;oscar ellison 2&#010;oscar ellison 2&#010;oscar falkner 1&#010;oscar garcia 1&#010;oscar hernandez 1&#010;oscar hernandez 1&#010;oscar ichabod 2&#010;oscar ichabod 1&#010;oscar ichabod 1&#010;oscar ichabod 1&#010;oscar johnson 2&#010;oscar johnson 1&#010;oscar king 1&#010;oscar king 1&#010;oscar king 1&#010;oscar laertes 1&#010;oscar laertes 1&#010;oscar laertes 1&#010;oscar laertes 1&#010;oscar nixon 1&#010;oscar ovid 1&#010;oscar ovid 1&#010;oscar ovid 1&#010;oscar polk 1&#010;oscar polk 1&#010;oscar quirinius 2&#010;oscar quirinius 2&#010;oscar quirinius 1&#010;oscar quirinius 1&#010;oscar robinson 2&#010;oscar robinson 1&#010;oscar robinson 1&#010;oscar robinson 1&#010;oscar steinbeck 1&#010;oscar thompson 1&#010;oscar thompson 1&#010;oscar thompson 1&#010;oscar thompson 1&#010;oscar underhill 1&#010;oscar van buren 1&#010;oscar van buren 1&#010;oscar van buren 1&#010;oscar white 1&#010;oscar white 1&#010;oscar white 1&#010;oscar white 1&#010;oscar xylophone 2&#010;oscar xylophone 1&#010;oscar xylophone 1&#010;oscar zipper 2&#010;oscar zipper 1&#010;oscar zipper 1&#010;priscilla brown 2&#010;priscilla brown 1&#010;priscilla brown 1&#010;priscilla carson 2&#010;priscilla carson 1&#010;priscilla carson 1&#010;priscilla ichabod 2&#010;priscilla ichabod 1&#010;priscilla johnson 1&#010;priscilla johnson 1&#010;priscilla johnson 1&#010;priscilla johnson 1&#010;priscilla johnson 1&#010;priscilla king 1&#010;priscilla nixon 2&#010;priscilla nixon 2&#010;priscilla ovid 2&#010;priscilla ovid 1&#010;priscilla polk 1&#010;priscilla quirinius 1&#010;priscilla thompson 1&#010;priscilla underhill 1&#010;priscilla underhill 1&#010;priscilla van buren 2&#010;priscilla van buren 1&#010;priscilla van buren 1&#010;priscilla white 1&#010;priscilla xylophone 1&#010;priscilla xylophone 1&#010;priscilla xylophone 1&#010;priscilla young 1&#010;priscilla young 1&#010;priscilla zipper 1&#010;priscilla zipper 1&#010;quinn allen 1&#010;quinn allen 1&#010;quinn brown 1&#010;quinn brown 1&#010;quinn brown 1&#010;quinn davidson 2&#010;quinn davidson 1&#010;quinn davidson 1&#010;quinn davidson 1&#010;quinn ellison 1&#010;quinn ellison 1&#010;quinn garcia 1&#010;quinn garcia 1&#010;quinn garcia 1&#010;quinn garcia 1&#010;quinn ichabod 1&#010;quinn king 1&#010;quinn king 1&#010;quinn laertes 1&#010;quinn laertes 1&#010;quinn laertes 1&#010;quinn nixon 2&#010;quinn ovid 1&#010;quinn quirinius 1&#010;quinn robinson 2&#010;quinn steinbeck 1&#010;quinn steinbeck 1&#010;quinn thompson 1&#010;quinn thompson 1&#010;quinn underhill 2&#010;quinn underhill 1&#010;quinn underhill 1&#010;quinn van buren 1&#010;quinn young 2&#010;quinn zipper 1&#010;quinn zipper 1&#010;rachel allen 1&#010;rachel allen 1&#010;rachel brown 3&#010;rachel brown 1&#010;rachel brown 1&#010;rachel brown 1&#010;rachel brown 1&#010;rachel carson 2&#010;rachel carson 1&#010;rachel davidson 1&#010;rachel ellison 1&#010;rachel falkner 1&#010;rachel falkner 1&#010;rachel falkner 1&#010;rachel falkner 1&#010;rachel johnson 1&#010;rachel king 2&#010;rachel king 1&#010;rachel laertes 1&#010;rachel laertes 1&#010;rachel ovid 1&#010;rachel ovid 1&#010;rachel polk 1&#010;rachel quirinius 1&#010;rachel robinson 1&#010;rachel robinson 1&#010;rachel robinson 1&#010;rachel thompson 1&#010;rachel thompson 1&#010;rachel thompson 1&#010;rachel underhill 1&#010;rachel white 1&#010;rachel white 1&#010;rachel young 1&#010;rachel zipper 1&#010;rachel zipper 1&#010;sarah carson 1&#010;sarah carson 1&#010;sarah carson 1&#010;sarah ellison 1&#010;sarah falkner 1&#010;sarah falkner 1&#010;sarah garcia 1&#010;sarah garcia 1&#010;sarah garcia 1&#010;sarah ichabod 1&#010;sarah ichabod 1&#010;sarah johnson 1&#010;sarah johnson 1&#010;sarah johnson 1&#010;sarah johnson 1&#010;sarah king 1&#010;sarah king 1&#010;sarah miller 1&#010;sarah ovid 1&#010;sarah robinson 1&#010;sarah robinson 1&#010;sarah steinbeck 1&#010;sarah white 1&#010;sarah white 1&#010;sarah xylophone 1&#010;sarah young 1&#010;sarah zipper 1&#010;tom brown 1&#010;tom brown 1&#010;tom carson 1&#010;tom carson 1&#010;tom carson 1&#010;tom davidson 1&#010;tom ellison 1&#010;tom ellison 1&#010;tom ellison 1&#010;tom falkner 1&#010;tom falkner 1&#010;tom hernandez 1&#010;tom hernandez 1&#010;tom ichabod 1&#010;tom johnson 1&#010;tom johnson 1&#010;tom king 1&#010;tom laertes 2&#010;tom laertes 1&#010;tom miller 2&#010;tom miller 1&#010;tom miller 1&#010;tom nixon 2&#010;tom ovid 1&#010;tom polk 1&#010;tom polk 1&#010;tom quirinius 1&#010;tom quirinius 1&#010;tom robinson 1&#010;tom robinson 1&#010;tom robinson 1&#010;tom robinson 1&#010;tom steinbeck 3&#010;tom van buren 1&#010;tom van buren 1&#010;tom van buren 1&#010;tom white 2&#010;tom young 1&#010;tom young 1&#010;tom zipper 3&#010;ulysses brown 1&#010;ulysses carson 4&#010;ulysses carson 1&#010;ulysses carson 1&#010;ulysses carson 1&#010;ulysses davidson 2&#010;ulysses ellison 1&#010;ulysses garcia 1&#010;ulysses hernandez 1&#010;ulysses hernandez 1&#010;ulysses hernandez 1&#010;ulysses ichabod 1&#010;ulysses ichabod 1&#010;ulysses johnson 2&#010;ulysses king 1&#010;ulysses laertes 2&#010;ulysses laertes 1&#010;ulysses laertes 1&#010;ulysses miller 1&#010;ulysses miller 1&#010;ulysses nixon 1&#010;ulysses ovid 1&#010;ulysses polk 1&#010;ulysses polk 1&#010;ulysses polk 1&#010;ulysses polk 1&#010;ulysses quirinius 1&#010;ulysses robinson 1&#010;ulysses steinbeck 1&#010;ulysses steinbeck 1&#010;ulysses thompson 1&#010;ulysses underhill 2&#010;ulysses underhill 1&#010;ulysses underhill 1&#010;ulysses underhill 1&#010;ulysses underhill 1&#010;ulysses underhill 1&#010;ulysses underhill 1&#010;ulysses van buren 1&#010;ulysses white 1&#010;ulysses white 1&#010;ulysses xylophone 2&#010;ulysses xylophone 1&#010;ulysses xylophone 1&#010;ulysses young 2&#010;ulysses young 1&#010;ulysses young 1&#010;victor allen 1&#010;victor allen 1&#010;victor brown 1&#010;victor brown 1&#010;victor brown 1&#010;victor brown 1&#010;victor davidson 1&#010;victor davidson 1&#010;victor davidson 1&#010;victor ellison 2&#010;victor ellison 1&#010;victor hernandez 1&#010;victor hernandez 1&#010;victor hernandez 1&#010;victor hernandez 1&#010;victor hernandez 1&#010;victor johnson 2&#010;victor johnson 1&#010;victor johnson 1&#010;victor king 1&#010;victor king 1&#010;victor laertes 1&#010;victor laertes 1&#010;victor miller 1&#010;victor nixon 1&#010;victor nixon 1&#010;victor ovid 2&#010;victor polk 2&#010;victor quirinius 1&#010;victor quirinius 1&#010;victor robinson 2&#010;victor robinson 1&#010;victor steinbeck 2&#010;victor steinbeck 1&#010;victor steinbeck 1&#010;victor thompson 1&#010;victor van buren 1&#010;victor van buren 1&#010;victor white 2&#010;victor white 1&#010;victor xylophone 1&#010;victor xylophone 1&#010;victor xylophone 1&#010;victor xylophone 1&#010;victor xylophone 1&#010;victor young 1&#010;victor zipper 1&#010;wendy allen 1&#010;wendy allen 1&#010;wendy allen 1&#010;wendy brown 1&#010;wendy brown 1&#010;wendy ellison 1&#010;wendy ellison 1&#010;wendy falkner 2&#010;wendy falkner 1&#010;wendy falkner 1&#010;wendy garcia 2&#010;wendy garcia 1&#010;wendy garcia 1&#010;wendy garcia 1&#010;wendy hernandez 1&#010;wendy ichabod 1&#010;wendy king 1&#010;wendy king 1&#010;wendy king 1&#010;wendy laertes 1&#010;wendy laertes 1&#010;wendy laertes 1&#010;wendy miller 1&#010;wendy miller 1&#010;wendy nixon 1&#010;wendy nixon 1&#010;wendy ovid 1&#010;wendy ovid 1&#010;wendy polk 2&#010;wendy polk 1&#010;wendy quirinius 1&#010;wendy quirinius 1&#010;wendy robinson 2&#010;wendy robinson 1&#010;wendy robinson 1&#010;wendy steinbeck 1&#010;wendy thompson 2&#010;wendy thompson 1&#010;wendy underhill 2&#010;wendy underhill 1&#010;wendy underhill 1&#010;wendy van buren 1&#010;wendy van buren 1&#010;wendy white 1&#010;wendy xylophone 1&#010;wendy xylophone 1&#010;wendy young 1&#010;wendy young 1&#010;xavier allen 1&#010;xavier allen 1&#010;xavier allen 1&#010;xavier brown 1&#010;xavier brown 1&#010;xavier brown 1&#010;xavier carson 1&#010;xavier carson 1&#010;xavier davidson 1&#010;xavier davidson 1&#010;xavier davidson 1&#010;xavier ellison 1&#010;xavier ellison 1&#010;xavier garcia 1&#010;xavier hernandez 1&#010;xavier hernandez 1&#010;xavier hernandez 1&#010;xavier ichabod 1&#010;xavier ichabod 1&#010;xavier johnson 1&#010;xavier johnson 1&#010;xavier king 1&#010;xavier king 1&#010;xavier laertes 1&#010;xavier ovid 2&#010;xavier polk 1&#010;xavier polk 1&#010;xavier polk 1&#010;xavier polk 1&#010;xavier quirinius 2&#010;xavier quirinius 2&#010;xavier quirinius 1&#010;xavier quirinius 1&#010;xavier thompson 1&#010;xavier underhill 1&#010;xavier white 2&#010;xavier white 1&#010;xavier xylophone 1&#010;xavier zipper 1&#010;yuri allen 1&#010;yuri allen 1&#010;yuri brown 1&#010;yuri brown 1&#010;yuri carson 1&#010;yuri carson 1&#010;yuri ellison 1&#010;yuri ellison 1&#010;yuri falkner 1&#010;yuri falkner 1&#010;yuri garcia 1&#010;yuri hernandez 1&#010;yuri johnson 1&#010;yuri johnson 1&#010;yuri johnson 1&#010;yuri king 2&#010;yuri laertes 1&#010;yuri laertes 1&#010;yuri nixon 1&#010;yuri nixon 1&#010;yuri polk 1&#010;yuri polk 1&#010;yuri polk 1&#010;yuri quirinius 1&#010;yuri quirinius 1&#010;yuri quirinius 1&#010;yuri steinbeck 1&#010;yuri steinbeck 1&#010;yuri thompson 1&#010;yuri underhill 1&#010;yuri underhill 1&#010;yuri white 1&#010;yuri xylophone 1&#010;zach allen 1&#010;zach brown 2&#010;zach brown 1&#010;zach brown 1&#010;zach brown 1&#010;zach brown 1&#010;zach carson 2&#010;zach ellison 1&#010;zach falkner 1&#010;zach falkner 1&#010;zach garcia 2&#010;zach garcia 1&#010;zach garcia 1&#010;zach garcia 1&#010;zach ichabod 1&#010;zach ichabod 1&#010;zach king 2&#010;zach king 1&#010;zach king 1&#010;zach miller 1&#010;zach miller 1&#010;zach miller 1&#010;zach ovid 1&#010;zach ovid 1&#010;zach ovid 1&#010;zach ovid 1&#010;zach quirinius 1&#010;zach robinson 1&#010;zach steinbeck 1&#010;zach steinbeck 1&#010;zach thompson 2&#010;zach thompson 1&#010;zach underhill 1&#010;zach white 1&#010;zach xylophone 2&#010;zach xylophone 1&#010;zach young 1&#010;zach zipper 1&#010;zach zipper 1&#010;zach zipper 1&#010;


      org.scalatest.exceptions.TestFailedException: 
Failed to execute query using catalyst:
Error: execute, tree:
Exchange rangepartitioning(s#204183 ASC NULLS FIRST, rn#204174 DESC NULLS LAST, 5), true, [id=#151594]
+- *(2) Project [s#204183, rn#204174]
   +- Window [row_number() windowspecdefinition(d#204181, dec#204185 ASC NULLS FIRST, specifiedwindowframe(RowFrame, unboundedpreceding$(), currentrow$())) AS rn#204174], [knownfloatingpointnormalized(normalizenanandzero(d#204181))], [dec#204185 ASC NULLS FIRST]
      +- *(1) Sort [knownfloatingpointnormalized(normalizenanandzero(d#204181)) ASC NULLS FIRST, dec#204185 ASC NULLS FIRST], false, 0
         +- Exchange hashpartitioning(knownfloatingpointnormalized(normalizenanandzero(d#204181)), 5), true, [id=#151580]
            +- Scan hive default.over1k [s#204183, d#204181, dec#204185], HiveTableRelation `default`.`over1k`, org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe, [t#204176, si#204177, i#204178, b#204179L, f#204180, d#204181, bo#204182, s#204183, ts#204184, dec#204185, bin#204186]

org.apache.spark.sql.catalyst.errors.package$TreeNodeException: execute, tree:
Exchange rangepartitioning(s#204183 ASC NULLS FIRST, rn#204174 DESC NULLS LAST, 5), true, [id=#151594]
+- *(2) Project [s#204183, rn#204174]
   +- Window [row_number() windowspecdefinition(d#204181, dec#204185 ASC NULLS FIRST, specifiedwindowframe(RowFrame, unboundedpreceding$(), currentrow$())) AS rn#204174], [knownfloatingpointnormalized(normalizenanandzero(d#204181))], [dec#204185 ASC NULLS FIRST]
      +- *(1) Sort [knownfloatingpointnormalized(normalizenanandzero(d#204181)) ASC NULLS FIRST, dec#204185 ASC NULLS FIRST], false, 0
         +- Exchange hashpartitioning(knownfloatingpointnormalized(normalizenanandzero(d#204181)), 5), true, [id=#151580]
            +- Scan hive default.over1k [s#204183, d#204181, dec#204185], HiveTableRelation `default`.`over1k`, org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe, [t#204176, si#204177, i#204178, b#204179L, f#204180, d#204181, bo#204182, s#204183, ts#204184, dec#204185, bin#204186]

	at org.apache.spark.sql.catalyst.errors.package$.attachTree(package.scala:56)
	at org.apache.spark.sql.execution.exchange.ShuffleExchangeExec.doExecute(ShuffleExchangeExec.scala:90)
	at org.apache.spark.sql.execution.SparkPlan.$anonfun$execute$1(SparkPlan.scala:189)
	at org.apache.spark.sql.execution.SparkPlan.$anonfun$executeQuery$1(SparkPlan.scala:227)
	at org.apache.spark.rdd.RDDOperationScope$.withScope(RDDOperationScope.scala:151)
	at org.apache.spark.sql.execution.SparkPlan.executeQuery(SparkPlan.scala:224)
	at org.apache.spark.sql.execution.SparkPlan.execute(SparkPlan.scala:185)
	at org.apache.spark.sql.execution.InputAdapter.inputRDD(WholeStageCodegenExec.scala:524)
	at org.apache.spark.sql.execution.InputRDDCodegen.inputRDDs(WholeStageCodegenExec.scala:452)
	at org.apache.spark.sql.execution.InputRDDCodegen.inputRDDs$(WholeStageCodegenExec.scala:451)
	at org.apache.spark.sql.execution.InputAdapter.inputRDDs(WholeStageCodegenExec.scala:495)
	at org.apache.spark.sql.execution.SortExec.inputRDDs(SortExec.scala:124)
	at org.apache.spark.sql.execution.WholeStageCodegenExec.doExecute(WholeStageCodegenExec.scala:717)
	at org.apache.spark.sql.execution.SparkPlan.$anonfun$execute$1(SparkPlan.scala:189)
	at org.apache.spark.sql.execution.SparkPlan.$anonfun$executeQuery$1(SparkPlan.scala:227)
	at org.apache.spark.rdd.RDDOperationScope$.withScope(RDDOperationScope.scala:151)
	at org.apache.spark.sql.execution.SparkPlan.executeQuery(SparkPlan.scala:224)
	at org.apache.spark.sql.execution.SparkPlan.execute(SparkPlan.scala:185)
	at org.apache.spark.sql.execution.SparkPlan.getByteArrayRdd(SparkPlan.scala:329)
	at org.apache.spark.sql.execution.SparkPlan.executeCollect(SparkPlan.scala:378)
	at org.apache.spark.sql.execution.SparkPlan.executeCollectPublic(SparkPlan.scala:408)
	at org.apache.spark.sql.execution.HiveResult$.hiveResultString(HiveResult.scala:52)
	at org.apache.spark.sql.hive.execution.HiveComparisonTest.$anonfun$createQueryTest$32(HiveComparisonTest.scala:351)
	at org.apache.spark.sql.execution.SQLExecution$.$anonfun$withNewExecutionId$4(SQLExecution.scala:100)
	at org.apache.spark.sql.execution.SQLExecution$.withSQLConfPropagated(SQLExecution.scala:160)
	at org.apache.spark.sql.execution.SQLExecution$.withNewExecutionId(SQLExecution.scala:87)
	at org.apache.spark.sql.hive.execution.HiveComparisonTest.getResult$1(HiveComparisonTest.scala:351)
	at org.apache.spark.sql.hive.execution.HiveComparisonTest.$anonfun$createQueryTest$31(HiveComparisonTest.scala:353)
	at scala.collection.TraversableLike.$anonfun$map$1(TraversableLike.scala:237)
	at scala.collection.mutable.ResizableArray.foreach(ResizableArray.scala:62)
	at scala.collection.mutable.ResizableArray.foreach$(ResizableArray.scala:55)
	at scala.collection.mutable.ArrayBuffer.foreach(ArrayBuffer.scala:49)
	at scala.collection.TraversableLike.map(TraversableLike.scala:237)
	at scala.collection.TraversableLike.map$(TraversableLike.scala:230)
	at scala.collection.AbstractTraversable.map(Traversable.scala:108)
	at org.apache.spark.sql.hive.execution.HiveComparisonTest.doTest$1(HiveComparisonTest.scala:347)
	at org.apache.spark.sql.hive.execution.HiveComparisonTest.$anonfun$createQueryTest$10(HiveComparisonTest.scala:467)
	at org.scalatest.OutcomeOf.outcomeOf(OutcomeOf.scala:85)
	at org.scalatest.OutcomeOf.outcomeOf$(OutcomeOf.scala:83)
	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:149)
	at org.scalatest.FunSuiteLike.invokeWithFixture$1(FunSuiteLike.scala:184)
	at org.scalatest.FunSuiteLike.$anonfun$runTest$1(FunSuiteLike.scala:196)
	at org.scalatest.SuperEngine.runTestImpl(Engine.scala:289)
	at org.scalatest.FunSuiteLike.runTest(FunSuiteLike.scala:196)
	at org.scalatest.FunSuiteLike.runTest$(FunSuiteLike.scala:178)
	at org.apache.spark.SparkFunSuite.org$scalatest$BeforeAndAfterEach$$super$runTest(SparkFunSuite.scala:56)
	at org.scalatest.BeforeAndAfterEach.runTest(BeforeAndAfterEach.scala:221)
	at org.scalatest.BeforeAndAfterEach.runTest$(BeforeAndAfterEach.scala:214)
	at org.apache.spark.sql.hive.execution.HiveWindowFunctionQuerySuite.org$scalatest$BeforeAndAfter$$super$runTest(HiveWindowFunctionQuerySuite.scala:35)
	at org.scalatest.BeforeAndAfter.runTest(BeforeAndAfter.scala:203)
	at org.scalatest.BeforeAndAfter.runTest$(BeforeAndAfter.scala:192)
	at org.apache.spark.sql.hive.execution.HiveWindowFunctionQuerySuite.runTest(HiveWindowFunctionQuerySuite.scala:35)
	at org.scalatest.FunSuiteLike.$anonfun$runTests$1(FunSuiteLike.scala:229)
	at org.scalatest.SuperEngine.$anonfun$runTestsInBranch$1(Engine.scala:396)
	at scala.collection.immutable.List.foreach(List.scala:392)
	at org.scalatest.SuperEngine.traverseSubNodes$1(Engine.scala:384)
	at org.scalatest.SuperEngine.runTestsInBranch(Engine.scala:379)
	at org.scalatest.SuperEngine.runTestsImpl(Engine.scala:461)
	at org.scalatest.FunSuiteLike.runTests(FunSuiteLike.scala:229)
	at org.scalatest.FunSuiteLike.runTests$(FunSuiteLike.scala:228)
	at org.scalatest.FunSuite.runTests(FunSuite.scala:1560)
	at org.scalatest.Suite.run(Suite.scala:1147)
	at org.scalatest.Suite.run$(Suite.scala:1129)
	at org.scalatest.FunSuite.org$scalatest$FunSuiteLike$$super$run(FunSuite.scala:1560)
	at org.scalatest.FunSuiteLike.$anonfun$run$1(FunSuiteLike.scala:233)
	at org.scalatest.SuperEngine.runImpl(Engine.scala:521)
	at org.scalatest.FunSuiteLike.run(FunSuiteLike.scala:233)
	at org.scalatest.FunSuiteLike.run$(FunSuiteLike.scala:232)
	at org.apache.spark.SparkFunSuite.org$scalatest$BeforeAndAfterAll$$super$run(SparkFunSuite.scala:56)
	at org.scalatest.BeforeAndAfterAll.liftedTree1$1(BeforeAndAfterAll.scala:213)
	at org.scalatest.BeforeAndAfterAll.run(BeforeAndAfterAll.scala:210)
	at org.scalatest.BeforeAndAfterAll.run$(BeforeAndAfterAll.scala:208)
	at org.apache.spark.sql.hive.execution.HiveWindowFunctionQuerySuite.org$scalatest$BeforeAndAfter$$super$run(HiveWindowFunctionQuerySuite.scala:35)
	at org.scalatest.BeforeAndAfter.run(BeforeAndAfter.scala:258)
	at org.scalatest.BeforeAndAfter.run$(BeforeAndAfter.scala:256)
	at org.apache.spark.sql.hive.execution.HiveWindowFunctionQuerySuite.run(HiveWindowFunctionQuerySuite.scala:35)
	at org.scalatest.Suite.callExecuteOnSuite$1(Suite.scala:1210)
	at org.scalatest.Suite.$anonfun$runNestedSuites$1(Suite.scala:1257)
	at scala.collection.IndexedSeqOptimized.foreach(IndexedSeqOptimized.scala:36)
	at scala.collection.IndexedSeqOptimized.foreach$(IndexedSeqOptimized.scala:33)
	at scala.collection.mutable.ArrayOps$ofRef.foreach(ArrayOps.scala:198)
	at org.scalatest.Suite.runNestedSuites(Suite.scala:1255)
	at org.scalatest.Suite.runNestedSuites$(Suite.scala:1189)
	at org.scalatest.tools.DiscoverySuite.runNestedSuites(DiscoverySuite.scala:30)
	at org.scalatest.Suite.run(Suite.scala:1144)
	at org.scalatest.Suite.run$(Suite.scala:1129)
	at org.scalatest.tools.DiscoverySuite.run(DiscoverySuite.scala:30)
	at org.scalatest.tools.SuiteRunner.run(SuiteRunner.scala:45)
	at org.scalatest.tools.Runner$.$anonfun$doRunRunRunDaDoRunRun$13(Runner.scala:1346)
	at org.scalatest.tools.Runner$.$anonfun$doRunRunRunDaDoRunRun$13$adapted(Runner.scala:1340)
	at scala.collection.immutable.List.foreach(List.scala:392)
	at org.scalatest.tools.Runner$.doRunRunRunDaDoRunRun(Runner.scala:1340)
	at org.scalatest.tools.Runner$.$anonfun$runOptionallyWithPassFailReporter$24(Runner.scala:1031)
	at org.scalatest.tools.Runner$.$anonfun$runOptionallyWithPassFailReporter$24$adapted(Runner.scala:1010)
	at org.scalatest.tools.Runner$.withClassLoaderAndDispatchReporter(Runner.scala:1506)
	at org.scalatest.tools.Runner$.runOptionallyWithPassFailReporter(Runner.scala:1010)
	at org.scalatest.tools.Runner$.main(Runner.scala:827)
	at org.scalatest.tools.Runner.main(Runner.scala)
Caused by: org.apache.spark.sql.catalyst.errors.package$TreeNodeException: execute, tree:
Exchange hashpartitioning(knownfloatingpointnormalized(normalizenanandzero(d#204181)), 5), true, [id=#151580]
+- Scan hive default.over1k [s#204183, d#204181, dec#204185], HiveTableRelation `default`.`over1k`, org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe, [t#204176, si#204177, i#204178, b#204179L, f#204180, d#204181, bo#204182, s#204183, ts#204184, dec#204185, bin#204186]

	at org.apache.spark.sql.catalyst.errors.package$.attachTree(package.scala:56)
	at org.apache.spark.sql.execution.exchange.ShuffleExchangeExec.doExecute(ShuffleExchangeExec.scala:90)
	at org.apache.spark.sql.execution.SparkPlan.$anonfun$execute$1(SparkPlan.scala:189)
	at org.apache.spark.sql.execution.SparkPlan.$anonfun$executeQuery$1(SparkPlan.scala:227)
	at org.apache.spark.rdd.RDDOperationScope$.withScope(RDDOperationScope.scala:151)
	at org.apache.spark.sql.execution.SparkPlan.executeQuery(SparkPlan.scala:224)
	at org.apache.spark.sql.execution.SparkPlan.execute(SparkPlan.scala:185)
	at org.apache.spark.sql.execution.InputAdapter.inputRDD(WholeStageCodegenExec.scala:524)
	at org.apache.spark.sql.execution.InputRDDCodegen.inputRDDs(WholeStageCodegenExec.scala:452)
	at org.apache.spark.sql.execution.InputRDDCodegen.inputRDDs$(WholeStageCodegenExec.scala:451)
	at org.apache.spark.sql.execution.InputAdapter.inputRDDs(WholeStageCodegenExec.scala:495)
	at org.apache.spark.sql.execution.SortExec.inputRDDs(SortExec.scala:124)
	at org.apache.spark.sql.execution.WholeStageCodegenExec.doExecute(WholeStageCodegenExec.scala:717)
	at org.apache.spark.sql.execution.SparkPlan.$anonfun$execute$1(SparkPlan.scala:189)
	at org.apache.spark.sql.execution.SparkPlan.$anonfun$executeQuery$1(SparkPlan.scala:227)
	at org.apache.spark.rdd.RDDOperationScope$.withScope(RDDOperationScope.scala:151)
	at org.apache.spark.sql.execution.SparkPlan.executeQuery(SparkPlan.scala:224)
	at org.apache.spark.sql.execution.SparkPlan.execute(SparkPlan.scala:185)
	at org.apache.spark.sql.execution.window.WindowExec.doExecute(WindowExec.scala:115)
	at org.apache.spark.sql.execution.SparkPlan.$anonfun$execute$1(SparkPlan.scala:189)
	at org.apache.spark.sql.execution.SparkPlan.$anonfun$executeQuery$1(SparkPlan.scala:227)
	at org.apache.spark.rdd.RDDOperationScope$.withScope(RDDOperationScope.scala:151)
	at org.apache.spark.sql.execution.SparkPlan.executeQuery(SparkPlan.scala:224)
	at org.apache.spark.sql.execution.SparkPlan.execute(SparkPlan.scala:185)
	at org.apache.spark.sql.execution.InputAdapter.inputRDD(WholeStageCodegenExec.scala:524)
	at org.apache.spark.sql.execution.InputRDDCodegen.inputRDDs(WholeStageCodegenExec.scala:452)
	at org.apache.spark.sql.execution.InputRDDCodegen.inputRDDs$(WholeStageCodegenExec.scala:451)
	at org.apache.spark.sql.execution.InputAdapter.inputRDDs(WholeStageCodegenExec.scala:495)
	at org.apache.spark.sql.execution.ProjectExec.inputRDDs(basicPhysicalOperators.scala:45)
	at org.apache.spark.sql.execution.WholeStageCodegenExec.doExecute(WholeStageCodegenExec.scala:717)
	at org.apache.spark.sql.execution.SparkPlan.$anonfun$execute$1(SparkPlan.scala:189)
	at org.apache.spark.sql.execution.SparkPlan.$anonfun$executeQuery$1(SparkPlan.scala:227)
	at org.apache.spark.rdd.RDDOperationScope$.withScope(RDDOperationScope.scala:151)
	at org.apache.spark.sql.execution.SparkPlan.executeQuery(SparkPlan.scala:224)
	at org.apache.spark.sql.execution.SparkPlan.execute(SparkPlan.scala:185)
	at org.apache.spark.sql.execution.exchange.ShuffleExchangeExec.inputRDD$lzycompute(ShuffleExchangeExec.scala:64)
	at org.apache.spark.sql.execution.exchange.ShuffleExchangeExec.inputRDD(ShuffleExchangeExec.scala:64)
	at org.apache.spark.sql.execution.exchange.ShuffleExchangeExec.shuffleDependency$lzycompute(ShuffleExchangeExec.scala:74)
	at org.apache.spark.sql.execution.exchange.ShuffleExchangeExec.shuffleDependency(ShuffleExchangeExec.scala:72)
	at org.apache.spark.sql.execution.exchange.ShuffleExchangeExec.createShuffledRDD(ShuffleExchangeExec.scala:82)
	at org.apache.spark.sql.execution.exchange.ShuffleExchangeExec.$anonfun$doExecute$1(ShuffleExchangeExec.scala:93)
	at org.apache.spark.sql.catalyst.errors.package$.attachTree(package.scala:52)
	... 101 more
Caused by: java.lang.IllegalStateException: Cannot call methods on a stopped SparkContext.
This stopped SparkContext was created at:

org.apache.spark.sql.hive.StatisticsSuite.<init>(StatisticsSuite.scala:46)
sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
java.lang.reflect.Constructor.newInstance(Constructor.java:423)
java.lang.Class.newInstance(Class.java:442)
org.scalatest.tools.DiscoverySuite$.getSuiteInstance(DiscoverySuite.scala:66)
org.scalatest.tools.DiscoverySuite.$anonfun$nestedSuites$1(DiscoverySuite.scala:38)
scala.collection.TraversableLike.$anonfun$map$1(TraversableLike.scala:237)
scala.collection.Iterator.foreach(Iterator.scala:941)
scala.collection.Iterator.foreach$(Iterator.scala:941)
scala.collection.AbstractIterator.foreach(Iterator.scala:1429)
scala.collection.IterableLike.foreach(IterableLike.scala:74)
scala.collection.IterableLike.foreach$(IterableLike.scala:73)
scala.collection.AbstractIterable.foreach(Iterable.scala:56)
scala.collection.TraversableLike.map(TraversableLike.scala:237)
scala.collection.TraversableLike.map$(TraversableLike.scala:230)
scala.collection.AbstractTraversable.map(Traversable.scala:108)
org.scalatest.tools.DiscoverySuite.<init>(DiscoverySuite.scala:37)
org.scalatest.tools.Runner$.genDiscoSuites$1(Runner.scala:1165)

The currently active SparkContext was created at:

(No active SparkContext.)
         
	at org.apache.spark.SparkContext.assertNotStopped(SparkContext.scala:109)
	at org.apache.spark.SparkContext.broadcast(SparkContext.scala:1466)
	at org.apache.spark.sql.hive.HadoopTableReader.<init>(TableReader.scala:90)
	at org.apache.spark.sql.hive.execution.HiveTableScanExec.hadoopReader$lzycompute(HiveTableScanExec.scala:110)
	at org.apache.spark.sql.hive.execution.HiveTableScanExec.hadoopReader(HiveTableScanExec.scala:105)
	at org.apache.spark.sql.hive.execution.HiveTableScanExec.$anonfun$doExecute$1(HiveTableScanExec.scala:188)
	at org.apache.spark.util.Utils$.withDummyCallSite(Utils.scala:2488)
	at org.apache.spark.sql.hive.execution.HiveTableScanExec.doExecute(HiveTableScanExec.scala:188)
	at org.apache.spark.sql.execution.SparkPlan.$anonfun$execute$1(SparkPlan.scala:189)
	at org.apache.spark.sql.execution.SparkPlan.$anonfun$executeQuery$1(SparkPlan.scala:227)
	at org.apache.spark.rdd.RDDOperationScope$.withScope(RDDOperationScope.scala:151)
	at org.apache.spark.sql.execution.SparkPlan.executeQuery(SparkPlan.scala:224)
	at org.apache.spark.sql.execution.SparkPlan.execute(SparkPlan.scala:185)
	at org.apache.spark.sql.execution.exchange.ShuffleExchangeExec.inputRDD$lzycompute(ShuffleExchangeExec.scala:64)
	at org.apache.spark.sql.execution.exchange.ShuffleExchangeExec.inputRDD(ShuffleExchangeExec.scala:64)
	at org.apache.spark.sql.execution.exchange.ShuffleExchangeExec.shuffleDependency$lzycompute(ShuffleExchangeExec.scala:74)
	at org.apache.spark.sql.execution.exchange.ShuffleExchangeExec.shuffleDependency(ShuffleExchangeExec.scala:72)
	at org.apache.spark.sql.execution.exchange.ShuffleExchangeExec.createShuffledRDD(ShuffleExchangeExec.scala:82)
	at org.apache.spark.sql.execution.exchange.ShuffleExchangeExec.$anonfun$doExecute$1(ShuffleExchangeExec.scala:93)
	at org.apache.spark.sql.catalyst.errors.package$.attachTree(package.scala:52)
	... 142 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#204174]
   +- 'UnresolvedRelation [over1k]

== Analyzed Logical Plan ==
s: string, rn: int
Sort [s#204183 ASC NULLS FIRST, rn#204174 DESC NULLS LAST], true
+- Project [s#204183, rn#204174]
   +- Project [s#204183, d#204181, dec#204185, rn#204174, rn#204174]
      +- Window [row_number() windowspecdefinition(d#204181, dec#204185 ASC NULLS FIRST, specifiedwindowframe(RowFrame, unboundedpreceding$(), currentrow$())) AS rn#204174], [d#204181], [dec#204185 ASC NULLS FIRST]
         +- Project [s#204183, d#204181, dec#204185]
            +- SubqueryAlias `default`.`over1k`
               +- HiveTableRelation `default`.`over1k`, org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe, [t#204176, si#204177, i#204178, b#204179L, f#204180, d#204181, bo#204182, s#204183, ts#204184, dec#204185, bin#204186]

== Optimized Logical Plan ==
Sort [s#204183 ASC NULLS FIRST, rn#204174 DESC NULLS LAST], true
+- Project [s#204183, rn#204174]
   +- Window [row_number() windowspecdefinition(d#204181, dec#204185 ASC NULLS FIRST, specifiedwindowframe(RowFrame, unboundedpreceding$(), currentrow$())) AS rn#204174], [knownfloatingpointnormalized(normalizenanandzero(d#204181))], [dec#204185 ASC NULLS FIRST]
      +- Project [s#204183, d#204181, dec#204185]
         +- HiveTableRelation `default`.`over1k`, org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe, [t#204176, si#204177, i#204178, b#204179L, f#204180, d#204181, bo#204182, s#204183, ts#204184, dec#204185, bin#204186]

== Physical Plan ==
*(3) Sort [s#204183 ASC NULLS FIRST, rn#204174 DESC NULLS LAST], true, 0
+- Exchange rangepartitioning(s#204183 ASC NULLS FIRST, rn#204174 DESC NULLS LAST, 5), true, [id=#151594]
   +- *(2) Project [s#204183, rn#204174]
      +- Window [row_number() windowspecdefinition(d#204181, dec#204185 ASC NULLS FIRST, specifiedwindowframe(RowFrame, unboundedpreceding$(), currentrow$())) AS rn#204174], [knownfloatingpointnormalized(normalizenanandzero(d#204181))], [dec#204185 ASC NULLS FIRST]
         +- *(1) Sort [knownfloatingpointnormalized(normalizenanandzero(d#204181)) ASC NULLS FIRST, dec#204185 ASC NULLS FIRST], false, 0
            +- Exchange hashpartitioning(knownfloatingpointnormalized(normalizenanandzero(d#204181)), 5), true, [id=#151580]
               +- Scan hive default.over1k [s#204183, d#204181, dec#204185], HiveTableRelation `default`.`over1k`, org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe, [t#204176, si#204177, i#204178, b#204179L, f#204180, d#204181, bo#204182, s#204183, ts#204184, dec#204185, bin#204186]

== 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.newAssertionFailedException(Assertions.scala:528)
      at org.scalatest.Assertions.newAssertionFailedException$(Assertions.scala:527)
      at org.scalatest.FunSuite.newAssertionFailedException(FunSuite.scala:1560)
      at org.scalatest.Assertions.fail(Assertions.scala:1089)
      at org.scalatest.Assertions.fail$(Assertions.scala:1085)
      at org.scalatest.FunSuite.fail(FunSuite.scala:1560)
      at org.apache.spark.sql.hive.execution.HiveComparisonTest.$anonfun$createQueryTest$31(HiveComparisonTest.scala:366)
      at scala.collection.TraversableLike.$anonfun$map$1(TraversableLike.scala:237)
      at scala.collection.mutable.ResizableArray.foreach(ResizableArray.scala:62)
      at scala.collection.mutable.ResizableArray.foreach$(ResizableArray.scala:55)
      at scala.collection.mutable.ArrayBuffer.foreach(ArrayBuffer.scala:49)
      at scala.collection.TraversableLike.map(TraversableLike.scala:237)
      at scala.collection.TraversableLike.map$(TraversableLike.scala:230)
      at scala.collection.AbstractTraversable.map(Traversable.scala:108)
      at org.apache.spark.sql.hive.execution.HiveComparisonTest.doTest$1(HiveComparisonTest.scala:347)
      at org.apache.spark.sql.hive.execution.HiveComparisonTest.$anonfun$createQueryTest$10(HiveComparisonTest.scala:467)
      at org.scalatest.OutcomeOf.outcomeOf(OutcomeOf.scala:85)
      at org.scalatest.OutcomeOf.outcomeOf$(OutcomeOf.scala:83)
      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:149)
      at org.scalatest.FunSuiteLike.invokeWithFixture$1(FunSuiteLike.scala:184)
      at org.scalatest.FunSuiteLike.$anonfun$runTest$1(FunSuiteLike.scala:196)
      at org.scalatest.SuperEngine.runTestImpl(Engine.scala:289)
      at org.scalatest.FunSuiteLike.runTest(FunSuiteLike.scala:196)
      at org.scalatest.FunSuiteLike.runTest$(FunSuiteLike.scala:178)
      at org.apache.spark.SparkFunSuite.org$scalatest$BeforeAndAfterEach$$super$runTest(SparkFunSuite.scala:56)
      at org.scalatest.BeforeAndAfterEach.runTest(BeforeAndAfterEach.scala:221)
      at org.scalatest.BeforeAndAfterEach.runTest$(BeforeAndAfterEach.scala:214)
      at org.apache.spark.sql.hive.execution.HiveWindowFunctionQuerySuite.org$scalatest$BeforeAndAfter$$super$runTest(HiveWindowFunctionQuerySuite.scala:35)
      at org.scalatest.BeforeAndAfter.runTest(BeforeAndAfter.scala:203)
      at org.scalatest.BeforeAndAfter.runTest$(BeforeAndAfter.scala:192)
      at org.apache.spark.sql.hive.execution.HiveWindowFunctionQuerySuite.runTest(HiveWindowFunctionQuerySuite.scala:35)
      at org.scalatest.FunSuiteLike.$anonfun$runTests$1(FunSuiteLike.scala:229)
      at org.scalatest.SuperEngine.$anonfun$runTestsInBranch$1(Engine.scala:396)
      at scala.collection.immutable.List.foreach(List.scala:392)
      at org.scalatest.SuperEngine.traverseSubNodes$1(Engine.scala:384)
      at org.scalatest.SuperEngine.runTestsInBranch(Engine.scala:379)
      at org.scalatest.SuperEngine.runTestsImpl(Engine.scala:461)
      at org.scalatest.FunSuiteLike.runTests(FunSuiteLike.scala:229)
      at org.scalatest.FunSuiteLike.runTests$(FunSuiteLike.scala:228)
      at org.scalatest.FunSuite.runTests(FunSuite.scala:1560)
      at org.scalatest.Suite.run(Suite.scala:1147)
      at org.scalatest.Suite.run$(Suite.scala:1129)
      at org.scalatest.FunSuite.org$scalatest$FunSuiteLike$$super$run(FunSuite.scala:1560)
      at org.scalatest.FunSuiteLike.$anonfun$run$1(FunSuiteLike.scala:233)
      at org.scalatest.SuperEngine.runImpl(Engine.scala:521)
      at org.scalatest.FunSuiteLike.run(FunSuiteLike.scala:233)
      at org.scalatest.FunSuiteLike.run$(FunSuiteLike.scala:232)
      at org.apache.spark.SparkFunSuite.org$scalatest$BeforeAndAfterAll$$super$run(SparkFunSuite.scala:56)
      at org.scalatest.BeforeAndAfterAll.liftedTree1$1(BeforeAndAfterAll.scala:213)
      at org.scalatest.BeforeAndAfterAll.run(BeforeAndAfterAll.scala:210)
      at org.scalatest.BeforeAndAfterAll.run$(BeforeAndAfterAll.scala:208)
      at org.apache.spark.sql.hive.execution.HiveWindowFunctionQuerySuite.org$scalatest$BeforeAndAfter$$super$run(HiveWindowFunctionQuerySuite.scala:35)
      at org.scalatest.BeforeAndAfter.run(BeforeAndAfter.scala:258)
      at org.scalatest.BeforeAndAfter.run$(BeforeAndAfter.scala:256)
      at org.apache.spark.sql.hive.execution.HiveWindowFunctionQuerySuite.run(HiveWindowFunctionQuerySuite.scala:35)
      at org.scalatest.Suite.callExecuteOnSuite$1(Suite.scala:1210)
      at org.scalatest.Suite.$anonfun$runNestedSuites$1(Suite.scala:1257)
      at scala.collection.IndexedSeqOptimized.foreach(IndexedSeqOptimized.scala:36)
      at scala.collection.IndexedSeqOptimized.foreach$(IndexedSeqOptimized.scala:33)
      at scala.collection.mutable.ArrayOps$ofRef.foreach(ArrayOps.scala:198)
      at org.scalatest.Suite.runNestedSuites(Suite.scala:1255)
      at org.scalatest.Suite.runNestedSuites$(Suite.scala:1189)
      at org.scalatest.tools.DiscoverySuite.runNestedSuites(DiscoverySuite.scala:30)
      at org.scalatest.Suite.run(Suite.scala:1144)
      at org.scalatest.Suite.run$(Suite.scala:1129)
      at org.scalatest.tools.DiscoverySuite.run(DiscoverySuite.scala:30)
      at org.scalatest.tools.SuiteRunner.run(SuiteRunner.scala:45)
      at org.scalatest.tools.Runner$.$anonfun$doRunRunRunDaDoRunRun$13(Runner.scala:1346)
      at org.scalatest.tools.Runner$.$anonfun$doRunRunRunDaDoRunRun$13$adapted(Runner.scala:1340)
      at scala.collection.immutable.List.foreach(List.scala:392)
      at org.scalatest.tools.Runner$.doRunRunRunDaDoRunRun(Runner.scala:1340)
      at org.scalatest.tools.Runner$.$anonfun$runOptionallyWithPassFailReporter$24(Runner.scala:1031)
      at org.scalatest.tools.Runner$.$anonfun$runOptionallyWithPassFailReporter$24$adapted(Runner.scala:1010)
      at org.scalatest.tools.Runner$.withClassLoaderAndDispatchReporter(Runner.scala:1506)
      at org.scalatest.tools.Runner$.runOptionallyWithPassFailReporter(Runner.scala:1010)
      at org.scalatest.tools.Runner$.main(Runner.scala:827)
      at org.scalatest.tools.Runner.main(Runner.scala)