http://git-wip-us.apache.org/repos/asf/hive/blob/a0df0ace/ql/src/test/results/clientpositive/llap/vector_windowing_range_multiorder.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/llap/vector_windowing_range_multiorder.q.out b/ql/src/test/results/clientpositive/llap/vector_windowing_range_multiorder.q.out new file mode 100644 index 0000000..56c2cf0 --- /dev/null +++ b/ql/src/test/results/clientpositive/llap/vector_windowing_range_multiorder.q.out @@ -0,0 +1,12584 @@ +PREHOOK: query: drop table over10k +PREHOOK: type: DROPTABLE +POSTHOOK: query: drop table over10k +POSTHOOK: type: DROPTABLE +PREHOOK: query: create table over10k( + t tinyint, + si smallint, + i int, + b bigint, + f float, + d double, + bo boolean, + s string, + ts timestamp, + `dec` decimal(4,2), + bin binary) + row format delimited + fields terminated by '|' +PREHOOK: type: CREATETABLE +PREHOOK: Output: database:default +PREHOOK: Output: default@over10k +POSTHOOK: query: create table over10k( + t tinyint, + si smallint, + i int, + b bigint, + f float, + d double, + bo boolean, + s string, + ts timestamp, + `dec` decimal(4,2), + bin binary) + row format delimited + fields terminated by '|' +POSTHOOK: type: CREATETABLE +POSTHOOK: Output: database:default +POSTHOOK: Output: default@over10k +PREHOOK: query: load data local inpath '../../data/files/over10k' into table over10k +PREHOOK: type: LOAD +#### A masked pattern was here #### +PREHOOK: Output: default@over10k +POSTHOOK: query: load data local inpath '../../data/files/over10k' into table over10k +POSTHOOK: type: LOAD +#### A masked pattern was here #### +POSTHOOK: Output: default@over10k +PREHOOK: query: explain vectorization detail +select first_value(t) over ( partition by si order by i, b ) from over10k limit 100 +PREHOOK: type: QUERY +POSTHOOK: query: explain vectorization detail +select first_value(t) over ( partition by si order by i, b ) from over10k limit 100 +POSTHOOK: type: QUERY +Explain +PLAN VECTORIZATION: + enabled: true + enabledConditionsMet: [hive.vectorized.execution.enabled IS true] + +STAGE DEPENDENCIES: + Stage-1 is a root stage + Stage-0 depends on stages: Stage-1 + +STAGE PLANS: + Stage: Stage-1 + Tez +#### A masked pattern was here #### + Edges: + Reducer 2 <- Map 1 (SIMPLE_EDGE) +#### A masked pattern was here #### + Vertices: + Map 1 + Map Operator Tree: + TableScan + alias: over10k + Statistics: Num rows: 50877 Data size: 1017544 Basic stats: COMPLETE Column stats: NONE + TableScan Vectorization: + native: true + projectedOutputColumns: [0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10] + Reduce Output Operator + key expressions: si (type: smallint), i (type: int), b (type: bigint) + sort order: +++ + Map-reduce partition columns: si (type: smallint) + Reduce Sink Vectorization: + className: VectorReduceSinkObjectHashOperator + keyColumns: [1, 2, 3] + native: true + nativeConditionsMet: hive.vectorized.execution.reducesink.new.enabled IS true, hive.execution.engine tez IN [tez, spark] IS true, No PTF TopN IS true, No DISTINCT columns IS true, BinarySortableSerDe for keys IS true, LazyBinarySerDe for values IS true + partitionColumns: [1] + valueColumns: [0] + Statistics: Num rows: 50877 Data size: 1017544 Basic stats: COMPLETE Column stats: NONE + value expressions: t (type: tinyint) + Execution mode: vectorized, llap + LLAP IO: no inputs + Map Vectorization: + enabled: true + enabledConditionsMet: hive.vectorized.use.vector.serde.deserialize IS true + groupByVectorOutput: true + inputFileFormats: org.apache.hadoop.mapred.TextInputFormat + allNative: true + usesVectorUDFAdaptor: false + vectorized: true + rowBatchContext: + dataColumnCount: 11 + includeColumns: [0, 1, 2, 3] + dataColumns: t:tinyint, si:smallint, i:int, b:bigint, f:float, d:double, bo:boolean, s:string, ts:timestamp, dec:decimal(4,2), bin:binary + partitionColumnCount: 0 + Reducer 2 + Execution mode: vectorized, llap + Reduce Vectorization: + enabled: true + enableConditionsMet: hive.vectorized.execution.reduce.enabled IS true, hive.execution.engine tez IN [tez, spark] IS true + reduceColumnNullOrder: aaa + reduceColumnSortOrder: +++ + groupByVectorOutput: true + allNative: false + usesVectorUDFAdaptor: false + vectorized: true + rowBatchContext: + dataColumnCount: 4 + dataColumns: KEY.reducesinkkey0:smallint, KEY.reducesinkkey1:int, KEY.reducesinkkey2:bigint, VALUE._col0:tinyint + partitionColumnCount: 0 + scratchColumnTypeNames: bigint + Reduce Operator Tree: + Select Operator + expressions: VALUE._col0 (type: tinyint), KEY.reducesinkkey0 (type: smallint), KEY.reducesinkkey1 (type: int), KEY.reducesinkkey2 (type: bigint) + outputColumnNames: _col0, _col1, _col2, _col3 + Select Vectorization: + className: VectorSelectOperator + native: true + projectedOutputColumns: [3, 0, 1, 2] + Statistics: Num rows: 50877 Data size: 1017544 Basic stats: COMPLETE Column stats: NONE + PTF Operator + Function definitions: + Input definition + input alias: ptf_0 + output shape: _col0: tinyint, _col1: smallint, _col2: int, _col3: bigint + type: WINDOWING + Windowing table definition + input alias: ptf_1 + name: windowingtablefunction + order by: _col2 ASC NULLS FIRST, _col3 ASC NULLS FIRST + partition by: _col1 + raw input shape: + window functions: + window function definition + alias: first_value_window_0 + arguments: _col0 + name: first_value + window function: GenericUDAFFirstValueEvaluator + window frame: RANGE PRECEDING(MAX)~CURRENT + PTF Vectorization: + className: VectorPTFOperator + evaluatorClasses: [VectorPTFEvaluatorLongFirstValue] + functionInputExpressions: [col 3] + functionNames: [first_value] + keyInputColumns: [0, 1, 2] + native: true + nonKeyInputColumns: [3] + orderExpressions: [col 1, col 2] + outputColumns: [4, 3, 0, 1, 2] + outputTypes: [tinyint, tinyint, smallint, int, bigint] + partitionExpressions: [col 0] + streamingColumns: [4] + Statistics: Num rows: 50877 Data size: 1017544 Basic stats: COMPLETE Column stats: NONE + Select Operator + expressions: first_value_window_0 (type: tinyint) + outputColumnNames: _col0 + Select Vectorization: + className: VectorSelectOperator + native: true + projectedOutputColumns: [4] + Statistics: Num rows: 50877 Data size: 1017544 Basic stats: COMPLETE Column stats: NONE + Limit + Number of rows: 100 + Limit Vectorization: + className: VectorLimitOperator + native: true + Statistics: Num rows: 100 Data size: 2000 Basic stats: COMPLETE Column stats: NONE + File Output Operator + compressed: false + File Sink Vectorization: + className: VectorFileSinkOperator + native: false + Statistics: Num rows: 100 Data size: 2000 Basic stats: COMPLETE Column stats: NONE + table: + input format: org.apache.hadoop.mapred.SequenceFileInputFormat + output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat + serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe + + Stage: Stage-0 + Fetch Operator + limit: 100 + Processor Tree: + ListSink + +PREHOOK: query: select first_value(t) over ( partition by si order by i, b ) from over10k limit 100 +PREHOOK: type: QUERY +PREHOOK: Input: default@over10k +#### A masked pattern was here #### +POSTHOOK: query: select first_value(t) over ( partition by si order by i, b ) from over10k limit 100 +POSTHOOK: type: QUERY +POSTHOOK: Input: default@over10k +#### A masked pattern was here #### +first_value_window_0 +51 +51 +51 +51 +51 +51 +51 +51 +51 +51 +51 +51 +51 +51 +51 +51 +51 +51 +51 +51 +51 +51 +51 +51 +51 +51 +51 +51 +51 +51 +51 +51 +51 +51 +51 +51 +51 +48 +48 +48 +48 +48 +48 +48 +48 +48 +48 +48 +48 +48 +48 +48 +48 +48 +48 +48 +48 +48 +48 +48 +48 +48 +48 +48 +48 +48 +48 +48 +48 +48 +48 +48 +48 +48 +48 +48 +48 +47 +47 +47 +47 +47 +47 +47 +47 +47 +47 +47 +47 +47 +47 +47 +47 +47 +47 +47 +47 +47 +47 +47 +PREHOOK: query: explain vectorization detail +select last_value(i) over (partition by si, bo order by i, f desc range current row) from over10k limit 100 +PREHOOK: type: QUERY +POSTHOOK: query: explain vectorization detail +select last_value(i) over (partition by si, bo order by i, f desc range current row) from over10k limit 100 +POSTHOOK: type: QUERY +Explain +PLAN VECTORIZATION: + enabled: true + enabledConditionsMet: [hive.vectorized.execution.enabled IS true] + +STAGE DEPENDENCIES: + Stage-1 is a root stage + Stage-0 depends on stages: Stage-1 + +STAGE PLANS: + Stage: Stage-1 + Tez +#### A masked pattern was here #### + Edges: + Reducer 2 <- Map 1 (SIMPLE_EDGE) +#### A masked pattern was here #### + Vertices: + Map 1 + Map Operator Tree: + TableScan + alias: over10k + Statistics: Num rows: 63596 Data size: 1017544 Basic stats: COMPLETE Column stats: NONE + TableScan Vectorization: + native: true + projectedOutputColumns: [0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10] + Reduce Output Operator + key expressions: si (type: smallint), bo (type: boolean), i (type: int), f (type: float) + sort order: +++- + Map-reduce partition columns: si (type: smallint), bo (type: boolean) + Reduce Sink Vectorization: + className: VectorReduceSinkObjectHashOperator + keyColumns: [1, 6, 2, 4] + native: true + nativeConditionsMet: hive.vectorized.execution.reducesink.new.enabled IS true, hive.execution.engine tez IN [tez, spark] IS true, No PTF TopN IS true, No DISTINCT columns IS true, BinarySortableSerDe for keys IS true, LazyBinarySerDe for values IS true + partitionColumns: [1, 6] + valueColumns: [] + Statistics: Num rows: 63596 Data size: 1017544 Basic stats: COMPLETE Column stats: NONE + Execution mode: vectorized, llap + LLAP IO: no inputs + Map Vectorization: + enabled: true + enabledConditionsMet: hive.vectorized.use.vector.serde.deserialize IS true + groupByVectorOutput: true + inputFileFormats: org.apache.hadoop.mapred.TextInputFormat + allNative: true + usesVectorUDFAdaptor: false + vectorized: true + rowBatchContext: + dataColumnCount: 11 + includeColumns: [1, 2, 4, 6] + dataColumns: t:tinyint, si:smallint, i:int, b:bigint, f:float, d:double, bo:boolean, s:string, ts:timestamp, dec:decimal(4,2), bin:binary + partitionColumnCount: 0 + Reducer 2 + Execution mode: llap + Reduce Vectorization: + enabled: true + enableConditionsMet: hive.vectorized.execution.reduce.enabled IS true, hive.execution.engine tez IN [tez, spark] IS true + notVectorizedReason: PTF operator: last_value only UNBOUNDED start frame is supported + vectorized: false + Reduce Operator Tree: + Select Operator + expressions: KEY.reducesinkkey0 (type: smallint), KEY.reducesinkkey2 (type: int), KEY.reducesinkkey3 (type: float), KEY.reducesinkkey1 (type: boolean) + outputColumnNames: _col1, _col2, _col4, _col6 + Statistics: Num rows: 63596 Data size: 1017544 Basic stats: COMPLETE Column stats: NONE + PTF Operator + Function definitions: + Input definition + input alias: ptf_0 + output shape: _col1: smallint, _col2: int, _col4: float, _col6: boolean + type: WINDOWING + Windowing table definition + input alias: ptf_1 + name: windowingtablefunction + order by: _col2 ASC NULLS FIRST, _col4 DESC NULLS LAST + partition by: _col1, _col6 + raw input shape: + window functions: + window function definition + alias: last_value_window_0 + arguments: _col2 + name: last_value + window function: GenericUDAFLastValueEvaluator + window frame: RANGE CURRENT~CURRENT + Statistics: Num rows: 63596 Data size: 1017544 Basic stats: COMPLETE Column stats: NONE + Select Operator + expressions: last_value_window_0 (type: int) + outputColumnNames: _col0 + Statistics: Num rows: 63596 Data size: 1017544 Basic stats: COMPLETE Column stats: NONE + Limit + Number of rows: 100 + Statistics: Num rows: 100 Data size: 1600 Basic stats: COMPLETE Column stats: NONE + File Output Operator + compressed: false + Statistics: Num rows: 100 Data size: 1600 Basic stats: COMPLETE Column stats: NONE + table: + input format: org.apache.hadoop.mapred.SequenceFileInputFormat + output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat + serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe + + Stage: Stage-0 + Fetch Operator + limit: 100 + Processor Tree: + ListSink + +PREHOOK: query: select last_value(i) over (partition by si, bo order by i, f desc range current row) from over10k limit 100 +PREHOOK: type: QUERY +PREHOOK: Input: default@over10k +#### A masked pattern was here #### +POSTHOOK: query: select last_value(i) over (partition by si, bo order by i, f desc range current row) from over10k limit 100 +POSTHOOK: type: QUERY +POSTHOOK: Input: default@over10k +#### A masked pattern was here #### +last_value_window_0 +65543 +65549 +65558 +65580 +65586 +65596 +65616 +65620 +65627 +65640 +65643 +65706 +65713 +65737 +65744 +65752 +65778 +65540 +65563 +65599 +65604 +65613 +65613 +65615 +65651 +65653 +65668 +65693 +65731 +65733 +65738 +65741 +65744 +65747 +65763 +65778 +65789 +65541 +65547 +65560 +65572 +65574 +65575 +65578 +65588 +65594 +65610 +65691 +65694 +65711 +65719 +65722 +65738 +65756 +65790 +65542 +65557 +65566 +65584 +65610 +65612 +65626 +65631 +65638 +65654 +65654 +65655 +65699 +65712 +65720 +65732 +65748 +65752 +65771 +65771 +65771 +65781 +65565 +65569 +65573 +65582 +65584 +65606 +65656 +65669 +65717 +65724 +65728 +65761 +65762 +65770 +65771 +65781 +65546 +65551 +65551 +65568 +65568 +65579 +65603 +PREHOOK: query: explain vectorization detail +select row_number() over (partition by si, bo order by i, f desc range between unbounded preceding and unbounded following) from over10k limit 100 +PREHOOK: type: QUERY +POSTHOOK: query: explain vectorization detail +select row_number() over (partition by si, bo order by i, f desc range between unbounded preceding and unbounded following) from over10k limit 100 +POSTHOOK: type: QUERY +Explain +PLAN VECTORIZATION: + enabled: true + enabledConditionsMet: [hive.vectorized.execution.enabled IS true] + +STAGE DEPENDENCIES: + Stage-1 is a root stage + Stage-0 depends on stages: Stage-1 + +STAGE PLANS: + Stage: Stage-1 + Tez +#### A masked pattern was here #### + Edges: + Reducer 2 <- Map 1 (SIMPLE_EDGE) +#### A masked pattern was here #### + Vertices: + Map 1 + Map Operator Tree: + TableScan + alias: over10k + Statistics: Num rows: 63596 Data size: 1017544 Basic stats: COMPLETE Column stats: NONE + TableScan Vectorization: + native: true + projectedOutputColumns: [0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10] + Reduce Output Operator + key expressions: si (type: smallint), bo (type: boolean), i (type: int), f (type: float) + sort order: +++- + Map-reduce partition columns: si (type: smallint), bo (type: boolean) + Reduce Sink Vectorization: + className: VectorReduceSinkObjectHashOperator + keyColumns: [1, 6, 2, 4] + native: true + nativeConditionsMet: hive.vectorized.execution.reducesink.new.enabled IS true, hive.execution.engine tez IN [tez, spark] IS true, No PTF TopN IS true, No DISTINCT columns IS true, BinarySortableSerDe for keys IS true, LazyBinarySerDe for values IS true + partitionColumns: [1, 6] + valueColumns: [] + Statistics: Num rows: 63596 Data size: 1017544 Basic stats: COMPLETE Column stats: NONE + Execution mode: vectorized, llap + LLAP IO: no inputs + Map Vectorization: + enabled: true + enabledConditionsMet: hive.vectorized.use.vector.serde.deserialize IS true + groupByVectorOutput: true + inputFileFormats: org.apache.hadoop.mapred.TextInputFormat + allNative: true + usesVectorUDFAdaptor: false + vectorized: true + rowBatchContext: + dataColumnCount: 11 + includeColumns: [1, 2, 4, 6] + dataColumns: t:tinyint, si:smallint, i:int, b:bigint, f:float, d:double, bo:boolean, s:string, ts:timestamp, dec:decimal(4,2), bin:binary + partitionColumnCount: 0 + Reducer 2 + Execution mode: llap + Reduce Vectorization: + enabled: true + enableConditionsMet: hive.vectorized.execution.reduce.enabled IS true, hive.execution.engine tez IN [tez, spark] IS true + notVectorizedReason: PTF operator: row_number only CURRENT ROW end frame is supported for RANGE + vectorized: false + Reduce Operator Tree: + Select Operator + expressions: KEY.reducesinkkey0 (type: smallint), KEY.reducesinkkey2 (type: int), KEY.reducesinkkey3 (type: float), KEY.reducesinkkey1 (type: boolean) + outputColumnNames: _col1, _col2, _col4, _col6 + Statistics: Num rows: 63596 Data size: 1017544 Basic stats: COMPLETE Column stats: NONE + PTF Operator + Function definitions: + Input definition + input alias: ptf_0 + output shape: _col1: smallint, _col2: int, _col4: float, _col6: boolean + type: WINDOWING + Windowing table definition + input alias: ptf_1 + name: windowingtablefunction + order by: _col2 ASC NULLS FIRST, _col4 DESC NULLS LAST + partition by: _col1, _col6 + raw input shape: + window functions: + window function definition + alias: row_number_window_0 + name: row_number + window function: GenericUDAFRowNumberEvaluator + window frame: RANGE PRECEDING(MAX)~FOLLOWING(MAX) + isPivotResult: true + Statistics: Num rows: 63596 Data size: 1017544 Basic stats: COMPLETE Column stats: NONE + Select Operator + expressions: row_number_window_0 (type: int) + outputColumnNames: _col0 + Statistics: Num rows: 63596 Data size: 1017544 Basic stats: COMPLETE Column stats: NONE + Limit + Number of rows: 100 + Statistics: Num rows: 100 Data size: 1600 Basic stats: COMPLETE Column stats: NONE + File Output Operator + compressed: false + Statistics: Num rows: 100 Data size: 1600 Basic stats: COMPLETE Column stats: NONE + table: + input format: org.apache.hadoop.mapred.SequenceFileInputFormat + output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat + serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe + + Stage: Stage-0 + Fetch Operator + limit: 100 + Processor Tree: + ListSink + +PREHOOK: query: select row_number() over (partition by si, bo order by i, f desc range between unbounded preceding and unbounded following) from over10k limit 100 +PREHOOK: type: QUERY +PREHOOK: Input: default@over10k +#### A masked pattern was here #### +POSTHOOK: query: select row_number() over (partition by si, bo order by i, f desc range between unbounded preceding and unbounded following) from over10k limit 100 +POSTHOOK: type: QUERY +POSTHOOK: Input: default@over10k +#### A masked pattern was here #### +row_number_window_0 +1 +2 +3 +4 +5 +6 +7 +8 +9 +10 +11 +12 +13 +14 +15 +16 +17 +1 +2 +3 +4 +5 +6 +7 +8 +9 +10 +11 +12 +13 +14 +15 +16 +17 +18 +19 +20 +1 +2 +3 +4 +5 +6 +7 +8 +9 +10 +11 +12 +13 +14 +15 +16 +17 +18 +1 +2 +3 +4 +5 +6 +7 +8 +9 +10 +11 +12 +13 +14 +15 +16 +17 +18 +19 +20 +21 +22 +1 +2 +3 +4 +5 +6 +7 +8 +9 +10 +11 +12 +13 +14 +15 +16 +1 +2 +3 +4 +5 +6 +7 +PREHOOK: query: explain vectorization detail +select s, si, i, avg(i) over (partition by s range between unbounded preceding and current row) from over10k +PREHOOK: type: QUERY +POSTHOOK: query: explain vectorization detail +select s, si, i, avg(i) over (partition by s range between unbounded preceding and current row) from over10k +POSTHOOK: type: QUERY +Explain +PLAN VECTORIZATION: + enabled: true + enabledConditionsMet: [hive.vectorized.execution.enabled IS true] + +STAGE DEPENDENCIES: + Stage-1 is a root stage + Stage-0 depends on stages: Stage-1 + +STAGE PLANS: + Stage: Stage-1 + Tez +#### A masked pattern was here #### + Edges: + Reducer 2 <- Map 1 (SIMPLE_EDGE) +#### A masked pattern was here #### + Vertices: + Map 1 + Map Operator Tree: + TableScan + alias: over10k + Statistics: Num rows: 9421 Data size: 1017544 Basic stats: COMPLETE Column stats: NONE + TableScan Vectorization: + native: true + projectedOutputColumns: [0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10] + Reduce Output Operator + key expressions: s (type: string) + sort order: + + Map-reduce partition columns: s (type: string) + Reduce Sink Vectorization: + className: VectorReduceSinkStringOperator + keyColumns: [7] + native: true + nativeConditionsMet: hive.vectorized.execution.reducesink.new.enabled IS true, hive.execution.engine tez IN [tez, spark] IS true, No PTF TopN IS true, No DISTINCT columns IS true, BinarySortableSerDe for keys IS true, LazyBinarySerDe for values IS true + valueColumns: [1, 2] + Statistics: Num rows: 9421 Data size: 1017544 Basic stats: COMPLETE Column stats: NONE + value expressions: si (type: smallint), i (type: int) + Execution mode: vectorized, llap + LLAP IO: no inputs + Map Vectorization: + enabled: true + enabledConditionsMet: hive.vectorized.use.vector.serde.deserialize IS true + groupByVectorOutput: true + inputFileFormats: org.apache.hadoop.mapred.TextInputFormat + allNative: true + usesVectorUDFAdaptor: false + vectorized: true + rowBatchContext: + dataColumnCount: 11 + includeColumns: [1, 2, 7] + dataColumns: t:tinyint, si:smallint, i:int, b:bigint, f:float, d:double, bo:boolean, s:string, ts:timestamp, dec:decimal(4,2), bin:binary + partitionColumnCount: 0 + Reducer 2 + Execution mode: vectorized, llap + Reduce Vectorization: + enabled: true + enableConditionsMet: hive.vectorized.execution.reduce.enabled IS true, hive.execution.engine tez IN [tez, spark] IS true + reduceColumnNullOrder: a + reduceColumnSortOrder: + + groupByVectorOutput: true + allNative: false + usesVectorUDFAdaptor: false + vectorized: true + rowBatchContext: + dataColumnCount: 3 + dataColumns: KEY.reducesinkkey0:string, VALUE._col1:smallint, VALUE._col2:int + partitionColumnCount: 0 + scratchColumnTypeNames: double + Reduce Operator Tree: + Select Operator + expressions: VALUE._col1 (type: smallint), VALUE._col2 (type: int), KEY.reducesinkkey0 (type: string) + outputColumnNames: _col1, _col2, _col7 + Select Vectorization: + className: VectorSelectOperator + native: true + projectedOutputColumns: [1, 2, 0] + Statistics: Num rows: 9421 Data size: 1017544 Basic stats: COMPLETE Column stats: NONE + PTF Operator + Function definitions: + Input definition + input alias: ptf_0 + output shape: _col1: smallint, _col2: int, _col7: string + type: WINDOWING + Windowing table definition + input alias: ptf_1 + name: windowingtablefunction + order by: _col7 ASC NULLS FIRST + partition by: _col7 + raw input shape: + window functions: + window function definition + alias: avg_window_0 + arguments: _col2 + name: avg + window function: GenericUDAFAverageEvaluatorDouble + window frame: RANGE PRECEDING(MAX)~CURRENT + PTF Vectorization: + className: VectorPTFOperator + evaluatorClasses: [VectorPTFEvaluatorLongAvg] + functionInputExpressions: [col 2] + functionNames: [avg] + keyInputColumns: [0] + native: true + nonKeyInputColumns: [1, 2] + orderExpressions: [col 0] + outputColumns: [3, 1, 2, 0] + outputTypes: [double, smallint, int, string] + streamingColumns: [] + Statistics: Num rows: 9421 Data size: 1017544 Basic stats: COMPLETE Column stats: NONE + Select Operator + expressions: _col7 (type: string), _col1 (type: smallint), _col2 (type: int), avg_window_0 (type: double) + outputColumnNames: _col0, _col1, _col2, _col3 + Select Vectorization: + className: VectorSelectOperator + native: true + projectedOutputColumns: [0, 1, 2, 3] + Statistics: Num rows: 9421 Data size: 1017544 Basic stats: COMPLETE Column stats: NONE + File Output Operator + compressed: false + File Sink Vectorization: + className: VectorFileSinkOperator + native: false + Statistics: Num rows: 9421 Data size: 1017544 Basic stats: COMPLETE Column stats: NONE + table: + input format: org.apache.hadoop.mapred.SequenceFileInputFormat + output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat + serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe + + Stage: Stage-0 + Fetch Operator + limit: -1 + Processor Tree: + ListSink + +PREHOOK: query: select s, si, i, avg(i) over (partition by s range between unbounded preceding and current row) from over10k +PREHOOK: type: QUERY +PREHOOK: Input: default@over10k +#### A masked pattern was here #### +POSTHOOK: query: select s, si, i, avg(i) over (partition by s range between unbounded preceding and current row) from over10k +POSTHOOK: type: QUERY +POSTHOOK: Input: default@over10k +#### A masked pattern was here #### +s si i avg_window_0 +alice falkner 323 65669 65695.76470588235 +alice falkner 477 65722 65695.76470588235 +alice falkner 455 65718 65695.76470588235 +alice falkner 481 65709 65695.76470588235 +alice falkner 345 65773 65695.76470588235 +alice falkner 280 65597 65695.76470588235 +alice falkner 500 65775 65695.76470588235 +alice falkner 339 65785 65695.76470588235 +alice falkner 452 65596 65695.76470588235 +alice falkner 382 65690 65695.76470588235 +alice falkner 382 65622 65695.76470588235 +alice falkner 393 65611 65695.76470588235 +alice falkner 393 65685 65695.76470588235 +alice falkner 342 65752 65695.76470588235 +alice falkner 311 65715 65695.76470588235 +alice falkner 371 65710 65695.76470588235 +alice falkner 389 65699 65695.76470588235 +alice ichabod 366 65590 65654.95454545454 +alice ichabod 458 65550 65654.95454545454 +alice ichabod 436 65738 65654.95454545454 +alice ichabod 315 65772 65654.95454545454 +alice ichabod 453 65780 65654.95454545454 +alice ichabod 347 65547 65654.95454545454 +alice ichabod 398 65659 65654.95454545454 +alice ichabod 338 65538 65654.95454545454 +alice ichabod 440 65725 65654.95454545454 +alice ichabod 320 65622 65654.95454545454 +alice ichabod 412 65718 65654.95454545454 +alice ichabod 305 65617 65654.95454545454 +alice ichabod 292 65585 65654.95454545454 +alice ichabod 303 65692 65654.95454545454 +alice ichabod 338 65545 65654.95454545454 +alice ichabod 398 65680 65654.95454545454 +alice ichabod 416 65536 65654.95454545454 +alice ichabod 344 65545 65654.95454545454 +alice ichabod 300 65704 65654.95454545454 +alice ichabod 292 65788 65654.95454545454 +alice ichabod 398 65785 65654.95454545454 +alice ichabod 301 65693 65654.95454545454 +alice polk 443 65734 65661.57142857143 +alice polk 444 65564 65661.57142857143 +alice polk 357 65550 65661.57142857143 +alice polk 321 65744 65661.57142857143 +alice polk 273 65548 65661.57142857143 +alice polk 366 65595 65661.57142857143 +alice polk 285 65761 65661.57142857143 +alice polk 466 65561 65661.57142857143 +alice polk 324 65749 65661.57142857143 +alice polk 487 65746 65661.57142857143 +alice polk 378 65598 65661.57142857143 +alice polk 395 65751 65661.57142857143 +alice polk 407 65617 65661.57142857143 +alice polk 507 65744 65661.57142857143 +alice young 468 65649 65706.63636363637 +alice young 489 65646 65706.63636363637 +alice young 286 65705 65706.63636363637 +alice young 447 65789 65706.63636363637 +alice young 425 65677 65706.63636363637 +alice young 282 65671 65706.63636363637 +alice young 351 65776 65706.63636363637 +alice young 308 65776 65706.63636363637 +alice young 314 65791 65706.63636363637 +alice young 419 65735 65706.63636363637 +alice young 383 65558 65706.63636363637 +bob falkner 394 65648 65674.17647058824 +bob falkner 414 65587 65674.17647058824 +bob falkner 389 65738 65674.17647058824 +bob falkner 302 65711 65674.17647058824 +bob falkner 390 65556 65674.17647058824 +bob falkner 357 65566 65674.17647058824 +bob falkner 264 65693 65674.17647058824 +bob falkner 329 65720 65674.17647058824 +bob falkner 317 65624 65674.17647058824 +bob falkner 258 65551 65674.17647058824 +bob falkner 410 65749 65674.17647058824 +bob falkner 330 65727 65674.17647058824 +bob falkner 474 65734 65674.17647058824 +bob falkner 260 65595 65674.17647058824 +bob falkner 459 65746 65674.17647058824 +bob falkner 406 65727 65674.17647058824 +bob falkner 291 65789 65674.17647058824 +bob garcia 422 65655 65675.86666666667 +bob garcia 279 65754 65675.86666666667 +bob garcia 466 65673 65675.86666666667 +bob garcia 416 65582 65675.86666666667 +bob garcia 418 65598 65675.86666666667 +bob garcia 344 65738 65675.86666666667 +bob garcia 320 65585 65675.86666666667 +bob garcia 315 65782 65675.86666666667 +bob garcia 444 65789 65675.86666666667 +bob garcia 354 65687 65675.86666666667 +bob garcia 480 65567 65675.86666666667 +bob garcia 332 65642 65675.86666666667 +bob garcia 361 65737 65675.86666666667 +bob garcia 398 65697 65675.86666666667 +bob garcia 421 65652 65675.86666666667 +bob laertes 423 65663 65671.23529411765 +bob laertes 303 65646 65671.23529411765 +bob laertes 429 65591 65671.23529411765 +bob laertes 446 65602 65671.23529411765 +bob laertes 341 65554 65671.23529411765 +bob laertes 267 65646 65671.23529411765 +bob laertes 376 65602 65671.23529411765 +bob laertes 362 65667 65671.23529411765 +bob laertes 285 65567 65671.23529411765 +bob laertes 437 65729 65671.23529411765 +bob laertes 487 65720 65671.23529411765 +bob laertes 406 65773 65671.23529411765 +bob laertes 405 65752 65671.23529411765 +bob laertes 406 65726 65671.23529411765 +bob laertes 456 65650 65671.23529411765 +bob laertes 440 65751 65671.23529411765 +bob laertes 482 65772 65671.23529411765 +bob polk 434 65731 65660.4 +bob polk 264 65776 65660.4 +bob polk 420 65599 65660.4 +bob polk 433 65767 65660.4 +bob polk 325 65594 65660.4 +bob polk 310 65599 65660.4 +bob polk 316 65778 65660.4 +bob polk 436 65569 65660.4 +bob polk 511 65582 65660.4 +bob polk 423 65609 65660.4 +bob young 317 65758 65684.17647058824 +bob young 263 65778 65684.17647058824 +bob young 415 65635 65684.17647058824 +bob young 468 65654 65684.17647058824 +bob young 488 65668 65684.17647058824 +bob young 410 65758 65684.17647058824 +bob young 348 65556 65684.17647058824 +bob young 494 65629 65684.17647058824 +bob young 504 65694 65684.17647058824 +bob young 453 65735 65684.17647058824 +bob young 448 65726 65684.17647058824 +bob young 321 65727 65684.17647058824 +bob young 288 65599 65684.17647058824 +bob young 459 65727 65684.17647058824 +bob young 349 65777 65684.17647058824 +bob young 449 65589 65684.17647058824 +bob young 299 65621 65684.17647058824 +calvin allen 351 65701 65671.81818181818 +calvin allen 466 65747 65671.81818181818 +calvin allen 360 65575 65671.81818181818 +calvin allen 443 65681 65671.81818181818 +calvin allen 499 65665 65671.81818181818 +calvin allen 479 65751 65671.81818181818 +calvin allen 432 65669 65671.81818181818 +calvin allen 309 65538 65671.81818181818 +calvin allen 276 65661 65671.81818181818 +calvin allen 437 65726 65671.81818181818 +calvin allen 326 65676 65671.81818181818 +calvin carson 447 65546 65651.94117647059 +calvin carson 464 65543 65651.94117647059 +calvin carson 341 65697 65651.94117647059 +calvin carson 344 65557 65651.94117647059 +calvin carson 507 65595 65651.94117647059 +calvin carson 295 65663 65651.94117647059 +calvin carson 435 65637 65651.94117647059 +calvin carson 389 65682 65651.94117647059 +calvin carson 401 65613 65651.94117647059 +calvin carson 450 65688 65651.94117647059 +calvin carson 440 65778 65651.94117647059 +calvin carson 264 65614 65651.94117647059 +calvin carson 310 65686 65651.94117647059 +calvin carson 397 65668 65651.94117647059 +calvin carson 373 65728 65651.94117647059 +calvin carson 440 65781 65651.94117647059 +calvin carson 333 65607 65651.94117647059 +calvin davidson 264 65564 65671.71428571429 +calvin davidson 258 65780 65671.71428571429 +calvin davidson 309 65689 65671.71428571429 +calvin davidson 506 65632 65671.71428571429 +calvin davidson 466 65541 65671.71428571429 +calvin davidson 337 65547 65671.71428571429 +calvin davidson 478 65775 65671.71428571429 +calvin davidson 360 65771 65671.71428571429 +calvin davidson 347 65578 65671.71428571429 +calvin davidson 468 65583 65671.71428571429 +calvin davidson 411 65772 65671.71428571429 +calvin davidson 427 65704 65671.71428571429 +calvin davidson 389 65752 65671.71428571429 +calvin davidson 301 65716 65671.71428571429 +calvin hernandez 507 65779 65690.94117647059 +calvin hernandez 283 65788 65690.94117647059 +calvin hernandez 345 65765 65690.94117647059 +calvin hernandez 369 65546 65690.94117647059 +calvin hernandez 288 65578 65690.94117647059 +calvin hernandez 376 65665 65690.94117647059 +calvin hernandez 422 65589 65690.94117647059 +calvin hernandez 460 65688 65690.94117647059 +calvin hernandez 464 65716 65690.94117647059 +calvin hernandez 372 65728 65690.94117647059 +calvin hernandez 313 65687 65690.94117647059 +calvin hernandez 415 65785 65690.94117647059 +calvin hernandez 506 65745 65690.94117647059 +calvin hernandez 313 65672 65690.94117647059 +calvin hernandez 446 65588 65690.94117647059 +calvin hernandez 443 65706 65690.94117647059 +calvin hernandez 434 65721 65690.94117647059 +calvin ichabod 385 65713 65691.76923076923 +calvin ichabod 273 65760 65691.76923076923 +calvin ichabod 324 65721 65691.76923076923 +calvin ichabod 505 65643 65691.76923076923 +calvin ichabod 467 65687 65691.76923076923 +calvin ichabod 431 65635 65691.76923076923 +calvin ichabod 322 65543 65691.76923076923 +calvin ichabod 271 65619 65691.76923076923 +calvin ichabod 268 65720 65691.76923076923 +calvin ichabod 497 65778 65691.76923076923 +calvin ichabod 432 65759 65691.76923076923 +calvin ichabod 317 65671 65691.76923076923 +calvin ichabod 453 65744 65691.76923076923 +calvin king 311 65777 65684.35294117648 +calvin king 443 65624 65684.35294117648 +calvin king 344 65605 65684.35294117648 +calvin king 400 65624 65684.35294117648 +calvin king 290 65670 65684.35294117648 +calvin king 280 65596 65684.35294117648 +calvin king 328 65684 65684.35294117648 +calvin king 423 65751 65684.35294117648 +calvin king 424 65756 65684.35294117648 +calvin king 263 65725 65684.35294117648 +calvin king 348 65645 65684.35294117648 +calvin king 443 65724 65684.35294117648 +calvin king 372 65556 65684.35294117648 +calvin king 275 65692 65684.35294117648 +calvin king 503 65724 65684.35294117648 +calvin king 467 65708 65684.35294117648 +calvin king 467 65773 65684.35294117648 +calvin steinbeck 325 65575 65666.93333333333 +calvin steinbeck 432 65692 65666.93333333333 +calvin steinbeck 400 65740 65666.93333333333 +calvin steinbeck 429 65777 65666.93333333333 +calvin steinbeck 273 65779 65666.93333333333 +calvin steinbeck 355 65548 65666.93333333333 +calvin steinbeck 306 65667 65666.93333333333 +calvin steinbeck 323 65612 65666.93333333333 +calvin steinbeck 476 65563 65666.93333333333 +calvin steinbeck 477 65680 65666.93333333333 +calvin steinbeck 479 65649 65666.93333333333 +calvin steinbeck 381 65687 65666.93333333333 +calvin steinbeck 467 65658 65666.93333333333 +calvin steinbeck 282 65615 65666.93333333333 +calvin steinbeck 258 65762 65666.93333333333 +calvin van buren 501 65782 65685.86666666667 +calvin van buren 329 65684 65685.86666666667 +calvin van buren 486 65588 65685.86666666667 +calvin van buren 430 65729 65685.86666666667 +calvin van buren 352 65752 65685.86666666667 +calvin van buren 296 65738 65685.86666666667 +calvin van buren 426 65664 65685.86666666667 +calvin van buren 363 65745 65685.86666666667 +calvin van buren 417 65717 65685.86666666667 +calvin van buren 313 65678 65685.86666666667 +calvin van buren 411 65574 65685.86666666667 +calvin van buren 447 65557 65685.86666666667 +calvin van buren 420 65771 65685.86666666667 +calvin van buren 417 65552 65685.86666666667 +calvin van buren 474 65757 65685.86666666667 +calvin xylophone 507 65699 65674.27777777778 +calvin xylophone 407 65740 65674.27777777778 +calvin xylophone 491 65727 65674.27777777778 +calvin xylophone 313 65726 65674.27777777778 +calvin xylophone 260 65621 65674.27777777778 +calvin xylophone 457 65722 65674.27777777778 +calvin xylophone 318 65742 65674.27777777778 +calvin xylophone 305 65767 65674.27777777778 +calvin xylophone 433 65624 65674.27777777778 +calvin xylophone 483 65713 65674.27777777778 +calvin xylophone 322 65645 65674.27777777778 +calvin xylophone 275 65596 65674.27777777778 +calvin xylophone 262 65580 65674.27777777778 +calvin xylophone 370 65631 65674.27777777778 +calvin xylophone 366 65667 65674.27777777778 +calvin xylophone 438 65575 65674.27777777778 +calvin xylophone 462 65699 65674.27777777778 +calvin xylophone 398 65663 65674.27777777778 +david davidson 423 65754 65669.61538461539 +david davidson 423 65649 65669.61538461539 +david davidson 271 65627 65669.61538461539 +david davidson 341 65756 65669.61538461539 +david davidson 311 65762 65669.61538461539 +david davidson 363 65569 65669.61538461539 +david davidson 308 65559 65669.61538461539 +david davidson 271 65620 65669.61538461539 +david davidson 502 65584 65669.61538461539 +david davidson 382 65779 65669.61538461539 +david davidson 256 65778 65669.61538461539 +david davidson 443 65664 65669.61538461539 +david davidson 276 65604 65669.61538461539 +david garcia 259 65789 65691.26666666666 +david garcia 485 65684 65691.26666666666 +david garcia 258 65582 65691.26666666666 +david garcia 347 65600 65691.26666666666 +david garcia 275 65707 65691.26666666666 +david garcia 396 65770 65691.26666666666 +david garcia 496 65716 65691.26666666666 +david garcia 332 65750 65691.26666666666 +david garcia 486 65771 65691.26666666666 +david garcia 479 65603 65691.26666666666 +david garcia 290 65692 65691.26666666666 +david garcia 411 65576 65691.26666666666 +david garcia 424 65728 65691.26666666666 +david garcia 425 65752 65691.26666666666 +david garcia 324 65649 65691.26666666666 +david johnson 409 65577 65637.07142857143 +david johnson 277 65565 65637.07142857143 +david johnson 286 65536 65637.07142857143 +david johnson 482 65634 65637.07142857143 +david johnson 497 65671 65637.07142857143 +david johnson 314 65685 65637.07142857143 +david johnson 491 65598 65637.07142857143 +david johnson 455 65703 65637.07142857143 +david johnson 260 65708 65637.07142857143 +david johnson 433 65582 65637.07142857143 +david johnson 341 65724 65637.07142857143 +david johnson 333 65624 65637.07142857143 +david johnson 301 65719 65637.07142857143 +david johnson 480 65593 65637.07142857143 +david king 439 65545 65649.2 +david king 425 65732 65649.2 +david king 305 65689 65649.2 +david king 368 65657 65649.2 +david king 436 65764 65649.2 +david king 412 65564 65649.2 +david king 379 65603 65649.2 +david king 262 65555 65649.2 +david king 427 65598 65649.2 +david king 442 65576 65649.2 +david king 270 65725 65649.2 +david king 274 65780 65649.2 +david king 291 65644 65649.2 +david king 382 65633 65649.2 +david king 447 65673 65649.2 +david ovid 392 65709 65683.625 +david ovid 315 65619 65683.625 +david ovid 410 65571 65683.625 +david ovid 270 65755 65683.625 +david ovid 329 65628 65683.625 +david ovid 264 65587 65683.625 +david ovid 359 65695 65683.625 +david ovid 382 65623 65683.625 +david ovid 411 65743 65683.625 +david ovid 438 65664 65683.625 +david ovid 299 65741 65683.625 +david ovid 475 65777 65683.625 +david ovid 396 65762 65683.625 +david ovid 356 65765 65683.625 +david ovid 332 65721 65683.625 +david ovid 336 65578 65683.625 +david polk 441 65659 65653.72727272728 +david polk 496 65605 65653.72727272728 +david polk 460 65709 65653.72727272728 +david polk 470 65735 65653.72727272728 +david polk 266 65693 65653.72727272728 +david polk 361 65551 65653.72727272728 +david polk 402 65732 65653.72727272728 +david polk 415 65715 65653.72727272728 +david polk 277 65539 65653.72727272728 +david polk 318 65560 65653.72727272728 +david polk 486 65693 65653.72727272728 +ethan davidson 317 65769 65678.92857142857 +ethan davidson 319 65620 65678.92857142857 +ethan davidson 411 65624 65678.92857142857 +ethan davidson 470 65589 65678.92857142857 +ethan davidson 442 65604 65678.92857142857 +ethan davidson 308 65767 65678.92857142857 +ethan davidson 262 65734 65678.92857142857 +ethan davidson 379 65749 65678.92857142857 +ethan davidson 485 65617 65678.92857142857 +ethan davidson 490 65600 65678.92857142857 +ethan davidson 322 65748 65678.92857142857 +ethan davidson 436 65695 65678.92857142857 +ethan davidson 383 65758 65678.92857142857 +ethan davidson 271 65631 65678.92857142857 +ethan johnson 490 65627 65617.27272727272 +ethan johnson 261 65550 65617.27272727272 +ethan johnson 431 65658 65617.27272727272 +ethan johnson 454 65617 65617.27272727272 +ethan johnson 352 65731 65617.27272727272 +ethan johnson 497 65558 65617.27272727272 +ethan johnson 301 65536 65617.27272727272 +ethan johnson 483 65578 65617.27272727272 +ethan johnson 492 65690 65617.27272727272 +ethan johnson 473 65630 65617.27272727272 +ethan johnson 283 65615 65617.27272727272 +ethan polk 417 65786 65677.25 +ethan polk 487 65749 65677.25 +ethan polk 329 65572 65677.25 +ethan polk 323 65617 65677.25 +ethan polk 283 65695 65677.25 +ethan polk 402 65622 65677.25 +ethan polk 421 65769 65677.25 +ethan polk 260 65589 65677.25 +ethan polk 378 65695 65677.25 +ethan polk 302 65615 65677.25 +ethan polk 302 65683 65677.25 +ethan polk 257 65712 65677.25 +ethan polk 431 65592 65677.25 +ethan polk 367 65785 65677.25 +ethan polk 468 65733 65677.25 +ethan polk 463 65622 65677.25 +ethan zipper 387 65740 65681.64285714286 +ethan zipper 400 65707 65681.64285714286 +ethan zipper 390 65769 65681.64285714286 +ethan zipper 354 65593 65681.64285714286 +ethan zipper 378 65555 65681.64285714286 +ethan zipper 435 65645 65681.64285714286 +ethan zipper 269 65779 65681.64285714286 +ethan zipper 491 65575 65681.64285714286 +ethan zipper 364 65767 65681.64285714286 +ethan zipper 366 65759 65681.64285714286 +ethan zipper 288 65764 65681.64285714286 +ethan zipper 411 65680 65681.64285714286 +ethan zipper 343 65605 65681.64285714286 +ethan zipper 506 65605 65681.64285714286 +fred carson 361 65617 65671.22222222222 +fred carson 443 65593 65671.22222222222 +fred carson 312 65739 65671.22222222222 +fred carson 320 65716 65671.22222222222 +fred carson 463 65554 65671.22222222222 +fred carson 361 65679 65671.22222222222 +fred carson 308 65726 65671.22222222222 +fred carson 320 65709 65671.22222222222 +fred carson 383 65708 65671.22222222222 +fred nixon 374 65725 65674.52631578948 +fred nixon 334 65542 65674.52631578948 +fred nixon 389 65718 65674.52631578948 +fred nixon 427 65596 65674.52631578948 +fred nixon 497 65612 65674.52631578948 +fred nixon 463 65718 65674.52631578948 +fred nixon 473 65719 65674.52631578948 +fred nixon 359 65560 65674.52631578948 +fred nixon 262 65649 65674.52631578948 +fred nixon 362 65686 65674.52631578948 +fred nixon 473 65787 65674.52631578948 +fred nixon 291 65734 65674.52631578948 +fred nixon 274 65705 65674.52631578948 +fred nixon 403 65735 65674.52631578948 +fred nixon 322 65582 65674.52631578948 +fred nixon 467 65718 65674.52631578948 +fred nixon 317 65702 65674.52631578948 +fred nixon 317 65703 65674.52631578948 +fred nixon 372 65625 65674.52631578948 +fred robinson 422 65586 65655.23529411765 +fred robinson 423 65594 65655.23529411765 +fred robinson 358 65627 65655.23529411765 +fred robinson 345 65760 65655.23529411765 +fred robinson 363 65706 65655.23529411765 +fred robinson 493 65723 65655.23529411765 +fred robinson 371 65719 65655.23529411765 +fred robinson 286 65554 65655.23529411765 +fred robinson 323 65611 65655.23529411765 +fred robinson 474 65638 65655.23529411765 +fred robinson 495 65785 65655.23529411765 +fred robinson 436 65623 65655.23529411765 +fred robinson 409 65670 65655.23529411765 +fred robinson 297 65566 65655.23529411765 +fred robinson 391 65583 65655.23529411765 +fred robinson 428 65673 65655.23529411765 +fred robinson 453 65721 65655.23529411765 +fred van buren 482 65658 65669.41176470589 +fred van buren 277 65620 65669.41176470589 +fred van buren 403 65670 65669.41176470589 +fred van buren 279 65745 65669.41176470589 +fred van buren 309 65648 65669.41176470589 +fred van buren 332 65758 65669.41176470589 +fred van buren 391 65615 65669.41176470589 +fred van buren 291 65670 65669.41176470589 +fred van buren 337 65606 65669.41176470589 +fred van buren 485 65764 65669.41176470589 +fred van buren 266 65786 65669.41176470589 +fred van buren 503 65624 65669.41176470589 +fred van buren 318 65789 65669.41176470589 +fred van buren 302 65655 65669.41176470589 +fred van buren 329 65561 65669.41176470589 +fred van buren 501 65674 65669.41176470589 +fred van buren 458 65537 65669.41176470589 +fred xylophone 385 65644 65696.36363636363 +fred xylophone 282 65605 65696.36363636363 +fred xylophone 463 65701 65696.36363636363 +fred xylophone 316 65751 65696.36363636363 +fred xylophone 320 65753 65696.36363636363 +fred xylophone 289 65617 65696.36363636363 +fred xylophone 284 65614 65696.36363636363 +fred xylophone 327 65753 65696.36363636363 +fred xylophone 508 65778 65696.36363636363 +fred xylophone 416 65684 65696.36363636363 +fred xylophone 450 65760 65696.36363636363 +fred zipper 333 65666 65662.84615384616 +fred zipper 299 65735 65662.84615384616 +fred zipper 302 65743 65662.84615384616 +fred zipper 257 65756 65662.84615384616 +fred zipper 366 65555 65662.84615384616 +fred zipper 405 65779 65662.84615384616 +fred zipper 317 65543 65662.84615384616 +fred zipper 434 65553 65662.84615384616 +fred zipper 455 65601 65662.84615384616 +fred zipper 300 65553 65662.84615384616 +fred zipper 270 65744 65662.84615384616 +fred zipper 265 65674 65662.84615384616 +fred zipper 510 65715 65662.84615384616 +gabriella allen 503 65677 65645.71428571429 +gabriella allen 410 65569 65645.71428571429 +gabriella allen 316 65646 65645.71428571429 +gabriella allen 452 65704 65645.71428571429 +gabriella allen 471 65624 65645.71428571429 +gabriella allen 402 65725 65645.71428571429 +gabriella allen 282 65575 65645.71428571429 +gabriella brown 376 65739 65696.47368421052 +gabriella brown 460 65731 65696.47368421052 +gabriella brown 326 65758 65696.47368421052 +gabriella brown 297 65704 65696.47368421052 +gabriella brown 472 65715 65696.47368421052 +gabriella brown 304 65733 65696.47368421052 +gabriella brown 475 65766 65696.47368421052 +gabriella brown 416 65666 65696.47368421052 +gabriella brown 498 65587 65696.47368421052 +gabriella brown 328 65565 65696.47368421052 +gabriella brown 343 65702 65696.47368421052 +gabriella brown 471 65583 65696.47368421052 +gabriella brown 488 65723 65696.47368421052 +gabriella brown 284 65753 65696.47368421052 +gabriella brown 297 65712 65696.47368421052 +gabriella brown 270 65698 65696.47368421052 +gabriella brown 498 65751 65696.47368421052 +gabriella brown 462 65627 65696.47368421052 +gabriella brown 487 65720 65696.47368421052 +gabriella ellison 466 65574 65655.85 +gabriella ellison 306 65559 65655.85 +gabriella ellison 474 65704 65655.85 +gabriella ellison 495 65561 65655.85 +gabriella ellison 404 65621 65655.85 +gabriella ellison 280 65716 65655.85 +gabriella ellison 457 65573 65655.85 +gabriella ellison 315 65550 65655.85 +gabriella ellison 284 65673 65655.85 +gabriella ellison 378 65771 65655.85 +gabriella ellison 283 65666 65655.85 +gabriella ellison 310 65737 65655.85 +gabriella ellison 429 65682 65655.85 +gabriella ellison 452 65605 65655.85 +gabriella ellison 271 65715 65655.85 +gabriella ellison 422 65774 65655.85 +gabriella ellison 396 65760 65655.85 +gabriella ellison 351 65586 65655.85 +gabriella ellison 327 65706 65655.85 +gabriella ellison 257 65584 65655.85 +gabriella falkner 398 65678 65678.8125 +gabriella falkner 259 65767 65678.8125 +gabriella falkner 268 65676 65678.8125 +gabriella falkner 330 65649 65678.8125 +gabriella falkner 391 65745 65678.8125 +gabriella falkner 413 65623 65678.8125 +gabriella falkner 301 65638 65678.8125 +gabriella falkner 504 65751 65678.8125 +gabriella falkner 294 65754 65678.8125 +gabriella falkner 263 65690 65678.8125 +gabriella falkner 462 65635 65678.8125 +gabriella falkner 283 65711 65678.8125 +gabriella falkner 256 65731 65678.8125 +gabriella falkner 267 65596 65678.8125 +gabriella falkner 384 65644 65678.8125 +gabriella falkner 324 65573 65678.8125 +gabriella garcia 431 65743 65676.4 +gabriella garcia 395 65788 65676.4 +gabriella garcia 306 65571 65676.4 +gabriella garcia 444 65611 65676.4 +gabriella garcia 485 65788 65676.4 +gabriella garcia 355 65687 65676.4 +gabriella garcia 495 65787 65676.4 +gabriella garcia 271 65665 65676.4 +gabriella garcia 303 65721 65676.4 +gabriella garcia 288 65536 65676.4 +gabriella garcia 391 65738 65676.4 +gabriella garcia 261 65645 65676.4 +gabriella garcia 446 65672 65676.4 +gabriella garcia 272 65555 65676.4 +gabriella garcia 273 65639 65676.4 +gabriella hernandez 323 65701 65631.78947368421 +gabriella hernandez 413 65540 65631.78947368421 +gabriella hernandez 432 65592 65631.78947368421 +gabriella hernandez 427 65570 65631.78947368421 +gabriella hernandez 340 65596 65631.78947368421 +gabriella hernandez 352 65628 65631.78947368421 +gabriella hernandez 273 65615 65631.78947368421 +gabriella hernandez 289 65706 65631.78947368421 +gabriella hernandez 506 65647 65631.78947368421 +gabriella hernandez 372 65587 65631.78947368421 +gabriella hernandez 302 65701 65631.78947368421 +gabriella hernandez 457 65594 65631.78947368421 +gabriella hernandez 350 65717 65631.78947368421 +gabriella hernandez 483 65584 65631.78947368421 +gabriella hernandez 491 65744 65631.78947368421 +gabriella hernandez 454 65645 65631.78947368421 +gabriella hernandez 503 65609 65631.78947368421 +gabriella hernandez 384 65634 65631.78947368421 +gabriella hernandez 269 65594 65631.78947368421 +gabriella johnson 368 65752 65637.5 +gabriella johnson 284 65553 65637.5 +gabriella johnson 278 65538 65637.5 +gabriella johnson 390 65544 65637.5 +gabriella johnson 424 65768 65637.5 +gabriella johnson 292 65669 65637.5 +gabriella johnson 408 65683 65637.5 +gabriella johnson 466 65593 65637.5 +gabriella miller 463 65646 65673.16666666667 +gabriella miller 370 65631 65673.16666666667 +gabriella miller 454 65735 65673.16666666667 +gabriella miller 458 65716 65673.16666666667 +gabriella miller 311 65700 65673.16666666667 +gabriella miller 280 65611 65673.16666666667 +gabriella steinbeck 399 65652 65669.61111111111 +gabriella steinbeck 263 65582 65669.61111111111 +gabriella steinbeck 301 65603 65669.61111111111 +gabriella steinbeck 420 65594 65669.61111111111 +gabriella steinbeck 305 65780 65669.61111111111 +gabriella steinbeck 334 65653 65669.61111111111 +gabriella steinbeck 485 65680 65669.61111111111 +gabriella steinbeck 367 65717 65669.61111111111 +gabriella steinbeck 291 65661 65669.61111111111 +gabriella steinbeck 393 65786 65669.61111111111 +gabriella steinbeck 423 65758 65669.61111111111 +gabriella steinbeck 495 65626 65669.61111111111 +gabriella steinbeck 493 65630 65669.61111111111 +gabriella steinbeck 491 65594 65669.61111111111 +gabriella steinbeck 510 65632 65669.61111111111 +gabriella steinbeck 467 65713 65669.61111111111 +gabriella steinbeck 443 65613 65669.61111111111 +gabriella steinbeck 340 65779 65669.61111111111 +gabriella xylophone 424 65784 65703.16666666667 +gabriella xylophone 480 65693 65703.16666666667 +gabriella xylophone 428 65790 65703.16666666667 +gabriella xylophone 266 65586 65703.16666666667 +gabriella xylophone 354 65714 65703.16666666667 +gabriella xylophone 481 65729 65703.16666666667 +gabriella xylophone 333 65724 65703.16666666667 +gabriella xylophone 467 65745 65703.16666666667 +gabriella xylophone 322 65598 65703.16666666667 +gabriella xylophone 403 65748 65703.16666666667 +gabriella xylophone 285 65669 65703.16666666667 +gabriella xylophone 383 65658 65703.16666666667 +gabriella young 403 65547 65636.0 +gabriella young 498 65774 65636.0 +gabriella young 405 65598 65636.0 +gabriella young 313 65699 65636.0 +gabriella young 258 65573 65636.0 +gabriella young 455 65571 65636.0 +gabriella young 379 65736 65636.0 +gabriella young 295 65590 65636.0 +holly brown 478 65599 65636.11111111111 +holly brown 301 65583 65636.11111111111 +holly brown 417 65569 65636.11111111111 +holly brown 279 65774 65636.11111111111 +holly brown 451 65567 65636.11111111111 +holly brown 261 65632 65636.11111111111 +holly brown 353 65668 65636.11111111111 +holly brown 385 65714 65636.11111111111 +holly brown 346 65619 65636.11111111111 +holly falkner 310 65553 65659.79166666667 +holly falkner 407 65742 65659.79166666667 +holly falkner 407 65682 65659.79166666667 +holly falkner 369 65674 65659.79166666667 +holly falkner 423 65718 65659.79166666667 +holly falkner 289 65746 65659.79166666667 +holly falkner 319 65633 65659.79166666667 +holly falkner 448 65775 65659.79166666667 +holly falkner 411 65623 65659.79166666667 +holly falkner 473 65720 65659.79166666667 +holly falkner 383 65597 65659.79166666667 +holly falkner 390 65552 65659.79166666667 +holly falkner 470 65746 65659.79166666667 +holly falkner 474 65721 65659.79166666667 +holly falkner 452 65557 65659.79166666667 +holly falkner 368 65617 65659.79166666667 +holly falkner 480 65711 65659.79166666667 +holly falkner 443 65542 65659.79166666667 +holly falkner 434 65629 65659.79166666667 +holly falkner 461 65719 65659.79166666667 +holly falkner 268 65632 65659.79166666667 +holly falkner 479 65538 65659.79166666667 +holly falkner 388 65719 65659.79166666667 +holly falkner 377 65689 65659.79166666667 +holly hernandez 463 65767 65680.33333333333 +holly hernandez 496 65699 65680.33333333333 +holly hernandez 377 65597 65680.33333333333 +holly hernandez 329 65788 65680.33333333333 +holly hernandez 385 65623 65680.33333333333 +holly hernandez 346 65787 65680.33333333333 +holly hernandez 458 65538 65680.33333333333 +holly hernandez 426 65602 65680.33333333333 +holly hernandez 396 65635 65680.33333333333 +holly hernandez 461 65686 65680.33333333333 +holly hernandez 350 65615 65680.33333333333 +holly hernandez 481 65750 65680.33333333333 +holly hernandez 374 65748 65680.33333333333 +holly hernandez 356 65564 65680.33333333333 +holly hernandez 416 65554 65680.33333333333 +holly hernandez 434 65755 65680.33333333333 +holly hernandez 411 65791 65680.33333333333 +holly hernandez 486 65747 65680.33333333333 +holly nixon 260 65605 65640.08333333333 +holly nixon 467 65548 65640.08333333333 +holly nixon 419 65773 65640.08333333333 +holly nixon 449 65778 65640.08333333333 +holly nixon 447 65680 65640.08333333333 +holly nixon 396 65549 65640.08333333333 +holly nixon 505 65565 65640.08333333333 +holly nixon 393 65764 65640.08333333333 +holly nixon 331 65539 65640.08333333333 +holly nixon 288 65658 65640.08333333333 +holly nixon 272 65571 65640.08333333333 +holly nixon 293 65651 65640.08333333333 +holly quirinius 404 65638 65633.3125 +holly quirinius 486 65619 65633.3125 +holly quirinius 352 65778 65633.3125 +holly quirinius 379 65637 65633.3125 +holly quirinius 363 65558 65633.3125 +holly quirinius 299 65650 65633.3125 +holly quirinius 287 65674 65633.3125 +holly quirinius 482 65642 65633.3125 +holly quirinius 399 65597 65633.3125 +holly quirinius 454 65537 65633.3125 +holly quirinius 278 65569 65633.3125 +holly quirinius 476 65696 65633.3125 +holly quirinius 291 65635 65633.3125 +holly quirinius 270 65694 65633.3125 +holly quirinius 279 65546 65633.3125 +holly quirinius 274 65663 65633.3125 +irene carson 274 65755 65638.22222222222 +irene carson 509 65574 65638.22222222222 +irene carson 450 65604 65638.22222222222 +irene carson 421 65786 65638.22222222222 +irene carson 447 65566 65638.22222222222 +irene carson 327 65564 65638.22222222222 +irene carson 317 65570 65638.22222222222 +irene carson 283 65589 65638.22222222222 +irene carson 313 65635 65638.22222222222 +irene carson 376 65640 65638.22222222222 +irene carson 310 65651 65638.22222222222 +irene carson 481 65590 65638.22222222222 +irene carson 504 65618 65638.22222222222 +irene carson 403 65728 65638.22222222222 +irene carson 428 65590 65638.22222222222 +irene carson 434 65672 65638.22222222222 +irene carson 370 65766 65638.22222222222 +irene carson 415 65590 65638.22222222222 +irene ellison 381 65569 65683.875 +irene ellison 287 65725 65683.875 +irene ellison 424 65742 65683.875 +irene ellison 481 65659 65683.875 +irene ellison 458 65696 65683.875 +irene ellison 352 65745 65683.875 +irene ellison 442 65659 65683.875 +irene ellison 418 65744 65683.875 +irene ellison 349 65674 65683.875 +irene ellison 350 65697 65683.875 +irene ellison 510 65651 65683.875 +irene ellison 321 65791 65683.875 +irene ellison 458 65542 65683.875 +irene ellison 279 65732 65683.875 +irene ellison 312 65654 65683.875 +irene ellison 404 65662 65683.875 +irene falkner 382 65601 65673.9375 +irene falkner 508 65593 65673.9375 +irene falkner 438 65737 65673.9375 +irene falkner 471 65567 65673.9375 +irene falkner 352 65584 65673.9375 +irene falkner 486 65672 65673.9375 +irene falkner 399 65682 65673.9375 +irene falkner 284 65665 65673.9375 +irene falkner 469 65661 65673.9375 +irene falkner 326 65750 65673.9375 +irene falkner 453 65759 65673.9375 +irene falkner 405 65785 65673.9375 +irene falkner 305 65771 65673.9375 +irene falkner 472 65620 65673.9375 +irene falkner 440 65686 65673.9375 +irene falkner 441 65650 65673.9375 +irene garcia 423 65597 65672.6 +irene garcia 427 65787 65672.6 +irene garcia 344 65712 65672.6 +irene garcia 425 65660 65672.6 +irene garcia 456 65640 65672.6 +irene garcia 392 65711 65672.6 +irene garcia 464 65683 65672.6 +irene garcia 290 65744 65672.6 +irene garcia 332 65756 65672.6 +irene garcia 486 65684 65672.6 +irene garcia 267 65700 65672.6 +irene garcia 324 65625 65672.6 +irene garcia 292 65540 65672.6 +irene garcia 440 65701 65672.6 +irene garcia 272 65549 65672.6 +irene miller 451 65776 65686.1875 +irene miller 331 65689 65686.1875 +irene miller 353 65577 65686.1875 +irene miller 415 65734 65686.1875 +irene miller 503 65789 65686.1875 +irene miller 507 65769 65686.1875 +irene miller 362 65712 65686.1875 +irene miller 376 65593 65686.1875 +irene miller 387 65556 65686.1875 +irene miller 437 65675 65686.1875 +irene miller 464 65756 65686.1875 +irene miller 385 65730 65686.1875 +irene miller 346 65751 65686.1875 +irene miller 385 65685 65686.1875 +irene miller 427 65599 65686.1875 +irene miller 500 65588 65686.1875 +irene nixon 338 65614 65692.35294117648 +irene nixon 321 65764 65692.35294117648 +irene nixon 488 65779 65692.35294117648 +irene nixon 341 65684 65692.35294117648 +irene nixon 324 65677 65692.35294117648 +irene nixon 399 65583 65692.35294117648 +irene nixon 339 65710 65692.35294117648 +irene nixon 438 65741 65692.35294117648 +irene nixon 454 65771 65692.35294117648 +irene nixon 269 65568 65692.35294117648 +irene nixon 298 65653 65692.35294117648 +irene nixon 482 65785 65692.35294117648 +irene nixon 281 65643 65692.35294117648 +irene nixon 476 65631 65692.35294117648 +irene nixon 443 65787 65692.35294117648 +irene nixon 509 65648 65692.35294117648 +irene nixon 345 65732 65692.35294117648 +irene thompson 277 65723 65670.75 +irene thompson 400 65705 65670.75 +irene thompson 507 65722 65670.75 +irene thompson 430 65598 65670.75 +irene thompson 303 65603 65670.75 +irene thompson 385 65604 65670.75 +irene thompson 404 65598 65670.75 +irene thompson 271 65754 65670.75 +irene thompson 418 65706 65670.75 +irene thompson 442 65585 65670.75 +irene thompson 341 65691 65670.75 +irene thompson 352 65720 65670.75 +irene thompson 413 65706 65670.75 +irene thompson 264 65688 65670.75 +irene thompson 325 65614 65670.75 +irene thompson 393 65715 65670.75 +irene young 288 65785 65678.0 +irene young 507 65625 65678.0 +irene young 484 65552 65678.0 +irene young 369 65642 65678.0 +irene young 458 65679 65678.0 +irene young 337 65729 65678.0 +irene young 459 65785 65678.0 +irene young 304 65568 65678.0 +irene young 511 65578 65678.0 +irene young 406 65769 65678.0 +irene young 257 65654 65678.0 +irene young 510 65770 65678.0 +irene zipper 348 65752 65683.71428571429 +irene zipper 479 65689 65683.71428571429 +irene zipper 290 65684 65683.71428571429 +irene zipper 503 65583 65683.71428571429 +irene zipper 365 65658 65683.71428571429 +irene zipper 404 65706 65683.71428571429 +irene zipper 412 65714 65683.71428571429 +jessica allen 348 65622 65669.16666666667 +jessica allen 420 65751 65669.16666666667 +jessica allen 347 65587 65669.16666666667 +jessica allen 449 65576 65669.16666666667 +jessica allen 492 65769 65669.16666666667 +jessica allen 357 65645 65669.16666666667 +jessica allen 307 65704 65669.16666666667 +jessica allen 450 65678 65669.16666666667 +jessica allen 407 65647 65669.16666666667 +jessica allen 362 65726 65669.16666666667 +jessica allen 408 65705 65669.16666666667 +jessica allen 329 65620 65669.16666666667 +jessica brown 288 65789 65679.5625 +jessica brown 467 65672 65679.5625 +jessica brown 346 65641 65679.5625 +jessica brown 300 65762 65679.5625 +jessica brown 420 65726 65679.5625 +jessica brown 472 65707 65679.5625 +jessica brown 388 65635 65679.5625 +jessica brown 388 65642 65679.5625 +jessica brown 370 65691 65679.5625 +jessica brown 341 65588 65679.5625 +jessica brown 345 65646 65679.5625 +jessica brown 455 65625 65679.5625 +jessica brown 444 65760 65679.5625 +jessica brown 510 65695 65679.5625 +jessica brown 496 65595 65679.5625 +jessica brown 410 65699 65679.5625 +jessica falkner 349 65683 65670.5 +jessica falkner 447 65687 65670.5 +jessica falkner 412 65706 65670.5 +jessica falkner 290 65560 65670.5 +jessica falkner 342 65730 65670.5 +jessica falkner 336 65638 65670.5 +jessica falkner 352 65655 65670.5 +jessica falkner 432 65701 65670.5 +jessica falkner 258 65761 65670.5 +jessica falkner 347 65584 65670.5 +jessica laertes 403 65677 65709.7 +jessica laertes 433 65786 65709.7 +jessica laertes 454 65738 65709.7 +jessica laertes 258 65617 65709.7 +jessica laertes 457 65760 65709.7 +jessica laertes 400 65790 65709.7 +jessica laertes 368 65691 65709.7 +jessica laertes 481 65694 65709.7 +jessica laertes 447 65713 65709.7 +jessica laertes 257 65631 65709.7 +jessica nixon 307 65624 65675.5 +jessica nixon 440 65677 65675.5 +jessica nixon 303 65733 65675.5 +jessica nixon 345 65769 65675.5 +jessica nixon 315 65678 65675.5 +jessica nixon 411 65589 65675.5 +jessica nixon 510 65694 65675.5 +jessica nixon 449 65769 65675.5 +jessica nixon 385 65595 65675.5 +jessica nixon 423 65677 65675.5 +jessica nixon 390 65692 65675.5 +jessica nixon 350 65746 65675.5 +jessica nixon 416 65658 65675.5 +jessica nixon 280 65774 65675.5 +jessica nixon 442 65660 65675.5 +jessica nixon 341 65573 65675.5 +jessica nixon 294 65590 65675.5 +jessica nixon 434 65661 65675.5 +jessica van buren 361 65572 65608.44444444444 +jessica van buren 460 65549 65608.44444444444 +jessica van buren 366 65548 65608.44444444444 +jessica van buren 350 65665 65608.44444444444 +jessica van buren 284 65680 65608.44444444444 +jessica van buren 478 65615 65608.44444444444 +jessica van buren 408 65657 65608.44444444444 +jessica van buren 263 65622 65608.44444444444 +jessica van buren 346 65568 65608.44444444444 +jessica white 329 65611 65661.79166666667 +jessica white 362 65709 65661.79166666667 +jessica white 344 65786 65661.79166666667 +jessica white 352 65750 65661.79166666667 +jessica white 284 65566 65661.79166666667 +jessica white 460 65570 65661.79166666667 +jessica white 488 65726 65661.79166666667 +jessica white 294 65779 65661.79166666667 +jessica white 423 65673 65661.79166666667 +jessica white 299 65639 65661.79166666667 +jessica white 311 65721 65661.79166666667 +jessica white 434 65681 65661.79166666667 +jessica white 409 65674 65661.79166666667 +jessica white 268 65578 65661.79166666667 +jessica white 485 65546 65661.79166666667 +jessica white 346 65610 65661.79166666667 +jessica white 314 65707 65661.79166666667 +jessica white 305 65739 65661.79166666667 +jessica white 301 65677 65661.79166666667 +jessica white 417 65727 65661.79166666667 +jessica white 452 65544 65661.79166666667 +jessica white 357 65563 65661.79166666667 +jessica white 354 65713 65661.79166666667 +jessica white 450 65594 65661.79166666667 +jessica young 491 65711 65704.76923076923 +jessica young 346 65748 65704.76923076923 +jessica young 461 65671 65704.76923076923 +jessica young 474 65788 65704.76923076923 +jessica young 415 65767 65704.76923076923 +jessica young 300 65729 65704.76923076923 +jessica young 419 65703 65704.76923076923 +jessica young 304 65748 65704.76923076923 +jessica young 266 65660 65704.76923076923 +jessica young 417 65692 65704.76923076923 +jessica young 499 65623 65704.76923076923 +jessica young 417 65683 65704.76923076923 +jessica young 307 65639 65704.76923076923 +katie allen 462 65750 65674.8 +katie allen 404 65772 65674.8 +katie allen 281 65649 65674.8 +katie allen 408 65658 65674.8 +katie allen 511 65713 65674.8 +katie allen 409 65766 65674.8 +katie allen 407 65607 65674.8 +katie allen 295 65553 65674.8 +katie allen 258 65565 65674.8 +katie allen 454 65542 65674.8 +katie allen 378 65784 65674.8 +katie allen 334 65730 65674.8 +katie allen 445 65756 65674.8 +katie allen 420 65594 65674.8 +katie allen 441 65683 65674.8 +katie carson 311 65710 65662.81818181818 +katie carson 307 65592 65662.81818181818 +katie carson 306 65589 65662.81818181818 +katie carson 259 65648 65662.81818181818 +katie carson 314 65690 65662.81818181818 +katie carson 369 65709 65662.81818181818 +katie carson 506 65626 65662.81818181818 +katie carson 286 65743 65662.81818181818 +katie carson 279 65663 65662.81818181818 +katie carson 263 65622 65662.81818181818 +katie carson 393 65699 65662.81818181818 +katie laertes 388 65728 65644.8125 +katie laertes 419 65541 65644.8125 +katie laertes 260 65707 65644.8125 +katie laertes 451 65745 65644.8125 +katie laertes 392 65643 65644.8125 +katie laertes 475 65663 65644.8125 +katie laertes 465 65662 65644.8125 +katie laertes 483 65648 65644.8125 +katie laertes 414 65559 65644.8125 +katie laertes 406 65545 65644.8125 +katie laertes 287 65773 65644.8125 +katie laertes 496 65553 65644.8125 +katie laertes 352 65687 65644.8125 +katie laertes 462 65606 65644.8125 +katie laertes 379 65705 65644.8125 +katie laertes 344 65552 65644.8125 +katie ovid 383 65737 65688.5 +katie ovid 353 65744 65688.5 +katie ovid 464 65703 65688.5 +katie ovid 464 65694 65688.5 +katie ovid 501 65643 65688.5 +katie ovid 308 65628 65688.5 +katie ovid 320 65598 65688.5 +katie ovid 295 65708 65688.5 +katie ovid 495 65764 65688.5 +katie ovid 382 65788 65688.5 +katie ovid 338 65681 65688.5 +katie ovid 434 65710 65688.5 +katie ovid 360 65706 65688.5 +katie ovid 502 65659 65688.5 +katie ovid 448 65609 65688.5 +katie ovid 334 65644 65688.5 +katie white 470 65763 65682.5294117647 +katie white 405 65719 65682.5294117647 +katie white 458 65722 65682.5294117647 +katie white 275 65743 65682.5294117647 +katie white 422 65656 65682.5294117647 +katie white 336 65627 65682.5294117647 +katie white 279 65635 65682.5294117647 +katie white 481 65610 65682.5294117647 +katie white 477 65640 65682.5294117647 +katie white 413 65724 65682.5294117647 +katie white 355 65705 65682.5294117647 +katie white 378 65747 65682.5294117647 +katie white 391 65620 65682.5294117647 +katie white 502 65705 65682.5294117647 +katie white 347 65731 65682.5294117647 +katie white 496 65684 65682.5294117647 +katie white 434 65572 65682.5294117647 +katie zipper 314 65556 65647.64705882352 +katie zipper 353 65621 65647.64705882352 +katie zipper 390 65631 65647.64705882352 +katie zipper 259 65674 65647.64705882352 +katie zipper 280 65772 65647.64705882352 +katie zipper 398 65577 65647.64705882352 +katie zipper 468 65611 65647.64705882352 +katie zipper 388 65661 65647.64705882352 +katie zipper 341 65733 65647.64705882352 +katie zipper 405 65555 65647.64705882352 +katie zipper 318 65691 65647.64705882352 +katie zipper 360 65736 65647.64705882352 +katie zipper 379 65684 65647.64705882352 +katie zipper 338 65731 65647.64705882352 +katie zipper 430 65605 65647.64705882352 +katie zipper 309 65568 65647.64705882352 +katie zipper 421 65604 65647.64705882352 +luke falkner 270 65623 65666.22222222222 +luke falkner 373 65589 65666.22222222222 +luke falkner 335 65653 65666.22222222222 +luke falkner 338 65577 65666.22222222222 +luke falkner 311 65652 65666.22222222222 +luke falkner 308 65595 65666.22222222222 +luke falkner 430 65760 65666.22222222222 +luke falkner 268 65655 65666.22222222222 +luke falkner 491 65618 65666.22222222222 +luke falkner 293 65566 65666.22222222222 +luke falkner 482 65747 65666.22222222222 +luke falkner 340 65781 65666.22222222222 +luke falkner 441 65789 65666.22222222222 +luke falkner 257 65694 65666.22222222222 +luke falkner 344 65609 65666.22222222222 +luke falkner 401 65615 65666.22222222222 +luke falkner 472 65693 65666.22222222222 +luke falkner 322 65776 65666.22222222222 +luke polk 484 65552 65683.17647058824 +luke polk 380 65564 65683.17647058824 +luke polk 420 65750 65683.17647058824 +luke polk 433 65669 65683.17647058824 +luke polk 348 65645 65683.17647058824 +luke polk 417 65742 65683.17647058824 +luke polk 397 65725 65683.17647058824 +luke polk 440 65742 65683.17647058824 +luke polk 477 65789 65683.17647058824 +luke polk 331 65579 65683.17647058824 +luke polk 274 65658 65683.17647058824 +luke polk 298 65784 65683.17647058824 +luke polk 480 65776 65683.17647058824 +luke polk 353 65635 65683.17647058824 +luke polk 490 65623 65683.17647058824 +luke polk 457 65705 65683.17647058824 +luke polk 447 65676 65683.17647058824 +luke robinson 403 65763 65674.27272727272 +luke robinson 462 65560 65674.27272727272 +luke robinson 500 65690 65674.27272727272 +luke robinson 475 65737 65674.27272727272 +luke robinson 261 65718 65674.27272727272 +luke robinson 392 65634 65674.27272727272 +luke robinson 391 65656 65674.27272727272 +luke robinson 425 65772 65674.27272727272 +luke robinson 308 65552 65674.27272727272 +luke robinson 341 65627 65674.27272727272 +luke robinson 309 65576 65674.27272727272 +luke robinson 428 65587 65674.27272727272 +luke robinson 326 65704 65674.27272727272 +luke robinson 374 65783 65674.27272727272 +luke robinson 408 65628 65674.27272727272 +luke robinson 461 65748 65674.27272727272 +luke robinson 389 65584 65674.27272727272 +luke robinson 341 65709 65674.27272727272 +luke robinson 364 65789 65674.27272727272 +luke robinson 333 65687 65674.27272727272 +luke robinson 443 65571 65674.27272727272 +luke robinson 502 65759 65674.27272727272 +luke van buren 377 65759 65693.1875 +luke van buren 282 65636 65693.1875 +luke van buren 388 65769 65693.1875 +luke van buren 450 65576 65693.1875 +luke van buren 402 65699 65693.1875 +luke van buren 436 65678 65693.1875 +luke van buren 270 65677 65693.1875 +luke van buren 304 65741 65693.1875 +luke van buren 444 65725 65693.1875 +luke van buren 476 65624 65693.1875 +luke van buren 409 65773 65693.1875 +luke van buren 363 65673 65693.1875 +luke van buren 274 65669 65693.1875 +luke van buren 301 65716 65693.1875 +luke van buren 407 65683 65693.1875 +luke van buren 398 65693 65693.1875 +luke white 397 65725 65695.0 +luke white 279 65715 65695.0 +luke white 323 65701 65695.0 +luke white 437 65538 65695.0 +luke white 360 65721 65695.0 +luke white 352 65684 65695.0 +luke white 304 65702 65695.0 +luke white 391 65715 65695.0 +luke white 509 65719 65695.0 +luke white 347 65732 65695.0 +luke white 346 65693 65695.0 +mike davidson 267 65752 65671.75 +mike davidson 410 65662 65671.75 +mike davidson 346 65621 65671.75 +mike davidson 307 65548 65671.75 +mike davidson 347 65768 65671.75 +mike davidson 491 65618 65671.75 +mike davidson 321 65658 65671.75 +mike davidson 344 65759 65671.75 +mike davidson 511 65588 65671.75 +mike davidson 362 65548 65671.75 +mike davidson 398 65752 65671.75 +mike davidson 436 65787 65671.75 +mike falkner 276 65562 65642.27272727272 +mike falkner 339 65715 65642.27272727272 +mike falkner 510 65646 65642.27272727272 +mike falkner 318 65734 65642.27272727272 +mike falkner 305 65662 65642.27272727272 +mike falkner 503 65554 65642.27272727272 +mike falkner 383 65600 65642.27272727272 +mike falkner 453 65624 65642.27272727272 +mike falkner 405 65609 65642.27272727272 +mike falkner 297 65675 65642.27272727272 +mike falkner 287 65684 65642.27272727272 +mike garcia 300 65635 65651.25 +mike garcia 477 65571 65651.25 +mike garcia 314 65770 65651.25 +mike garcia 387 65669 65651.25 +mike garcia 364 65550 65651.25 +mike garcia 354 65753 65651.25 +mike garcia 468 65640 65651.25 +mike garcia 332 65557 65651.25 +mike garcia 390 65641 65651.25 +mike garcia 343 65719 65651.25 +mike garcia 398 65701 65651.25 +mike garcia 345 65686 65651.25 +mike garcia 358 65683 65651.25 +mike garcia 415 65544 65651.25 +mike garcia 364 65650 65651.25 +mike garcia 495 65783 65651.25 +mike garcia 261 65600 65651.25 +mike garcia 415 65644 65651.25 +mike garcia 313 65537 65651.25 +mike garcia 469 65692 65651.25 +mike ichabod 286 65621 65649.26666666666 +mike ichabod 288 65602 65649.26666666666 +mike ichabod 416 65631 65649.26666666666 +mike ichabod 473 65583 65649.26666666666 +mike ichabod 392 65588 65649.26666666666 +mike ichabod 371 65671 65649.26666666666 +mike ichabod 434 65696 65649.26666666666 +mike ichabod 301 65788 65649.26666666666 +mike ichabod 334 65733 65649.26666666666 +mike ichabod 282 65630 65649.26666666666 +mike ichabod 310 65588 65649.26666666666 +mike ichabod 287 65571 65649.26666666666 +mike ichabod 465 65651 65649.26666666666 +mike ichabod 397 65783 65649.26666666666 +mike ichabod 478 65603 65649.26666666666 +mike steinbeck 329 65668 65640.69565217392 +mike steinbeck 492 65558 65640.69565217392 +mike steinbeck 284 65758 65640.69565217392 +mike steinbeck 405 65635 65640.69565217392 +mike steinbeck 439 65704 65640.69565217392 +mike steinbeck 468 65758 65640.69565217392 +mike steinbeck 320 65552 65640.69565217392 +mike steinbeck 492 65620 65640.69565217392 +mike steinbeck 266 65747 65640.69565217392 +mike steinbeck 508 65619 65640.69565217392 +mike steinbeck 285 65553 65640.69565217392 +mike steinbeck 392 65539 65640.69565217392 +mike steinbeck 465 65603 65640.69565217392 +mike steinbeck 315 65749 65640.69565217392 +mike steinbeck 504 65564 65640.69565217392 +mike steinbeck 482 65550 65640.69565217392 +mike steinbeck 269 65751 65640.69565217392 +mike steinbeck 461 65582 65640.69565217392 +mike steinbeck 473 65560 65640.69565217392 +mike steinbeck 448 65638 65640.69565217392 +mike steinbeck 429 65769 65640.69565217392 +mike steinbeck 349 65573 65640.69565217392 +mike steinbeck 364 65686 65640.69565217392 +mike zipper 502 65695 65677.0 +mike zipper 285 65740 65677.0 +mike zipper 505 65615 65677.0 +mike zipper 401 65779 65677.0 +mike zipper 400 65542 65677.0 +mike zipper 441 65655 65677.0 +mike zipper 279 65719 65677.0 +mike zipper 500 65648 65677.0 +mike zipper 288 65685 65677.0 +mike zipper 313 65726 65677.0 +mike zipper 455 65768 65677.0 +mike zipper 422 65552 65677.0 +mike zipper 377 65677 65677.0 +nick allen 481 65765 65704.3 +nick allen 287 65554 65704.3 +nick allen 314 65665 65704.3 +nick allen 277 65735 65704.3 +nick allen 364 65704 65704.3 +nick allen 273 65641 65704.3 +nick allen 419 65786 65704.3 +nick allen 385 65702 65704.3 +nick allen 409 65734 65704.3 +nick allen 326 65757 65704.3 +nick brown 490 65790 65646.05263157895 +nick brown 481 65780 65646.05263157895 +nick brown 480 65620 65646.05263157895 +nick brown 341 65587 65646.05263157895 +nick brown 268 65654 65646.05263157895 +nick brown 334 65665 65646.05263157895 +nick brown 443 65599 65646.05263157895 +nick brown 344 65634 65646.05263157895 +nick brown 351 65545 65646.05263157895 +nick brown 436 65597 65646.05263157895 +nick brown 303 65604 65646.05263157895 +nick brown 499 65724 65646.05263157895 +nick brown 315 65713 65646.05263157895 +nick brown 446 65647 65646.05263157895 +nick brown 376 65604 65646.05263157895 +nick brown 400 65717 65646.05263157895 +nick brown 354 65664 65646.05263157895 +nick brown 506 65579 65646.05263157895 +nick brown 291 65552 65646.05263157895 +nick davidson 435 65575 65665.88888888889 +nick davidson 437 65601 65665.88888888889 +nick davidson 297 65726 65665.88888888889 +nick davidson 347 65713 65665.88888888889 +nick davidson 476 65652 65665.88888888889 +nick davidson 257 65752 65665.88888888889 +nick davidson 274 65537 65665.88888888889 +nick davidson 374 65627 65665.88888888889 +nick davidson 502 65716 65665.88888888889 +nick davidson 483 65657 65665.88888888889 +nick davidson 429 65730 65665.88888888889 +nick davidson 338 65650 65665.88888888889 +nick davidson 298 65536 65665.88888888889 +nick davidson 414 65711 65665.88888888889 +nick davidson 376 65696 65665.88888888889 +nick davidson 360 65752 65665.88888888889 +nick davidson 318 65725 65665.88888888889 +nick davidson 355 65630 65665.88888888889 +nick falkner 413 65584 65643.41176470589 +nick falkner 451 65583 65643.41176470589 +nick falkner 489 65620 65643.41176470589 +nick falkner 423 65648 65643.41176470589 +nick falkner 258 65568 65643.41176470589 +nick falkner 306 65752 65643.41176470589 +nick falkner 350 65585 65643.41176470589 +nick falkner 283 65669 65643.41176470589 +nick falkner 510 65696 65643.41176470589 +nick falkner 482 65674 65643.41176470589 +nick falkner 384 65604 65643.41176470589 +nick falkner 362 65604 65643.41176470589 +nick falkner 272 65716 65643.41176470589 +nick falkner 293 65592 65643.41176470589 +nick falkner 273 65578 65643.41176470589 +nick falkner 424 65789 65643.41176470589 +nick falkner 330 65676 65643.41176470589 +nick johnson 495 65554 65637.5 +nick johnson 277 65585 65637.5 +nick johnson 328 65784 65637.5 +nick johnson 335 65547 65637.5 +nick johnson 381 65700 65637.5 +nick johnson 464 65689 65637.5 +nick johnson 302 65702 65637.5 +nick johnson 482 65558 65637.5 +nick johnson 363 65627 65637.5 +nick johnson 422 65629 65637.5 +nick miller 467 65698 65657.84615384616 +nick miller 473 65541 65657.84615384616 +nick miller 373 65652 65657.84615384616 +nick miller 280 65706 65657.84615384616 +nick miller 383 65694 65657.84615384616 +nick miller 353 65695 65657.84615384616 +nick miller 450 65710 65657.84615384616 +nick miller 415 65640 65657.84615384616 +nick miller 259 65757 65657.84615384616 +nick miller 419 65620 65657.84615384616 +nick miller 443 65576 65657.84615384616 +nick miller 277 65576 65657.84615384616 +nick miller 361 65687 65657.84615384616 +nick steinbeck 319 65652 65695.0625 +nick steinbeck 445 65775 65695.0625 +nick steinbeck 445 65764 65695.0625 +nick steinbeck 374 65714 65695.0625 +nick steinbeck 463 65675 65695.0625 +nick steinbeck 400 65617 65695.0625 +nick steinbeck 395 65569 65695.0625 +nick steinbeck 382 65718 65695.0625 +nick steinbeck 371 65622 65695.0625 +nick steinbeck 285 65689 65695.0625 +nick steinbeck 481 65782 65695.0625 +nick steinbeck 462 65673 65695.0625 +nick steinbeck 361 65733 65695.0625 +nick steinbeck 432 65747 65695.0625 +nick steinbeck 284 65615 65695.0625 +nick steinbeck 264 65776 65695.0625 +nick van buren 461 65569 65661.73684210527 +nick van buren 274 65638 65661.73684210527 +nick van buren 461 65541 65661.73684210527 +nick van buren 448 65615 65661.73684210527 +nick van buren 451 65714 65661.73684210527 +nick van buren 465 65745 65661.73684210527 +nick van buren 495 65779 65661.73684210527 +nick van buren 493 65602 65661.73684210527 +nick van buren 338 65775 65661.73684210527 +nick van buren 415 65618 65661.73684210527 +nick van buren 482 65702 65661.73684210527 +nick van buren 371 65603 65661.73684210527 +nick van buren 491 65751 65661.73684210527 +nick van buren 493 65570 65661.73684210527 +nick van buren 294 65745 65661.73684210527 +nick van buren 273 65604 65661.73684210527 +nick van buren 362 65660 65661.73684210527 +nick van buren 353 65634 65661.73684210527 +nick van buren 295 65708 65661.73684210527 +nick white 384 65547 65633.78571428571 +nick white 363 65564 65633.78571428571 +nick white 509 65669 65633.78571428571 +nick white 343 65644 65633.78571428571 +nick white 383 65603 65633.78571428571 +nick white 490 65658 65633.78571428571 +nick white 385 65653 65633.78571428571 +nick white 359 65568 65633.78571428571 +nick white 375 65757 65633.78571428571 +nick white 473 65593 65633.78571428571 +nick white 329 65755 65633.78571428571 +nick white 482 65557 65633.78571428571 +nick white 384 65586 65633.78571428571 +nick white 311 65719 65633.78571428571 +oscar allen 480 65662 65667.88235294117 +oscar allen 425 65578 65667.88235294117 +oscar allen 281 65685 65667.88235294117 +oscar allen 382 65644 65667.88235294117 +oscar allen 488 65629 65667.88235294117 +oscar allen 510 65677 65667.88235294117 +oscar allen 414 65788 65667.88235294117 +oscar allen 418 65743 65667.88235294117 +oscar allen 287 65776 65667.88235294117 +oscar allen 372 65536 65667.88235294117 +oscar allen 499 65643 65667.88235294117 +oscar allen 265 65655 65667.88235294117 +oscar allen 475 65564 65667.88235294117 +oscar allen 353 65742 65667.88235294117 +oscar allen 342 65609 65667.88235294117 +oscar allen 350 65635 65667.88235294117 +oscar allen 471 65788 65667.88235294117 +oscar davidson 274 65743 65670.22222222222 +oscar davidson 496 65698 65670.22222222222 +oscar davidson 427 65581 65670.22222222222 +oscar davidson 360 65539 65670.22222222222 +oscar davidson 301 65662 65670.22222222222 +oscar davidson 355 65556 65670.22222222222 +oscar davidson 432 65646 65670.22222222222 +oscar davidson 448 65734 65670.22222222222 +oscar davidson 292 65665 65670.22222222222 +oscar davidson 437 65773 65670.22222222222 +oscar davidson 314 65745 65670.22222222222 +oscar davidson 380 65709 65670.22222222222 +oscar davidson 281 65677 65670.22222222222 +oscar davidson 277 65628 65670.22222222222 +oscar davidson 290 65736 65670.22222222222 +oscar davidson 478 65695 65670.22222222222 +oscar davidson 493 65651 65670.22222222222 +oscar davidson 471 65626 65670.22222222222 +oscar ellison 413 65725 65673.15789473684 +oscar ellison 491 65717 65673.15789473684 +oscar ellison 290 65630 65673.15789473684 +oscar ellison 335 65750 65673.15789473684 +oscar ellison 481 65616 65673.15789473684 +oscar ellison 367 65657 65673.15789473684 +oscar ellison 427 65653 65673.15789473684 +oscar ellison 472 65747 65673.15789473684 +oscar ellison 347 65689 65673.15789473684 +oscar ellison 351 65737 65673.15789473684 +oscar ellison 507 65762 65673.15789473684 +oscar ellison 300 65709 65673.15789473684 +oscar ellison 447 65650 65673.15789473684 +oscar ellison 391 65691 65673.15789473684 +oscar ellison 471 65552 65673.15789473684 +oscar ellison 290 65630 65673.15789473684 +oscar ellison 448 65651 65673.15789473684 +oscar ellison 471 65617 65673.15789473684 +oscar ellison 289 65607 65673.15789473684 +oscar king 283 65739 65667.4375 +oscar king 496 65742 65667.4375 +oscar king 436 65541 65667.4375 +oscar king 274 65755 65667.4375 +oscar king 298 65683 65667.4375 +oscar king 465
<TRUNCATED>