hive-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From mmccl...@apache.org
Subject [20/36] hive git commit: HIVE-16369: Vectorization: Support PTF (Part 1: No Custom Window Framing -- Default Only) (Matt McCline, reviewed by Ashutosh Chauhan)
Date Thu, 20 Jul 2017 10:16:46 GMT
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>

Mime
View raw message