PageRenderTime 29ms CodeModel.GetById 17ms app.highlight 6ms RepoModel.GetById 1ms app.codeStats 0ms

/tags/release-0.2.0-rc0/hive/external/ql/src/test/results/clientpositive/union17.q.out

#
text | 961 lines | 947 code | 14 blank | 0 comment | 0 complexity | 16c76637a105fc1ac4af720abaa92c45 MD5 | raw file
  1PREHOOK: query: CREATE TABLE DEST1(key STRING, value STRING) STORED AS TEXTFILE
  2PREHOOK: type: CREATETABLE
  3POSTHOOK: query: CREATE TABLE DEST1(key STRING, value STRING) STORED AS TEXTFILE
  4POSTHOOK: type: CREATETABLE
  5POSTHOOK: Output: default@DEST1
  6PREHOOK: query: CREATE TABLE DEST2(key STRING, val1 STRING, val2 STRING) STORED AS TEXTFILE
  7PREHOOK: type: CREATETABLE
  8POSTHOOK: query: CREATE TABLE DEST2(key STRING, val1 STRING, val2 STRING) STORED AS TEXTFILE
  9POSTHOOK: type: CREATETABLE
 10POSTHOOK: Output: default@DEST2
 11PREHOOK: query: -- union case:map-reduce sub-queries followed by multi-table insert
 12
 13explain 
 14FROM (select 'tst1' as key, cast(count(1) as string) as value from src s1
 15                         UNION  ALL  
 16      select s2.key as key, s2.value as value from src s2) unionsrc
 17INSERT OVERWRITE TABLE DEST1 SELECT unionsrc.key, COUNT(DISTINCT SUBSTR(unionsrc.value,5)) GROUP BY unionsrc.key
 18INSERT OVERWRITE TABLE DEST2 SELECT unionsrc.key, unionsrc.value, COUNT(DISTINCT SUBSTR(unionsrc.value,5)) GROUP BY unionsrc.key, unionsrc.value
 19PREHOOK: type: QUERY
 20POSTHOOK: query: -- union case:map-reduce sub-queries followed by multi-table insert
 21
 22explain 
 23FROM (select 'tst1' as key, cast(count(1) as string) as value from src s1
 24                         UNION  ALL  
 25      select s2.key as key, s2.value as value from src s2) unionsrc
 26INSERT OVERWRITE TABLE DEST1 SELECT unionsrc.key, COUNT(DISTINCT SUBSTR(unionsrc.value,5)) GROUP BY unionsrc.key
 27INSERT OVERWRITE TABLE DEST2 SELECT unionsrc.key, unionsrc.value, COUNT(DISTINCT SUBSTR(unionsrc.value,5)) GROUP BY unionsrc.key, unionsrc.value
 28POSTHOOK: type: QUERY
 29ABSTRACT SYNTAX TREE:
 30  (TOK_QUERY (TOK_FROM (TOK_SUBQUERY (TOK_UNION (TOK_QUERY (TOK_FROM (TOK_TABREF (TOK_TABNAME src) s1)) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR 'tst1' key) (TOK_SELEXPR (TOK_FUNCTION TOK_STRING (TOK_FUNCTION count 1)) value)))) (TOK_QUERY (TOK_FROM (TOK_TABREF (TOK_TABNAME src) s2)) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR (. (TOK_TABLE_OR_COL s2) key) key) (TOK_SELEXPR (. (TOK_TABLE_OR_COL s2) value) value))))) unionsrc)) (TOK_INSERT (TOK_DESTINATION (TOK_TAB (TOK_TABNAME DEST1))) (TOK_SELECT (TOK_SELEXPR (. (TOK_TABLE_OR_COL unionsrc) key)) (TOK_SELEXPR (TOK_FUNCTIONDI COUNT (TOK_FUNCTION SUBSTR (. (TOK_TABLE_OR_COL unionsrc) value) 5)))) (TOK_GROUPBY (. (TOK_TABLE_OR_COL unionsrc) key))) (TOK_INSERT (TOK_DESTINATION (TOK_TAB (TOK_TABNAME DEST2))) (TOK_SELECT (TOK_SELEXPR (. (TOK_TABLE_OR_COL unionsrc) key)) (TOK_SELEXPR (. (TOK_TABLE_OR_COL unionsrc) value)) (TOK_SELEXPR (TOK_FUNCTIONDI COUNT (TOK_FUNCTION SUBSTR (. (TOK_TABLE_OR_COL unionsrc) value) 5)))) (TOK_GROUPBY (. (TOK_TABLE_OR_COL unionsrc) key) (. (TOK_TABLE_OR_COL unionsrc) value))))
 31
 32STAGE DEPENDENCIES:
 33  Stage-2 is a root stage
 34  Stage-3 depends on stages: Stage-2, Stage-8
 35  Stage-4 depends on stages: Stage-3
 36  Stage-0 depends on stages: Stage-4
 37  Stage-5 depends on stages: Stage-0
 38  Stage-6 depends on stages: Stage-3
 39  Stage-1 depends on stages: Stage-6
 40  Stage-7 depends on stages: Stage-1
 41  Stage-8 is a root stage
 42
 43STAGE PLANS:
 44  Stage: Stage-2
 45    Map Reduce
 46      Alias -> Map Operator Tree:
 47        null-subquery1:unionsrc-subquery1:s1 
 48          TableScan
 49            alias: s1
 50            Select Operator
 51              Group By Operator
 52                aggregations:
 53                      expr: count(1)
 54                bucketGroup: false
 55                mode: hash
 56                outputColumnNames: _col0
 57                Reduce Output Operator
 58                  sort order: 
 59                  tag: -1
 60                  value expressions:
 61                        expr: _col0
 62                        type: bigint
 63      Reduce Operator Tree:
 64        Group By Operator
 65          aggregations:
 66                expr: count(VALUE._col0)
 67          bucketGroup: false
 68          mode: mergepartial
 69          outputColumnNames: _col0
 70          Select Operator
 71            expressions:
 72                  expr: 'tst1'
 73                  type: string
 74                  expr: UDFToString(_col0)
 75                  type: string
 76            outputColumnNames: _col0, _col1
 77            File Output Operator
 78              compressed: false
 79              GlobalTableId: 0
 80              table:
 81                  input format: org.apache.hadoop.mapred.SequenceFileInputFormat
 82                  output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
 83
 84  Stage: Stage-3
 85    Map Reduce
 86      Alias -> Map Operator Tree:
 87        file:/tmp/sdong/hive_2011-02-10_17-49-53_652_5953303330246119337/-mr-10004 
 88          Union
 89            Reduce Output Operator
 90              key expressions:
 91                    expr: substr(_col1, 5)
 92                    type: string
 93              sort order: +
 94              Map-reduce partition columns:
 95                    expr: substr(_col1, 5)
 96                    type: string
 97              tag: -1
 98              value expressions:
 99                    expr: _col0
100                    type: string
101                    expr: _col1
102                    type: string
103        file:/tmp/sdong/hive_2011-02-10_17-49-53_652_5953303330246119337/-mr-10007 
104          Union
105            Reduce Output Operator
106              key expressions:
107                    expr: substr(_col1, 5)
108                    type: string
109              sort order: +
110              Map-reduce partition columns:
111                    expr: substr(_col1, 5)
112                    type: string
113              tag: -1
114              value expressions:
115                    expr: _col0
116                    type: string
117                    expr: _col1
118                    type: string
119      Reduce Operator Tree:
120        Forward
121          Group By Operator
122            aggregations:
123                  expr: count(DISTINCT KEY._col0)
124            bucketGroup: false
125            keys:
126                  expr: VALUE._col0
127                  type: string
128            mode: hash
129            outputColumnNames: _col0, _col1
130            File Output Operator
131              compressed: false
132              GlobalTableId: 0
133              table:
134                  input format: org.apache.hadoop.mapred.SequenceFileInputFormat
135                  output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
136          Group By Operator
137            aggregations:
138                  expr: count(DISTINCT KEY._col0)
139            bucketGroup: false
140            keys:
141                  expr: VALUE._col0
142                  type: string
143                  expr: VALUE._col1
144                  type: string
145            mode: hash
146            outputColumnNames: _col0, _col1, _col2
147            File Output Operator
148              compressed: false
149              GlobalTableId: 0
150              table:
151                  input format: org.apache.hadoop.mapred.SequenceFileInputFormat
152                  output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
153
154  Stage: Stage-4
155    Map Reduce
156      Alias -> Map Operator Tree:
157        file:/tmp/sdong/hive_2011-02-10_17-49-53_652_5953303330246119337/-mr-10005 
158            Reduce Output Operator
159              key expressions:
160                    expr: _col0
161                    type: string
162              sort order: +
163              Map-reduce partition columns:
164                    expr: _col0
165                    type: string
166              tag: -1
167              value expressions:
168                    expr: _col1
169                    type: bigint
170      Reduce Operator Tree:
171        Group By Operator
172          aggregations:
173                expr: count(VALUE._col0)
174          bucketGroup: false
175          keys:
176                expr: KEY._col0
177                type: string
178          mode: final
179          outputColumnNames: _col0, _col1
180          Select Operator
181            expressions:
182                  expr: _col0
183                  type: string
184                  expr: _col1
185                  type: bigint
186            outputColumnNames: _col0, _col1
187            File Output Operator
188              compressed: false
189              GlobalTableId: 1
190              table:
191                  input format: org.apache.hadoop.mapred.TextInputFormat
192                  output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
193                  serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
194                  name: default.dest1
195
196  Stage: Stage-0
197    Move Operator
198      tables:
199          replace: true
200          table:
201              input format: org.apache.hadoop.mapred.TextInputFormat
202              output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
203              serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
204              name: default.dest1
205
206  Stage: Stage-5
207    Stats-Aggr Operator
208
209  Stage: Stage-6
210    Map Reduce
211      Alias -> Map Operator Tree:
212        file:/tmp/sdong/hive_2011-02-10_17-49-53_652_5953303330246119337/-mr-10006 
213            Reduce Output Operator
214              key expressions:
215                    expr: _col0
216                    type: string
217                    expr: _col1
218                    type: string
219              sort order: ++
220              Map-reduce partition columns:
221                    expr: _col0
222                    type: string
223                    expr: _col1
224                    type: string
225              tag: -1
226              value expressions:
227                    expr: _col2
228                    type: bigint
229      Reduce Operator Tree:
230        Group By Operator
231          aggregations:
232                expr: count(VALUE._col0)
233          bucketGroup: false
234          keys:
235                expr: KEY._col0
236                type: string
237                expr: KEY._col1
238                type: string
239          mode: final
240          outputColumnNames: _col0, _col1, _col2
241          Select Operator
242            expressions:
243                  expr: _col0
244                  type: string
245                  expr: _col1
246                  type: string
247                  expr: _col2
248                  type: bigint
249            outputColumnNames: _col0, _col1, _col2
250            File Output Operator
251              compressed: false
252              GlobalTableId: 2
253              table:
254                  input format: org.apache.hadoop.mapred.TextInputFormat
255                  output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
256                  serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
257                  name: default.dest2
258
259  Stage: Stage-1
260    Move Operator
261      tables:
262          replace: true
263          table:
264              input format: org.apache.hadoop.mapred.TextInputFormat
265              output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
266              serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
267              name: default.dest2
268
269  Stage: Stage-7
270    Stats-Aggr Operator
271
272  Stage: Stage-8
273    Map Reduce
274      Alias -> Map Operator Tree:
275        null-subquery2:unionsrc-subquery2:s2 
276          TableScan
277            alias: s2
278            Select Operator
279              expressions:
280                    expr: key
281                    type: string
282                    expr: value
283                    type: string
284              outputColumnNames: _col0, _col1
285              File Output Operator
286                compressed: false
287                GlobalTableId: 0
288                table:
289                    input format: org.apache.hadoop.mapred.SequenceFileInputFormat
290                    output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
291
292
293PREHOOK: query: FROM (select 'tst1' as key, cast(count(1) as string) as value from src s1
294                         UNION  ALL  
295      select s2.key as key, s2.value as value from src s2) unionsrc
296INSERT OVERWRITE TABLE DEST1 SELECT unionsrc.key, COUNT(DISTINCT SUBSTR(unionsrc.value,5)) GROUP BY unionsrc.key
297INSERT OVERWRITE TABLE DEST2 SELECT unionsrc.key, unionsrc.value, COUNT(DISTINCT SUBSTR(unionsrc.value,5)) GROUP BY unionsrc.key, unionsrc.value
298PREHOOK: type: QUERY
299PREHOOK: Input: default@src
300PREHOOK: Output: default@dest1
301PREHOOK: Output: default@dest2
302POSTHOOK: query: FROM (select 'tst1' as key, cast(count(1) as string) as value from src s1
303                         UNION  ALL  
304      select s2.key as key, s2.value as value from src s2) unionsrc
305INSERT OVERWRITE TABLE DEST1 SELECT unionsrc.key, COUNT(DISTINCT SUBSTR(unionsrc.value,5)) GROUP BY unionsrc.key
306INSERT OVERWRITE TABLE DEST2 SELECT unionsrc.key, unionsrc.value, COUNT(DISTINCT SUBSTR(unionsrc.value,5)) GROUP BY unionsrc.key, unionsrc.value
307POSTHOOK: type: QUERY
308POSTHOOK: Input: default@src
309POSTHOOK: Output: default@dest1
310POSTHOOK: Output: default@dest2
311POSTHOOK: Lineage: dest1.key EXPRESSION [(src)s2.FieldSchema(name:key, type:string, comment:default), ]
312POSTHOOK: Lineage: dest1.value EXPRESSION [(src)s1.null, (src)s2.FieldSchema(name:value, type:string, comment:default), ]
313POSTHOOK: Lineage: dest2.key EXPRESSION [(src)s2.FieldSchema(name:key, type:string, comment:default), ]
314POSTHOOK: Lineage: dest2.val1 EXPRESSION [(src)s1.null, (src)s2.FieldSchema(name:value, type:string, comment:default), ]
315POSTHOOK: Lineage: dest2.val2 EXPRESSION [(src)s1.null, (src)s2.FieldSchema(name:value, type:string, comment:default), ]
316PREHOOK: query: SELECT DEST1.* FROM DEST1
317PREHOOK: type: QUERY
318PREHOOK: Input: default@dest1
319PREHOOK: Output: file:/tmp/sdong/hive_2011-02-10_17-50-12_560_4410894515392312905/-mr-10000
320POSTHOOK: query: SELECT DEST1.* FROM DEST1
321POSTHOOK: type: QUERY
322POSTHOOK: Input: default@dest1
323POSTHOOK: Output: file:/tmp/sdong/hive_2011-02-10_17-50-12_560_4410894515392312905/-mr-10000
324POSTHOOK: Lineage: dest1.key EXPRESSION [(src)s2.FieldSchema(name:key, type:string, comment:default), ]
325POSTHOOK: Lineage: dest1.value EXPRESSION [(src)s1.null, (src)s2.FieldSchema(name:value, type:string, comment:default), ]
326POSTHOOK: Lineage: dest2.key EXPRESSION [(src)s2.FieldSchema(name:key, type:string, comment:default), ]
327POSTHOOK: Lineage: dest2.val1 EXPRESSION [(src)s1.null, (src)s2.FieldSchema(name:value, type:string, comment:default), ]
328POSTHOOK: Lineage: dest2.val2 EXPRESSION [(src)s1.null, (src)s2.FieldSchema(name:value, type:string, comment:default), ]
3290	1
33010	1
331100	1
332103	1
333104	1
334105	1
33511	1
336111	1
337113	1
338114	1
339116	1
340118	1
341119	1
34212	1
343120	1
344125	1
345126	1
346128	1
347129	1
348131	1
349133	1
350134	1
351136	1
352137	1
353138	1
354143	1
355145	1
356146	1
357149	1
35815	1
359150	1
360152	1
361153	1
362155	1
363156	1
364157	1
365158	1
366160	1
367162	1
368163	1
369164	1
370165	1
371166	1
372167	1
373168	1
374169	1
37517	1
376170	1
377172	1
378174	1
379175	1
380176	1
381177	1
382178	1
383179	1
38418	1
385180	1
386181	1
387183	1
388186	1
389187	1
390189	1
39119	1
392190	1
393191	1
394192	1
395193	1
396194	1
397195	1
398196	1
399197	1
400199	1
4012	1
40220	1
403200	1
404201	1
405202	1
406203	1
407205	1
408207	1
409208	1
410209	1
411213	1
412214	1
413216	1
414217	1
415218	1
416219	1
417221	1
418222	1
419223	1
420224	1
421226	1
422228	1
423229	1
424230	1
425233	1
426235	1
427237	1
428238	1
429239	1
43024	1
431241	1
432242	1
433244	1
434247	1
435248	1
436249	1
437252	1
438255	1
439256	1
440257	1
441258	1
44226	1
443260	1
444262	1
445263	1
446265	1
447266	1
44827	1
449272	1
450273	1
451274	1
452275	1
453277	1
454278	1
45528	1
456280	1
457281	1
458282	1
459283	1
460284	1
461285	1
462286	1
463287	1
464288	1
465289	1
466291	1
467292	1
468296	1
469298	1
47030	1
471302	1
472305	1
473306	1
474307	1
475308	1
476309	1
477310	1
478311	1
479315	1
480316	1
481317	1
482318	1
483321	1
484322	1
485323	1
486325	1
487327	1
48833	1
489331	1
490332	1
491333	1
492335	1
493336	1
494338	1
495339	1
49634	1
497341	1
498342	1
499344	1
500345	1
501348	1
50235	1
503351	1
504353	1
505356	1
506360	1
507362	1
508364	1
509365	1
510366	1
511367	1
512368	1
513369	1
51437	1
515373	1
516374	1
517375	1
518377	1
519378	1
520379	1
521382	1
522384	1
523386	1
524389	1
525392	1
526393	1
527394	1
528395	1
529396	1
530397	1
531399	1
5324	1
533400	1
534401	1
535402	1
536403	1
537404	1
538406	1
539407	1
540409	1
54141	1
542411	1
543413	1
544414	1
545417	1
546418	1
547419	1
54842	1
549421	1
550424	1
551427	1
552429	1
55343	1
554430	1
555431	1
556432	1
557435	1
558436	1
559437	1
560438	1
561439	1
56244	1
563443	1
564444	1
565446	1
566448	1
567449	1
568452	1
569453	1
570454	1
571455	1
572457	1
573458	1
574459	1
575460	1
576462	1
577463	1
578466	1
579467	1
580468	1
581469	1
58247	1
583470	1
584472	1
585475	1
586477	1
587478	1
588479	1
589480	1
590481	1
591482	1
592483	1
593484	1
594485	1
595487	1
596489	1
597490	1
598491	1
599492	1
600493	1
601494	1
602495	1
603496	1
604497	1
605498	1
6065	1
60751	1
60853	1
60954	1
61057	1
61158	1
61264	1
61365	1
61466	1
61567	1
61669	1
61770	1
61872	1
61974	1
62076	1
62177	1
62278	1
6238	1
62480	1
62582	1
62683	1
62784	1
62885	1
62986	1
63087	1
6319	1
63290	1
63392	1
63495	1
63596	1
63697	1
63798	1
638tst1	1
639PREHOOK: query: SELECT DEST2.* FROM DEST2
640PREHOOK: type: QUERY
641PREHOOK: Input: default@dest2
642PREHOOK: Output: file:/tmp/sdong/hive_2011-02-10_17-50-12_948_8332394278542218529/-mr-10000
643POSTHOOK: query: SELECT DEST2.* FROM DEST2
644POSTHOOK: type: QUERY
645POSTHOOK: Input: default@dest2
646POSTHOOK: Output: file:/tmp/sdong/hive_2011-02-10_17-50-12_948_8332394278542218529/-mr-10000
647POSTHOOK: Lineage: dest1.key EXPRESSION [(src)s2.FieldSchema(name:key, type:string, comment:default), ]
648POSTHOOK: Lineage: dest1.value EXPRESSION [(src)s1.null, (src)s2.FieldSchema(name:value, type:string, comment:default), ]
649POSTHOOK: Lineage: dest2.key EXPRESSION [(src)s2.FieldSchema(name:key, type:string, comment:default), ]
650POSTHOOK: Lineage: dest2.val1 EXPRESSION [(src)s1.null, (src)s2.FieldSchema(name:value, type:string, comment:default), ]
651POSTHOOK: Lineage: dest2.val2 EXPRESSION [(src)s1.null, (src)s2.FieldSchema(name:value, type:string, comment:default), ]
6520	val_0	1
65310	val_10	1
654100	val_100	1
655103	val_103	1
656104	val_104	1
657105	val_105	1
65811	val_11	1
659111	val_111	1
660113	val_113	1
661114	val_114	1
662116	val_116	1
663118	val_118	1
664119	val_119	1
66512	val_12	1
666120	val_120	1
667125	val_125	1
668126	val_126	1
669128	val_128	1
670129	val_129	1
671131	val_131	1
672133	val_133	1
673134	val_134	1
674136	val_136	1
675137	val_137	1
676138	val_138	1
677143	val_143	1
678145	val_145	1
679146	val_146	1
680149	val_149	1
68115	val_15	1
682150	val_150	1
683152	val_152	1
684153	val_153	1
685155	val_155	1
686156	val_156	1
687157	val_157	1
688158	val_158	1
689160	val_160	1
690162	val_162	1
691163	val_163	1
692164	val_164	1
693165	val_165	1
694166	val_166	1
695167	val_167	1
696168	val_168	1
697169	val_169	1
69817	val_17	1
699170	val_170	1
700172	val_172	1
701174	val_174	1
702175	val_175	1
703176	val_176	1
704177	val_177	1
705178	val_178	1
706179	val_179	1
70718	val_18	1
708180	val_180	1
709181	val_181	1
710183	val_183	1
711186	val_186	1
712187	val_187	1
713189	val_189	1
71419	val_19	1
715190	val_190	1
716191	val_191	1
717192	val_192	1
718193	val_193	1
719194	val_194	1
720195	val_195	1
721196	val_196	1
722197	val_197	1
723199	val_199	1
7242	val_2	1
72520	val_20	1
726200	val_200	1
727201	val_201	1
728202	val_202	1
729203	val_203	1
730205	val_205	1
731207	val_207	1
732208	val_208	1
733209	val_209	1
734213	val_213	1
735214	val_214	1
736216	val_216	1
737217	val_217	1
738218	val_218	1
739219	val_219	1
740221	val_221	1
741222	val_222	1
742223	val_223	1
743224	val_224	1
744226	val_226	1
745228	val_228	1
746229	val_229	1
747230	val_230	1
748233	val_233	1
749235	val_235	1
750237	val_237	1
751238	val_238	1
752239	val_239	1
75324	val_24	1
754241	val_241	1
755242	val_242	1
756244	val_244	1
757247	val_247	1
758248	val_248	1
759249	val_249	1
760252	val_252	1
761255	val_255	1
762256	val_256	1
763257	val_257	1
764258	val_258	1
76526	val_26	1
766260	val_260	1
767262	val_262	1
768263	val_263	1
769265	val_265	1
770266	val_266	1
77127	val_27	1
772272	val_272	1
773273	val_273	1
774274	val_274	1
775275	val_275	1
776277	val_277	1
777278	val_278	1
77828	val_28	1
779280	val_280	1
780281	val_281	1
781282	val_282	1
782283	val_283	1
783284	val_284	1
784285	val_285	1
785286	val_286	1
786287	val_287	1
787288	val_288	1
788289	val_289	1
789291	val_291	1
790292	val_292	1
791296	val_296	1
792298	val_298	1
79330	val_30	1
794302	val_302	1
795305	val_305	1
796306	val_306	1
797307	val_307	1
798308	val_308	1
799309	val_309	1
800310	val_310	1
801311	val_311	1
802315	val_315	1
803316	val_316	1
804317	val_317	1
805318	val_318	1
806321	val_321	1
807322	val_322	1
808323	val_323	1
809325	val_325	1
810327	val_327	1
81133	val_33	1
812331	val_331	1
813332	val_332	1
814333	val_333	1
815335	val_335	1
816336	val_336	1
817338	val_338	1
818339	val_339	1
81934	val_34	1
820341	val_341	1
821342	val_342	1
822344	val_344	1
823345	val_345	1
824348	val_348	1
82535	val_35	1
826351	val_351	1
827353	val_353	1
828356	val_356	1
829360	val_360	1
830362	val_362	1
831364	val_364	1
832365	val_365	1
833366	val_366	1
834367	val_367	1
835368	val_368	1
836369	val_369	1
83737	val_37	1
838373	val_373	1
839374	val_374	1
840375	val_375	1
841377	val_377	1
842378	val_378	1
843379	val_379	1
844382	val_382	1
845384	val_384	1
846386	val_386	1
847389	val_389	1
848392	val_392	1
849393	val_393	1
850394	val_394	1
851395	val_395	1
852396	val_396	1
853397	val_397	1
854399	val_399	1
8554	val_4	1
856400	val_400	1
857401	val_401	1
858402	val_402	1
859403	val_403	1
860404	val_404	1
861406	val_406	1
862407	val_407	1
863409	val_409	1
86441	val_41	1
865411	val_411	1
866413	val_413	1
867414	val_414	1
868417	val_417	1
869418	val_418	1
870419	val_419	1
87142	val_42	1
872421	val_421	1
873424	val_424	1
874427	val_427	1
875429	val_429	1
87643	val_43	1
877430	val_430	1
878431	val_431	1
879432	val_432	1
880435	val_435	1
881436	val_436	1
882437	val_437	1
883438	val_438	1
884439	val_439	1
88544	val_44	1
886443	val_443	1
887444	val_444	1
888446	val_446	1
889448	val_448	1
890449	val_449	1
891452	val_452	1
892453	val_453	1
893454	val_454	1
894455	val_455	1
895457	val_457	1
896458	val_458	1
897459	val_459	1
898460	val_460	1
899462	val_462	1
900463	val_463	1
901466	val_466	1
902467	val_467	1
903468	val_468	1
904469	val_469	1
90547	val_47	1
906470	val_470	1
907472	val_472	1
908475	val_475	1
909477	val_477	1
910478	val_478	1
911479	val_479	1
912480	val_480	1
913481	val_481	1
914482	val_482	1
915483	val_483	1
916484	val_484	1
917485	val_485	1
918487	val_487	1
919489	val_489	1
920490	val_490	1
921491	val_491	1
922492	val_492	1
923493	val_493	1
924494	val_494	1
925495	val_495	1
926496	val_496	1
927497	val_497	1
928498	val_498	1
9295	val_5	1
93051	val_51	1
93153	val_53	1
93254	val_54	1
93357	val_57	1
93458	val_58	1
93564	val_64	1
93665	val_65	1
93766	val_66	1
93867	val_67	1
93969	val_69	1
94070	val_70	1
94172	val_72	1
94274	val_74	1
94376	val_76	1
94477	val_77	1
94578	val_78	1
9468	val_8	1
94780	val_80	1
94882	val_82	1
94983	val_83	1
95084	val_84	1
95185	val_85	1
95286	val_86	1
95387	val_87	1
9549	val_9	1
95590	val_90	1
95692	val_92	1
95795	val_95	1
95896	val_96	1
95997	val_97	1
96098	val_98	1
961tst1	500	1