http://git-wip-us.apache.org/repos/asf/hive/blob/975a49b6/ql/src/test/results/clientpositive/tez/auto_join0.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/tez/auto_join0.q.out b/ql/src/test/results/clientpositive/tez/auto_join0.q.out deleted file mode 100644 index 1d1ba5e..0000000 --- a/ql/src/test/results/clientpositive/tez/auto_join0.q.out +++ /dev/null @@ -1,166 +0,0 @@ -Warning: Map Join MAPJOIN[24][bigTable=?] in task 'Reducer 2' is a cross product -PREHOOK: query: -- SORT_QUERY_RESULTS - -explain -select sum(hash(a.k1,a.v1,a.k2, a.v2)) -from ( -SELECT src1.key as k1, src1.value as v1, - src2.key as k2, src2.value as v2 FROM - (SELECT * FROM src WHERE src.key < 10 order by src.key, src.value) src1 - JOIN - (SELECT * FROM src WHERE src.key < 10 order by src.key, src.value) src2 - SORT BY k1, v1, k2, v2 -) a -PREHOOK: type: QUERY -POSTHOOK: query: -- SORT_QUERY_RESULTS - -explain -select sum(hash(a.k1,a.v1,a.k2, a.v2)) -from ( -SELECT src1.key as k1, src1.value as v1, - src2.key as k2, src2.value as v2 FROM - (SELECT * FROM src WHERE src.key < 10 order by src.key, src.value) src1 - JOIN - (SELECT * FROM src WHERE src.key < 10 order by src.key, src.value) src2 - SORT BY k1, v1, k2, v2 -) a -POSTHOOK: type: QUERY -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), Reducer 6 (BROADCAST_EDGE) - Reducer 3 <- Reducer 2 (SIMPLE_EDGE) - Reducer 4 <- Reducer 3 (SIMPLE_EDGE) - Reducer 6 <- Map 5 (SIMPLE_EDGE) -#### A masked pattern was here #### - Vertices: - Map 1 - Map Operator Tree: - TableScan - alias: src - Statistics: Num rows: 500 Data size: 89000 Basic stats: COMPLETE Column stats: COMPLETE - Filter Operator - predicate: (key < 10) (type: boolean) - Statistics: Num rows: 166 Data size: 29548 Basic stats: COMPLETE Column stats: COMPLETE - Select Operator - expressions: key (type: string), value (type: string) - outputColumnNames: _col0, _col1 - Statistics: Num rows: 166 Data size: 29548 Basic stats: COMPLETE Column stats: COMPLETE - Reduce Output Operator - key expressions: _col0 (type: string), _col1 (type: string) - sort order: ++ - Statistics: Num rows: 166 Data size: 29548 Basic stats: COMPLETE Column stats: COMPLETE - Map 5 - Map Operator Tree: - TableScan - alias: src - Statistics: Num rows: 500 Data size: 89000 Basic stats: COMPLETE Column stats: COMPLETE - Filter Operator - predicate: (key < 10) (type: boolean) - Statistics: Num rows: 166 Data size: 29548 Basic stats: COMPLETE Column stats: COMPLETE - Select Operator - expressions: key (type: string), value (type: string) - outputColumnNames: _col0, _col1 - Statistics: Num rows: 166 Data size: 29548 Basic stats: COMPLETE Column stats: COMPLETE - Reduce Output Operator - key expressions: _col0 (type: string), _col1 (type: string) - sort order: ++ - Statistics: Num rows: 166 Data size: 29548 Basic stats: COMPLETE Column stats: COMPLETE - Reducer 2 - Reduce Operator Tree: - Select Operator - expressions: KEY.reducesinkkey0 (type: string), KEY.reducesinkkey1 (type: string) - outputColumnNames: _col0, _col1 - Statistics: Num rows: 166 Data size: 29548 Basic stats: COMPLETE Column stats: COMPLETE - Map Join Operator - condition map: - Inner Join 0 to 1 - keys: - 0 - 1 - outputColumnNames: _col0, _col1, _col2, _col3 - input vertices: - 1 Reducer 6 - Statistics: Num rows: 27556 Data size: 9809936 Basic stats: COMPLETE Column stats: COMPLETE - Reduce Output Operator - key expressions: _col0 (type: string), _col1 (type: string), _col2 (type: string), _col3 (type: string) - sort order: ++++ - Statistics: Num rows: 27556 Data size: 9809936 Basic stats: COMPLETE Column stats: COMPLETE - Reducer 3 - Reduce Operator Tree: - Select Operator - expressions: KEY.reducesinkkey0 (type: string), KEY.reducesinkkey1 (type: string), KEY.reducesinkkey2 (type: string), KEY.reducesinkkey3 (type: string) - outputColumnNames: _col0, _col1, _col2, _col3 - Statistics: Num rows: 27556 Data size: 9809936 Basic stats: COMPLETE Column stats: COMPLETE - Group By Operator - aggregations: sum(hash(_col0,_col1,_col2,_col3)) - mode: hash - outputColumnNames: _col0 - Statistics: Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats: COMPLETE - Reduce Output Operator - sort order: - Statistics: Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats: COMPLETE - value expressions: _col0 (type: bigint) - Reducer 4 - Reduce Operator Tree: - Group By Operator - aggregations: sum(VALUE._col0) - mode: mergepartial - outputColumnNames: _col0 - Statistics: Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats: COMPLETE - File Output Operator - compressed: false - Statistics: Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats: COMPLETE - 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 - Reducer 6 - Reduce Operator Tree: - Select Operator - expressions: KEY.reducesinkkey0 (type: string), KEY.reducesinkkey1 (type: string) - outputColumnNames: _col0, _col1 - Statistics: Num rows: 166 Data size: 29548 Basic stats: COMPLETE Column stats: COMPLETE - Reduce Output Operator - sort order: - Statistics: Num rows: 166 Data size: 29548 Basic stats: COMPLETE Column stats: COMPLETE - value expressions: _col0 (type: string), _col1 (type: string) - - Stage: Stage-0 - Fetch Operator - limit: -1 - Processor Tree: - ListSink - -Warning: Map Join MAPJOIN[24][bigTable=?] in task 'Reducer 2' is a cross product -PREHOOK: query: select sum(hash(a.k1,a.v1,a.k2, a.v2)) -from ( -SELECT src1.key as k1, src1.value as v1, - src2.key as k2, src2.value as v2 FROM - (SELECT * FROM src WHERE src.key < 10 order by src.key, src.value) src1 - JOIN - (SELECT * FROM src WHERE src.key < 10 order by src.key, src.value) src2 - SORT BY k1, v1, k2, v2 -) a -PREHOOK: type: QUERY -PREHOOK: Input: default@src -#### A masked pattern was here #### -POSTHOOK: query: select sum(hash(a.k1,a.v1,a.k2, a.v2)) -from ( -SELECT src1.key as k1, src1.value as v1, - src2.key as k2, src2.value as v2 FROM - (SELECT * FROM src WHERE src.key < 10 order by src.key, src.value) src1 - JOIN - (SELECT * FROM src WHERE src.key < 10 order by src.key, src.value) src2 - SORT BY k1, v1, k2, v2 -) a -POSTHOOK: type: QUERY -POSTHOOK: Input: default@src -#### A masked pattern was here #### -34441656720
http://git-wip-us.apache.org/repos/asf/hive/blob/975a49b6/ql/src/test/results/clientpositive/tez/auto_join1.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/tez/auto_join1.q.out b/ql/src/test/results/clientpositive/tez/auto_join1.q.out deleted file mode 100644 index 1d1c502..0000000 --- a/ql/src/test/results/clientpositive/tez/auto_join1.q.out +++ /dev/null @@ -1,124 +0,0 @@ -PREHOOK: query: -- SORT_QUERY_RESULTS - -CREATE TABLE dest_j1(key INT, value STRING) STORED AS TEXTFILE -PREHOOK: type: CREATETABLE -PREHOOK: Output: database:default -PREHOOK: Output: default@dest_j1 -POSTHOOK: query: -- SORT_QUERY_RESULTS - -CREATE TABLE dest_j1(key INT, value STRING) STORED AS TEXTFILE -POSTHOOK: type: CREATETABLE -POSTHOOK: Output: database:default -POSTHOOK: Output: default@dest_j1 -PREHOOK: query: explain -FROM src src1 JOIN src src2 ON (src1.key = src2.key) -INSERT OVERWRITE TABLE dest_j1 SELECT src1.key, src2.value -PREHOOK: type: QUERY -POSTHOOK: query: explain -FROM src src1 JOIN src src2 ON (src1.key = src2.key) -INSERT OVERWRITE TABLE dest_j1 SELECT src1.key, src2.value -POSTHOOK: type: QUERY -STAGE DEPENDENCIES: - Stage-1 is a root stage - Stage-2 depends on stages: Stage-1 - Stage-0 depends on stages: Stage-2 - Stage-3 depends on stages: Stage-0 - -STAGE PLANS: - Stage: Stage-1 - Tez -#### A masked pattern was here #### - Edges: - Map 2 <- Map 1 (BROADCAST_EDGE) -#### A masked pattern was here #### - Vertices: - Map 1 - Map Operator Tree: - TableScan - alias: src1 - Statistics: Num rows: 500 Data size: 43500 Basic stats: COMPLETE Column stats: COMPLETE - Filter Operator - predicate: key is not null (type: boolean) - Statistics: Num rows: 500 Data size: 43500 Basic stats: COMPLETE Column stats: COMPLETE - Select Operator - expressions: key (type: string) - outputColumnNames: _col0 - Statistics: Num rows: 500 Data size: 43500 Basic stats: COMPLETE Column stats: COMPLETE - Reduce Output Operator - key expressions: _col0 (type: string) - sort order: + - Map-reduce partition columns: _col0 (type: string) - Statistics: Num rows: 500 Data size: 43500 Basic stats: COMPLETE Column stats: COMPLETE - Map 2 - Map Operator Tree: - TableScan - alias: src2 - Statistics: Num rows: 500 Data size: 89000 Basic stats: COMPLETE Column stats: COMPLETE - Filter Operator - predicate: key is not null (type: boolean) - Statistics: Num rows: 500 Data size: 89000 Basic stats: COMPLETE Column stats: COMPLETE - Select Operator - expressions: key (type: string), value (type: string) - outputColumnNames: _col0, _col1 - Statistics: Num rows: 500 Data size: 89000 Basic stats: COMPLETE Column stats: COMPLETE - Map Join Operator - condition map: - Inner Join 0 to 1 - keys: - 0 _col0 (type: string) - 1 _col0 (type: string) - outputColumnNames: _col0, _col2 - input vertices: - 0 Map 1 - Statistics: Num rows: 1219 Data size: 216982 Basic stats: COMPLETE Column stats: COMPLETE - HybridGraceHashJoin: true - Select Operator - expressions: UDFToInteger(_col0) (type: int), _col2 (type: string) - outputColumnNames: _col0, _col1 - Statistics: Num rows: 1219 Data size: 115805 Basic stats: COMPLETE Column stats: COMPLETE - File Output Operator - compressed: false - Statistics: Num rows: 1219 Data size: 115805 Basic stats: COMPLETE Column stats: COMPLETE - table: - input format: org.apache.hadoop.mapred.TextInputFormat - output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat - serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe - name: default.dest_j1 - - Stage: Stage-2 - Dependency Collection - - Stage: Stage-0 - Move Operator - tables: - replace: true - table: - input format: org.apache.hadoop.mapred.TextInputFormat - output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat - serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe - name: default.dest_j1 - - Stage: Stage-3 - Stats-Aggr Operator - -PREHOOK: query: FROM src src1 JOIN src src2 ON (src1.key = src2.key) -INSERT OVERWRITE TABLE dest_j1 SELECT src1.key, src2.value -PREHOOK: type: QUERY -PREHOOK: Input: default@src -PREHOOK: Output: default@dest_j1 -POSTHOOK: query: FROM src src1 JOIN src src2 ON (src1.key = src2.key) -INSERT OVERWRITE TABLE dest_j1 SELECT src1.key, src2.value -POSTHOOK: type: QUERY -POSTHOOK: Input: default@src -POSTHOOK: Output: default@dest_j1 -POSTHOOK: Lineage: dest_j1.key EXPRESSION [(src)src1.FieldSchema(name:key, type:string, comment:default), ] -POSTHOOK: Lineage: dest_j1.value SIMPLE [(src)src2.FieldSchema(name:value, type:string, comment:default), ] -PREHOOK: query: SELECT sum(hash(dest_j1.key,dest_j1.value)) FROM dest_j1 -PREHOOK: type: QUERY -PREHOOK: Input: default@dest_j1 -#### A masked pattern was here #### -POSTHOOK: query: SELECT sum(hash(dest_j1.key,dest_j1.value)) FROM dest_j1 -POSTHOOK: type: QUERY -POSTHOOK: Input: default@dest_j1 -#### A masked pattern was here #### -101861029915 http://git-wip-us.apache.org/repos/asf/hive/blob/975a49b6/ql/src/test/results/clientpositive/tez/auto_join21.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/tez/auto_join21.q.out b/ql/src/test/results/clientpositive/tez/auto_join21.q.out deleted file mode 100644 index 9ca8b40..0000000 --- a/ql/src/test/results/clientpositive/tez/auto_join21.q.out +++ /dev/null @@ -1,611 +0,0 @@ -PREHOOK: query: -- SORT_QUERY_RESULTS - -explain -SELECT * FROM src src1 LEFT OUTER JOIN src src2 ON (src1.key = src2.key AND src1.key < 10 AND src2.key > 10) RIGHT OUTER JOIN src src3 ON (src2.key = src3.key AND src3.key < 10) SORT BY src1.key, src1.value, src2.key, src2.value, src3.key, src3.value -PREHOOK: type: QUERY -POSTHOOK: query: -- SORT_QUERY_RESULTS - -explain -SELECT * FROM src src1 LEFT OUTER JOIN src src2 ON (src1.key = src2.key AND src1.key < 10 AND src2.key > 10) RIGHT OUTER JOIN src src3 ON (src2.key = src3.key AND src3.key < 10) SORT BY src1.key, src1.value, src2.key, src2.value, src3.key, src3.value -POSTHOOK: type: QUERY -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), Map 4 (SIMPLE_EDGE), Map 5 (SIMPLE_EDGE) - Reducer 3 <- Reducer 2 (SIMPLE_EDGE) -#### A masked pattern was here #### - Vertices: - Map 1 - Map Operator Tree: - TableScan - alias: src1 - Statistics: Num rows: 500 Data size: 89000 Basic stats: COMPLETE Column stats: COMPLETE - Reduce Output Operator - key expressions: key (type: string) - sort order: + - Map-reduce partition columns: key (type: string) - Statistics: Num rows: 500 Data size: 89000 Basic stats: COMPLETE Column stats: COMPLETE - value expressions: value (type: string) - Map 4 - Map Operator Tree: - TableScan - alias: src2 - Statistics: Num rows: 500 Data size: 89000 Basic stats: COMPLETE Column stats: COMPLETE - Filter Operator - predicate: (key > 10) (type: boolean) - Statistics: Num rows: 166 Data size: 29548 Basic stats: COMPLETE Column stats: COMPLETE - Reduce Output Operator - key expressions: key (type: string) - sort order: + - Map-reduce partition columns: key (type: string) - Statistics: Num rows: 166 Data size: 29548 Basic stats: COMPLETE Column stats: COMPLETE - value expressions: value (type: string) - Map 5 - Map Operator Tree: - TableScan - alias: src3 - Statistics: Num rows: 500 Data size: 89000 Basic stats: COMPLETE Column stats: COMPLETE - Reduce Output Operator - key expressions: key (type: string) - sort order: + - Map-reduce partition columns: key (type: string) - Statistics: Num rows: 500 Data size: 89000 Basic stats: COMPLETE Column stats: COMPLETE - value expressions: value (type: string) - Reducer 2 - Reduce Operator Tree: - Merge Join Operator - condition map: - Left Outer Join0 to 1 - Right Outer Join1 to 2 - filter predicates: - 0 {(KEY.reducesinkkey0 < 10)} - 1 - 2 {(KEY.reducesinkkey0 < 10)} - keys: - 0 key (type: string) - 1 key (type: string) - 2 key (type: string) - outputColumnNames: _col0, _col1, _col5, _col6, _col10, _col11 - Statistics: Num rows: 987 Data size: 527058 Basic stats: COMPLETE Column stats: COMPLETE - Select Operator - expressions: _col0 (type: string), _col1 (type: string), _col5 (type: string), _col6 (type: string), _col10 (type: string), _col11 (type: string) - outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5 - Statistics: Num rows: 987 Data size: 527058 Basic stats: COMPLETE Column stats: COMPLETE - Reduce Output Operator - key expressions: _col0 (type: string), _col1 (type: string), _col2 (type: string), _col3 (type: string), _col4 (type: string), _col5 (type: string) - sort order: ++++++ - Statistics: Num rows: 987 Data size: 527058 Basic stats: COMPLETE Column stats: COMPLETE - Reducer 3 - Reduce Operator Tree: - Select Operator - expressions: KEY.reducesinkkey0 (type: string), KEY.reducesinkkey1 (type: string), KEY.reducesinkkey2 (type: string), KEY.reducesinkkey3 (type: string), KEY.reducesinkkey4 (type: string), KEY.reducesinkkey5 (type: string) - outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5 - Statistics: Num rows: 987 Data size: 527058 Basic stats: COMPLETE Column stats: COMPLETE - File Output Operator - compressed: false - Statistics: Num rows: 987 Data size: 527058 Basic stats: COMPLETE Column stats: COMPLETE - 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 * FROM src src1 LEFT OUTER JOIN src src2 ON (src1.key = src2.key AND src1.key < 10 AND src2.key > 10) RIGHT OUTER JOIN src src3 ON (src2.key = src3.key AND src3.key < 10) SORT BY src1.key, src1.value, src2.key, src2.value, src3.key, src3.value -PREHOOK: type: QUERY -PREHOOK: Input: default@src -#### A masked pattern was here #### -POSTHOOK: query: SELECT * FROM src src1 LEFT OUTER JOIN src src2 ON (src1.key = src2.key AND src1.key < 10 AND src2.key > 10) RIGHT OUTER JOIN src src3 ON (src2.key = src3.key AND src3.key < 10) SORT BY src1.key, src1.value, src2.key, src2.value, src3.key, src3.value -POSTHOOK: type: QUERY -POSTHOOK: Input: default@src -#### A masked pattern was here #### -NULL NULL NULL NULL 0 val_0 -NULL NULL NULL NULL 0 val_0 -NULL NULL NULL NULL 0 val_0 -NULL NULL NULL NULL 10 val_10 -NULL NULL NULL NULL 100 val_100 -NULL NULL NULL NULL 100 val_100 -NULL NULL NULL NULL 103 val_103 -NULL NULL NULL NULL 103 val_103 -NULL NULL NULL NULL 104 val_104 -NULL NULL NULL NULL 104 val_104 -NULL NULL NULL NULL 105 val_105 -NULL NULL NULL NULL 11 val_11 -NULL NULL NULL NULL 111 val_111 -NULL NULL NULL NULL 113 val_113 -NULL NULL NULL NULL 113 val_113 -NULL NULL NULL NULL 114 val_114 -NULL NULL NULL NULL 116 val_116 -NULL NULL NULL NULL 118 val_118 -NULL NULL NULL NULL 118 val_118 -NULL NULL NULL NULL 119 val_119 -NULL NULL NULL NULL 119 val_119 -NULL NULL NULL NULL 119 val_119 -NULL NULL NULL NULL 12 val_12 -NULL NULL NULL NULL 12 val_12 -NULL NULL NULL NULL 120 val_120 -NULL NULL NULL NULL 120 val_120 -NULL NULL NULL NULL 125 val_125 -NULL NULL NULL NULL 125 val_125 -NULL NULL NULL NULL 126 val_126 -NULL NULL NULL NULL 128 val_128 -NULL NULL NULL NULL 128 val_128 -NULL NULL NULL NULL 128 val_128 -NULL NULL NULL NULL 129 val_129 -NULL NULL NULL NULL 129 val_129 -NULL NULL NULL NULL 131 val_131 -NULL NULL NULL NULL 133 val_133 -NULL NULL NULL NULL 134 val_134 -NULL NULL NULL NULL 134 val_134 -NULL NULL NULL NULL 136 val_136 -NULL NULL NULL NULL 137 val_137 -NULL NULL NULL NULL 137 val_137 -NULL NULL NULL NULL 138 val_138 -NULL NULL NULL NULL 138 val_138 -NULL NULL NULL NULL 138 val_138 -NULL NULL NULL NULL 138 val_138 -NULL NULL NULL NULL 143 val_143 -NULL NULL NULL NULL 145 val_145 -NULL NULL NULL NULL 146 val_146 -NULL NULL NULL NULL 146 val_146 -NULL NULL NULL NULL 149 val_149 -NULL NULL NULL NULL 149 val_149 -NULL NULL NULL NULL 15 val_15 -NULL NULL NULL NULL 15 val_15 -NULL NULL NULL NULL 150 val_150 -NULL NULL NULL NULL 152 val_152 -NULL NULL NULL NULL 152 val_152 -NULL NULL NULL NULL 153 val_153 -NULL NULL NULL NULL 155 val_155 -NULL NULL NULL NULL 156 val_156 -NULL NULL NULL NULL 157 val_157 -NULL NULL NULL NULL 158 val_158 -NULL NULL NULL NULL 160 val_160 -NULL NULL NULL NULL 162 val_162 -NULL NULL NULL NULL 163 val_163 -NULL NULL NULL NULL 164 val_164 -NULL NULL NULL NULL 164 val_164 -NULL NULL NULL NULL 165 val_165 -NULL NULL NULL NULL 165 val_165 -NULL NULL NULL NULL 166 val_166 -NULL NULL NULL NULL 167 val_167 -NULL NULL NULL NULL 167 val_167 -NULL NULL NULL NULL 167 val_167 -NULL NULL NULL NULL 168 val_168 -NULL NULL NULL NULL 169 val_169 -NULL NULL NULL NULL 169 val_169 -NULL NULL NULL NULL 169 val_169 -NULL NULL NULL NULL 169 val_169 -NULL NULL NULL NULL 17 val_17 -NULL NULL NULL NULL 170 val_170 -NULL NULL NULL NULL 172 val_172 -NULL NULL NULL NULL 172 val_172 -NULL NULL NULL NULL 174 val_174 -NULL NULL NULL NULL 174 val_174 -NULL NULL NULL NULL 175 val_175 -NULL NULL NULL NULL 175 val_175 -NULL NULL NULL NULL 176 val_176 -NULL NULL NULL NULL 176 val_176 -NULL NULL NULL NULL 177 val_177 -NULL NULL NULL NULL 178 val_178 -NULL NULL NULL NULL 179 val_179 -NULL NULL NULL NULL 179 val_179 -NULL NULL NULL NULL 18 val_18 -NULL NULL NULL NULL 18 val_18 -NULL NULL NULL NULL 180 val_180 -NULL NULL NULL NULL 181 val_181 -NULL NULL NULL NULL 183 val_183 -NULL NULL NULL NULL 186 val_186 -NULL NULL NULL NULL 187 val_187 -NULL NULL NULL NULL 187 val_187 -NULL NULL NULL NULL 187 val_187 -NULL NULL NULL NULL 189 val_189 -NULL NULL NULL NULL 19 val_19 -NULL NULL NULL NULL 190 val_190 -NULL NULL NULL NULL 191 val_191 -NULL NULL NULL NULL 191 val_191 -NULL NULL NULL NULL 192 val_192 -NULL NULL NULL NULL 193 val_193 -NULL NULL NULL NULL 193 val_193 -NULL NULL NULL NULL 193 val_193 -NULL NULL NULL NULL 194 val_194 -NULL NULL NULL NULL 195 val_195 -NULL NULL NULL NULL 195 val_195 -NULL NULL NULL NULL 196 val_196 -NULL NULL NULL NULL 197 val_197 -NULL NULL NULL NULL 197 val_197 -NULL NULL NULL NULL 199 val_199 -NULL NULL NULL NULL 199 val_199 -NULL NULL NULL NULL 199 val_199 -NULL NULL NULL NULL 2 val_2 -NULL NULL NULL NULL 20 val_20 -NULL NULL NULL NULL 200 val_200 -NULL NULL NULL NULL 200 val_200 -NULL NULL NULL NULL 201 val_201 -NULL NULL NULL NULL 202 val_202 -NULL NULL NULL NULL 203 val_203 -NULL NULL NULL NULL 203 val_203 -NULL NULL NULL NULL 205 val_205 -NULL NULL NULL NULL 205 val_205 -NULL NULL NULL NULL 207 val_207 -NULL NULL NULL NULL 207 val_207 -NULL NULL NULL NULL 208 val_208 -NULL NULL NULL NULL 208 val_208 -NULL NULL NULL NULL 208 val_208 -NULL NULL NULL NULL 209 val_209 -NULL NULL NULL NULL 209 val_209 -NULL NULL NULL NULL 213 val_213 -NULL NULL NULL NULL 213 val_213 -NULL NULL NULL NULL 214 val_214 -NULL NULL NULL NULL 216 val_216 -NULL NULL NULL NULL 216 val_216 -NULL NULL NULL NULL 217 val_217 -NULL NULL NULL NULL 217 val_217 -NULL NULL NULL NULL 218 val_218 -NULL NULL NULL NULL 219 val_219 -NULL NULL NULL NULL 219 val_219 -NULL NULL NULL NULL 221 val_221 -NULL NULL NULL NULL 221 val_221 -NULL NULL NULL NULL 222 val_222 -NULL NULL NULL NULL 223 val_223 -NULL NULL NULL NULL 223 val_223 -NULL NULL NULL NULL 224 val_224 -NULL NULL NULL NULL 224 val_224 -NULL NULL NULL NULL 226 val_226 -NULL NULL NULL NULL 228 val_228 -NULL NULL NULL NULL 229 val_229 -NULL NULL NULL NULL 229 val_229 -NULL NULL NULL NULL 230 val_230 -NULL NULL NULL NULL 230 val_230 -NULL NULL NULL NULL 230 val_230 -NULL NULL NULL NULL 230 val_230 -NULL NULL NULL NULL 230 val_230 -NULL NULL NULL NULL 233 val_233 -NULL NULL NULL NULL 233 val_233 -NULL NULL NULL NULL 235 val_235 -NULL NULL NULL NULL 237 val_237 -NULL NULL NULL NULL 237 val_237 -NULL NULL NULL NULL 238 val_238 -NULL NULL NULL NULL 238 val_238 -NULL NULL NULL NULL 239 val_239 -NULL NULL NULL NULL 239 val_239 -NULL NULL NULL NULL 24 val_24 -NULL NULL NULL NULL 24 val_24 -NULL NULL NULL NULL 241 val_241 -NULL NULL NULL NULL 242 val_242 -NULL NULL NULL NULL 242 val_242 -NULL NULL NULL NULL 244 val_244 -NULL NULL NULL NULL 247 val_247 -NULL NULL NULL NULL 248 val_248 -NULL NULL NULL NULL 249 val_249 -NULL NULL NULL NULL 252 val_252 -NULL NULL NULL NULL 255 val_255 -NULL NULL NULL NULL 255 val_255 -NULL NULL NULL NULL 256 val_256 -NULL NULL NULL NULL 256 val_256 -NULL NULL NULL NULL 257 val_257 -NULL NULL NULL NULL 258 val_258 -NULL NULL NULL NULL 26 val_26 -NULL NULL NULL NULL 26 val_26 -NULL NULL NULL NULL 260 val_260 -NULL NULL NULL NULL 262 val_262 -NULL NULL NULL NULL 263 val_263 -NULL NULL NULL NULL 265 val_265 -NULL NULL NULL NULL 265 val_265 -NULL NULL NULL NULL 266 val_266 -NULL NULL NULL NULL 27 val_27 -NULL NULL NULL NULL 272 val_272 -NULL NULL NULL NULL 272 val_272 -NULL NULL NULL NULL 273 val_273 -NULL NULL NULL NULL 273 val_273 -NULL NULL NULL NULL 273 val_273 -NULL NULL NULL NULL 274 val_274 -NULL NULL NULL NULL 275 val_275 -NULL NULL NULL NULL 277 val_277 -NULL NULL NULL NULL 277 val_277 -NULL NULL NULL NULL 277 val_277 -NULL NULL NULL NULL 277 val_277 -NULL NULL NULL NULL 278 val_278 -NULL NULL NULL NULL 278 val_278 -NULL NULL NULL NULL 28 val_28 -NULL NULL NULL NULL 280 val_280 -NULL NULL NULL NULL 280 val_280 -NULL NULL NULL NULL 281 val_281 -NULL NULL NULL NULL 281 val_281 -NULL NULL NULL NULL 282 val_282 -NULL NULL NULL NULL 282 val_282 -NULL NULL NULL NULL 283 val_283 -NULL NULL NULL NULL 284 val_284 -NULL NULL NULL NULL 285 val_285 -NULL NULL NULL NULL 286 val_286 -NULL NULL NULL NULL 287 val_287 -NULL NULL NULL NULL 288 val_288 -NULL NULL NULL NULL 288 val_288 -NULL NULL NULL NULL 289 val_289 -NULL NULL NULL NULL 291 val_291 -NULL NULL NULL NULL 292 val_292 -NULL NULL NULL NULL 296 val_296 -NULL NULL NULL NULL 298 val_298 -NULL NULL NULL NULL 298 val_298 -NULL NULL NULL NULL 298 val_298 -NULL NULL NULL NULL 30 val_30 -NULL NULL NULL NULL 302 val_302 -NULL NULL NULL NULL 305 val_305 -NULL NULL NULL NULL 306 val_306 -NULL NULL NULL NULL 307 val_307 -NULL NULL NULL NULL 307 val_307 -NULL NULL NULL NULL 308 val_308 -NULL NULL NULL NULL 309 val_309 -NULL NULL NULL NULL 309 val_309 -NULL NULL NULL NULL 310 val_310 -NULL NULL NULL NULL 311 val_311 -NULL NULL NULL NULL 311 val_311 -NULL NULL NULL NULL 311 val_311 -NULL NULL NULL NULL 315 val_315 -NULL NULL NULL NULL 316 val_316 -NULL NULL NULL NULL 316 val_316 -NULL NULL NULL NULL 316 val_316 -NULL NULL NULL NULL 317 val_317 -NULL NULL NULL NULL 317 val_317 -NULL NULL NULL NULL 318 val_318 -NULL NULL NULL NULL 318 val_318 -NULL NULL NULL NULL 318 val_318 -NULL NULL NULL NULL 321 val_321 -NULL NULL NULL NULL 321 val_321 -NULL NULL NULL NULL 322 val_322 -NULL NULL NULL NULL 322 val_322 -NULL NULL NULL NULL 323 val_323 -NULL NULL NULL NULL 325 val_325 -NULL NULL NULL NULL 325 val_325 -NULL NULL NULL NULL 327 val_327 -NULL NULL NULL NULL 327 val_327 -NULL NULL NULL NULL 327 val_327 -NULL NULL NULL NULL 33 val_33 -NULL NULL NULL NULL 331 val_331 -NULL NULL NULL NULL 331 val_331 -NULL NULL NULL NULL 332 val_332 -NULL NULL NULL NULL 333 val_333 -NULL NULL NULL NULL 333 val_333 -NULL NULL NULL NULL 335 val_335 -NULL NULL NULL NULL 336 val_336 -NULL NULL NULL NULL 338 val_338 -NULL NULL NULL NULL 339 val_339 -NULL NULL NULL NULL 34 val_34 -NULL NULL NULL NULL 341 val_341 -NULL NULL NULL NULL 342 val_342 -NULL NULL NULL NULL 342 val_342 -NULL NULL NULL NULL 344 val_344 -NULL NULL NULL NULL 344 val_344 -NULL NULL NULL NULL 345 val_345 -NULL NULL NULL NULL 348 val_348 -NULL NULL NULL NULL 348 val_348 -NULL NULL NULL NULL 348 val_348 -NULL NULL NULL NULL 348 val_348 -NULL NULL NULL NULL 348 val_348 -NULL NULL NULL NULL 35 val_35 -NULL NULL NULL NULL 35 val_35 -NULL NULL NULL NULL 35 val_35 -NULL NULL NULL NULL 351 val_351 -NULL NULL NULL NULL 353 val_353 -NULL NULL NULL NULL 353 val_353 -NULL NULL NULL NULL 356 val_356 -NULL NULL NULL NULL 360 val_360 -NULL NULL NULL NULL 362 val_362 -NULL NULL NULL NULL 364 val_364 -NULL NULL NULL NULL 365 val_365 -NULL NULL NULL NULL 366 val_366 -NULL NULL NULL NULL 367 val_367 -NULL NULL NULL NULL 367 val_367 -NULL NULL NULL NULL 368 val_368 -NULL NULL NULL NULL 369 val_369 -NULL NULL NULL NULL 369 val_369 -NULL NULL NULL NULL 369 val_369 -NULL NULL NULL NULL 37 val_37 -NULL NULL NULL NULL 37 val_37 -NULL NULL NULL NULL 373 val_373 -NULL NULL NULL NULL 374 val_374 -NULL NULL NULL NULL 375 val_375 -NULL NULL NULL NULL 377 val_377 -NULL NULL NULL NULL 378 val_378 -NULL NULL NULL NULL 379 val_379 -NULL NULL NULL NULL 382 val_382 -NULL NULL NULL NULL 382 val_382 -NULL NULL NULL NULL 384 val_384 -NULL NULL NULL NULL 384 val_384 -NULL NULL NULL NULL 384 val_384 -NULL NULL NULL NULL 386 val_386 -NULL NULL NULL NULL 389 val_389 -NULL NULL NULL NULL 392 val_392 -NULL NULL NULL NULL 393 val_393 -NULL NULL NULL NULL 394 val_394 -NULL NULL NULL NULL 395 val_395 -NULL NULL NULL NULL 395 val_395 -NULL NULL NULL NULL 396 val_396 -NULL NULL NULL NULL 396 val_396 -NULL NULL NULL NULL 396 val_396 -NULL NULL NULL NULL 397 val_397 -NULL NULL NULL NULL 397 val_397 -NULL NULL NULL NULL 399 val_399 -NULL NULL NULL NULL 399 val_399 -NULL NULL NULL NULL 4 val_4 -NULL NULL NULL NULL 400 val_400 -NULL NULL NULL NULL 401 val_401 -NULL NULL NULL NULL 401 val_401 -NULL NULL NULL NULL 401 val_401 -NULL NULL NULL NULL 401 val_401 -NULL NULL NULL NULL 401 val_401 -NULL NULL NULL NULL 402 val_402 -NULL NULL NULL NULL 403 val_403 -NULL NULL NULL NULL 403 val_403 -NULL NULL NULL NULL 403 val_403 -NULL NULL NULL NULL 404 val_404 -NULL NULL NULL NULL 404 val_404 -NULL NULL NULL NULL 406 val_406 -NULL NULL NULL NULL 406 val_406 -NULL NULL NULL NULL 406 val_406 -NULL NULL NULL NULL 406 val_406 -NULL NULL NULL NULL 407 val_407 -NULL NULL NULL NULL 409 val_409 -NULL NULL NULL NULL 409 val_409 -NULL NULL NULL NULL 409 val_409 -NULL NULL NULL NULL 41 val_41 -NULL NULL NULL NULL 411 val_411 -NULL NULL NULL NULL 413 val_413 -NULL NULL NULL NULL 413 val_413 -NULL NULL NULL NULL 414 val_414 -NULL NULL NULL NULL 414 val_414 -NULL NULL NULL NULL 417 val_417 -NULL NULL NULL NULL 417 val_417 -NULL NULL NULL NULL 417 val_417 -NULL NULL NULL NULL 418 val_418 -NULL NULL NULL NULL 419 val_419 -NULL NULL NULL NULL 42 val_42 -NULL NULL NULL NULL 42 val_42 -NULL NULL NULL NULL 421 val_421 -NULL NULL NULL NULL 424 val_424 -NULL NULL NULL NULL 424 val_424 -NULL NULL NULL NULL 427 val_427 -NULL NULL NULL NULL 429 val_429 -NULL NULL NULL NULL 429 val_429 -NULL NULL NULL NULL 43 val_43 -NULL NULL NULL NULL 430 val_430 -NULL NULL NULL NULL 430 val_430 -NULL NULL NULL NULL 430 val_430 -NULL NULL NULL NULL 431 val_431 -NULL NULL NULL NULL 431 val_431 -NULL NULL NULL NULL 431 val_431 -NULL NULL NULL NULL 432 val_432 -NULL NULL NULL NULL 435 val_435 -NULL NULL NULL NULL 436 val_436 -NULL NULL NULL NULL 437 val_437 -NULL NULL NULL NULL 438 val_438 -NULL NULL NULL NULL 438 val_438 -NULL NULL NULL NULL 438 val_438 -NULL NULL NULL NULL 439 val_439 -NULL NULL NULL NULL 439 val_439 -NULL NULL NULL NULL 44 val_44 -NULL NULL NULL NULL 443 val_443 -NULL NULL NULL NULL 444 val_444 -NULL NULL NULL NULL 446 val_446 -NULL NULL NULL NULL 448 val_448 -NULL NULL NULL NULL 449 val_449 -NULL NULL NULL NULL 452 val_452 -NULL NULL NULL NULL 453 val_453 -NULL NULL NULL NULL 454 val_454 -NULL NULL NULL NULL 454 val_454 -NULL NULL NULL NULL 454 val_454 -NULL NULL NULL NULL 455 val_455 -NULL NULL NULL NULL 457 val_457 -NULL NULL NULL NULL 458 val_458 -NULL NULL NULL NULL 458 val_458 -NULL NULL NULL NULL 459 val_459 -NULL NULL NULL NULL 459 val_459 -NULL NULL NULL NULL 460 val_460 -NULL NULL NULL NULL 462 val_462 -NULL NULL NULL NULL 462 val_462 -NULL NULL NULL NULL 463 val_463 -NULL NULL NULL NULL 463 val_463 -NULL NULL NULL NULL 466 val_466 -NULL NULL NULL NULL 466 val_466 -NULL NULL NULL NULL 466 val_466 -NULL NULL NULL NULL 467 val_467 -NULL NULL NULL NULL 468 val_468 -NULL NULL NULL NULL 468 val_468 -NULL NULL NULL NULL 468 val_468 -NULL NULL NULL NULL 468 val_468 -NULL NULL NULL NULL 469 val_469 -NULL NULL NULL NULL 469 val_469 -NULL NULL NULL NULL 469 val_469 -NULL NULL NULL NULL 469 val_469 -NULL NULL NULL NULL 469 val_469 -NULL NULL NULL NULL 47 val_47 -NULL NULL NULL NULL 470 val_470 -NULL NULL NULL NULL 472 val_472 -NULL NULL NULL NULL 475 val_475 -NULL NULL NULL NULL 477 val_477 -NULL NULL NULL NULL 478 val_478 -NULL NULL NULL NULL 478 val_478 -NULL NULL NULL NULL 479 val_479 -NULL NULL NULL NULL 480 val_480 -NULL NULL NULL NULL 480 val_480 -NULL NULL NULL NULL 480 val_480 -NULL NULL NULL NULL 481 val_481 -NULL NULL NULL NULL 482 val_482 -NULL NULL NULL NULL 483 val_483 -NULL NULL NULL NULL 484 val_484 -NULL NULL NULL NULL 485 val_485 -NULL NULL NULL NULL 487 val_487 -NULL NULL NULL NULL 489 val_489 -NULL NULL NULL NULL 489 val_489 -NULL NULL NULL NULL 489 val_489 -NULL NULL NULL NULL 489 val_489 -NULL NULL NULL NULL 490 val_490 -NULL NULL NULL NULL 491 val_491 -NULL NULL NULL NULL 492 val_492 -NULL NULL NULL NULL 492 val_492 -NULL NULL NULL NULL 493 val_493 -NULL NULL NULL NULL 494 val_494 -NULL NULL NULL NULL 495 val_495 -NULL NULL NULL NULL 496 val_496 -NULL NULL NULL NULL 497 val_497 -NULL NULL NULL NULL 498 val_498 -NULL NULL NULL NULL 498 val_498 -NULL NULL NULL NULL 498 val_498 -NULL NULL NULL NULL 5 val_5 -NULL NULL NULL NULL 5 val_5 -NULL NULL NULL NULL 5 val_5 -NULL NULL NULL NULL 51 val_51 -NULL NULL NULL NULL 51 val_51 -NULL NULL NULL NULL 53 val_53 -NULL NULL NULL NULL 54 val_54 -NULL NULL NULL NULL 57 val_57 -NULL NULL NULL NULL 58 val_58 -NULL NULL NULL NULL 58 val_58 -NULL NULL NULL NULL 64 val_64 -NULL NULL NULL NULL 65 val_65 -NULL NULL NULL NULL 66 val_66 -NULL NULL NULL NULL 67 val_67 -NULL NULL NULL NULL 67 val_67 -NULL NULL NULL NULL 69 val_69 -NULL NULL NULL NULL 70 val_70 -NULL NULL NULL NULL 70 val_70 -NULL NULL NULL NULL 70 val_70 -NULL NULL NULL NULL 72 val_72 -NULL NULL NULL NULL 72 val_72 -NULL NULL NULL NULL 74 val_74 -NULL NULL NULL NULL 76 val_76 -NULL NULL NULL NULL 76 val_76 -NULL NULL NULL NULL 77 val_77 -NULL NULL NULL NULL 78 val_78 -NULL NULL NULL NULL 8 val_8 -NULL NULL NULL NULL 80 val_80 -NULL NULL NULL NULL 82 val_82 -NULL NULL NULL NULL 83 val_83 -NULL NULL NULL NULL 83 val_83 -NULL NULL NULL NULL 84 val_84 -NULL NULL NULL NULL 84 val_84 -NULL NULL NULL NULL 85 val_85 -NULL NULL NULL NULL 86 val_86 -NULL NULL NULL NULL 87 val_87 -NULL NULL NULL NULL 9 val_9 -NULL NULL NULL NULL 90 val_90 -NULL NULL NULL NULL 90 val_90 -NULL NULL NULL NULL 90 val_90 -NULL NULL NULL NULL 92 val_92 -NULL NULL NULL NULL 95 val_95 -NULL NULL NULL NULL 95 val_95 -NULL NULL NULL NULL 96 val_96 -NULL NULL NULL NULL 97 val_97 -NULL NULL NULL NULL 97 val_97 -NULL NULL NULL NULL 98 val_98 -NULL NULL NULL NULL 98 val_98
