&#010;Failed to execute query using catalyst:&#010;Error: execute, tree:&#010;Exchange rangepartitioning(s#204069 ASC NULLS FIRST, r#204058 ASC NULLS FIRST, sum#204059L ASC NULLS FIRST, 5), true, [id=#151359]&#010;+- *(2) Project [s#204069, r#204058, sum#204059L]&#010; +- Window [rank(si#204063) windowspecdefinition(s#204069, si#204063 ASC NULLS FIRST, specifiedwindowframe(RowFrame, unboundedpreceding$(), currentrow$())) AS r#204058, sum(b#204065L) windowspecdefinition(s#204069, si#204063 ASC NULLS FIRST, specifiedwindowframe(RangeFrame, unboundedpreceding$(), currentrow$())) AS sum#204059L], [s#204069], [si#204063 ASC NULLS FIRST]&#010; +- *(1) Sort [s#204069 ASC NULLS FIRST, si#204063 ASC NULLS FIRST], false, 0&#010; +- Exchange hashpartitioning(s#204069, 5), true, [id=#151345]&#010; +- Scan hive default.over1k [s#204069, si#204063, b#204065L], HiveTableRelation `default`.`over1k`, org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe, [t#204062, si#204063, i#204064, b#204065L, f#204066, d#204067, bo#204068, s#204069, ts#204070, dec#204071, bin#204072]&#010;&#010;org.apache.spark.sql.catalyst.errors.package$TreeNodeException: execute, tree:&#010;Exchange rangepartitioning(s#204069 ASC NULLS FIRST, r#204058 ASC NULLS FIRST, sum#204059L ASC NULLS FIRST, 5), true, [id=#151359]&#010;+- *(2) Project [s#204069, r#204058, sum#204059L]&#010; +- Window [rank(si#204063) windowspecdefinition(s#204069, si#204063 ASC NULLS FIRST, specifiedwindowframe(RowFrame, unboundedpreceding$(), currentrow$())) AS r#204058, sum(b#204065L) windowspecdefinition(s#204069, si#204063 ASC NULLS FIRST, specifiedwindowframe(RangeFrame, unboundedpreceding$(), currentrow$())) AS sum#204059L], [s#204069], [si#204063 ASC NULLS FIRST]&#010; +- *(1) Sort [s#204069 ASC NULLS FIRST, si#204063 ASC NULLS FIRST], false, 0&#010; +- Exchange hashpartitioning(s#204069, 5), true, [id=#151345]&#010; +- Scan hive default.over1k [s#204069, si#204063, b#204065L], HiveTableRelation `default`.`over1k`, org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe, [t#204062, si#204063, i#204064, b#204065L, f#204066, d#204067, bo#204068, s#204069, ts#204070, dec#204071, bin#204072]&#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(s#204069, 5), true, [id=#151345]&#010;+- Scan hive default.over1k [s#204069, si#204063, b#204065L], HiveTableRelation `default`.`over1k`, org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe, [t#204062, si#204063, i#204064, b#204065L, f#204066, d#204067, bo#204068, s#204069, ts#204070, dec#204071, bin#204072]&#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,&#010;rank() over (partition by s order by si) r,&#010;sum(b) over (partition by s order by si) sum&#010;from over1k&#010;order by s, r, sum&#010;== Parsed Logical Plan ==&#010;'Sort ['s ASC NULLS FIRST, 'r ASC NULLS FIRST, 'sum ASC NULLS FIRST], true&#010;+- 'Project ['s, 'rank() windowspecdefinition('s, 'si ASC NULLS FIRST, unspecifiedframe$()) AS r#204058, 'sum('b) windowspecdefinition('s, 'si ASC NULLS FIRST, unspecifiedframe$()) AS sum#204059]&#010; +- 'UnresolvedRelation [over1k]&#010;&#010;== Analyzed Logical Plan ==&#010;s: string, r: int, sum: bigint&#010;Sort [s#204069 ASC NULLS FIRST, r#204058 ASC NULLS FIRST, sum#204059L ASC NULLS FIRST], true&#010;+- Project [s#204069, r#204058, sum#204059L]&#010; +- Project [s#204069, si#204063, b#204065L, r#204058, sum#204059L, r#204058, sum#204059L]&#010; +- Window [rank(si#204063) windowspecdefinition(s#204069, si#204063 ASC NULLS FIRST, specifiedwindowframe(RowFrame, unboundedpreceding$(), currentrow$())) AS r#204058, sum(b#204065L) windowspecdefinition(s#204069, si#204063 ASC NULLS FIRST, specifiedwindowframe(RangeFrame, unboundedpreceding$(), currentrow$())) AS sum#204059L], [s#204069], [si#204063 ASC NULLS FIRST]&#010; +- Project [s#204069, si#204063, b#204065L]&#010; +- SubqueryAlias `default`.`over1k`&#010; +- HiveTableRelation `default`.`over1k`, org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe, [t#204062, si#204063, i#204064, b#204065L, f#204066, d#204067, bo#204068, s#204069, ts#204070, dec#204071, bin#204072]&#010;&#010;== Optimized Logical Plan ==&#010;Sort [s#204069 ASC NULLS FIRST, r#204058 ASC NULLS FIRST, sum#204059L ASC NULLS FIRST], true&#010;+- Project [s#204069, r#204058, sum#204059L]&#010; +- Window [rank(si#204063) windowspecdefinition(s#204069, si#204063 ASC NULLS FIRST, specifiedwindowframe(RowFrame, unboundedpreceding$(), currentrow$())) AS r#204058, sum(b#204065L) windowspecdefinition(s#204069, si#204063 ASC NULLS FIRST, specifiedwindowframe(RangeFrame, unboundedpreceding$(), currentrow$())) AS sum#204059L], [s#204069], [si#204063 ASC NULLS FIRST]&#010; +- Project [s#204069, si#204063, b#204065L]&#010; +- HiveTableRelation `default`.`over1k`, org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe, [t#204062, si#204063, i#204064, b#204065L, f#204066, d#204067, bo#204068, s#204069, ts#204070, dec#204071, bin#204072]&#010;&#010;== Physical Plan ==&#010;*(3) Sort [s#204069 ASC NULLS FIRST, r#204058 ASC NULLS FIRST, sum#204059L ASC NULLS FIRST], true, 0&#010;+- Exchange rangepartitioning(s#204069 ASC NULLS FIRST, r#204058 ASC NULLS FIRST, sum#204059L ASC NULLS FIRST, 5), true, [id=#151359]&#010; +- *(2) Project [s#204069, r#204058, sum#204059L]&#010; +- Window [rank(si#204063) windowspecdefinition(s#204069, si#204063 ASC NULLS FIRST, specifiedwindowframe(RowFrame, unboundedpreceding$(), currentrow$())) AS r#204058, sum(b#204065L) windowspecdefinition(s#204069, si#204063 ASC NULLS FIRST, specifiedwindowframe(RangeFrame, unboundedpreceding$(), currentrow$())) AS sum#204059L], [s#204069], [si#204063 ASC NULLS FIRST]&#010; +- *(1) Sort [s#204069 ASC NULLS FIRST, si#204063 ASC NULLS FIRST], false, 0&#010; +- Exchange hashpartitioning(s#204069, 5), true, [id=#151345]&#010; +- Scan hive default.over1k [s#204069, si#204063, b#204065L], HiveTableRelation `default`.`over1k`, org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe, [t#204062, si#204063, i#204064, b#204065L, f#204066, d#204067, bo#204068, s#204069, ts#204070, dec#204071, bin#204072]&#010;&#010;== HIVE - 1049 row(s) ==&#010; 1 4294967354&#010; 2 8589934811&#010; 3 12884902227&#010;alice allen 1 4294967487&#010;alice allen 2 8589935012&#010;alice allen 3 12884902543&#010;alice brown 1 4294967355&#010;alice carson 1 4294967370&#010;alice davidson 1 4294967517&#010;alice falkner 1 4294967316&#010;alice garcia 1 4294967369&#010;alice hernandez 1 4294967314&#010;alice hernandez 2 8589934613&#010;alice johnson 1 4294967424&#010;alice king 1 4294967387&#010;alice king 2 8589934903&#010;alice king 3 12884902449&#010;alice laertes 1 4294967519&#010;alice laertes 2 8589935038&#010;alice miller 1 4294967324&#010;alice nixon 1 4294967484&#010;alice nixon 2 8589934894&#010;alice nixon 3 12884902307&#010;alice ovid 1 4294967412&#010;alice polk 1 4294967366&#010;alice quirinius 1 4294967505&#010;alice quirinius 2 8589935054&#010;alice robinson 1 4294967502&#010;alice robinson 2 8589934947&#010;alice steinbeck 1 4294967549&#010;alice steinbeck 2 8589934913&#010;alice steinbeck 3 12884902387&#010;alice underhill 1 4294967441&#010;alice van buren 1 4294967428&#010;alice xylophone 1 4294967519&#010;alice xylophone 2 8589934877&#010;alice xylophone 3 12884902240&#010;alice zipper 1 4294967380&#010;alice zipper 2 8589934919&#010;alice zipper 3 12884902439&#010;bob brown 1 4294967431&#010;bob brown 2 8589934853&#010;bob brown 3 12884902280&#010;bob carson 1 4294967408&#010;bob davidson 1 4294967435&#010;bob davidson 2 8589934939&#010;bob davidson 3 12884902293&#010;bob ellison 1 4294967530&#010;bob ellison 2 8589934966&#010;bob ellison 3 12884902328&#010;bob ellison 4 17179869672&#010;bob falkner 1 4294967464&#010;bob garcia 1 4294967435&#010;bob garcia 2 8589934804&#010;bob garcia 3 12884902148&#010;bob garcia 4 17179869587&#010;bob garcia 5 21474836905&#010;bob hernandez 1 4294967500&#010;bob ichabod 1 4294967424&#010;bob king 1 4294967443&#010;bob king 2 8589934740&#010;bob king 3 12884902279&#010;bob laertes 1 4294967472&#010;bob laertes 2 8589934852&#010;bob miller 1 4294967349&#010;bob ovid 1 4294967401&#010;bob ovid 2 8589934801&#010;bob ovid 3 12884902313&#010;bob ovid 4 17179869708&#010;bob polk 1 4294967337&#010;bob quirinius 1 4294967346&#010;bob steinbeck 1 4294967342&#010;bob van buren 1 4294967422&#010;bob white 1 4294967493&#010;bob white 2 8589934855&#010;bob xylophone 1 4294967407&#010;bob xylophone 2 8589934872&#010;bob young 1 4294967413&#010;bob zipper 1 4294967416&#010;bob zipper 2 8589934769&#010;bob zipper 3 12884902068&#010;calvin allen 1 4294967373&#010;calvin brown 1 4294967530&#010;calvin brown 2 8589934967&#010;calvin brown 3 12884902378&#010;calvin carson 1 4294967534&#010;calvin davidson 1 4294967437&#010;calvin davidson 2 8589934905&#010;calvin ellison 1 4294967480&#010;calvin falkner 1 4294967305&#010;calvin falkner 2 8589934723&#010;calvin falkner 3 12884902155&#010;calvin falkner 4 17179869455&#010;calvin falkner 5 21474836800&#010;calvin falkner 6 25769804250&#010;calvin garcia 1 4294967492&#010;calvin hernandez 1 4294967341&#010;calvin johnson 1 4294967546&#010;calvin laertes 1 4294967499&#010;calvin laertes 2 8589934930&#010;calvin nixon 1 4294967488&#010;calvin nixon 2 8589934788&#010;calvin nixon 3 12884902200&#010;calvin ovid 1 4294967343&#010;calvin ovid 2 8589934881&#010;calvin ovid 3 12884902210&#010;calvin ovid 4 17179869559&#010;calvin polk 1 4294967416&#010;calvin quirinius 1 4294967532&#010;calvin quirinius 2 8589935053&#010;calvin robinson 1 4294967326&#010;calvin steinbeck 1 4294967417&#010;calvin steinbeck 2 8589934891&#010;calvin steinbeck 3 12884902396&#010;calvin thompson 1 4294967346&#010;calvin thompson 2 8589934859&#010;calvin underhill 1 4294967478&#010;calvin van buren 1 4294967300&#010;calvin van buren 2 8589934808&#010;calvin white 1 4294967304&#010;calvin white 2 8589934848&#010;calvin xylophone 1 4294967299&#010;calvin xylophone 2 8589934675&#010;calvin xylophone 3 12884902133&#010;calvin young 1 4294967410&#010;calvin young 2 8589934752&#010;calvin zipper 1 4294967441&#010;calvin zipper 2 8589934960&#010;david allen 1 4294967381&#010;david allen 2 8589934752&#010;david brown 1 4294967544&#010;david brown 2 8589934870&#010;david davidson 1 4294967487&#010;david davidson 2 8589934952&#010;david davidson 3 12884902474&#010;david davidson 4 17179869819&#010;david ellison 1 4294967477&#010;david ellison 2 8589934963&#010;david ellison 3 12884902426&#010;david hernandez 1 4294967324&#010;david ichabod 1 4294967385&#010;david ichabod 2 8589934872&#010;david laertes 1 4294967385&#010;david nixon 1 4294967381&#010;david ovid 1 4294967396&#010;david ovid 2 8589934839&#010;david quirinius 1 4294967375&#010;david quirinius 2 8589934905&#010;david quirinius 3 12884902362&#010;david robinson 1 4294967465&#010;david robinson 2 8589934933&#010;david thompson 1 4294967361&#010;david underhill 1 4294967331&#010;david underhill 2 8589934715&#010;david underhill 3 12884902185&#010;david van buren 1 4294967438&#010;david van buren 2 8589934747&#010;david white 1 4294967428&#010;david xylophone 1 8589934898&#010;david xylophone 1 8589934898&#010;david xylophone 3 12884902378&#010;david young 1 4294967296&#010;david young 2 8589934601&#010;ethan allen 1 4294967351&#010;ethan brown 1 4294967477&#010;ethan brown 2 8589934897&#010;ethan brown 3 12884902217&#010;ethan brown 4 17179869548&#010;ethan brown 5 21474836951&#010;ethan brown 6 25769804375&#010;ethan carson 1 4294967352&#010;ethan ellison 1 4294967514&#010;ethan ellison 2 8589934923&#010;ethan falkner 1 4294967318&#010;ethan falkner 2 8589934779&#010;ethan garcia 1 4294967310&#010;ethan hernandez 1 4294967349&#010;ethan johnson 1 4294967357&#010;ethan king 1 4294967413&#010;ethan laertes 1 4294967402&#010;ethan laertes 2 8589934859&#010;ethan laertes 3 12884902390&#010;ethan laertes 4 17179869880&#010;ethan laertes 5 21474837302&#010;ethan laertes 6 25769804603&#010;ethan laertes 7 30064771974&#010;ethan miller 1 4294967352&#010;ethan nixon 1 4294967499&#010;ethan ovid 1 4294967452&#010;ethan polk 1 4294967329&#010;ethan polk 2 8589934711&#010;ethan polk 3 12884902253&#010;ethan polk 4 17179869732&#010;ethan quirinius 1 4294967501&#010;ethan quirinius 2 8589934852&#010;ethan quirinius 3 12884902200&#010;ethan robinson 1 4294967353&#010;ethan robinson 2 8589934855&#010;ethan underhill 1 4294967466&#010;ethan van buren 1 4294967511&#010;ethan white 1 4294967445&#010;ethan white 2 8589934872&#010;ethan xylophone 1 4294967543&#010;ethan zipper 1 4294967462&#010;ethan zipper 2 8589934815&#010;fred davidson 1 4294967512&#010;fred davidson 2 8589934936&#010;fred davidson 3 12884902424&#010;fred ellison 1 4294967470&#010;fred ellison 2 8589934901&#010;fred ellison 3 12884902294&#010;fred falkner 1 4294967340&#010;fred falkner 2 8589934887&#010;fred falkner 3 12884902187&#010;fred hernandez 1 4294967365&#010;fred ichabod 1 4294967342&#010;fred ichabod 2 8589934831&#010;fred johnson 1 4294967373&#010;fred king 1 4294967346&#010;fred king 2 8589934766&#010;fred laertes 1 4294967351&#010;fred miller 1 4294967490&#010;fred nixon 1 4294967514&#010;fred nixon 2 8589934811&#010;fred nixon 3 12884902293&#010;fred nixon 4 17179869668&#010;fred polk 1 4294967332&#010;fred polk 2 8589934775&#010;fred polk 3 12884902233&#010;fred polk 4 17179869740&#010;fred quirinius 1 4294967426&#010;fred quirinius 2 8589934951&#010;fred robinson 1 4294967461&#010;fred steinbeck 1 4294967411&#010;fred steinbeck 2 8589934740&#010;fred steinbeck 3 12884902212&#010;fred underhill 1 4294967387&#010;fred van buren 1 4294967431&#010;fred van buren 2 8589934812&#010;fred van buren 3 12884902338&#010;fred van buren 4 17179869801&#010;fred white 1 4294967434&#010;fred young 1 4294967495&#010;fred young 2 8589934980&#010;fred zipper 1 4294967447&#010;gabriella allen 1 4294967405&#010;gabriella allen 2 8589934939&#010;gabriella brown 1 4294967543&#010;gabriella brown 2 8589934946&#010;gabriella carson 1 4294967540&#010;gabriella davidson 1 4294967507&#010;gabriella ellison 1 4294967393&#010;gabriella ellison 2 8589934733&#010;gabriella falkner 1 4294967378&#010;gabriella falkner 2 8589934901&#010;gabriella falkner 3 12884902335&#010;gabriella garcia 1 4294967419&#010;gabriella hernandez 1 4294967481&#010;gabriella hernandez 2 8589934943&#010;gabriella ichabod 1 4294967337&#010;gabriella ichabod 2 8589934725&#010;gabriella ichabod 3 12884902062&#010;gabriella ichabod 4 17179869382&#010;gabriella ichabod 5 21474836880&#010;gabriella king 1 4294967434&#010;gabriella king 2 8589934827&#010;gabriella laertes 1 4294967410&#010;gabriella miller 1 4294967363&#010;gabriella ovid 1 4294967482&#010;gabriella ovid 2 8589935004&#010;gabriella polk 1 4294967410&#010;gabriella polk 2 8589934712&#010;gabriella steinbeck 1 4294967500&#010;gabriella steinbeck 2 8589934935&#010;gabriella thompson 1 4294967299&#010;gabriella thompson 2 8589934711&#010;gabriella thompson 3 12884902196&#010;gabriella van buren 1 4294967457&#010;gabriella van buren 2 8589934927&#010;gabriella white 1 4294967335&#010;gabriella young 1 4294967493&#010;gabriella young 2 8589934924&#010;gabriella zipper 1 4294967357&#010;gabriella zipper 2 8589934867&#010;holly allen 1 4294967327&#010;holly brown 1 4294967321&#010;holly brown 2 8589934659&#010;holly falkner 1 4294967324&#010;holly hernandez 1 4294967378&#010;holly hernandez 2 8589934921&#010;holly hernandez 3 12884902465&#010;holly hernandez 4 17179869773&#010;holly ichabod 1 4294967342&#010;holly ichabod 2 8589934800&#010;holly ichabod 3 12884902129&#010;holly johnson 1 4294967517&#010;holly johnson 2 8589934897&#010;holly johnson 3 12884902432&#010;holly king 1 4294967392&#010;holly king 2 8589934753&#010;holly laertes 1 4294967406&#010;holly miller 1 4294967388&#010;holly nixon 1 4294967383&#010;holly nixon 2 8589934707&#010;holly polk 1 4294967398&#010;holly polk 2 8589934832&#010;holly robinson 1 4294967532&#010;holly thompson 1 4294967529&#010;holly thompson 2 8589934868&#010;holly thompson 3 12884902242&#010;holly underhill 1 4294967383&#010;holly underhill 2 8589934894&#010;holly underhill 3 12884902330&#010;holly underhill 4 17179869856&#010;holly van buren 1 4294967539&#010;holly white 1 4294967320&#010;holly white 2 8589934735&#010;holly xylophone 1 4294967435&#010;holly young 1 4294967487&#010;holly young 2 8589934987&#010;holly zipper 1 4294967337&#010;holly zipper 2 8589934846&#010;irene allen 1 4294967518&#010;irene brown 1 4294967434&#010;irene brown 2 8589934862&#010;irene brown 3 12884902272&#010;irene carson 1 4294967473&#010;irene ellison 1 4294967379&#010;irene ellison 2 8589934797&#010;irene falkner 1 4294967404&#010;irene falkner 2 8589934952&#010;irene garcia 1 4294967498&#010;irene garcia 2 8589934869&#010;irene garcia 3 12884902192&#010;irene ichabod 1 4294967529&#010;irene ichabod 2 8589935038&#010;irene johnson 1 4294967468&#010;irene laertes 1 4294967481&#010;irene laertes 2 8589934780&#010;irene laertes 3 12884902116&#010;irene miller 1 4294967387&#010;irene nixon 1 4294967323&#010;irene nixon 2 8589934824&#010;irene nixon 3 12884902362&#010;irene ovid 1 4294967499&#010;irene ovid 2 8589934870&#010;irene ovid 3 12884902230&#010;irene polk 1 4294967521&#010;irene polk 2 8589934930&#010;irene polk 3 12884902395&#010;irene polk 4 17179869941&#010;irene polk 5 21474837237&#010;irene quirinius 1 4294967365&#010;irene quirinius 2 8589934751&#010;irene quirinius 3 12884902141&#010;irene robinson 1 4294967347&#010;irene steinbeck 1 4294967549&#010;irene thompson 1 4294967479&#010;irene underhill 1 4294967371&#010;irene underhill 2 8589934753&#010;irene van buren 1 4294967439&#010;irene van buren 2 8589934906&#010;irene xylophone 1 4294967436&#010;jessica brown 1 4294967496&#010;jessica carson 1 4294967389&#010;jessica carson 2 8589934897&#010;jessica carson 3 12884902345&#010;jessica davidson 1 4294967325&#010;jessica davidson 2 8589934709&#010;jessica davidson 3 12884902098&#010;jessica davidson 4 17179869569&#010;jessica ellison 1 4294967316&#010;jessica ellison 2 8589934721&#010;jessica falkner 1 4294967549&#010;jessica garcia 1 4294967540&#010;jessica garcia 2 8589935041&#010;jessica ichabod 1 4294967413&#010;jessica johnson 1 4294967497&#010;jessica johnson 2 8589934870&#010;jessica miller 1 4294967495&#010;jessica nixon 1 4294967311&#010;jessica nixon 2 8589934754&#010;jessica ovid 1 4294967330&#010;jessica ovid 2 8589934855&#010;jessica polk 1 4294967403&#010;jessica quirinius 1 4294967523&#010;jessica quirinius 2 8589934942&#010;jessica quirinius 3 12884902388&#010;jessica quirinius 4 17179869696&#010;jessica robinson 1 4294967542&#010;jessica thompson 1 4294967449&#010;jessica thompson 2 8589934763&#010;jessica underhill 1 4294967541&#010;jessica underhill 2 8589934844&#010;jessica underhill 3 12884902153&#010;jessica van buren 1 4294967344&#010;jessica white 1 4294967482&#010;jessica white 2 8589934929&#010;jessica white 3 12884902378&#010;jessica white 4 17179869687&#010;jessica white 5 21474837086&#010;jessica xylophone 1 4294967421&#010;jessica young 1 4294967382&#010;jessica young 2 8589934903&#010;jessica zipper 1 4294967334&#010;jessica zipper 2 8589934785&#010;jessica zipper 3 12884902157&#010;katie allen 1 4294967443&#010;katie brown 1 4294967420&#010;katie davidson 1 4294967459&#010;katie ellison 1 4294967486&#010;katie ellison 2 8589934861&#010;katie falkner 1 4294967362&#010;katie garcia 1 4294967306&#010;katie garcia 2 8589934680&#010;katie hernandez 1 4294967451&#010;katie ichabod 1 4294967330&#010;katie ichabod 2 8589934742&#010;katie ichabod 3 12884902209&#010;katie king 1 4294967339&#010;katie king 2 8589934760&#010;katie king 3 12884902199&#010;katie miller 1 4294967425&#010;katie miller 2 8589934859&#010;katie nixon 1 4294967500&#010;katie ovid 1 4294967519&#010;katie polk 1 4294967384&#010;katie polk 2 8589934926&#010;katie robinson 1 4294967310&#010;katie van buren 1 4294967335&#010;katie van buren 2 8589934647&#010;katie white 1 4294967337&#010;katie white 2 8589934643&#010;katie xylophone 1 4294967486&#010;katie young 1 4294967349&#010;katie young 2 8589934681&#010;katie young 3 12884902225&#010;katie zipper 1 4294967354&#010;katie zipper 2 8589934766&#010;luke allen 1 4294967533&#010;luke allen 2 8589934836&#010;luke allen 3 12884902346&#010;luke allen 4 17179869863&#010;luke allen 5 21474837208&#010;luke brown 1 4294967473&#010;luke davidson 1 4294967550&#010;luke davidson 2 8589934904&#010;luke ellison 1 4294967322&#010;luke ellison 2 8589934675&#010;luke ellison 3 12884902103&#010;luke falkner 1 4294967359&#010;luke falkner 2 8589934782&#010;luke garcia 1 4294967304&#010;luke garcia 2 8589934683&#010;luke ichabod 1 4294967324&#010;luke ichabod 2 8589934766&#010;luke johnson 1 4294967527&#010;luke johnson 2 8589934987&#010;luke johnson 3 12884902342&#010;luke laertes 1 4294967505&#010;luke laertes 2 8589935011&#010;luke laertes 3 12884902497&#010;luke laertes 4 17179869806&#010;luke laertes 5 21474837193&#010;luke miller 1 4294967497&#010;luke ovid 1 4294967492&#010;luke ovid 2 8589934901&#010;luke polk 1 4294967545&#010;luke polk 2 8589934873&#010;luke quirinius 1 4294967320&#010;luke robinson 1 4294967299&#010;luke robinson 2 8589934606&#010;luke thompson 1 4294967521&#010;luke underhill 1 4294967393&#010;luke underhill 2 8589934803&#010;luke underhill 3 12884902122&#010;luke van buren 1 4294967424&#010;luke white 1 4294967505&#010;luke xylophone 1 4294967382&#010;luke zipper 1 4294967353&#010;mike allen 1 4294967466&#010;mike brown 1 4294967369&#010;mike carson 1 4294967477&#010;mike carson 2 8589934934&#010;mike carson 3 12884902482&#010;mike davidson 1 4294967501&#010;mike davidson 2 8589934965&#010;mike ellison 1 4294967353&#010;mike ellison 2 8589934747&#010;mike ellison 3 12884902282&#010;mike ellison 4 17179869806&#010;mike ellison 5 21474837309&#010;mike falkner 1 4294967301&#010;mike garcia 1 4294967428&#010;mike garcia 2 8589934826&#010;mike garcia 3 12884902289&#010;mike hernandez 1 4294967316&#010;mike hernandez 2 8589934800&#010;mike ichabod 1 4294967494&#010;mike king 1 4294967323&#010;mike king 2 8589934848&#010;mike king 3 12884902248&#010;mike king 4 17179869595&#010;mike king 5 21474837046&#010;mike king 6 25769804478&#010;mike miller 1 4294967449&#010;mike nixon 1 4294967527&#010;mike nixon 2 8589935004&#010;mike polk 1 4294967389&#010;mike polk 2 8589934848&#010;mike polk 3 12884902351&#010;mike quirinius 1 4294967422&#010;mike steinbeck 1 4294967519&#010;mike steinbeck 2 8589934827&#010;mike steinbeck 3 12884902316&#010;mike steinbeck 4 17179869850&#010;mike van buren 1 4294967544&#010;mike van buren 2 8589935061&#010;mike white 1 4294967336&#010;mike white 2 8589934882&#010;mike white 3 12884902374&#010;mike white 4 17179869843&#010;mike young 1 4294967453&#010;mike young 2 8589934804&#010;mike young 3 12884902198&#010;mike zipper 1 4294967402&#010;mike zipper 2 8589934727&#010;mike zipper 3 12884902228&#010;nick allen 1 4294967507&#010;nick allen 2 8589934807&#010;nick brown 1 4294967334&#010;nick davidson 1 4294967357&#010;nick ellison 1 4294967397&#010;nick ellison 2 8589934699&#010;nick falkner 1 4294967480&#010;nick falkner 2 8589934923&#010;nick garcia 1 4294967384&#010;nick garcia 2 8589934797&#010;nick garcia 3 12884902319&#010;nick ichabod 1 4294967388&#010;nick ichabod 2 8589934758&#010;nick ichabod 3 12884902225&#010;nick johnson 1 4294967398&#010;nick johnson 2 8589934809&#010;nick laertes 1 4294967389&#010;nick miller 1 4294967550&#010;nick nixon 1 4294967482&#010;nick ovid 1 4294967488&#010;nick polk 1 4294967551&#010;nick quirinius 1 4294967316&#010;nick quirinius 2 8589934612&#010;nick robinson 1 4294967409&#010;nick robinson 2 8589934731&#010;nick steinbeck 1 4294967355&#010;nick thompson 1 4294967401&#010;nick underhill 1 4294967527&#010;nick van buren 1 4294967303&#010;nick xylophone 1 4294967460&#010;nick young 1 4294967405&#010;nick young 2 8589934917&#010;nick zipper 1 4294967430&#010;nick zipper 2 8589934796&#010;oscar allen 1 4294967500&#010;oscar brown 1 4294967331&#010;oscar carson 1 4294967460&#010;oscar carson 2 8589934904&#010;oscar carson 3 12884902286&#010;oscar carson 4 17179869599&#010;oscar carson 5 21474836960&#010;oscar davidson 1 4294967482&#010;oscar ellison 1 8589934740&#010;oscar ellison 1 8589934740&#010;oscar falkner 1 4294967526&#010;oscar garcia 1 4294967301&#010;oscar hernandez 1 4294967343&#010;oscar hernandez 2 8589934843&#010;oscar ichabod 1 4294967513&#010;oscar ichabod 2 8589934837&#010;oscar ichabod 3 12884902165&#010;oscar ichabod 4 17179869569&#010;oscar johnson 1 4294967418&#010;oscar johnson 2 8589934763&#010;oscar king 1 4294967465&#010;oscar king 2 8589934936&#010;oscar king 3 12884902469&#010;oscar laertes 1 4294967425&#010;oscar laertes 2 8589934876&#010;oscar laertes 3 12884902426&#010;oscar laertes 4 17179869786&#010;oscar nixon 1 4294967532&#010;oscar ovid 1 4294967508&#010;oscar ovid 2 8589934910&#010;oscar ovid 3 12884902418&#010;oscar polk 1 4294967325&#010;oscar polk 2 8589934713&#010;oscar quirinius 1 4294967416&#010;oscar quirinius 2 8589934932&#010;oscar quirinius 3 12884902390&#010;oscar quirinius 4 17179869763&#010;oscar robinson 1 4294967355&#010;oscar robinson 2 8589934681&#010;oscar robinson 3 12884902031&#010;oscar robinson 4 17179869383&#010;oscar steinbeck 1 4294967548&#010;oscar thompson 1 4294967453&#010;oscar thompson 2 8589934824&#010;oscar thompson 3 12884902197&#010;oscar thompson 4 17179869496&#010;oscar underhill 1 4294967374&#010;oscar van buren 1 4294967520&#010;oscar van buren 2 8589934990&#010;oscar van buren 3 12884902490&#010;oscar white 1 4294967454&#010;oscar white 2 8589934761&#010;oscar white 3 12884902163&#010;oscar white 4 17179869512&#010;oscar xylophone 1 4294967400&#010;oscar xylophone 2 8589934806&#010;oscar xylophone 3 12884902124&#010;oscar zipper 1 4294967449&#010;oscar zipper 2 8589934969&#010;oscar zipper 3 12884902458&#010;priscilla brown 1 4294967369&#010;priscilla brown 2 8589934897&#010;priscilla brown 3 12884902360&#010;priscilla carson 1 4294967489&#010;priscilla carson 2 8589934838&#010;priscilla carson 3 12884902270&#010;priscilla ichabod 1 4294967379&#010;priscilla ichabod 2 8589934926&#010;priscilla johnson 1 4294967535&#010;priscilla johnson 2 8589935003&#010;priscilla johnson 3 12884902308&#010;priscilla johnson 4 17179869707&#010;priscilla johnson 5 21474837167&#010;priscilla king 1 4294967385&#010;priscilla nixon 1 4294967388&#010;priscilla nixon 2 8589934849&#010;priscilla ovid 1 4294967528&#010;priscilla ovid 2 8589935035&#010;priscilla polk 1 4294967434&#010;priscilla quirinius 1 4294967347&#010;priscilla thompson 1 4294967497&#010;priscilla underhill 1 4294967520&#010;priscilla underhill 2 8589934853&#010;priscilla van buren 1 4294967318&#010;priscilla van buren 2 8589934809&#010;priscilla van buren 3 12884902351&#010;priscilla white 1 4294967419&#010;priscilla xylophone 1 4294967503&#010;priscilla xylophone 2 8589934956&#010;priscilla xylophone 3 12884902406&#010;priscilla young 1 4294967401&#010;priscilla young 2 8589934931&#010;priscilla zipper 1 4294967516&#010;priscilla zipper 2 8589934950&#010;quinn allen 1 4294967339&#010;quinn allen 2 8589934881&#010;quinn brown 1 4294967335&#010;quinn brown 2 8589934651&#010;quinn brown 3 12884902099&#010;quinn davidson 1 4294967478&#010;quinn davidson 2 8589934849&#010;quinn davidson 3 12884902238&#010;quinn davidson 4 17179869565&#010;quinn ellison 1 4294967392&#010;quinn ellison 2 8589934907&#010;quinn garcia 1 4294967344&#010;quinn garcia 2 8589934882&#010;quinn garcia 3 12884902395&#010;quinn garcia 4 17179869868&#010;quinn ichabod 1 4294967405&#010;quinn king 1 4294967538&#010;quinn king 2 8589934996&#010;quinn laertes 1 4294967533&#010;quinn laertes 2 8589934977&#010;quinn laertes 3 12884902524&#010;quinn nixon 1 4294967432&#010;quinn ovid 1 4294967340&#010;quinn quirinius 1 4294967347&#010;quinn robinson 1 4294967365&#010;quinn steinbeck 1 4294967358&#010;quinn steinbeck 2 8589934810&#010;quinn thompson 1 4294967488&#010;quinn thompson 2 8589934888&#010;quinn underhill 1 4294967307&#010;quinn underhill 2 8589934744&#010;quinn underhill 3 12884902278&#010;quinn van buren 1 4294967362&#010;quinn young 1 4294967392&#010;quinn zipper 1 4294967521&#010;quinn zipper 2 8589934944&#010;rachel allen 1 4294967334&#010;rachel allen 2 8589934713&#010;rachel brown 1 4294967451&#010;rachel brown 2 8589934886&#010;rachel brown 3 12884902325&#010;rachel brown 4 17179869632&#010;rachel brown 5 21474836938&#010;rachel carson 1 4294967461&#010;rachel carson 2 8589934777&#010;rachel davidson 1 4294967387&#010;rachel ellison 1 4294967423&#010;rachel falkner 1 4294967544&#010;rachel falkner 2 8589934892&#010;rachel falkner 3 12884902350&#010;rachel falkner 4 17179869809&#010;rachel johnson 1 4294967541&#010;rachel king 1 4294967442&#010;rachel king 2 8589934771&#010;rachel laertes 1 4294967446&#010;rachel laertes 2 8589934804&#010;rachel ovid 1 4294967481&#010;rachel ovid 2 8589934832&#010;rachel polk 1 4294967335&#010;rachel quirinius 1 4294967297&#010;rachel robinson 1 4294967344&#010;rachel robinson 2 8589934807&#010;rachel robinson 3 12884902135&#010;rachel thompson 1 4294967518&#010;rachel thompson 2 8589934881&#010;rachel thompson 3 12884902306&#010;rachel underhill 1 4294967382&#010;rachel white 1 4294967457&#010;rachel white 2 8589934793&#010;rachel young 1 4294967391&#010;rachel zipper 1 4294967434&#010;rachel zipper 2 8589934813&#010;sarah carson 1 4294967503&#010;sarah carson 2 8589934822&#010;sarah carson 3 12884902167&#010;sarah ellison 1 4294967542&#010;sarah falkner 1 4294967525&#010;sarah falkner 2 8589934974&#010;sarah garcia 1 4294967391&#010;sarah garcia 2 8589934849&#010;sarah garcia 3 12884902247&#010;sarah ichabod 1 4294967370&#010;sarah ichabod 2 8589934909&#010;sarah johnson 1 4294967433&#010;sarah johnson 2 8589934926&#010;sarah johnson 3 12884902235&#010;sarah johnson 4 17179869559&#010;sarah king 1 4294967496&#010;sarah king 2 8589935039&#010;sarah miller 1 4294967458&#010;sarah ovid 1 4294967350&#010;sarah robinson 1 4294967419&#010;sarah robinson 2 8589934917&#010;sarah steinbeck 1 4294967456&#010;sarah white 1 4294967514&#010;sarah white 2 8589934882&#010;sarah xylophone 1 4294967355&#010;sarah young 1 4294967442&#010;sarah zipper 1 4294967432&#010;tom brown 1 4294967432&#010;tom brown 2 8589934950&#010;tom carson 1 4294967388&#010;tom carson 2 8589934693&#010;tom carson 3 12884902227&#010;tom davidson 1 4294967507&#010;tom ellison 1 4294967487&#010;tom ellison 2 8589934844&#010;tom ellison 3 12884902188&#010;tom falkner 1 4294967382&#010;tom falkner 2 8589934837&#010;tom hernandez 1 8589934733&#010;tom hernandez 1 8589934733&#010;tom ichabod 1 4294967445&#010;tom johnson 1 4294967492&#010;tom johnson 2 8589934923&#010;tom king 1 4294967331&#010;tom laertes 1 4294967431&#010;tom laertes 2 8589934744&#010;tom miller 1 4294967366&#010;tom miller 2 8589934723&#010;tom miller 3 12884902078&#010;tom nixon 1 4294967506&#010;tom ovid 1 4294967512&#010;tom polk 1 4294967329&#010;tom polk 2 8589934869&#010;tom quirinius 1 4294967507&#010;tom quirinius 2 8589934823&#010;tom robinson 1 4294967457&#010;tom robinson 2 8589935008&#010;tom robinson 3 12884902462&#010;tom robinson 4 17179869770&#010;tom steinbeck 1 4294967447&#010;tom van buren 1 4294967374&#010;tom van buren 2 8589934703&#010;tom van buren 3 12884902195&#010;tom white 1 4294967413&#010;tom young 1 4294967539&#010;tom young 2 8589935074&#010;tom zipper 1 4294967526&#010;ulysses brown 1 4294967537&#010;ulysses carson 1 4294967323&#010;ulysses carson 2 8589934815&#010;ulysses carson 3 12884902127&#010;ulysses carson 4 17179869485&#010;ulysses davidson 1 4294967467&#010;ulysses ellison 1 4294967442&#010;ulysses garcia 1 4294967470&#010;ulysses hernandez 1 4294967449&#010;ulysses hernandez 2 8589934995&#010;ulysses hernandez 3 12884902393&#010;ulysses ichabod 1 4294967353&#010;ulysses ichabod 2 8589934728&#010;ulysses johnson 1 4294967432&#010;ulysses king 1 4294967537&#010;ulysses laertes 1 4294967391&#010;ulysses laertes 2 8589934938&#010;ulysses laertes 3 12884902431&#010;ulysses miller 1 4294967373&#010;ulysses miller 2 8589934808&#010;ulysses nixon 1 4294967296&#010;ulysses ovid 1 4294967394&#010;ulysses polk 1 4294967509&#010;ulysses polk 2 8589934960&#010;ulysses polk 3 12884902440&#010;ulysses polk 4 17179869745&#010;ulysses quirinius 1 4294967449&#010;ulysses robinson 1 4294967531&#010;ulysses steinbeck 1 4294967303&#010;ulysses steinbeck 2 8589934788&#010;ulysses thompson 1 4294967389&#010;ulysses underhill 1 4294967544&#010;ulysses underhill 2 8589934949&#010;ulysses underhill 3 12884902275&#010;ulysses underhill 4 17179869726&#010;ulysses underhill 5 21474837190&#010;ulysses underhill 6 25769804570&#010;ulysses underhill 7 30064771927&#010;ulysses van buren 1 4294967439&#010;ulysses white 1 4294967429&#010;ulysses white 2 8589934878&#010;ulysses xylophone 1 4294967524&#010;ulysses xylophone 2 8589935025&#010;ulysses xylophone 3 12884902473&#010;ulysses young 1 4294967427&#010;ulysses young 2 8589934763&#010;ulysses young 3 12884902154&#010;victor allen 1 4294967450&#010;victor allen 2 8589934776&#010;victor brown 1 4294967521&#010;victor brown 2 8589934864&#010;victor brown 3 12884902170&#010;victor brown 4 17179869625&#010;victor davidson 1 4294967419&#010;victor davidson 2 8589934720&#010;victor davidson 3 12884902156&#010;victor ellison 1 4294967362&#010;victor ellison 2 8589934831&#010;victor hernandez 1 4294967428&#010;victor hernandez 2 8589934733&#010;victor hernandez 3 12884902062&#010;victor hernandez 4 17179869402&#010;victor hernandez 5 21474836874&#010;victor johnson 1 4294967496&#010;victor johnson 2 8589934824&#010;victor johnson 3 12884902246&#010;victor king 1 4294967401&#010;victor king 2 8589934884&#010;victor laertes 1 4294967407&#010;victor laertes 2 8589934862&#010;victor miller 1 4294967410&#010;victor nixon 1 4294967424&#010;victor nixon 2 8589934803&#010;victor ovid 1 4294967355&#010;victor polk 1 4294967333&#010;victor quirinius 1 4294967520&#010;victor quirinius 2 8589934846&#010;victor robinson 1 4294967440&#010;victor robinson 2 8589934930&#010;victor steinbeck 1 4294967390&#010;victor steinbeck 2 8589934707&#010;victor steinbeck 3 12884902037&#010;victor thompson 1 4294967319&#010;victor van buren 1 4294967365&#010;victor van buren 2 8589934906&#010;victor white 1 4294967403&#010;victor white 2 8589934862&#010;victor xylophone 1 4294967331&#010;victor xylophone 2 8589934864&#010;victor xylophone 3 12884902262&#010;victor xylophone 4 17179869633&#010;victor xylophone 5 21474837062&#010;victor young 1 4294967337&#010;victor zipper 1 4294967428&#010;wendy allen 1 4294967473&#010;wendy allen 2 8589934989&#010;wendy allen 3 12884902367&#010;wendy brown 1 4294967337&#010;wendy brown 2 8589934817&#010;wendy ellison 1 4294967475&#010;wendy ellison 2 8589934989&#010;wendy falkner 1 4294967313&#010;wendy falkner 2 8589934810&#010;wendy falkner 3 12884902236&#010;wendy garcia 1 4294967394&#010;wendy garcia 2 8589934775&#010;wendy garcia 3 12884902088&#010;wendy garcia 4 17179869400&#010;wendy hernandez 1 4294967299&#010;wendy ichabod 1 4294967516&#010;wendy king 1 4294967420&#010;wendy king 2 8589934811&#010;wendy king 3 12884902252&#010;wendy laertes 1 4294967519&#010;wendy laertes 2 8589934939&#010;wendy laertes 3 12884902315&#010;wendy miller 1 4294967478&#010;wendy miller 2 8589934957&#010;wendy nixon 1 4294967407&#010;wendy nixon 2 8589934901&#010;wendy ovid 1 4294967464&#010;wendy ovid 2 8589934894&#010;wendy polk 1 4294967434&#010;wendy polk 2 8589934824&#010;wendy quirinius 1 4294967334&#010;wendy quirinius 2 8589934782&#010;wendy robinson 1 4294967302&#010;wendy robinson 2 8589934613&#010;wendy robinson 3 12884901977&#010;wendy steinbeck 1 4294967444&#010;wendy thompson 1 4294967301&#010;wendy thompson 2 8589934621&#010;wendy underhill 1 4294967540&#010;wendy underhill 2 8589934993&#010;wendy underhill 3 12884902410&#010;wendy van buren 1 4294967488&#010;wendy van buren 2 8589934835&#010;wendy white 1 4294967490&#010;wendy xylophone 1 4294967488&#010;wendy xylophone 2 8589934939&#010;wendy young 1 4294967395&#010;wendy young 2 8589934708&#010;xavier allen 1 4294967304&#010;xavier allen 2 8589934743&#010;xavier allen 3 12884902129&#010;xavier brown 1 4294967546&#010;xavier brown 2 8589935074&#010;xavier brown 3 12884902532&#010;xavier carson 1 4294967547&#010;xavier carson 2 8589934862&#010;xavier davidson 1 4294967361&#010;xavier davidson 2 8589934760&#010;xavier davidson 3 12884902204&#010;xavier ellison 1 4294967441&#010;xavier ellison 2 8589934914&#010;xavier garcia 1 4294967465&#010;xavier hernandez 1 4294967383&#010;xavier hernandez 2 8589934743&#010;xavier hernandez 3 12884902274&#010;xavier ichabod 1 4294967511&#010;xavier ichabod 2 8589934950&#010;xavier johnson 1 4294967507&#010;xavier johnson 2 8589934898&#010;xavier king 1 4294967456&#010;xavier king 2 8589934758&#010;xavier laertes 1 4294967450&#010;xavier ovid 1 4294967403&#010;xavier polk 1 4294967506&#010;xavier polk 2 8589934925&#010;xavier polk 3 12884902406&#010;xavier polk 4 17179869906&#010;xavier quirinius 1 4294967383&#010;xavier quirinius 2 8589934748&#010;xavier quirinius 3 12884902060&#010;xavier quirinius 4 17179869562&#010;xavier thompson 1 4294967444&#010;xavier underhill 1 4294967332&#010;xavier white 1 4294967473&#010;xavier white 2 8589934952&#010;xavier xylophone 1 4294967499&#010;xavier zipper 1 4294967547&#010;yuri allen 1 4294967528&#010;yuri allen 2 8589935079&#010;yuri brown 1 4294967433&#010;yuri brown 2 8589934960&#010;yuri carson 1 4294967317&#010;yuri carson 2 8589934851&#010;yuri ellison 1 4294967299&#010;yuri ellison 2 8589934697&#010;yuri falkner 1 4294967368&#010;yuri falkner 2 8589934891&#010;yuri garcia 1 4294967362&#010;yuri hernandez 1 4294967367&#010;yuri johnson 1 4294967421&#010;yuri johnson 2 8589934877&#010;yuri johnson 3 12884902361&#010;yuri king 1 4294967376&#010;yuri laertes 1 4294967402&#010;yuri laertes 2 8589934924&#010;yuri nixon 1 4294967400&#010;yuri nixon 2 8589934706&#010;yuri polk 1 4294967391&#010;yuri polk 2 8589934861&#010;yuri polk 3 12884902167&#010;yuri quirinius 1 4294967398&#010;yuri quirinius 2 8589934768&#010;yuri quirinius 3 12884902081&#010;yuri steinbeck 1 4294967535&#010;yuri steinbeck 2 8589934873&#010;yuri thompson 1 4294967447&#010;yuri underhill 1 4294967499&#010;yuri underhill 2 8589934900&#010;yuri white 1 4294967341&#010;yuri xylophone 1 4294967420&#010;zach allen 1 4294967507&#010;zach brown 1 4294967316&#010;zach brown 2 8589934728&#010;zach brown 3 12884902099&#010;zach brown 4 17179869452&#010;zach brown 5 21474836769&#010;zach carson 1 4294967463&#010;zach ellison 1 4294967471&#010;zach falkner 1 4294967362&#010;zach falkner 2 8589934717&#010;zach garcia 1 4294967481&#010;zach garcia 2 8589934854&#010;zach garcia 3 12884902240&#010;zach garcia 4 17179869723&#010;zach ichabod 1 4294967539&#010;zach ichabod 2 8589934912&#010;zach king 1 4294967424&#010;zach king 2 8589934956&#010;zach king 3 12884902458&#010;zach miller 1 4294967442&#010;zach miller 2 8589934772&#010;zach miller 3 12884902163&#010;zach ovid 1 4294967412&#010;zach ovid 2 8589934775&#010;zach ovid 3 12884902244&#010;zach ovid 4 17179869574&#010;zach quirinius 1 4294967299&#010;zach robinson 1 4294967325&#010;zach steinbeck 1 4294967469&#010;zach steinbeck 2 8589934834&#010;zach thompson 1 4294967405&#010;zach thompson 2 8589934730&#010;zach underhill 1 4294967496&#010;zach white 1 4294967501&#010;zach xylophone 1 4294967452&#010;zach xylophone 2 8589934755&#010;zach young 1 4294967297&#010;zach zipper 1 4294967497&#010;zach zipper 2 8589934855&#010;zach zipper 3 12884902222&#010;


      org.scalatest.exceptions.TestFailedException: 
Failed to execute query using catalyst:
Error: execute, tree:
Exchange rangepartitioning(s#204069 ASC NULLS FIRST, r#204058 ASC NULLS FIRST, sum#204059L ASC NULLS FIRST, 5), true, [id=#151359]
+- *(2) Project [s#204069, r#204058, sum#204059L]
   +- Window [rank(si#204063) windowspecdefinition(s#204069, si#204063 ASC NULLS FIRST, specifiedwindowframe(RowFrame, unboundedpreceding$(), currentrow$())) AS r#204058, sum(b#204065L) windowspecdefinition(s#204069, si#204063 ASC NULLS FIRST, specifiedwindowframe(RangeFrame, unboundedpreceding$(), currentrow$())) AS sum#204059L], [s#204069], [si#204063 ASC NULLS FIRST]
      +- *(1) Sort [s#204069 ASC NULLS FIRST, si#204063 ASC NULLS FIRST], false, 0
         +- Exchange hashpartitioning(s#204069, 5), true, [id=#151345]
            +- Scan hive default.over1k [s#204069, si#204063, b#204065L], HiveTableRelation `default`.`over1k`, org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe, [t#204062, si#204063, i#204064, b#204065L, f#204066, d#204067, bo#204068, s#204069, ts#204070, dec#204071, bin#204072]

org.apache.spark.sql.catalyst.errors.package$TreeNodeException: execute, tree:
Exchange rangepartitioning(s#204069 ASC NULLS FIRST, r#204058 ASC NULLS FIRST, sum#204059L ASC NULLS FIRST, 5), true, [id=#151359]
+- *(2) Project [s#204069, r#204058, sum#204059L]
   +- Window [rank(si#204063) windowspecdefinition(s#204069, si#204063 ASC NULLS FIRST, specifiedwindowframe(RowFrame, unboundedpreceding$(), currentrow$())) AS r#204058, sum(b#204065L) windowspecdefinition(s#204069, si#204063 ASC NULLS FIRST, specifiedwindowframe(RangeFrame, unboundedpreceding$(), currentrow$())) AS sum#204059L], [s#204069], [si#204063 ASC NULLS FIRST]
      +- *(1) Sort [s#204069 ASC NULLS FIRST, si#204063 ASC NULLS FIRST], false, 0
         +- Exchange hashpartitioning(s#204069, 5), true, [id=#151345]
            +- Scan hive default.over1k [s#204069, si#204063, b#204065L], HiveTableRelation `default`.`over1k`, org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe, [t#204062, si#204063, i#204064, b#204065L, f#204066, d#204067, bo#204068, s#204069, ts#204070, dec#204071, bin#204072]

	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(s#204069, 5), true, [id=#151345]
+- Scan hive default.over1k [s#204069, si#204063, b#204065L], HiveTableRelation `default`.`over1k`, org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe, [t#204062, si#204063, i#204064, b#204065L, f#204066, d#204067, bo#204068, s#204069, ts#204070, dec#204071, bin#204072]

	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,
rank() over (partition by s order by si) r,
sum(b) over (partition by s order by si) sum
from over1k
order by s, r, sum
== Parsed Logical Plan ==
'Sort ['s ASC NULLS FIRST, 'r ASC NULLS FIRST, 'sum ASC NULLS FIRST], true
+- 'Project ['s, 'rank() windowspecdefinition('s, 'si ASC NULLS FIRST, unspecifiedframe$()) AS r#204058, 'sum('b) windowspecdefinition('s, 'si ASC NULLS FIRST, unspecifiedframe$()) AS sum#204059]
   +- 'UnresolvedRelation [over1k]

== Analyzed Logical Plan ==
s: string, r: int, sum: bigint
Sort [s#204069 ASC NULLS FIRST, r#204058 ASC NULLS FIRST, sum#204059L ASC NULLS FIRST], true
+- Project [s#204069, r#204058, sum#204059L]
   +- Project [s#204069, si#204063, b#204065L, r#204058, sum#204059L, r#204058, sum#204059L]
      +- Window [rank(si#204063) windowspecdefinition(s#204069, si#204063 ASC NULLS FIRST, specifiedwindowframe(RowFrame, unboundedpreceding$(), currentrow$())) AS r#204058, sum(b#204065L) windowspecdefinition(s#204069, si#204063 ASC NULLS FIRST, specifiedwindowframe(RangeFrame, unboundedpreceding$(), currentrow$())) AS sum#204059L], [s#204069], [si#204063 ASC NULLS FIRST]
         +- Project [s#204069, si#204063, b#204065L]
            +- SubqueryAlias `default`.`over1k`
               +- HiveTableRelation `default`.`over1k`, org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe, [t#204062, si#204063, i#204064, b#204065L, f#204066, d#204067, bo#204068, s#204069, ts#204070, dec#204071, bin#204072]

== Optimized Logical Plan ==
Sort [s#204069 ASC NULLS FIRST, r#204058 ASC NULLS FIRST, sum#204059L ASC NULLS FIRST], true
+- Project [s#204069, r#204058, sum#204059L]
   +- Window [rank(si#204063) windowspecdefinition(s#204069, si#204063 ASC NULLS FIRST, specifiedwindowframe(RowFrame, unboundedpreceding$(), currentrow$())) AS r#204058, sum(b#204065L) windowspecdefinition(s#204069, si#204063 ASC NULLS FIRST, specifiedwindowframe(RangeFrame, unboundedpreceding$(), currentrow$())) AS sum#204059L], [s#204069], [si#204063 ASC NULLS FIRST]
      +- Project [s#204069, si#204063, b#204065L]
         +- HiveTableRelation `default`.`over1k`, org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe, [t#204062, si#204063, i#204064, b#204065L, f#204066, d#204067, bo#204068, s#204069, ts#204070, dec#204071, bin#204072]

== Physical Plan ==
*(3) Sort [s#204069 ASC NULLS FIRST, r#204058 ASC NULLS FIRST, sum#204059L ASC NULLS FIRST], true, 0
+- Exchange rangepartitioning(s#204069 ASC NULLS FIRST, r#204058 ASC NULLS FIRST, sum#204059L ASC NULLS FIRST, 5), true, [id=#151359]
   +- *(2) Project [s#204069, r#204058, sum#204059L]
      +- Window [rank(si#204063) windowspecdefinition(s#204069, si#204063 ASC NULLS FIRST, specifiedwindowframe(RowFrame, unboundedpreceding$(), currentrow$())) AS r#204058, sum(b#204065L) windowspecdefinition(s#204069, si#204063 ASC NULLS FIRST, specifiedwindowframe(RangeFrame, unboundedpreceding$(), currentrow$())) AS sum#204059L], [s#204069], [si#204063 ASC NULLS FIRST]
         +- *(1) Sort [s#204069 ASC NULLS FIRST, si#204063 ASC NULLS FIRST], false, 0
            +- Exchange hashpartitioning(s#204069, 5), true, [id=#151345]
               +- Scan hive default.over1k [s#204069, si#204063, b#204065L], HiveTableRelation `default`.`over1k`, org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe, [t#204062, si#204063, i#204064, b#204065L, f#204066, d#204067, bo#204068, s#204069, ts#204070, dec#204071, bin#204072]

== HIVE - 1049 row(s) ==
	1	4294967354
	2	8589934811
	3	12884902227
alice allen	1	4294967487
alice allen	2	8589935012
alice allen	3	12884902543
alice brown	1	4294967355
alice carson	1	4294967370
alice davidson	1	4294967517
alice falkner	1	4294967316
alice garcia	1	4294967369
alice hernandez	1	4294967314
alice hernandez	2	8589934613
alice johnson	1	4294967424
alice king	1	4294967387
alice king	2	8589934903
alice king	3	12884902449
alice laertes	1	4294967519
alice laertes	2	8589935038
alice miller	1	4294967324
alice nixon	1	4294967484
alice nixon	2	8589934894
alice nixon	3	12884902307
alice ovid	1	4294967412
alice polk	1	4294967366
alice quirinius	1	4294967505
alice quirinius	2	8589935054
alice robinson	1	4294967502
alice robinson	2	8589934947
alice steinbeck	1	4294967549
alice steinbeck	2	8589934913
alice steinbeck	3	12884902387
alice underhill	1	4294967441
alice van buren	1	4294967428
alice xylophone	1	4294967519
alice xylophone	2	8589934877
alice xylophone	3	12884902240
alice zipper	1	4294967380
alice zipper	2	8589934919
alice zipper	3	12884902439
bob brown	1	4294967431
bob brown	2	8589934853
bob brown	3	12884902280
bob carson	1	4294967408
bob davidson	1	4294967435
bob davidson	2	8589934939
bob davidson	3	12884902293
bob ellison	1	4294967530
bob ellison	2	8589934966
bob ellison	3	12884902328
bob ellison	4	17179869672
bob falkner	1	4294967464
bob garcia	1	4294967435
bob garcia	2	8589934804
bob garcia	3	12884902148
bob garcia	4	17179869587
bob garcia	5	21474836905
bob hernandez	1	4294967500
bob ichabod	1	4294967424
bob king	1	4294967443
bob king	2	8589934740
bob king	3	12884902279
bob laertes	1	4294967472
bob laertes	2	8589934852
bob miller	1	4294967349
bob ovid	1	4294967401
bob ovid	2	8589934801
bob ovid	3	12884902313
bob ovid	4	17179869708
bob polk	1	4294967337
bob quirinius	1	4294967346
bob steinbeck	1	4294967342
bob van buren	1	4294967422
bob white	1	4294967493
bob white	2	8589934855
bob xylophone	1	4294967407
bob xylophone	2	8589934872
bob young	1	4294967413
bob zipper	1	4294967416
bob zipper	2	8589934769
bob zipper	3	12884902068
calvin allen	1	4294967373
calvin brown	1	4294967530
calvin brown	2	8589934967
calvin brown	3	12884902378
calvin carson	1	4294967534
calvin davidson	1	4294967437
calvin davidson	2	8589934905
calvin ellison	1	4294967480
calvin falkner	1	4294967305
calvin falkner	2	8589934723
calvin falkner	3	12884902155
calvin falkner	4	17179869455
calvin falkner	5	21474836800
calvin falkner	6	25769804250
calvin garcia	1	4294967492
calvin hernandez	1	4294967341
calvin johnson	1	4294967546
calvin laertes	1	4294967499
calvin laertes	2	8589934930
calvin nixon	1	4294967488
calvin nixon	2	8589934788
calvin nixon	3	12884902200
calvin ovid	1	4294967343
calvin ovid	2	8589934881
calvin ovid	3	12884902210
calvin ovid	4	17179869559
calvin polk	1	4294967416
calvin quirinius	1	4294967532
calvin quirinius	2	8589935053
calvin robinson	1	4294967326
calvin steinbeck	1	4294967417
calvin steinbeck	2	8589934891
calvin steinbeck	3	12884902396
calvin thompson	1	4294967346
calvin thompson	2	8589934859
calvin underhill	1	4294967478
calvin van buren	1	4294967300
calvin van buren	2	8589934808
calvin white	1	4294967304
calvin white	2	8589934848
calvin xylophone	1	4294967299
calvin xylophone	2	8589934675
calvin xylophone	3	12884902133
calvin young	1	4294967410
calvin young	2	8589934752
calvin zipper	1	4294967441
calvin zipper	2	8589934960
david allen	1	4294967381
david allen	2	8589934752
david brown	1	4294967544
david brown	2	8589934870
david davidson	1	4294967487
david davidson	2	8589934952
david davidson	3	12884902474
david davidson	4	17179869819
david ellison	1	4294967477
david ellison	2	8589934963
david ellison	3	12884902426
david hernandez	1	4294967324
david ichabod	1	4294967385
david ichabod	2	8589934872
david laertes	1	4294967385
david nixon	1	4294967381
david ovid	1	4294967396
david ovid	2	8589934839
david quirinius	1	4294967375
david quirinius	2	8589934905
david quirinius	3	12884902362
david robinson	1	4294967465
david robinson	2	8589934933
david thompson	1	4294967361
david underhill	1	4294967331
david underhill	2	8589934715
david underhill	3	12884902185
david van buren	1	4294967438
david van buren	2	8589934747
david white	1	4294967428
david xylophone	1	8589934898
david xylophone	1	8589934898
david xylophone	3	12884902378
david young	1	4294967296
david young	2	8589934601
ethan allen	1	4294967351
ethan brown	1	4294967477
ethan brown	2	8589934897
ethan brown	3	12884902217
ethan brown	4	17179869548
ethan brown	5	21474836951
ethan brown	6	25769804375
ethan carson	1	4294967352
ethan ellison	1	4294967514
ethan ellison	2	8589934923
ethan falkner	1	4294967318
ethan falkner	2	8589934779
ethan garcia	1	4294967310
ethan hernandez	1	4294967349
ethan johnson	1	4294967357
ethan king	1	4294967413
ethan laertes	1	4294967402
ethan laertes	2	8589934859
ethan laertes	3	12884902390
ethan laertes	4	17179869880
ethan laertes	5	21474837302
ethan laertes	6	25769804603
ethan laertes	7	30064771974
ethan miller	1	4294967352
ethan nixon	1	4294967499
ethan ovid	1	4294967452
ethan polk	1	4294967329
ethan polk	2	8589934711
ethan polk	3	12884902253
ethan polk	4	17179869732
ethan quirinius	1	4294967501
ethan quirinius	2	8589934852
ethan quirinius	3	12884902200
ethan robinson	1	4294967353
ethan robinson	2	8589934855
ethan underhill	1	4294967466
ethan van buren	1	4294967511
ethan white	1	4294967445
ethan white	2	8589934872
ethan xylophone	1	4294967543
ethan zipper	1	4294967462
ethan zipper	2	8589934815
fred davidson	1	4294967512
fred davidson	2	8589934936
fred davidson	3	12884902424
fred ellison	1	4294967470
fred ellison	2	8589934901
fred ellison	3	12884902294
fred falkner	1	4294967340
fred falkner	2	8589934887
fred falkner	3	12884902187
fred hernandez	1	4294967365
fred ichabod	1	4294967342
fred ichabod	2	8589934831
fred johnson	1	4294967373
fred king	1	4294967346
fred king	2	8589934766
fred laertes	1	4294967351
fred miller	1	4294967490
fred nixon	1	4294967514
fred nixon	2	8589934811
fred nixon	3	12884902293
fred nixon	4	17179869668
fred polk	1	4294967332
fred polk	2	8589934775
fred polk	3	12884902233
fred polk	4	17179869740
fred quirinius	1	4294967426
fred quirinius	2	8589934951
fred robinson	1	4294967461
fred steinbeck	1	4294967411
fred steinbeck	2	8589934740
fred steinbeck	3	12884902212
fred underhill	1	4294967387
fred van buren	1	4294967431
fred van buren	2	8589934812
fred van buren	3	12884902338
fred van buren	4	17179869801
fred white	1	4294967434
fred young	1	4294967495
fred young	2	8589934980
fred zipper	1	4294967447
gabriella allen	1	4294967405
gabriella allen	2	8589934939
gabriella brown	1	4294967543
gabriella brown	2	8589934946
gabriella carson	1	4294967540
gabriella davidson	1	4294967507
gabriella ellison	1	4294967393
gabriella ellison	2	8589934733
gabriella falkner	1	4294967378
gabriella falkner	2	8589934901
gabriella falkner	3	12884902335
gabriella garcia	1	4294967419
gabriella hernandez	1	4294967481
gabriella hernandez	2	8589934943
gabriella ichabod	1	4294967337
gabriella ichabod	2	8589934725
gabriella ichabod	3	12884902062
gabriella ichabod	4	17179869382
gabriella ichabod	5	21474836880
gabriella king	1	4294967434
gabriella king	2	8589934827
gabriella laertes	1	4294967410
gabriella miller	1	4294967363
gabriella ovid	1	4294967482
gabriella ovid	2	8589935004
gabriella polk	1	4294967410
gabriella polk	2	8589934712
gabriella steinbeck	1	4294967500
gabriella steinbeck	2	8589934935
gabriella thompson	1	4294967299
gabriella thompson	2	8589934711
gabriella thompson	3	12884902196
gabriella van buren	1	4294967457
gabriella van buren	2	8589934927
gabriella white	1	4294967335
gabriella young	1	4294967493
gabriella young	2	8589934924
gabriella zipper	1	4294967357
gabriella zipper	2	8589934867
holly allen	1	4294967327
holly brown	1	4294967321
holly brown	2	8589934659
holly falkner	1	4294967324
holly hernandez	1	4294967378
holly hernandez	2	8589934921
holly hernandez	3	12884902465
holly hernandez	4	17179869773
holly ichabod	1	4294967342
holly ichabod	2	8589934800
holly ichabod	3	12884902129
holly johnson	1	4294967517
holly johnson	2	8589934897
holly johnson	3	12884902432
holly king	1	4294967392
holly king	2	8589934753
holly laertes	1	4294967406
holly miller	1	4294967388
holly nixon	1	4294967383
holly nixon	2	8589934707
holly polk	1	4294967398
holly polk	2	8589934832
holly robinson	1	4294967532
holly thompson	1	4294967529
holly thompson	2	8589934868
holly thompson	3	12884902242
holly underhill	1	4294967383
holly underhill	2	8589934894
holly underhill	3	12884902330
holly underhill	4	17179869856
holly van buren	1	4294967539
holly white	1	4294967320
holly white	2	8589934735
holly xylophone	1	4294967435
holly young	1	4294967487
holly young	2	8589934987
holly zipper	1	4294967337
holly zipper	2	8589934846
irene allen	1	4294967518
irene brown	1	4294967434
irene brown	2	8589934862
irene brown	3	12884902272
irene carson	1	4294967473
irene ellison	1	4294967379
irene ellison	2	8589934797
irene falkner	1	4294967404
irene falkner	2	8589934952
irene garcia	1	4294967498
irene garcia	2	8589934869
irene garcia	3	12884902192
irene ichabod	1	4294967529
irene ichabod	2	8589935038
irene johnson	1	4294967468
irene laertes	1	4294967481
irene laertes	2	8589934780
irene laertes	3	12884902116
irene miller	1	4294967387
irene nixon	1	4294967323
irene nixon	2	8589934824
irene nixon	3	12884902362
irene ovid	1	4294967499
irene ovid	2	8589934870
irene ovid	3	12884902230
irene polk	1	4294967521
irene polk	2	8589934930
irene polk	3	12884902395
irene polk	4	17179869941
irene polk	5	21474837237
irene quirinius	1	4294967365
irene quirinius	2	8589934751
irene quirinius	3	12884902141
irene robinson	1	4294967347
irene steinbeck	1	4294967549
irene thompson	1	4294967479
irene underhill	1	4294967371
irene underhill	2	8589934753
irene van buren	1	4294967439
irene van buren	2	8589934906
irene xylophone	1	4294967436
jessica brown	1	4294967496
jessica carson	1	4294967389
jessica carson	2	8589934897
jessica carson	3	12884902345
jessica davidson	1	4294967325
jessica davidson	2	8589934709
jessica davidson	3	12884902098
jessica davidson	4	17179869569
jessica ellison	1	4294967316
jessica ellison	2	8589934721
jessica falkner	1	4294967549
jessica garcia	1	4294967540
jessica garcia	2	8589935041
jessica ichabod	1	4294967413
jessica johnson	1	4294967497
jessica johnson	2	8589934870
jessica miller	1	4294967495
jessica nixon	1	4294967311
jessica nixon	2	8589934754
jessica ovid	1	4294967330
jessica ovid	2	8589934855
jessica polk	1	4294967403
jessica quirinius	1	4294967523
jessica quirinius	2	8589934942
jessica quirinius	3	12884902388
jessica quirinius	4	17179869696
jessica robinson	1	4294967542
jessica thompson	1	4294967449
jessica thompson	2	8589934763
jessica underhill	1	4294967541
jessica underhill	2	8589934844
jessica underhill	3	12884902153
jessica van buren	1	4294967344
jessica white	1	4294967482
jessica white	2	8589934929
jessica white	3	12884902378
jessica white	4	17179869687
jessica white	5	21474837086
jessica xylophone	1	4294967421
jessica young	1	4294967382
jessica young	2	8589934903
jessica zipper	1	4294967334
jessica zipper	2	8589934785
jessica zipper	3	12884902157
katie allen	1	4294967443
katie brown	1	4294967420
katie davidson	1	4294967459
katie ellison	1	4294967486
katie ellison	2	8589934861
katie falkner	1	4294967362
katie garcia	1	4294967306
katie garcia	2	8589934680
katie hernandez	1	4294967451
katie ichabod	1	4294967330
katie ichabod	2	8589934742
katie ichabod	3	12884902209
katie king	1	4294967339
katie king	2	8589934760
katie king	3	12884902199
katie miller	1	4294967425
katie miller	2	8589934859
katie nixon	1	4294967500
katie ovid	1	4294967519
katie polk	1	4294967384
katie polk	2	8589934926
katie robinson	1	4294967310
katie van buren	1	4294967335
katie van buren	2	8589934647
katie white	1	4294967337
katie white	2	8589934643
katie xylophone	1	4294967486
katie young	1	4294967349
katie young	2	8589934681
katie young	3	12884902225
katie zipper	1	4294967354
katie zipper	2	8589934766
luke allen	1	4294967533
luke allen	2	8589934836
luke allen	3	12884902346
luke allen	4	17179869863
luke allen	5	21474837208
luke brown	1	4294967473
luke davidson	1	4294967550
luke davidson	2	8589934904
luke ellison	1	4294967322
luke ellison	2	8589934675
luke ellison	3	12884902103
luke falkner	1	4294967359
luke falkner	2	8589934782
luke garcia	1	4294967304
luke garcia	2	8589934683
luke ichabod	1	4294967324
luke ichabod	2	8589934766
luke johnson	1	4294967527
luke johnson	2	8589934987
luke johnson	3	12884902342
luke laertes	1	4294967505
luke laertes	2	8589935011
luke laertes	3	12884902497
luke laertes	4	17179869806
luke laertes	5	21474837193
luke miller	1	4294967497
luke ovid	1	4294967492
luke ovid	2	8589934901
luke polk	1	4294967545
luke polk	2	8589934873
luke quirinius	1	4294967320
luke robinson	1	4294967299
luke robinson	2	8589934606
luke thompson	1	4294967521
luke underhill	1	4294967393
luke underhill	2	8589934803
luke underhill	3	12884902122
luke van buren	1	4294967424
luke white	1	4294967505
luke xylophone	1	4294967382
luke zipper	1	4294967353
mike allen	1	4294967466
mike brown	1	4294967369
mike carson	1	4294967477
mike carson	2	8589934934
mike carson	3	12884902482
mike davidson	1	4294967501
mike davidson	2	8589934965
mike ellison	1	4294967353
mike ellison	2	8589934747
mike ellison	3	12884902282
mike ellison	4	17179869806
mike ellison	5	21474837309
mike falkner	1	4294967301
mike garcia	1	4294967428
mike garcia	2	8589934826
mike garcia	3	12884902289
mike hernandez	1	4294967316
mike hernandez	2	8589934800
mike ichabod	1	4294967494
mike king	1	4294967323
mike king	2	8589934848
mike king	3	12884902248
mike king	4	17179869595
mike king	5	21474837046
mike king	6	25769804478
mike miller	1	4294967449
mike nixon	1	4294967527
mike nixon	2	8589935004
mike polk	1	4294967389
mike polk	2	8589934848
mike polk	3	12884902351
mike quirinius	1	4294967422
mike steinbeck	1	4294967519
mike steinbeck	2	8589934827
mike steinbeck	3	12884902316
mike steinbeck	4	17179869850
mike van buren	1	4294967544
mike van buren	2	8589935061
mike white	1	4294967336
mike white	2	8589934882
mike white	3	12884902374
mike white	4	17179869843
mike young	1	4294967453
mike young	2	8589934804
mike young	3	12884902198
mike zipper	1	4294967402
mike zipper	2	8589934727
mike zipper	3	12884902228
nick allen	1	4294967507
nick allen	2	8589934807
nick brown	1	4294967334
nick davidson	1	4294967357
nick ellison	1	4294967397
nick ellison	2	8589934699
nick falkner	1	4294967480
nick falkner	2	8589934923
nick garcia	1	4294967384
nick garcia	2	8589934797
nick garcia	3	12884902319
nick ichabod	1	4294967388
nick ichabod	2	8589934758
nick ichabod	3	12884902225
nick johnson	1	4294967398
nick johnson	2	8589934809
nick laertes	1	4294967389
nick miller	1	4294967550
nick nixon	1	4294967482
nick ovid	1	4294967488
nick polk	1	4294967551
nick quirinius	1	4294967316
nick quirinius	2	8589934612
nick robinson	1	4294967409
nick robinson	2	8589934731
nick steinbeck	1	4294967355
nick thompson	1	4294967401
nick underhill	1	4294967527
nick van buren	1	4294967303
nick xylophone	1	4294967460
nick young	1	4294967405
nick young	2	8589934917
nick zipper	1	4294967430
nick zipper	2	8589934796
oscar allen	1	4294967500
oscar brown	1	4294967331
oscar carson	1	4294967460
oscar carson	2	8589934904
oscar carson	3	12884902286
oscar carson	4	17179869599
oscar carson	5	21474836960
oscar davidson	1	4294967482
oscar ellison	1	8589934740
oscar ellison	1	8589934740
oscar falkner	1	4294967526
oscar garcia	1	4294967301
oscar hernandez	1	4294967343
oscar hernandez	2	8589934843
oscar ichabod	1	4294967513
oscar ichabod	2	8589934837
oscar ichabod	3	12884902165
oscar ichabod	4	17179869569
oscar johnson	1	4294967418
oscar johnson	2	8589934763
oscar king	1	4294967465
oscar king	2	8589934936
oscar king	3	12884902469
oscar laertes	1	4294967425
oscar laertes	2	8589934876
oscar laertes	3	12884902426
oscar laertes	4	17179869786
oscar nixon	1	4294967532
oscar ovid	1	4294967508
oscar ovid	2	8589934910
oscar ovid	3	12884902418
oscar polk	1	4294967325
oscar polk	2	8589934713
oscar quirinius	1	4294967416
oscar quirinius	2	8589934932
oscar quirinius	3	12884902390
oscar quirinius	4	17179869763
oscar robinson	1	4294967355
oscar robinson	2	8589934681
oscar robinson	3	12884902031
oscar robinson	4	17179869383
oscar steinbeck	1	4294967548
oscar thompson	1	4294967453
oscar thompson	2	8589934824
oscar thompson	3	12884902197
oscar thompson	4	17179869496
oscar underhill	1	4294967374
oscar van buren	1	4294967520
oscar van buren	2	8589934990
oscar van buren	3	12884902490
oscar white	1	4294967454
oscar white	2	8589934761
oscar white	3	12884902163
oscar white	4	17179869512
oscar xylophone	1	4294967400
oscar xylophone	2	8589934806
oscar xylophone	3	12884902124
oscar zipper	1	4294967449
oscar zipper	2	8589934969
oscar zipper	3	12884902458
priscilla brown	1	4294967369
priscilla brown	2	8589934897
priscilla brown	3	12884902360
priscilla carson	1	4294967489
priscilla carson	2	8589934838
priscilla carson	3	12884902270
priscilla ichabod	1	4294967379
priscilla ichabod	2	8589934926
priscilla johnson	1	4294967535
priscilla johnson	2	8589935003
priscilla johnson	3	12884902308
priscilla johnson	4	17179869707
priscilla johnson	5	21474837167
priscilla king	1	4294967385
priscilla nixon	1	4294967388
priscilla nixon	2	8589934849
priscilla ovid	1	4294967528
priscilla ovid	2	8589935035
priscilla polk	1	4294967434
priscilla quirinius	1	4294967347
priscilla thompson	1	4294967497
priscilla underhill	1	4294967520
priscilla underhill	2	8589934853
priscilla van buren	1	4294967318
priscilla van buren	2	8589934809
priscilla van buren	3	12884902351
priscilla white	1	4294967419
priscilla xylophone	1	4294967503
priscilla xylophone	2	8589934956
priscilla xylophone	3	12884902406
priscilla young	1	4294967401
priscilla young	2	8589934931
priscilla zipper	1	4294967516
priscilla zipper	2	8589934950
quinn allen	1	4294967339
quinn allen	2	8589934881
quinn brown	1	4294967335
quinn brown	2	8589934651
quinn brown	3	12884902099
quinn davidson	1	4294967478
quinn davidson	2	8589934849
quinn davidson	3	12884902238
quinn davidson	4	17179869565
quinn ellison	1	4294967392
quinn ellison	2	8589934907
quinn garcia	1	4294967344
quinn garcia	2	8589934882
quinn garcia	3	12884902395
quinn garcia	4	17179869868
quinn ichabod	1	4294967405
quinn king	1	4294967538
quinn king	2	8589934996
quinn laertes	1	4294967533
quinn laertes	2	8589934977
quinn laertes	3	12884902524
quinn nixon	1	4294967432
quinn ovid	1	4294967340
quinn quirinius	1	4294967347
quinn robinson	1	4294967365
quinn steinbeck	1	4294967358
quinn steinbeck	2	8589934810
quinn thompson	1	4294967488
quinn thompson	2	8589934888
quinn underhill	1	4294967307
quinn underhill	2	8589934744
quinn underhill	3	12884902278
quinn van buren	1	4294967362
quinn young	1	4294967392
quinn zipper	1	4294967521
quinn zipper	2	8589934944
rachel allen	1	4294967334
rachel allen	2	8589934713
rachel brown	1	4294967451
rachel brown	2	8589934886
rachel brown	3	12884902325
rachel brown	4	17179869632
rachel brown	5	21474836938
rachel carson	1	4294967461
rachel carson	2	8589934777
rachel davidson	1	4294967387
rachel ellison	1	4294967423
rachel falkner	1	4294967544
rachel falkner	2	8589934892
rachel falkner	3	12884902350
rachel falkner	4	17179869809
rachel johnson	1	4294967541
rachel king	1	4294967442
rachel king	2	8589934771
rachel laertes	1	4294967446
rachel laertes	2	8589934804
rachel ovid	1	4294967481
rachel ovid	2	8589934832
rachel polk	1	4294967335
rachel quirinius	1	4294967297
rachel robinson	1	4294967344
rachel robinson	2	8589934807
rachel robinson	3	12884902135
rachel thompson	1	4294967518
rachel thompson	2	8589934881
rachel thompson	3	12884902306
rachel underhill	1	4294967382
rachel white	1	4294967457
rachel white	2	8589934793
rachel young	1	4294967391
rachel zipper	1	4294967434
rachel zipper	2	8589934813
sarah carson	1	4294967503
sarah carson	2	8589934822
sarah carson	3	12884902167
sarah ellison	1	4294967542
sarah falkner	1	4294967525
sarah falkner	2	8589934974
sarah garcia	1	4294967391
sarah garcia	2	8589934849
sarah garcia	3	12884902247
sarah ichabod	1	4294967370
sarah ichabod	2	8589934909
sarah johnson	1	4294967433
sarah johnson	2	8589934926
sarah johnson	3	12884902235
sarah johnson	4	17179869559
sarah king	1	4294967496
sarah king	2	8589935039
sarah miller	1	4294967458
sarah ovid	1	4294967350
sarah robinson	1	4294967419
sarah robinson	2	8589934917
sarah steinbeck	1	4294967456
sarah white	1	4294967514
sarah white	2	8589934882
sarah xylophone	1	4294967355
sarah young	1	4294967442
sarah zipper	1	4294967432
tom brown	1	4294967432
tom brown	2	8589934950
tom carson	1	4294967388
tom carson	2	8589934693
tom carson	3	12884902227
tom davidson	1	4294967507
tom ellison	1	4294967487
tom ellison	2	8589934844
tom ellison	3	12884902188
tom falkner	1	4294967382
tom falkner	2	8589934837
tom hernandez	1	8589934733
tom hernandez	1	8589934733
tom ichabod	1	4294967445
tom johnson	1	4294967492
tom johnson	2	8589934923
tom king	1	4294967331
tom laertes	1	4294967431
tom laertes	2	8589934744
tom miller	1	4294967366
tom miller	2	8589934723
tom miller	3	12884902078
tom nixon	1	4294967506
tom ovid	1	4294967512
tom polk	1	4294967329
tom polk	2	8589934869
tom quirinius	1	4294967507
tom quirinius	2	8589934823
tom robinson	1	4294967457
tom robinson	2	8589935008
tom robinson	3	12884902462
tom robinson	4	17179869770
tom steinbeck	1	4294967447
tom van buren	1	4294967374
tom van buren	2	8589934703
tom van buren	3	12884902195
tom white	1	4294967413
tom young	1	4294967539
tom young	2	8589935074
tom zipper	1	4294967526
ulysses brown	1	4294967537
ulysses carson	1	4294967323
ulysses carson	2	8589934815
ulysses carson	3	12884902127
ulysses carson	4	17179869485
ulysses davidson	1	4294967467
ulysses ellison	1	4294967442
ulysses garcia	1	4294967470
ulysses hernandez	1	4294967449
ulysses hernandez	2	8589934995
ulysses hernandez	3	12884902393
ulysses ichabod	1	4294967353
ulysses ichabod	2	8589934728
ulysses johnson	1	4294967432
ulysses king	1	4294967537
ulysses laertes	1	4294967391
ulysses laertes	2	8589934938
ulysses laertes	3	12884902431
ulysses miller	1	4294967373
ulysses miller	2	8589934808
ulysses nixon	1	4294967296
ulysses ovid	1	4294967394
ulysses polk	1	4294967509
ulysses polk	2	8589934960
ulysses polk	3	12884902440
ulysses polk	4	17179869745
ulysses quirinius	1	4294967449
ulysses robinson	1	4294967531
ulysses steinbeck	1	4294967303
ulysses steinbeck	2	8589934788
ulysses thompson	1	4294967389
ulysses underhill	1	4294967544
ulysses underhill	2	8589934949
ulysses underhill	3	12884902275
ulysses underhill	4	17179869726
ulysses underhill	5	21474837190
ulysses underhill	6	25769804570
ulysses underhill	7	30064771927
ulysses van buren	1	4294967439
ulysses white	1	4294967429
ulysses white	2	8589934878
ulysses xylophone	1	4294967524
ulysses xylophone	2	8589935025
ulysses xylophone	3	12884902473
ulysses young	1	4294967427
ulysses young	2	8589934763
ulysses young	3	12884902154
victor allen	1	4294967450
victor allen	2	8589934776
victor brown	1	4294967521
victor brown	2	8589934864
victor brown	3	12884902170
victor brown	4	17179869625
victor davidson	1	4294967419
victor davidson	2	8589934720
victor davidson	3	12884902156
victor ellison	1	4294967362
victor ellison	2	8589934831
victor hernandez	1	4294967428
victor hernandez	2	8589934733
victor hernandez	3	12884902062
victor hernandez	4	17179869402
victor hernandez	5	21474836874
victor johnson	1	4294967496
victor johnson	2	8589934824
victor johnson	3	12884902246
victor king	1	4294967401
victor king	2	8589934884
victor laertes	1	4294967407
victor laertes	2	8589934862
victor miller	1	4294967410
victor nixon	1	4294967424
victor nixon	2	8589934803
victor ovid	1	4294967355
victor polk	1	4294967333
victor quirinius	1	4294967520
victor quirinius	2	8589934846
victor robinson	1	4294967440
victor robinson	2	8589934930
victor steinbeck	1	4294967390
victor steinbeck	2	8589934707
victor steinbeck	3	12884902037
victor thompson	1	4294967319
victor van buren	1	4294967365
victor van buren	2	8589934906
victor white	1	4294967403
victor white	2	8589934862
victor xylophone	1	4294967331
victor xylophone	2	8589934864
victor xylophone	3	12884902262
victor xylophone	4	17179869633
victor xylophone	5	21474837062
victor young	1	4294967337
victor zipper	1	4294967428
wendy allen	1	4294967473
wendy allen	2	8589934989
wendy allen	3	12884902367
wendy brown	1	4294967337
wendy brown	2	8589934817
wendy ellison	1	4294967475
wendy ellison	2	8589934989
wendy falkner	1	4294967313
wendy falkner	2	8589934810
wendy falkner	3	12884902236
wendy garcia	1	4294967394
wendy garcia	2	8589934775
wendy garcia	3	12884902088
wendy garcia	4	17179869400
wendy hernandez	1	4294967299
wendy ichabod	1	4294967516
wendy king	1	4294967420
wendy king	2	8589934811
wendy king	3	12884902252
wendy laertes	1	4294967519
wendy laertes	2	8589934939
wendy laertes	3	12884902315
wendy miller	1	4294967478
wendy miller	2	8589934957
wendy nixon	1	4294967407
wendy nixon	2	8589934901
wendy ovid	1	4294967464
wendy ovid	2	8589934894
wendy polk	1	4294967434
wendy polk	2	8589934824
wendy quirinius	1	4294967334
wendy quirinius	2	8589934782
wendy robinson	1	4294967302
wendy robinson	2	8589934613
wendy robinson	3	12884901977
wendy steinbeck	1	4294967444
wendy thompson	1	4294967301
wendy thompson	2	8589934621
wendy underhill	1	4294967540
wendy underhill	2	8589934993
wendy underhill	3	12884902410
wendy van buren	1	4294967488
wendy van buren	2	8589934835
wendy white	1	4294967490
wendy xylophone	1	4294967488
wendy xylophone	2	8589934939
wendy young	1	4294967395
wendy young	2	8589934708
xavier allen	1	4294967304
xavier allen	2	8589934743
xavier allen	3	12884902129
xavier brown	1	4294967546
xavier brown	2	8589935074
xavier brown	3	12884902532
xavier carson	1	4294967547
xavier carson	2	8589934862
xavier davidson	1	4294967361
xavier davidson	2	8589934760
xavier davidson	3	12884902204
xavier ellison	1	4294967441
xavier ellison	2	8589934914
xavier garcia	1	4294967465
xavier hernandez	1	4294967383
xavier hernandez	2	8589934743
xavier hernandez	3	12884902274
xavier ichabod	1	4294967511
xavier ichabod	2	8589934950
xavier johnson	1	4294967507
xavier johnson	2	8589934898
xavier king	1	4294967456
xavier king	2	8589934758
xavier laertes	1	4294967450
xavier ovid	1	4294967403
xavier polk	1	4294967506
xavier polk	2	8589934925
xavier polk	3	12884902406
xavier polk	4	17179869906
xavier quirinius	1	4294967383
xavier quirinius	2	8589934748
xavier quirinius	3	12884902060
xavier quirinius	4	17179869562
xavier thompson	1	4294967444
xavier underhill	1	4294967332
xavier white	1	4294967473
xavier white	2	8589934952
xavier xylophone	1	4294967499
xavier zipper	1	4294967547
yuri allen	1	4294967528
yuri allen	2	8589935079
yuri brown	1	4294967433
yuri brown	2	8589934960
yuri carson	1	4294967317
yuri carson	2	8589934851
yuri ellison	1	4294967299
yuri ellison	2	8589934697
yuri falkner	1	4294967368
yuri falkner	2	8589934891
yuri garcia	1	4294967362
yuri hernandez	1	4294967367
yuri johnson	1	4294967421
yuri johnson	2	8589934877
yuri johnson	3	12884902361
yuri king	1	4294967376
yuri laertes	1	4294967402
yuri laertes	2	8589934924
yuri nixon	1	4294967400
yuri nixon	2	8589934706
yuri polk	1	4294967391
yuri polk	2	8589934861
yuri polk	3	12884902167
yuri quirinius	1	4294967398
yuri quirinius	2	8589934768
yuri quirinius	3	12884902081
yuri steinbeck	1	4294967535
yuri steinbeck	2	8589934873
yuri thompson	1	4294967447
yuri underhill	1	4294967499
yuri underhill	2	8589934900
yuri white	1	4294967341
yuri xylophone	1	4294967420
zach allen	1	4294967507
zach brown	1	4294967316
zach brown	2	8589934728
zach brown	3	12884902099
zach brown	4	17179869452
zach brown	5	21474836769
zach carson	1	4294967463
zach ellison	1	4294967471
zach falkner	1	4294967362
zach falkner	2	8589934717
zach garcia	1	4294967481
zach garcia	2	8589934854
zach garcia	3	12884902240
zach garcia	4	17179869723
zach ichabod	1	4294967539
zach ichabod	2	8589934912
zach king	1	4294967424
zach king	2	8589934956
zach king	3	12884902458
zach miller	1	4294967442
zach miller	2	8589934772
zach miller	3	12884902163
zach ovid	1	4294967412
zach ovid	2	8589934775
zach ovid	3	12884902244
zach ovid	4	17179869574
zach quirinius	1	4294967299
zach robinson	1	4294967325
zach steinbeck	1	4294967469
zach steinbeck	2	8589934834
zach thompson	1	4294967405
zach thompson	2	8589934730
zach underhill	1	4294967496
zach white	1	4294967501
zach xylophone	1	4294967452
zach xylophone	2	8589934755
zach young	1	4294967297
zach zipper	1	4294967497
zach zipper	2	8589934855
zach zipper	3	12884902222
                
      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)