You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@hive.apache.org by mm...@apache.org on 2017/07/20 10:16:46 UTC
[20/36] hive git commit: HIVE-16369: Vectorization: Support PTF (Part
1: No Custom Window Framing -- Default Only) (Matt McCline,
reviewed by Ashutosh Chauhan)
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>