PageRenderTime 39ms CodeModel.GetById 18ms app.highlight 12ms RepoModel.GetById 1ms app.codeStats 1ms

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

#
text | 6996 lines | 6961 code | 35 blank | 0 comment | 0 complexity | 372bec47dfd620e881c4d8b6998ffa16 MD5 | raw file

Large files files are truncated, but you can click here to view the full file

   1PREHOOK: query: create table merge_src as 
   2select key, value from srcpart where ds is not null
   3PREHOOK: type: CREATETABLE_AS_SELECT
   4PREHOOK: Input: default@srcpart@ds=2008-04-08/hr=11
   5PREHOOK: Input: default@srcpart@ds=2008-04-08/hr=12
   6PREHOOK: Input: default@srcpart@ds=2008-04-09/hr=11
   7PREHOOK: Input: default@srcpart@ds=2008-04-09/hr=12
   8POSTHOOK: query: create table merge_src as 
   9select key, value from srcpart where ds is not null
  10POSTHOOK: type: CREATETABLE_AS_SELECT
  11POSTHOOK: Input: default@srcpart@ds=2008-04-08/hr=11
  12POSTHOOK: Input: default@srcpart@ds=2008-04-08/hr=12
  13POSTHOOK: Input: default@srcpart@ds=2008-04-09/hr=11
  14POSTHOOK: Input: default@srcpart@ds=2008-04-09/hr=12
  15POSTHOOK: Output: default@merge_src
  16PREHOOK: query: create table merge_src_part (key string, value string) partitioned by (ds string)
  17PREHOOK: type: CREATETABLE
  18POSTHOOK: query: create table merge_src_part (key string, value string) partitioned by (ds string)
  19POSTHOOK: type: CREATETABLE
  20POSTHOOK: Output: default@merge_src_part
  21PREHOOK: query: insert overwrite table merge_src_part partition(ds) select key, value, ds from srcpart where ds is not null
  22PREHOOK: type: QUERY
  23PREHOOK: Input: default@srcpart@ds=2008-04-08/hr=11
  24PREHOOK: Input: default@srcpart@ds=2008-04-08/hr=12
  25PREHOOK: Input: default@srcpart@ds=2008-04-09/hr=11
  26PREHOOK: Input: default@srcpart@ds=2008-04-09/hr=12
  27PREHOOK: Output: default@merge_src_part
  28POSTHOOK: query: insert overwrite table merge_src_part partition(ds) select key, value, ds from srcpart where ds is not null
  29POSTHOOK: type: QUERY
  30POSTHOOK: Input: default@srcpart@ds=2008-04-08/hr=11
  31POSTHOOK: Input: default@srcpart@ds=2008-04-08/hr=12
  32POSTHOOK: Input: default@srcpart@ds=2008-04-09/hr=11
  33POSTHOOK: Input: default@srcpart@ds=2008-04-09/hr=12
  34POSTHOOK: Output: default@merge_src_part@ds=2008-04-08
  35POSTHOOK: Output: default@merge_src_part@ds=2008-04-09
  36POSTHOOK: Lineage: merge_src_part PARTITION(ds=2008-04-08).key SIMPLE [(srcpart)srcpart.FieldSchema(name:key, type:string, comment:default), ]
  37POSTHOOK: Lineage: merge_src_part PARTITION(ds=2008-04-08).value SIMPLE [(srcpart)srcpart.FieldSchema(name:value, type:string, comment:default), ]
  38POSTHOOK: Lineage: merge_src_part PARTITION(ds=2008-04-09).key SIMPLE [(srcpart)srcpart.FieldSchema(name:key, type:string, comment:default), ]
  39POSTHOOK: Lineage: merge_src_part PARTITION(ds=2008-04-09).value SIMPLE [(srcpart)srcpart.FieldSchema(name:value, type:string, comment:default), ]
  40PREHOOK: query: explain extended
  41create table merge_src2 as 
  42select key, value from merge_src
  43PREHOOK: type: CREATETABLE_AS_SELECT
  44POSTHOOK: query: explain extended
  45create table merge_src2 as 
  46select key, value from merge_src
  47POSTHOOK: type: CREATETABLE_AS_SELECT
  48POSTHOOK: Lineage: merge_src_part PARTITION(ds=2008-04-08).key SIMPLE [(srcpart)srcpart.FieldSchema(name:key, type:string, comment:default), ]
  49POSTHOOK: Lineage: merge_src_part PARTITION(ds=2008-04-08).value SIMPLE [(srcpart)srcpart.FieldSchema(name:value, type:string, comment:default), ]
  50POSTHOOK: Lineage: merge_src_part PARTITION(ds=2008-04-09).key SIMPLE [(srcpart)srcpart.FieldSchema(name:key, type:string, comment:default), ]
  51POSTHOOK: Lineage: merge_src_part PARTITION(ds=2008-04-09).value SIMPLE [(srcpart)srcpart.FieldSchema(name:value, type:string, comment:default), ]
  52ABSTRACT SYNTAX TREE:
  53  (TOK_CREATETABLE (TOK_TABNAME merge_src2) TOK_LIKETABLE (TOK_QUERY (TOK_FROM (TOK_TABREF (TOK_TABNAME merge_src))) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR (TOK_TABLE_OR_COL key)) (TOK_SELEXPR (TOK_TABLE_OR_COL value))))))
  54
  55STAGE DEPENDENCIES:
  56  Stage-1 is a root stage
  57  Stage-4 depends on stages: Stage-1 , consists of Stage-3, Stage-2
  58  Stage-3
  59  Stage-0 depends on stages: Stage-3, Stage-2
  60  Stage-5 depends on stages: Stage-0
  61  Stage-2
  62
  63STAGE PLANS:
  64  Stage: Stage-1
  65    Map Reduce
  66      Alias -> Map Operator Tree:
  67        merge_src 
  68          TableScan
  69            alias: merge_src
  70            GatherStats: false
  71            Select Operator
  72              expressions:
  73                    expr: key
  74                    type: string
  75                    expr: value
  76                    type: string
  77              outputColumnNames: _col0, _col1
  78              File Output Operator
  79                compressed: false
  80                GlobalTableId: 1
  81                directory: pfile:/data/users/tomasz/apache-hive/build/ql/scratchdir/hive_2011-06-01_20-01-44_376_1447687532118180204/-ext-10002
  82                NumFilesPerFileSink: 1
  83                Stats Publishing Key Prefix: pfile:/data/users/tomasz/apache-hive/build/ql/scratchdir/hive_2011-06-01_20-01-44_376_1447687532118180204/-ext-10001/
  84                table:
  85                    input format: org.apache.hadoop.mapred.TextInputFormat
  86                    output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
  87                    properties:
  88                      columns _col0,_col1
  89                      columns.types string:string
  90                      serialization.format 1
  91                TotalFiles: 1
  92                GatherStats: false
  93                MultiFileSpray: false
  94      Needs Tagging: false
  95      Path -> Alias:
  96        pfile:/data/users/tomasz/apache-hive/build/ql/test/data/warehouse/merge_src [merge_src]
  97      Path -> Partition:
  98        pfile:/data/users/tomasz/apache-hive/build/ql/test/data/warehouse/merge_src 
  99          Partition
 100            base file name: merge_src
 101            input format: org.apache.hadoop.mapred.TextInputFormat
 102            output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
 103            properties:
 104              bucket_count -1
 105              columns key,value
 106              columns.types string:string
 107              file.inputformat org.apache.hadoop.mapred.TextInputFormat
 108              file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
 109              location pfile:/data/users/tomasz/apache-hive/build/ql/test/data/warehouse/merge_src
 110              name default.merge_src
 111              serialization.ddl struct merge_src { string key, string value}
 112              serialization.format 1
 113              serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
 114              transient_lastDdlTime 1306983697
 115            serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
 116          
 117              input format: org.apache.hadoop.mapred.TextInputFormat
 118              output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
 119              properties:
 120                bucket_count -1
 121                columns key,value
 122                columns.types string:string
 123                file.inputformat org.apache.hadoop.mapred.TextInputFormat
 124                file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
 125                location pfile:/data/users/tomasz/apache-hive/build/ql/test/data/warehouse/merge_src
 126                name default.merge_src
 127                serialization.ddl struct merge_src { string key, string value}
 128                serialization.format 1
 129                serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
 130                transient_lastDdlTime 1306983697
 131              serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
 132              name: default.merge_src
 133            name: default.merge_src
 134
 135  Stage: Stage-4
 136    Conditional Operator
 137
 138  Stage: Stage-3
 139    Move Operator
 140      files:
 141          hdfs directory: true
 142          source: pfile:/data/users/tomasz/apache-hive/build/ql/scratchdir/hive_2011-06-01_20-01-44_376_1447687532118180204/-ext-10002
 143          destination: pfile:/data/users/tomasz/apache-hive/build/ql/scratchdir/hive_2011-06-01_20-01-44_376_1447687532118180204/-ext-10001
 144
 145  Stage: Stage-0
 146    Move Operator
 147      files:
 148          hdfs directory: true
 149          source: pfile:/data/users/tomasz/apache-hive/build/ql/scratchdir/hive_2011-06-01_20-01-44_376_1447687532118180204/-ext-10001
 150          destination: pfile:/data/users/tomasz/apache-hive/build/ql/test/data/warehouse/merge_src2
 151
 152  Stage: Stage-5
 153      Create Table Operator:
 154        Create Table
 155          columns: key string, value string
 156          if not exists: false
 157          input format: org.apache.hadoop.mapred.TextInputFormat
 158          # buckets: -1
 159          output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
 160          name: merge_src2
 161          isExternal: false
 162
 163  Stage: Stage-2
 164    Map Reduce
 165      Alias -> Map Operator Tree:
 166        pfile:/data/users/tomasz/apache-hive/build/ql/scratchdir/hive_2011-06-01_20-01-44_376_1447687532118180204/-ext-10002 
 167            File Output Operator
 168              compressed: false
 169              GlobalTableId: 0
 170              directory: pfile:/data/users/tomasz/apache-hive/build/ql/scratchdir/hive_2011-06-01_20-01-44_376_1447687532118180204/-ext-10001
 171              NumFilesPerFileSink: 1
 172              table:
 173                  input format: org.apache.hadoop.mapred.TextInputFormat
 174                  output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
 175                  properties:
 176                    columns _col0,_col1
 177                    columns.types string:string
 178                    serialization.format 1
 179              TotalFiles: 1
 180              GatherStats: false
 181              MultiFileSpray: false
 182      Needs Tagging: false
 183      Path -> Alias:
 184        pfile:/data/users/tomasz/apache-hive/build/ql/scratchdir/hive_2011-06-01_20-01-44_376_1447687532118180204/-ext-10002 [pfile:/data/users/tomasz/apache-hive/build/ql/scratchdir/hive_2011-06-01_20-01-44_376_1447687532118180204/-ext-10002]
 185      Path -> Partition:
 186        pfile:/data/users/tomasz/apache-hive/build/ql/scratchdir/hive_2011-06-01_20-01-44_376_1447687532118180204/-ext-10002 
 187          Partition
 188            base file name: -ext-10002
 189            input format: org.apache.hadoop.mapred.TextInputFormat
 190            output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
 191            properties:
 192              columns _col0,_col1
 193              columns.types string:string
 194              serialization.format 1
 195          
 196              input format: org.apache.hadoop.mapred.TextInputFormat
 197              output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
 198              properties:
 199                columns _col0,_col1
 200                columns.types string:string
 201                serialization.format 1
 202
 203
 204PREHOOK: query: create table merge_src2 as 
 205select key, value from merge_src
 206PREHOOK: type: CREATETABLE_AS_SELECT
 207PREHOOK: Input: default@merge_src
 208POSTHOOK: query: create table merge_src2 as 
 209select key, value from merge_src
 210POSTHOOK: type: CREATETABLE_AS_SELECT
 211POSTHOOK: Input: default@merge_src
 212POSTHOOK: Output: default@merge_src2
 213POSTHOOK: Lineage: merge_src_part PARTITION(ds=2008-04-08).key SIMPLE [(srcpart)srcpart.FieldSchema(name:key, type:string, comment:default), ]
 214POSTHOOK: Lineage: merge_src_part PARTITION(ds=2008-04-08).value SIMPLE [(srcpart)srcpart.FieldSchema(name:value, type:string, comment:default), ]
 215POSTHOOK: Lineage: merge_src_part PARTITION(ds=2008-04-09).key SIMPLE [(srcpart)srcpart.FieldSchema(name:key, type:string, comment:default), ]
 216POSTHOOK: Lineage: merge_src_part PARTITION(ds=2008-04-09).value SIMPLE [(srcpart)srcpart.FieldSchema(name:value, type:string, comment:default), ]
 217PREHOOK: query: select * from merge_src2
 218PREHOOK: type: QUERY
 219PREHOOK: Input: default@merge_src2
 220PREHOOK: Output: file:/tmp/tomasz/hive_2011-06-01_20-01-50_658_5738218994707061399/-mr-10000
 221POSTHOOK: query: select * from merge_src2
 222POSTHOOK: type: QUERY
 223POSTHOOK: Input: default@merge_src2
 224POSTHOOK: Output: file:/tmp/tomasz/hive_2011-06-01_20-01-50_658_5738218994707061399/-mr-10000
 225POSTHOOK: Lineage: merge_src_part PARTITION(ds=2008-04-08).key SIMPLE [(srcpart)srcpart.FieldSchema(name:key, type:string, comment:default), ]
 226POSTHOOK: Lineage: merge_src_part PARTITION(ds=2008-04-08).value SIMPLE [(srcpart)srcpart.FieldSchema(name:value, type:string, comment:default), ]
 227POSTHOOK: Lineage: merge_src_part PARTITION(ds=2008-04-09).key SIMPLE [(srcpart)srcpart.FieldSchema(name:key, type:string, comment:default), ]
 228POSTHOOK: Lineage: merge_src_part PARTITION(ds=2008-04-09).value SIMPLE [(srcpart)srcpart.FieldSchema(name:value, type:string, comment:default), ]
 229238	val_238
 23086	val_86
 231311	val_311
 23227	val_27
 233165	val_165
 234409	val_409
 235255	val_255
 236278	val_278
 23798	val_98
 238484	val_484
 239265	val_265
 240193	val_193
 241401	val_401
 242150	val_150
 243273	val_273
 244224	val_224
 245369	val_369
 24666	val_66
 247128	val_128
 248213	val_213
 249146	val_146
 250406	val_406
 251429	val_429
 252374	val_374
 253152	val_152
 254469	val_469
 255145	val_145
 256495	val_495
 25737	val_37
 258327	val_327
 259281	val_281
 260277	val_277
 261209	val_209
 26215	val_15
 26382	val_82
 264403	val_403
 265166	val_166
 266417	val_417
 267430	val_430
 268252	val_252
 269292	val_292
 270219	val_219
 271287	val_287
 272153	val_153
 273193	val_193
 274338	val_338
 275446	val_446
 276459	val_459
 277394	val_394
 278237	val_237
 279482	val_482
 280174	val_174
 281413	val_413
 282494	val_494
 283207	val_207
 284199	val_199
 285466	val_466
 286208	val_208
 287174	val_174
 288399	val_399
 289396	val_396
 290247	val_247
 291417	val_417
 292489	val_489
 293162	val_162
 294377	val_377
 295397	val_397
 296309	val_309
 297365	val_365
 298266	val_266
 299439	val_439
 300342	val_342
 301367	val_367
 302325	val_325
 303167	val_167
 304195	val_195
 305475	val_475
 30617	val_17
 307113	val_113
 308155	val_155
 309203	val_203
 310339	val_339
 3110	val_0
 312455	val_455
 313128	val_128
 314311	val_311
 315316	val_316
 31657	val_57
 317302	val_302
 318205	val_205
 319149	val_149
 320438	val_438
 321345	val_345
 322129	val_129
 323170	val_170
 32420	val_20
 325489	val_489
 326157	val_157
 327378	val_378
 328221	val_221
 32992	val_92
 330111	val_111
 33147	val_47
 33272	val_72
 3334	val_4
 334280	val_280
 33535	val_35
 336427	val_427
 337277	val_277
 338208	val_208
 339356	val_356
 340399	val_399
 341169	val_169
 342382	val_382
 343498	val_498
 344125	val_125
 345386	val_386
 346437	val_437
 347469	val_469
 348192	val_192
 349286	val_286
 350187	val_187
 351176	val_176
 35254	val_54
 353459	val_459
 35451	val_51
 355138	val_138
 356103	val_103
 357239	val_239
 358213	val_213
 359216	val_216
 360430	val_430
 361278	val_278
 362176	val_176
 363289	val_289
 364221	val_221
 36565	val_65
 366318	val_318
 367332	val_332
 368311	val_311
 369275	val_275
 370137	val_137
 371241	val_241
 37283	val_83
 373333	val_333
 374180	val_180
 375284	val_284
 37612	val_12
 377230	val_230
 378181	val_181
 37967	val_67
 380260	val_260
 381404	val_404
 382384	val_384
 383489	val_489
 384353	val_353
 385373	val_373
 386272	val_272
 387138	val_138
 388217	val_217
 38984	val_84
 390348	val_348
 391466	val_466
 39258	val_58
 3938	val_8
 394411	val_411
 395230	val_230
 396208	val_208
 397348	val_348
 39824	val_24
 399463	val_463
 400431	val_431
 401179	val_179
 402172	val_172
 40342	val_42
 404129	val_129
 405158	val_158
 406119	val_119
 407496	val_496
 4080	val_0
 409322	val_322
 410197	val_197
 411468	val_468
 412393	val_393
 413454	val_454
 414100	val_100
 415298	val_298
 416199	val_199
 417191	val_191
 418418	val_418
 41996	val_96
 42026	val_26
 421165	val_165
 422327	val_327
 423230	val_230
 424205	val_205
 425120	val_120
 426131	val_131
 42751	val_51
 428404	val_404
 42943	val_43
 430436	val_436
 431156	val_156
 432469	val_469
 433468	val_468
 434308	val_308
 43595	val_95
 436196	val_196
 437288	val_288
 438481	val_481
 439457	val_457
 44098	val_98
 441282	val_282
 442197	val_197
 443187	val_187
 444318	val_318
 445318	val_318
 446409	val_409
 447470	val_470
 448137	val_137
 449369	val_369
 450316	val_316
 451169	val_169
 452413	val_413
 45385	val_85
 45477	val_77
 4550	val_0
 456490	val_490
 45787	val_87
 458364	val_364
 459179	val_179
 460118	val_118
 461134	val_134
 462395	val_395
 463282	val_282
 464138	val_138
 465238	val_238
 466419	val_419
 46715	val_15
 468118	val_118
 46972	val_72
 47090	val_90
 471307	val_307
 47219	val_19
 473435	val_435
 47410	val_10
 475277	val_277
 476273	val_273
 477306	val_306
 478224	val_224
 479309	val_309
 480389	val_389
 481327	val_327
 482242	val_242
 483369	val_369
 484392	val_392
 485272	val_272
 486331	val_331
 487401	val_401
 488242	val_242
 489452	val_452
 490177	val_177
 491226	val_226
 4925	val_5
 493497	val_497
 494402	val_402
 495396	val_396
 496317	val_317
 497395	val_395
 49858	val_58
 49935	val_35
 500336	val_336
 50195	val_95
 50211	val_11
 503168	val_168
 50434	val_34
 505229	val_229
 506233	val_233
 507143	val_143
 508472	val_472
 509322	val_322
 510498	val_498
 511160	val_160
 512195	val_195
 51342	val_42
 514321	val_321
 515430	val_430
 516119	val_119
 517489	val_489
 518458	val_458
 51978	val_78
 52076	val_76
 52141	val_41
 522223	val_223
 523492	val_492
 524149	val_149
 525449	val_449
 526218	val_218
 527228	val_228
 528138	val_138
 529453	val_453
 53030	val_30
 531209	val_209
 53264	val_64
 533468	val_468
 53476	val_76
 53574	val_74
 536342	val_342
 53769	val_69
 538230	val_230
 53933	val_33
 540368	val_368
 541103	val_103
 542296	val_296
 543113	val_113
 544216	val_216
 545367	val_367
 546344	val_344
 547167	val_167
 548274	val_274
 549219	val_219
 550239	val_239
 551485	val_485
 552116	val_116
 553223	val_223
 554256	val_256
 555263	val_263
 55670	val_70
 557487	val_487
 558480	val_480
 559401	val_401
 560288	val_288
 561191	val_191
 5625	val_5
 563244	val_244
 564438	val_438
 565128	val_128
 566467	val_467
 567432	val_432
 568202	val_202
 569316	val_316
 570229	val_229
 571469	val_469
 572463	val_463
 573280	val_280
 5742	val_2
 57535	val_35
 576283	val_283
 577331	val_331
 578235	val_235
 57980	val_80
 58044	val_44
 581193	val_193
 582321	val_321
 583335	val_335
 584104	val_104
 585466	val_466
 586366	val_366
 587175	val_175
 588403	val_403
 589483	val_483
 59053	val_53
 591105	val_105
 592257	val_257
 593406	val_406
 594409	val_409
 595190	val_190
 596406	val_406
 597401	val_401
 598114	val_114
 599258	val_258
 60090	val_90
 601203	val_203
 602262	val_262
 603348	val_348
 604424	val_424
 60512	val_12
 606396	val_396
 607201	val_201
 608217	val_217
 609164	val_164
 610431	val_431
 611454	val_454
 612478	val_478
 613298	val_298
 614125	val_125
 615431	val_431
 616164	val_164
 617424	val_424
 618187	val_187
 619382	val_382
 6205	val_5
 62170	val_70
 622397	val_397
 623480	val_480
 624291	val_291
 62524	val_24
 626351	val_351
 627255	val_255
 628104	val_104
 62970	val_70
 630163	val_163
 631438	val_438
 632119	val_119
 633414	val_414
 634200	val_200
 635491	val_491
 636237	val_237
 637439	val_439
 638360	val_360
 639248	val_248
 640479	val_479
 641305	val_305
 642417	val_417
 643199	val_199
 644444	val_444
 645120	val_120
 646429	val_429
 647169	val_169
 648443	val_443
 649323	val_323
 650325	val_325
 651277	val_277
 652230	val_230
 653478	val_478
 654178	val_178
 655468	val_468
 656310	val_310
 657317	val_317
 658333	val_333
 659493	val_493
 660460	val_460
 661207	val_207
 662249	val_249
 663265	val_265
 664480	val_480
 66583	val_83
 666136	val_136
 667353	val_353
 668172	val_172
 669214	val_214
 670462	val_462
 671233	val_233
 672406	val_406
 673133	val_133
 674175	val_175
 675189	val_189
 676454	val_454
 677375	val_375
 678401	val_401
 679421	val_421
 680407	val_407
 681384	val_384
 682256	val_256
 68326	val_26
 684134	val_134
 68567	val_67
 686384	val_384
 687379	val_379
 68818	val_18
 689462	val_462
 690492	val_492
 691100	val_100
 692298	val_298
 6939	val_9
 694341	val_341
 695498	val_498
 696146	val_146
 697458	val_458
 698362	val_362
 699186	val_186
 700285	val_285
 701348	val_348
 702167	val_167
 70318	val_18
 704273	val_273
 705183	val_183
 706281	val_281
 707344	val_344
 70897	val_97
 709469	val_469
 710315	val_315
 71184	val_84
 71228	val_28
 71337	val_37
 714448	val_448
 715152	val_152
 716348	val_348
 717307	val_307
 718194	val_194
 719414	val_414
 720477	val_477
 721222	val_222
 722126	val_126
 72390	val_90
 724169	val_169
 725403	val_403
 726400	val_400
 727200	val_200
 72897	val_97
 729238	val_238
 73086	val_86
 731311	val_311
 73227	val_27
 733165	val_165
 734409	val_409
 735255	val_255
 736278	val_278
 73798	val_98
 738484	val_484
 739265	val_265
 740193	val_193
 741401	val_401
 742150	val_150
 743273	val_273
 744224	val_224
 745369	val_369
 74666	val_66
 747128	val_128
 748213	val_213
 749146	val_146
 750406	val_406
 751429	val_429
 752374	val_374
 753152	val_152
 754469	val_469
 755145	val_145
 756495	val_495
 75737	val_37
 758327	val_327
 759281	val_281
 760277	val_277
 761209	val_209
 76215	val_15
 76382	val_82
 764403	val_403
 765166	val_166
 766417	val_417
 767430	val_430
 768252	val_252
 769292	val_292
 770219	val_219
 771287	val_287
 772153	val_153
 773193	val_193
 774338	val_338
 775446	val_446
 776459	val_459
 777394	val_394
 778237	val_237
 779482	val_482
 780174	val_174
 781413	val_413
 782494	val_494
 783207	val_207
 784199	val_199
 785466	val_466
 786208	val_208
 787174	val_174
 788399	val_399
 789396	val_396
 790247	val_247
 791417	val_417
 792489	val_489
 793162	val_162
 794377	val_377
 795397	val_397
 796309	val_309
 797365	val_365
 798266	val_266
 799439	val_439
 800342	val_342
 801367	val_367
 802325	val_325
 803167	val_167
 804195	val_195
 805475	val_475
 80617	val_17
 807113	val_113
 808155	val_155
 809203	val_203
 810339	val_339
 8110	val_0
 812455	val_455
 813128	val_128
 814311	val_311
 815316	val_316
 81657	val_57
 817302	val_302
 818205	val_205
 819149	val_149
 820438	val_438
 821345	val_345
 822129	val_129
 823170	val_170
 82420	val_20
 825489	val_489
 826157	val_157
 827378	val_378
 828221	val_221
 82992	val_92
 830111	val_111
 83147	val_47
 83272	val_72
 8334	val_4
 834280	val_280
 83535	val_35
 836427	val_427
 837277	val_277
 838208	val_208
 839356	val_356
 840399	val_399
 841169	val_169
 842382	val_382
 843498	val_498
 844125	val_125
 845386	val_386
 846437	val_437
 847469	val_469
 848192	val_192
 849286	val_286
 850187	val_187
 851176	val_176
 85254	val_54
 853459	val_459
 85451	val_51
 855138	val_138
 856103	val_103
 857239	val_239
 858213	val_213
 859216	val_216
 860430	val_430
 861278	val_278
 862176	val_176
 863289	val_289
 864221	val_221
 86565	val_65
 866318	val_318
 867332	val_332
 868311	val_311
 869275	val_275
 870137	val_137
 871241	val_241
 87283	val_83
 873333	val_333
 874180	val_180
 875284	val_284
 87612	val_12
 877230	val_230
 878181	val_181
 87967	val_67
 880260	val_260
 881404	val_404
 882384	val_384
 883489	val_489
 884353	val_353
 885373	val_373
 886272	val_272
 887138	val_138
 888217	val_217
 88984	val_84
 890348	val_348
 891466	val_466
 89258	val_58
 8938	val_8
 894411	val_411
 895230	val_230
 896208	val_208
 897348	val_348
 89824	val_24
 899463	val_463
 900431	val_431
 901179	val_179
 902172	val_172
 90342	val_42
 904129	val_129
 905158	val_158
 906119	val_119
 907496	val_496
 9080	val_0
 909322	val_322
 910197	val_197
 911468	val_468
 912393	val_393
 913454	val_454
 914100	val_100
 915298	val_298
 916199	val_199
 917191	val_191
 918418	val_418
 91996	val_96
 92026	val_26
 921165	val_165
 922327	val_327
 923230	val_230
 924205	val_205
 925120	val_120
 926131	val_131
 92751	val_51
 928404	val_404
 92943	val_43
 930436	val_436
 931156	val_156
 932469	val_469
 933468	val_468
 934308	val_308
 93595	val_95
 936196	val_196
 937288	val_288
 938481	val_481
 939457	val_457
 94098	val_98
 941282	val_282
 942197	val_197
 943187	val_187
 944318	val_318
 945318	val_318
 946409	val_409
 947470	val_470
 948137	val_137
 949369	val_369
 950316	val_316
 951169	val_169
 952413	val_413
 95385	val_85
 95477	val_77
 9550	val_0
 956490	val_490
 95787	val_87
 958364	val_364
 959179	val_179
 960118	val_118
 961134	val_134
 962395	val_395
 963282	val_282
 964138	val_138
 965238	val_238
 966419	val_419
 96715	val_15
 968118	val_118
 96972	val_72
 97090	val_90
 971307	val_307
 97219	val_19
 973435	val_435
 97410	val_10
 975277	val_277
 976273	val_273
 977306	val_306
 978224	val_224
 979309	val_309
 980389	val_389
 981327	val_327
 982242	val_242
 983369	val_369
 984392	val_392
 985272	val_272
 986331	val_331
 987401	val_401
 988242	val_242
 989452	val_452
 990177	val_177
 991226	val_226
 9925	val_5
 993497	val_497
 994402	val_402
 995396	val_396
 996317	val_317
 997395	val_395
 99858	val_58
 99935	val_35
1000336	val_336
100195	val_95
100211	val_11
1003168	val_168
100434	val_34
1005229	val_229
1006233	val_233
1007143	val_143
1008472	val_472
1009322	val_322
1010498	val_498
1011160	val_160
1012195	val_195
101342	val_42
1014321	val_321
1015430	val_430
1016119	val_119
1017489	val_489
1018458	val_458
101978	val_78
102076	val_76
102141	val_41
1022223	val_223
1023492	val_492
1024149	val_149
1025449	val_449
1026218	val_218
1027228	val_228
1028138	val_138
1029453	val_453
103030	val_30
1031209	val_209
103264	val_64
1033468	val_468
103476	val_76
103574	val_74
1036342	val_342
103769	val_69
1038230	val_230
103933	val_33
1040368	val_368
1041103	val_103
1042296	val_296
1043113	val_113
1044216	val_216
1045367	val_367
1046344	val_344
1047167	val_167
1048274	val_274
1049219	val_219
1050239	val_239
1051485	val_485
1052116	val_116
1053223	val_223
1054256	val_256
1055263	val_263
105670	val_70
1057487	val_487
1058480	val_480
1059401	val_401
1060288	val_288
1061191	val_191
10625	val_5
1063244	val_244
1064438	val_438
1065128	val_128
1066467	val_467
1067432	val_432
1068202	val_202
1069316	val_316
1070229	val_229
1071469	val_469
1072463	val_463
1073280	val_280
10742	val_2
107535	val_35
1076283	val_283
1077331	val_331
1078235	val_235
107980	val_80
108044	val_44
1081193	val_193
1082321	val_321
1083335	val_335
1084104	val_104
1085466	val_466
1086366	val_366
1087175	val_175
1088403	val_403
1089483	val_483
109053	val_53
1091105	val_105
1092257	val_257
1093406	val_406
1094409	val_409
1095190	val_190
1096406	val_406
1097401	val_401
1098114	val_114
1099258	val_258
110090	val_90
1101203	val_203
1102262	val_262
1103348	val_348
1104424	val_424
110512	val_12
1106396	val_396
1107201	val_201
1108217	val_217
1109164	val_164
1110431	val_431
1111454	val_454
1112478	val_478
1113298	val_298
1114125	val_125
1115431	val_431
1116164	val_164
1117424	val_424
1118187	val_187
1119382	val_382
11205	val_5
112170	val_70
1122397	val_397
1123480	val_480
1124291	val_291
112524	val_24
1126351	val_351
1127255	val_255
1128104	val_104
112970	val_70
1130163	val_163
1131438	val_438
1132119	val_119
1133414	val_414
1134200	val_200
1135491	val_491
1136237	val_237
1137439	val_439
1138360	val_360
1139248	val_248
1140479	val_479
1141305	val_305
1142417	val_417
1143199	val_199
1144444	val_444
1145120	val_120
1146429	val_429
1147169	val_169
1148443	val_443
1149323	val_323
1150325	val_325
1151277	val_277
1152230	val_230
1153478	val_478
1154178	val_178
1155468	val_468
1156310	val_310
1157317	val_317
1158333	val_333
1159493	val_493
1160460	val_460
1161207	val_207
1162249	val_249
1163265	val_265
1164480	val_480
116583	val_83
1166136	val_136
1167353	val_353
1168172	val_172
1169214	val_214
1170462	val_462
1171233	val_233
1172406	val_406
1173133	val_133
1174175	val_175
1175189	val_189
1176454	val_454
1177375	val_375
1178401	val_401
1179421	val_421
1180407	val_407
1181384	val_384
1182256	val_256
118326	val_26
1184134	val_134
118567	val_67
1186384	val_384
1187379	val_379
118818	val_18
1189462	val_462
1190492	val_492
1191100	val_100
1192298	val_298
11939	val_9
1194341	val_341
1195498	val_498
1196146	val_146
1197458	val_458
1198362	val_362
1199186	val_186
1200285	val_285
1201348	val_348
1202167	val_167
120318	val_18
1204273	val_273
1205183	val_183
1206281	val_281
1207344	val_344
120897	val_97
1209469	val_469
1210315	val_315
121184	val_84
121228	val_28
121337	val_37
1214448	val_448
1215152	val_152
1216348	val_348
1217307	val_307
1218194	val_194
1219414	val_414
1220477	val_477
1221222	val_222
1222126	val_126
122390	val_90
1224169	val_169
1225403	val_403
1226400	val_400
1227200	val_200
122897	val_97
1229238	val_238
123086	val_86
1231311	val_311
123227	val_27
1233165	val_165
1234409	val_409
1235255	val_255
1236278	val_278
123798	val_98
1238484	val_484
1239265	val_265
1240193	val_193
1241401	val_401
1242150	val_150
1243273	val_273
1244224	val_224
1245369	val_369
124666	val_66
1247128	val_128
1248213	val_213
1249146	val_146
1250406	val_406
1251429	val_429
1252374	val_374
1253152	val_152
1254469	val_469
1255145	val_145
1256495	val_495
125737	val_37
1258327	val_327
1259281	val_281
1260277	val_277
1261209	val_209
126215	val_15
126382	val_82
1264403	val_403
1265166	val_166
1266417	val_417
1267430	val_430
1268252	val_252
1269292	val_292
1270219	val_219
1271287	val_287
1272153	val_153
1273193	val_193
1274338	val_338
1275446	val_446
1276459	val_459
1277394	val_394
1278237	val_237
1279482	val_482
1280174	val_174
1281413	val_413
1282494	val_494
1283207	val_207
1284199	val_199
1285466	val_466
1286208	val_208
1287174	val_174
1288399	val_399
1289396	val_396
1290247	val_247
1291417	val_417
1292489	val_489
1293162	val_162
1294377	val_377
1295397	val_397
1296309	val_309
1297365	val_365
1298266	val_266
1299439	val_439
1300342	val_342
1301367	val_367
1302325	val_325
1303167	val_167
1304195	val_195
1305475	val_475
130617	val_17
1307113	val_113
1308155	val_155
1309203	val_203
1310339	val_339
13110	val_0
1312455	val_455
1313128	val_128
1314311	val_311
1315316	val_316
131657	val_57
1317302	val_302
1318205	val_205
1319149	val_149
1320438	val_438
1321345	val_345
1322129	val_129
1323170	val_170
132420	val_20
1325489	val_489
1326157	val_157
1327378	val_378
1328221	val_221
132992	val_92
1330111	val_111
133147	val_47
133272	val_72
13334	val_4
1334280	val_280
133535	val_35
1336427	val_427
1337277	val_277
1338208	val_208
1339356	val_356
1340399	val_399
1341169	val_169
1342382	val_382
1343498	val_498
1344125	val_125
1345386	val_386
1346437	val_437
1347469	val_469
1348192	val_192
1349286	val_286
1350187	val_187
1351176	val_176
135254	val_54
1353459	val_459
135451	val_51
1355138	val_138
1356103	val_103
1357239	val_239
1358213	val_213
1359216	val_216
1360430	val_430
1361278	val_278
1362176	val_176
1363289	val_289
1364221	val_221
136565	val_65
1366318	val_318
1367332	val_332
1368311	val_311
1369275	val_275
1370137	val_137
1371241	val_241
137283	val_83
1373333	val_333
1374180	val_180
1375284	val_284
137612	val_12
1377230	val_230
1378181	val_181
137967	val_67
1380260	val_260
1381404	val_404
1382384	val_384
1383489	val_489
1384353	val_353
1385373	val_373
1386272	val_272
1387138	val_138
1388217	val_217
138984	val_84
1390348	val_348
1391466	val_466
139258	val_58
13938	val_8
1394411	val_411
1395230	val_230
1396208	val_208
1397348	val_348
139824	val_24
1399463	val_463
1400431	val_431
1401179	val_179
1402172	val_172
140342	val_42
1404129	val_129
1405158	val_158
1406119	val_119
1407496	val_496
14080	val_0
1409322	val_322
1410197	val_197
1411468	val_468
1412393	val_393
1413454	val_454
1414100	val_100
1415298	val_298
1416199	val_199
1417191	val_191
1418418	val_418
141996	val_96
142026	val_26
1421165	val_165
1422327	val_327
1423230	val_230
1424205	val_205
1425120	val_120
1426131	val_131
142751	val_51
1428404	val_404
142943	val_43
1430436	val_436
1431156	val_156
1432469	val_469
1433468	val_468
1434308	val_308
143595	val_95
1436196	val_196
1437288	val_288
1438481	val_481
1439457	val_457
144098	val_98
1441282	val_282
1442197	val_197
1443187	val_187
1444318	val_318
1445318	val_318
1446409	val_409
1447470	val_470
1448137	val_137
1449369	val_369
1450316	val_316
1451169	val_169
1452413	val_413
145385	val_85
145477	val_77
14550	val_0
1456490	val_490
145787	val_87
1458364	val_364
1459179	val_179
1460118	val_118
1461134	val_134
1462395	val_395
1463282	val_282
1464138	val_138
1465238	val_238
1466419	val_419
146715	val_15
1468118	val_118
146972	val_72
147090	val_90
1471307	val_307
147219	val_19
1473435	val_435
147410	val_10
1475277	val_277
1476273	val_273
1477306	val_306
1478224	val_224
1479309	val_309
1480389	val_389
1481327	val_327
1482242	val_242
1483369	val_369
1484392	val_392
1485272	val_272
1486331	val_331
1487401	val_401
1488242	val_242
1489452	val_452
1490177	val_177
1491226	val_226
14925	val_5
1493497	val_497
1494402	val_402
1495396	val_396
1496317	val_317
1497395	val_395
149858	val_58
149935	val_35
1500336	val_336
150195	val_95
150211	val_11
1503168	val_168
150434	val_34
1505229	val_229
1506233	val_233
1507143	val_143
1508472	val_472
1509322	val_322
1510498	val_498
1511160	val_160
1512195	val_195
151342	val_42
1514321	val_321
1515430	val_430
1516119	val_119
1517489	val_489
1518458	val_458
151978	val_78
152076	val_76
152141	val_41
1522223	val_223
1523492	val_492
1524149	val_149
1525449	val_449
1526218	val_218
1527228	val_228
1528138	val_138
1529453	val_453
153030	val_30
1531209	val_209
153264	val_64
1533468	val_468
153476	val_76
153574	val_74
1536342	val_342
153769	val_69
1538230	val_230
153933	val_33
1540368	val_368
1541103	val_103
1542296	val_296
1543113	val_113
1544216	val_216
1545367	val_367
1546344	val_344
1547167	val_167
1548274	val_274
1549219	val_219
1550239	val_239
1551485	val_485
1552116	val_116
1553223	val_223
1554256	val_256
1555263	val_263
155670	val_70
1557487	val_487
1558480	val_480
1559401	val_401
1560288	val_288
1561191	val_191
15625	val_5
1563244	val_244
1564438	val_438
1565128	val_128
1566467	val_467
1567432	val_432
1568202	val_202
1569316	val_316
1570229	val_229
1571469	val_469
1572463	val_463
1573280	val_280
15742	val_2
157535	val_35
1576283	val_283
1577331	val_331
1578235	val_235
157980	val_80
158044	val_44
1581193	val_193
1582321	val_321
1583335	val_335
1584104	val_104
1585466	val_466
1586366	val_366
1587175	val_175
1588403	val_403
1589483	val_483
159053	val_53
1591105	val_105
1592257	val_257
1593406	val_406
1594409	val_409
1595190	val_190
1596406	val_406
1597401	val_401
1598114	val_114
1599258	val_258
160090	val_90
1601203	val_203
1602262	val_262
1603348	val_348
1604424	val_424
160512	val_12
1606396	val_396
1607201	val_201
1608217	val_217
1609164	val_164
1610431	val_431
1611454	val_454
1612478	val_478
1613298	val_298
1614125	val_125
1615431	val_431
1616164	val_164
1617424	val_424
1618187	val_187
1619382	val_382
16205	val_5
162170	val_70
1622397	val_397
1623480	val_480
1624291	val_291
162524	val_24
1626351	val_351
1627255	val_255
1628104	val_104
162970	val_70
1630163	val_163
1631438	val_438
1632119	val_119
1633414	val_414
1634200	val_200
1635491	val_491
1636237	val_237
1637439	val_439
1638360	val_360
1639248	val_248
1640479	val_479
1641305	val_305
1642417	val_417
1643199	val_199
1644444	val_444
1645120	val_120
1646429	val_429
1647169	val_169
1648443	val_443
1649323	val_323
1650325	val_325
1651277	val_277
1652230	val_230
1653478	val_478
1654178	val_178
1655468	val_468
1656310	val_310
1657317	val_317
1658333	val_333
1659493	val_493
1660460	val_460
1661207	val_207
1662249	val_249
1663265	val_265
1664480	val_480
166583	val_83
1666136	val_136
1667353	val_353
1668172	val_172
1669214	val_214
1670462	val_462
1671233	val_233
1672406	val_406
1673133	val_133
1674175	val_175
1675189	val_189
1676454	val_454
1677375	val_375
1678401	val_401
1679421	val_421
1680407	val_407
1681384	val_384
1682256	val_256
168326	val_26
1684134	val_134
168567	val_67
1686384	val_384
1687379	val_379
168818	val_18
1689462	val_462
1690492	val_492
1691100	val_100
1692298	val_298
16939	val_9
1694341	val_341
1695498	val_498
1696146	val_146
1697458	val_458
1698362	val_362
1699186	val_186
1700285	val_285
1701348	val_348
1702167	val_167
170318	val_18
1704273	val_273
1705183	val_183
1706281	val_281
1707344	val_344
170897	val_97
1709469	val_469
1710315	val_315
171184	val_84
171228	val_28
171337	val_37
1714448	val_448
1715152	val_152
1716348	val_348
1717307	val_307
1718194	val_194
1719414	val_414
1720477	val_477
1721222	val_222
1722126	val_126
172390	val_90
1724169	val_169
1725403	val_403
1726400	val_400
1727200	val_200
172897	val_97
1729238	val_238
173086	val_86
1731311	val_311
173227	val_27
1733165	val_165
1734409	val_409
1735255	val_255
1736278	val_278
173798	val_98
1738484	val_484
1739265	val_265
1740193	val_193
1741401	val_401
1742150	val_150
1743273	val_273
1744224	val_224
1745369	val_369
174666	val_66
1747128	val_128
1748213	val_213
1749146	val_146
1750406	val_406
1751429	val_429
1752374	val_374
1753152	val_152
1754469	val_469
1755145	val_145
1756495	val_495
175737	val_37
1758327	val_327
1759281	val_281
1760277	val_277
1761209	val_209
176215	val_15
176382	val_82
1764403	val_403
1765166	val_166
1766417	val_417
1767430	val_430
1768252	val_252
1769292	val_292
1770219	val_219
1771287	val_287
1772153	val_153
1773193	val_193
1774338	val_338
1775446	val_446
1776459	val_459
1777394	val_394
1778237	val_237
1779482	val_482
1780174	val_174
1781413	val_413
1782494	val_494
1783207	val_207
1784199	val_199
1785466	val_466
1786208	val_208
1787174	val_174
1788399	val_399
1789396	val_396
1790247	val_247
1791417	val_417
1792489	val_489
1793162	val_162
1794377	val_377
1795397	val_397
1796309	val_309
1797365	val_365
1798266	val_266
1799439	val_439
1800342	val_342
1801367	val_367
1802325	val_325
1803167	val_167
1804195	val_195
1805475	val_475
180617	val_17
1807113	val_113
1808155	val_155
1809203	val_203
1810339	val_339
18110	val_0
1812455	val_455
1813128	val_128
1814311	val_311
1815316	val_316
181657	val_57
1817302	val_302
1818205	val_205
1819149	val_149
1820438	val_438
1821345	val_345
1822129	val_129
1823170	val_170
182420	val_20
1825489	val_489
1826157	val_157
1827378	val_378
1828221	val_221
182992	val_92
1830111	val_111
183147	val_47
183272	val_72
18334	val_4
1834280	val_280
183535	val_35
1836427	val_427
1837277	val_277
1838208	val_208
1839356	val_356
1840399	val_399
1841169	val_169
1842382	val_382
1843498	val_498
1844125	val_125
1845386	val_386
1846437	val_437
1847469	val_469
1848192	val_192
1849286	val_286
1850187	val_187
1851176	val_176
185254	val_54
1853459	val_459
185451	val_51
1855138	val_138
1856103	val_103
1857239	val_239
1858213	val_213
1859216	val_216
1860430	val_430
1861278	val_278
1862176	val_176
1863289	val_289
1864221	val_221
186565	val_65
1866318	val_318
1867332	val_332
1868311	val_311
1869275	val_275
1870137	val_137
1871241	val_241
187283	val_83
1873333	val_333
1874180	val_180
1875284	val_284
187612	val_12
1877230	val_230
1878181	val_181
187967	val_67
1880260	val_260
1881404	val_404
1882384	val_384
1883489	val_489
1884353	val_353
1885373	val_373
1886272	val_272
1887138	val_138
1888217	val_217
188984	val_84
1890348	val_348
1891466	val_466
189258	val_58
18938	val_8
1894411	val_411
1895230	val_230
1896208	val_208
1897348	val_348
189824	val_24
1899463	val_463
1900431	val_431
1901179	val_179
1902172	val_172
190342	val_42
1904129	val_129
1905158	val_158
1906119	val_119
1907496	val_496
19080	val_0
1909322	val_322
1910197	val_197
1911468	val_468
1912393	val_393
1913454	val_454
1914100	val_100
1915298	val_298
1916199	val_199
1917191	val_191
1918418	val_418
191996	val_96
192026	val_26
1921165	val_165
1922327	val_327
1923230	val_230
1924205	val_205
1925120	val_120
1926131	val_131
192751	val_51
1928404	val_404
192943	val_43
1930436	val_436
1931156	val_156
1932469	val_469
1933468	val_468
1934308	val_308
193595	val_95
1936196	val_196
1937288	val_288
1938481	val_481
1939457	val_457
194098	val_98
1941282	val_282
1942197	val_197
1943187	val_187
1944318	val_318
1945318	val_318
1946409	val_409
1947470	val_470
1948137	val_137
1949369	val_369
1950316	val_316
1951169	val_169
1952413	val_413
195385	val_85
195477	val_77
19550	val_0
1956490	val_490
195787	val_87
1958364	val_364
1959179	val_179
1960118	val_118
1961134	val_134
1962395	val_395
1963282	val_282
1964138	val_138
1965238	val_238
1966419	val_419
196715	val_15
1968118	val_118
196972	val_72
197090	val_90
1971307	val_307
197219	val_19
1973435	val_435
197410	val_10
1975277	val_277
1976273	val_273
1977306	val_306
1978224	val_224
1979309	val_309
1980389	val_389
1981327	val_327
1982242	val_242
1983369	val_369
1984392	val_392
1985272	val_272
1986331	val_331
1987401	val_401
1988242	val_242
1989452	val_452
1990177	val_177
1991226	val_226
19925	val_5
1993497	val_497
1994402	val_402
1995396	val_396
1996317	val_317
1997395	val_395
199858	val_58
199935	val_35
2000336	val_336
200195	val_95
200211	val_11
2003168	val_168
200434	val_34
2005229	val_229
2006233	val_233
2007143	val_143
2008472	val_472
2009322	val_322
2010498	val_498
2011160	val_160
2012195	val_195
201342	val_42
2014321	val_321
2015430	val_430
2016119	val_119
2017489	val_489
2018458	val_458
201978	val_78
202076	val_76
202141	val_41
2022223	val_223
2023492	val_492
2024149	val_149
2025449	val_449
2026218	val_218
2027228	val_228
2028138	val_138
2029453	val_453
203030	val_30
2031209	val_209
203264	val_64
2033468	val_468
203476	val_76
203574	val_74
2036342	val_342
203769	val_69
2038230	val_230
203933	val_33
2040368	val_368
2041103	val_103
2042296	val_296
2043113	val_113
2044216	val_216
2045367	val_367
2046344	val_344
2047167	val_167
2048274	val_274
2049219	val_219
2050239	val_239
2051485	val_485
2052116	val_116
2053223	val_223
2054256	val_256
2055263	val_263
205670	val_70
2057487	val_487
2058480	val_480
2059401	val_401
2060288	val_288
2061191	val_191
20625	val_5
2063244	val_244
2064438	val_438
2065128	val_128
2066467	val_467
2067432	val_432
2068202	val_202
2069316	val_316
2070229	val_229
2071469	val_469
2072463	val_463
2073280	val_280
20742	val_2
207535	val_35
2076283	val_283
2077331	val_331
2078235	val_235
207980	val_80
208044	val_44
2081193	val_193
2082321	val_321
2083335	val_335
2084104	val_104
2085466	val_466
2086366	val_366
2087175	val_175
2088403	val_403
2089483	val_483
209053	val_53
2091105	val_105
2092257	val_257
2093406	val_406
2094409	val_409
2095190	val_190
2096406	val_406
2097401	val_401
2098114	val_114
2099258	val_258
210090	val_90
2101203	val_203
2102262	val_262
2103348	val_348
2104424	val_424
210512	val_12
2106396	val_396
2107201	val_201
2108217	val_217
2109164	val_164
2110431	val_431
2111454	val_454
2112478	val_478
2113298	val_298
2114125	val_125
2115431	val_431
2116164	val_164
2117424	val_424
2118187	val_187
2119382	val_382
21205	val_5
212170	val_70
2122397	val_397
2123480	val_480
2124291	val_291
212524	val_24
2126351	val_351
2127255	val_255
2128104	val_104
212970	val_70
2130163	val_163
2131438	val_438
2132119	val_119
2133414	val_414
2134200	val_200
2135491	val_491
2136237	val_237
2137439	val_439
2138360	val_360
2139248	val_248
2140479	val_479
2141305	val_305
2142417	val_417
2143199	val_199
2144444	val_444
2145120	val_120
2146429	val_429
2147169	val_169
2148443	val_443
2149323	val_323
2150325	val_325
2151277	val_277
2152230	val_230
2153478	val_478
2154178	val_178
2155468	val_468
2156310	val_310
2157317	val_317
2158333	val_333
2159493	val_493
2160460	val_460
2161207	val_207
2162249	val_249
2163265	val_265
2164480	val_480
216583	val_83
2166136	val_136
2167353	val_353
2168172	val_172
2169214	val_214
2170462	val_462
2171233	val_233
2172406	val_406
2173133	val_133
2174175	val_175
2175189	val_189
2176454	val_454
2177375	val_375
2178401	val_401
2179421	val_421
2180407	val_407
2181384	val_384
2182256	val_256
218326	val_26
2184134	val_134
218567	val_67
2186384	val_384
2187379	val_379
218818	val_18
2189462	val_462
2190492	val_492
2191100	val_100
2192298	val_298
21939	val_9
2194341	val_341
2195498	val_498
2196146	val_146
2197458	val_458
2198362	val_362
2199186	val_186
2200285	val_285
2201348	val_348
2202167	val_167
220318	val_18
2204273	val_273
2205183	val_183
2206281	val_281
2207344	val_344
220897	val_97
2209469	val_469
2210315	val_315
221184	val_84
221228	val_28
221337	val_37
2214448	val_448
2215152	val_152
2216348	val_348
2217307	val_307
2218194	val_194
2219414	val_414
2220477	val_477
2221222	val_222
2222126	val_126
222390	val_90
2224169	val_169
2225403	val_403
2226400	val_400
2227200	val_200
222897	val_97
2229PREHOOK: query: create table merge_src_part2 like merge_src_part
2230PREHOOK: type: CREATETABLE
2231POSTHOOK: query: create table merge_src_part2 like merge_src_part
2232POSTHOOK: type: CREATETABLE
2233POSTHOOK: Output: default@merge_src_part2
2234POSTHOOK: Lineage: merge_src_part PARTITION(ds=2008-04-08).key SIMPLE [(srcpart)srcpart.FieldSchema(name:key, type:string, comment:default), ]
2235POSTHOOK: Lineage: merge_src_part PARTITION(ds=2008-04-08).value SIMPLE [(srcpart)srcpart.FieldSchema(name:value, type:string, comment:default), ]
2236POSTHOOK: Lineage: merge_src_part PARTITION(ds=2008-04-09).key SIMPLE [(srcpart)srcpart.FieldSchema(name:key, type:string, comment:default), ]
2237POSTHOOK: Lineage: merge_src_part PARTITION(ds=2008-04-09).value SIMPLE [(srcpart)srcpart.FieldSchema(name:value, type:string, comment:default), ]
2238PREHOOK: query: explain extended 
2239insert overwrite table merge_src_part2 partition(ds)
2240select key, value, ds from merge_src_part
2241where ds is not null
2242PREHOOK: type: QUERY
2243POSTHOOK: query: explain extended 
2244insert overwrite table merge_src_part2 partition(ds)
2245select key, value, ds from merge_src_part
2246where ds is not null
2247POSTHOOK: type: QUERY
2248POSTHOOK: Lineage: merge_src_part PARTITION(ds=2008-04-08).key SIMPLE [(srcpart)srcpart.FieldSchema(name:key, type:string, comment:default), ]
2249POSTHOOK: Lineage: merge_src_part PARTITION(ds=2008-04-08).value SIMPLE [(srcpart)srcpart.FieldSchema(name:value, type:string, comment:default), ]
2250POSTHOOK: Lineage: merge_src_part PARTITION(ds=2008-04-09).key SIMPLE [(srcpart)srcpart.FieldSchema(name:key, type:string, comment:default), ]
2251POSTHOOK: Lineage: merge_src_part PARTITION(ds=2008-04-09).value SIMPLE [(srcpart)srcpart.FieldSchema(name:value, type:string, comment:default), ]
2252ABSTRACT SYNTAX TREE:
2253  (TOK_QUERY (TOK_FROM (TOK_TABREF (TOK_TABNAME merge_src_part))) (TOK_INSERT (TOK_DESTINATION (TOK_TAB (TOK_TABNAME merge_src_part2) (TOK_PARTSPEC (TOK_PARTVAL ds)))) (TOK_SELECT (TOK_SELEXPR (TOK_TABLE_OR_COL key)) (TOK_SELEXPR (TOK_TABLE_OR_COL value)) (TOK_SELEXPR (TOK_TABLE_OR_COL ds))) (TOK_WHERE (TOK_FUNCTION TOK_ISNOTNULL (TOK_TABLE_OR_COL ds)))))
2254
2255STAGE DEPENDENCIES:
2256  Stage-1 is a root stage
2257  Stage-5 depends on stages: Stage-1 , consists of Stage-4, Stage-3
2258  Stage-4
2259  Stage-0 depends on stages: Stage-4, Stage-3
2260  Stage-2 depends on stages: Stage-0
2261  Stage-3
2262
2263STAGE PLANS:
2264  Stage: Stage-1
2265    Map Reduce
2266      Alias -> Map Operator Tree:
2267        merge_src_part 
2268          TableScan
2269            alias: merge_src_part
2270            GatherStats: false
2271            Select Operator
2272              expressions:
2273                    expr: key
2274                    type: string
2275                    expr: value
2276                    type: string
2277                    expr: ds
2278                    type: string
2279              outputColumnNames: _col0, _col1, _col2
2280              File Output Operator
2281                compressed: false
2282                GlobalTableId: 1
2283                directory: pfile:/home/amarsri/workspace/hive/build/ql/scratchdir/hive_2011-07-11_02-35-46_067_3066864399805575043/-ext-10002
2284                NumFilesPerFileSink: 1
2285                Stats Publishing Key Prefix: pfile:/home/amarsri/workspace/hive/build/ql/scratchdir/hive_2011-07-11_02-35-46_067_3066864399805575043/-ext-10000/
2286                table:
2287                    input format: org.apache.hadoop.mapred.TextInputFormat
2288                    output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
2289                    properties:
2290                      bucket_count -1
2291                      columns key,value
2292                      columns.types string:string
2293                      file.inputformat org.apache.hadoop.mapred.TextInputFormat
2294                      file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
2295                      location pfile:/home/amarsri/workspace/hive/build/ql/test/data/warehouse/merge_src_part2
2296                      name default.merge_src_part2
2297                      partition_columns ds
2298                      serialization.ddl struct merge_src_part2 { string key, string value}
2299                      serialization.format 1
2300                      serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
2301                      transient_lastDdlTime 1310376946
2302                    serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
2303                    name: default.merge_src_part2
2304                TotalFiles: 1
2305                GatherStats: true
2306                MultiFileSpray: false
2307      Needs Tagging: false
2308      Path -> Alias:
2309        pfile:/data/users/tomasz/apache-hive/build/ql/test/data/warehouse/merge_src_part/ds=2008-04-08 [merge_src_part]
2310        pfile:/data/users/tomasz/apache-hive/build/ql/test/data/warehouse/merge_src_part/ds=2008-04-09 [merge_src_part]
2311      Path -> Partition:
2312        pfile:/data/users/tomasz/apache-hive/build/ql/test/data/warehouse/merge_src_part/ds=2008-04-08 
2313          Partition
2314            base file name: ds=2008-04-08
2315            input format: org.apache.hadoop.mapred.TextInputFormat
2316            output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
2317            partition values:
2318              ds 2008-04-08
2319            properties:
2320              bucket_count -1
2321              columns key,value
2322              columns.types string:string
2323              file.inputformat org.apache.hadoop.mapred.TextInputFormat
2324              file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
2325              location pfile:/data/users/tomasz/apache-hive/build/ql/test/data/warehouse/merge_src_part/ds=2008-04-08
2326              name default.merge_src_part
2327              numFiles 2
2328              numPartitions 2
2329              numRows 1000
2330              partition_columns ds
2331              rawDataSize 10624
2332              serialization.ddl struct merge_src_part { string key, string value}
2333              serialization.format 1
2334              serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
2335              totalSize 11624
2336              transient_lastDdlTime 1306983704
2337            serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
2338          
2339              input format: org.apache.hadoop.mapred.TextInputFormat
2340              output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
2341              properties:
2342                bucket_count -1
2343                columns key,value
2344                columns.types string:string
2345                file.inputformat org.apache.hadoop.mapred.TextInputFormat
2346                file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
2347                location pfile:/data/users/tomasz/apache-hive/build/ql/test/data/warehouse/merge_src_part
2348                name default.merge_src_part
2349                numFiles 4
2350                numPartitions 2
2351                numRows 2000
2352                partition_columns ds
2353                rawDataSize 21248
2354                serialization.ddl struct merge_src_part { string key, string value}
2355                serialization.format 1
2356                serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
2357                totalSize 23248
2358                transient_lastDdlTime 1306983704
2359              serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
2360              name: default.merge_src_part
2361            name: default.merge_src_part
2362        pfile:/data/users/tomasz/apache-hive/build/ql/test/data/warehouse/merge_src_part/ds=2008-04-09 
2363          Partition
2364            base file name: ds=2008-04-09
2365            input format: org.apache.hadoop.mapred.TextInputFormat
2366            output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
2367            partition values:
2368              ds 2008-04-09
2369            properties:
2370              bucket_count -1
2371              columns key,value
2372              columns.types string:string
2373              file.inputformat org.apache.hadoop.mapred.TextInputFormat
2374              file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
2375              location pfile:/data/users/tomasz/apache-hive/build/ql/test/data/warehouse/merge_src_part/ds=2008-04-09
2376              name default.merge_src_part
2377              numFiles 2
2378              numPartitions 2
2379              numRows 1000
2380              partition_columns ds
2381              rawDataSize 10624
2382              serialization.ddl struct merge_src_part { string key, string value}
2383              serialization.format 1
2384              serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
2385              totalSize 11624
2386              transient_lastDdlTime 1306983704
2387            serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
2388          
2389              input format: org.apache.hadoop.mapred.TextInputFormat
2390              output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
2391              properties:
2392                bucket_count -1
2393                columns key,value
2394                columns.types string:string
2395                file.inputformat org.apache.hadoop.mapred.TextInputFormat
2396                file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
2397                location pfile:/data/users/tomasz/apache-hive/build/ql/test/data/warehouse/merge_src_part
2398                name default.merge_src_part
2399                numFiles 4
2400                numPartitions 2
2401                numRows 2000
2402                partition_columns ds
2403                rawDataSize 21248
2404                serialization.ddl struct merge_src_part { string key, string value}
2405                serialization.format 1
2406                serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
2407                totalSize 23248
2408                transient_lastDdlTime 1306983704
2409              serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
2410              name: default.merge_src_part
2411            name: default.merge_src_part
2412
2413  Stage: Stage-5
2414    Conditional Operator
2415
2416  Stage: Stage-4
2417    Move Operator
2418      files:
2419          hdfs directory: true
2420          source: pfile:/data/users/tomasz/apache-hive/build/ql/scratchdir/hive_2011-06-01_20-01-51_051_6120737160044680268/-ext-10002
2421          destination: pfile:/data/users/tomasz/apache-hive/build/ql/scratchdir/hive_2011-06-01_20-01-51_051_6120737160044680268/-ext-10000
2422
2423  Stage: Stage-0
2424    Move Operator
2425      tables:
2426          partition:
2427            ds 
2428          replace: true
2429          source: pfile:/data/users/tomasz/apache-hive/build/ql/scratchdir/hive_2011-06-01_20-01-51_051_6120737160044680268/-ext-10000
2430          table:
2431              input format: org.apache.hadoop.mapred.TextInputFormat
2432              output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
2433              properties:
2434                bucket_count -1
2435                columns key,value
2436                columns.types string:string
2437                file.inputformat org.apache.hadoop.mapred.TextInputFormat
2438                file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
2439                location pfile:/data/users/tomasz/apache-hive/build/ql/test/data/warehouse/merge_src_part2
2440                name default.merge_src_part2
2441                partition_columns ds
2442                serialization.ddl struct merge_src_part2 { string key, string value}
2443                serialization.format 1
2444                serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
2445                transient_lastDdlTime 1306983711
2446              serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
2447              name: default.merge_src_part2
2448          tmp directory: pfile:/data/users/tomasz/apache-hive/build/ql/scratchdir/hive_2011-06-01_20-01-51_051_6120737160044680268/-ext-10001
2449
2450  Stage: Stage-2
2451    Stats-Aggr Operator
2452      Stats Aggregation Key Prefix: pfile:/data/users/tomasz/apache-hive/build/ql/scratchdir/hive_2011-06-01_20-01-51_051_6120737160044680268/-ext-10000/
2453
2454  Stage: Stage-3
2455    Map Reduce
2456      Alias -> Map Operator Tree:
2457        pfile:/data/users/tomasz/apache-hive/build/ql/scratchdir/hive_2011-06-01_20-01-51_051_6120737160044680268/-ext-10002 
2458            File Output Operator
2459              compressed: false
2460              GlobalTableId: 0
2461              directory: pfile:/data/users/tomasz/apache-hive/build/ql/scratchdir/hive_2011-06-01_20-01-51_051_6120737160044680268/-ext-10000
2462              NumFilesPerFileSink: 1
2463              table:
2464                  input format: org.apache.hadoop.mapred.TextInputFormat
2465                  output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
2466                  properties:
2467                    bucket_count -1
2468                    columns key,value
2469                    columns.types string:string
2470                    file.inputformat org.apache.hadoop.mapred.TextInputFormat
2471                    file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
2472                    location pfile:/data/users/tomasz/apache-hive/build/ql/test/data/warehouse/merge_src_part2
2473                    name default.merge_src_part2
2474                    partition_columns ds
2475                    serialization.ddl struct merge_src_part2 { string key, string value}
2476                    serialization.format 1
2477                    serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
2478                    transient_lastDdlTime 1306983711
2479                  serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
2480                  name: default.merge_src_part2
2481              TotalFiles: 1
2482              GatherStats: false
2483              MultiFileSpray: false
2484      Needs Tagging: false
2485      Path -> Alias:
2486        pfile:/data/users/tomasz/apache-hive/build/ql/scratchdir/hive_2011-06-01_20-01-51_051_6120737160044680268/-ext-10002 [pfile:/data/users/tomasz/apache-hive/build/ql/scratchdir/hive_2011-06-01_20-01-51_051_6120737160044680268/-ext-10002]
2487      Path -> Partition:
2488        pfile:/data/users/tomasz/apache-hive/build/ql/scratchdir/hive_2011-06-01_20-01-51_051_6120737160044680268/-ext-10002 
2489          Partition
2490            base file name: -ext-10002
2491            input format: org.apache.hadoop.mapred.TextInputFormat
2492            output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
2493            properties:
2494              bucket_count -1
2495              columns key,value
2496              columns.types string:string
2497              file.inputforma…

Large files files are truncated, but you can click here to view the full file