PageRenderTime 67ms CodeModel.GetById 17ms app.highlight 34ms RepoModel.GetById 1ms app.codeStats 1ms

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

#
text | 4006 lines | 3972 code | 34 blank | 0 comment | 0 complexity | 6cef18a732eab18be3ff7efa602ee397 MD5 | raw file

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

   1PREHOOK: query: EXPLAIN SELECT x.key, x.value, y.key, y.value
   2FROM src x left outer JOIN (select * from src where key <= 100) y ON (x.key = y.key)
   3PREHOOK: type: QUERY
   4POSTHOOK: query: EXPLAIN SELECT x.key, x.value, y.key, y.value
   5FROM src x left outer JOIN (select * from src where key <= 100) y ON (x.key = y.key)
   6POSTHOOK: type: QUERY
   7ABSTRACT SYNTAX TREE:
   8  (TOK_QUERY (TOK_FROM (TOK_LEFTOUTERJOIN (TOK_TABREF (TOK_TABNAME src) x) (TOK_SUBQUERY (TOK_QUERY (TOK_FROM (TOK_TABREF (TOK_TABNAME src))) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR TOK_ALLCOLREF)) (TOK_WHERE (<= (TOK_TABLE_OR_COL key) 100)))) y) (= (. (TOK_TABLE_OR_COL x) key) (. (TOK_TABLE_OR_COL y) key)))) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR (. (TOK_TABLE_OR_COL x) key)) (TOK_SELEXPR (. (TOK_TABLE_OR_COL x) value)) (TOK_SELEXPR (. (TOK_TABLE_OR_COL y) key)) (TOK_SELEXPR (. (TOK_TABLE_OR_COL y) value)))))
   9
  10STAGE DEPENDENCIES:
  11  Stage-1 is a root stage
  12  Stage-0 is a root stage
  13
  14STAGE PLANS:
  15  Stage: Stage-1
  16    Map Reduce
  17      Alias -> Map Operator Tree:
  18        x 
  19          TableScan
  20            alias: x
  21            Reduce Output Operator
  22              key expressions:
  23                    expr: key
  24                    type: string
  25              sort order: +
  26              Map-reduce partition columns:
  27                    expr: key
  28                    type: string
  29              tag: 0
  30              value expressions:
  31                    expr: key
  32                    type: string
  33                    expr: value
  34                    type: string
  35        y:src 
  36          TableScan
  37            alias: src
  38            Filter Operator
  39              predicate:
  40                  expr: (key <= 100)
  41                  type: boolean
  42              Select Operator
  43                expressions:
  44                      expr: key
  45                      type: string
  46                      expr: value
  47                      type: string
  48                outputColumnNames: _col0, _col1
  49                Reduce Output Operator
  50                  key expressions:
  51                        expr: _col0
  52                        type: string
  53                  sort order: +
  54                  Map-reduce partition columns:
  55                        expr: _col0
  56                        type: string
  57                  tag: 1
  58                  value expressions:
  59                        expr: _col0
  60                        type: string
  61                        expr: _col1
  62                        type: string
  63      Reduce Operator Tree:
  64        Join Operator
  65          condition map:
  66               Left Outer Join0 to 1
  67          condition expressions:
  68            0 {VALUE._col0} {VALUE._col1}
  69            1 {VALUE._col0} {VALUE._col1}
  70          handleSkewJoin: false
  71          outputColumnNames: _col0, _col1, _col4, _col5
  72          Select Operator
  73            expressions:
  74                  expr: _col0
  75                  type: string
  76                  expr: _col1
  77                  type: string
  78                  expr: _col4
  79                  type: string
  80                  expr: _col5
  81                  type: string
  82            outputColumnNames: _col0, _col1, _col2, _col3
  83            File Output Operator
  84              compressed: false
  85              GlobalTableId: 0
  86              table:
  87                  input format: org.apache.hadoop.mapred.TextInputFormat
  88                  output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
  89
  90  Stage: Stage-0
  91    Fetch Operator
  92      limit: -1
  93
  94
  95PREHOOK: query: SELECT x.key, x.value, y.key, y.value
  96FROM src x left outer JOIN (select * from src where key <= 100) y ON (x.key = y.key)
  97PREHOOK: type: QUERY
  98PREHOOK: Input: default@src
  99PREHOOK: Output: file:/tmp/sdong/hive_2011-02-10_16-07-26_728_575634996407286755/-mr-10000
 100POSTHOOK: query: SELECT x.key, x.value, y.key, y.value
 101FROM src x left outer JOIN (select * from src where key <= 100) y ON (x.key = y.key)
 102POSTHOOK: type: QUERY
 103POSTHOOK: Input: default@src
 104POSTHOOK: Output: file:/tmp/sdong/hive_2011-02-10_16-07-26_728_575634996407286755/-mr-10000
 1050	val_0	0	val_0
 1060	val_0	0	val_0
 1070	val_0	0	val_0
 1080	val_0	0	val_0
 1090	val_0	0	val_0
 1100	val_0	0	val_0
 1110	val_0	0	val_0
 1120	val_0	0	val_0
 1130	val_0	0	val_0
 11410	val_10	10	val_10
 115100	val_100	100	val_100
 116100	val_100	100	val_100
 117100	val_100	100	val_100
 118100	val_100	100	val_100
 119103	val_103	NULL	NULL
 120103	val_103	NULL	NULL
 121104	val_104	NULL	NULL
 122104	val_104	NULL	NULL
 123105	val_105	NULL	NULL
 12411	val_11	11	val_11
 125111	val_111	NULL	NULL
 126113	val_113	NULL	NULL
 127113	val_113	NULL	NULL
 128114	val_114	NULL	NULL
 129116	val_116	NULL	NULL
 130118	val_118	NULL	NULL
 131118	val_118	NULL	NULL
 132119	val_119	NULL	NULL
 133119	val_119	NULL	NULL
 134119	val_119	NULL	NULL
 13512	val_12	12	val_12
 13612	val_12	12	val_12
 13712	val_12	12	val_12
 13812	val_12	12	val_12
 139120	val_120	NULL	NULL
 140120	val_120	NULL	NULL
 141125	val_125	NULL	NULL
 142125	val_125	NULL	NULL
 143126	val_126	NULL	NULL
 144128	val_128	NULL	NULL
 145128	val_128	NULL	NULL
 146128	val_128	NULL	NULL
 147129	val_129	NULL	NULL
 148129	val_129	NULL	NULL
 149131	val_131	NULL	NULL
 150133	val_133	NULL	NULL
 151134	val_134	NULL	NULL
 152134	val_134	NULL	NULL
 153136	val_136	NULL	NULL
 154137	val_137	NULL	NULL
 155137	val_137	NULL	NULL
 156138	val_138	NULL	NULL
 157138	val_138	NULL	NULL
 158138	val_138	NULL	NULL
 159138	val_138	NULL	NULL
 160143	val_143	NULL	NULL
 161145	val_145	NULL	NULL
 162146	val_146	NULL	NULL
 163146	val_146	NULL	NULL
 164149	val_149	NULL	NULL
 165149	val_149	NULL	NULL
 16615	val_15	15	val_15
 16715	val_15	15	val_15
 16815	val_15	15	val_15
 16915	val_15	15	val_15
 170150	val_150	NULL	NULL
 171152	val_152	NULL	NULL
 172152	val_152	NULL	NULL
 173153	val_153	NULL	NULL
 174155	val_155	NULL	NULL
 175156	val_156	NULL	NULL
 176157	val_157	NULL	NULL
 177158	val_158	NULL	NULL
 178160	val_160	NULL	NULL
 179162	val_162	NULL	NULL
 180163	val_163	NULL	NULL
 181164	val_164	NULL	NULL
 182164	val_164	NULL	NULL
 183165	val_165	NULL	NULL
 184165	val_165	NULL	NULL
 185166	val_166	NULL	NULL
 186167	val_167	NULL	NULL
 187167	val_167	NULL	NULL
 188167	val_167	NULL	NULL
 189168	val_168	NULL	NULL
 190169	val_169	NULL	NULL
 191169	val_169	NULL	NULL
 192169	val_169	NULL	NULL
 193169	val_169	NULL	NULL
 19417	val_17	17	val_17
 195170	val_170	NULL	NULL
 196172	val_172	NULL	NULL
 197172	val_172	NULL	NULL
 198174	val_174	NULL	NULL
 199174	val_174	NULL	NULL
 200175	val_175	NULL	NULL
 201175	val_175	NULL	NULL
 202176	val_176	NULL	NULL
 203176	val_176	NULL	NULL
 204177	val_177	NULL	NULL
 205178	val_178	NULL	NULL
 206179	val_179	NULL	NULL
 207179	val_179	NULL	NULL
 20818	val_18	18	val_18
 20918	val_18	18	val_18
 21018	val_18	18	val_18
 21118	val_18	18	val_18
 212180	val_180	NULL	NULL
 213181	val_181	NULL	NULL
 214183	val_183	NULL	NULL
 215186	val_186	NULL	NULL
 216187	val_187	NULL	NULL
 217187	val_187	NULL	NULL
 218187	val_187	NULL	NULL
 219189	val_189	NULL	NULL
 22019	val_19	19	val_19
 221190	val_190	NULL	NULL
 222191	val_191	NULL	NULL
 223191	val_191	NULL	NULL
 224192	val_192	NULL	NULL
 225193	val_193	NULL	NULL
 226193	val_193	NULL	NULL
 227193	val_193	NULL	NULL
 228194	val_194	NULL	NULL
 229195	val_195	NULL	NULL
 230195	val_195	NULL	NULL
 231196	val_196	NULL	NULL
 232197	val_197	NULL	NULL
 233197	val_197	NULL	NULL
 234199	val_199	NULL	NULL
 235199	val_199	NULL	NULL
 236199	val_199	NULL	NULL
 2372	val_2	2	val_2
 23820	val_20	20	val_20
 239200	val_200	NULL	NULL
 240200	val_200	NULL	NULL
 241201	val_201	NULL	NULL
 242202	val_202	NULL	NULL
 243203	val_203	NULL	NULL
 244203	val_203	NULL	NULL
 245205	val_205	NULL	NULL
 246205	val_205	NULL	NULL
 247207	val_207	NULL	NULL
 248207	val_207	NULL	NULL
 249208	val_208	NULL	NULL
 250208	val_208	NULL	NULL
 251208	val_208	NULL	NULL
 252209	val_209	NULL	NULL
 253209	val_209	NULL	NULL
 254213	val_213	NULL	NULL
 255213	val_213	NULL	NULL
 256214	val_214	NULL	NULL
 257216	val_216	NULL	NULL
 258216	val_216	NULL	NULL
 259217	val_217	NULL	NULL
 260217	val_217	NULL	NULL
 261218	val_218	NULL	NULL
 262219	val_219	NULL	NULL
 263219	val_219	NULL	NULL
 264221	val_221	NULL	NULL
 265221	val_221	NULL	NULL
 266222	val_222	NULL	NULL
 267223	val_223	NULL	NULL
 268223	val_223	NULL	NULL
 269224	val_224	NULL	NULL
 270224	val_224	NULL	NULL
 271226	val_226	NULL	NULL
 272228	val_228	NULL	NULL
 273229	val_229	NULL	NULL
 274229	val_229	NULL	NULL
 275230	val_230	NULL	NULL
 276230	val_230	NULL	NULL
 277230	val_230	NULL	NULL
 278230	val_230	NULL	NULL
 279230	val_230	NULL	NULL
 280233	val_233	NULL	NULL
 281233	val_233	NULL	NULL
 282235	val_235	NULL	NULL
 283237	val_237	NULL	NULL
 284237	val_237	NULL	NULL
 285238	val_238	NULL	NULL
 286238	val_238	NULL	NULL
 287239	val_239	NULL	NULL
 288239	val_239	NULL	NULL
 28924	val_24	24	val_24
 29024	val_24	24	val_24
 29124	val_24	24	val_24
 29224	val_24	24	val_24
 293241	val_241	NULL	NULL
 294242	val_242	NULL	NULL
 295242	val_242	NULL	NULL
 296244	val_244	NULL	NULL
 297247	val_247	NULL	NULL
 298248	val_248	NULL	NULL
 299249	val_249	NULL	NULL
 300252	val_252	NULL	NULL
 301255	val_255	NULL	NULL
 302255	val_255	NULL	NULL
 303256	val_256	NULL	NULL
 304256	val_256	NULL	NULL
 305257	val_257	NULL	NULL
 306258	val_258	NULL	NULL
 30726	val_26	26	val_26
 30826	val_26	26	val_26
 30926	val_26	26	val_26
 31026	val_26	26	val_26
 311260	val_260	NULL	NULL
 312262	val_262	NULL	NULL
 313263	val_263	NULL	NULL
 314265	val_265	NULL	NULL
 315265	val_265	NULL	NULL
 316266	val_266	NULL	NULL
 31727	val_27	27	val_27
 318272	val_272	NULL	NULL
 319272	val_272	NULL	NULL
 320273	val_273	NULL	NULL
 321273	val_273	NULL	NULL
 322273	val_273	NULL	NULL
 323274	val_274	NULL	NULL
 324275	val_275	NULL	NULL
 325277	val_277	NULL	NULL
 326277	val_277	NULL	NULL
 327277	val_277	NULL	NULL
 328277	val_277	NULL	NULL
 329278	val_278	NULL	NULL
 330278	val_278	NULL	NULL
 33128	val_28	28	val_28
 332280	val_280	NULL	NULL
 333280	val_280	NULL	NULL
 334281	val_281	NULL	NULL
 335281	val_281	NULL	NULL
 336282	val_282	NULL	NULL
 337282	val_282	NULL	NULL
 338283	val_283	NULL	NULL
 339284	val_284	NULL	NULL
 340285	val_285	NULL	NULL
 341286	val_286	NULL	NULL
 342287	val_287	NULL	NULL
 343288	val_288	NULL	NULL
 344288	val_288	NULL	NULL
 345289	val_289	NULL	NULL
 346291	val_291	NULL	NULL
 347292	val_292	NULL	NULL
 348296	val_296	NULL	NULL
 349298	val_298	NULL	NULL
 350298	val_298	NULL	NULL
 351298	val_298	NULL	NULL
 35230	val_30	30	val_30
 353302	val_302	NULL	NULL
 354305	val_305	NULL	NULL
 355306	val_306	NULL	NULL
 356307	val_307	NULL	NULL
 357307	val_307	NULL	NULL
 358308	val_308	NULL	NULL
 359309	val_309	NULL	NULL
 360309	val_309	NULL	NULL
 361310	val_310	NULL	NULL
 362311	val_311	NULL	NULL
 363311	val_311	NULL	NULL
 364311	val_311	NULL	NULL
 365315	val_315	NULL	NULL
 366316	val_316	NULL	NULL
 367316	val_316	NULL	NULL
 368316	val_316	NULL	NULL
 369317	val_317	NULL	NULL
 370317	val_317	NULL	NULL
 371318	val_318	NULL	NULL
 372318	val_318	NULL	NULL
 373318	val_318	NULL	NULL
 374321	val_321	NULL	NULL
 375321	val_321	NULL	NULL
 376322	val_322	NULL	NULL
 377322	val_322	NULL	NULL
 378323	val_323	NULL	NULL
 379325	val_325	NULL	NULL
 380325	val_325	NULL	NULL
 381327	val_327	NULL	NULL
 382327	val_327	NULL	NULL
 383327	val_327	NULL	NULL
 38433	val_33	33	val_33
 385331	val_331	NULL	NULL
 386331	val_331	NULL	NULL
 387332	val_332	NULL	NULL
 388333	val_333	NULL	NULL
 389333	val_333	NULL	NULL
 390335	val_335	NULL	NULL
 391336	val_336	NULL	NULL
 392338	val_338	NULL	NULL
 393339	val_339	NULL	NULL
 39434	val_34	34	val_34
 395341	val_341	NULL	NULL
 396342	val_342	NULL	NULL
 397342	val_342	NULL	NULL
 398344	val_344	NULL	NULL
 399344	val_344	NULL	NULL
 400345	val_345	NULL	NULL
 401348	val_348	NULL	NULL
 402348	val_348	NULL	NULL
 403348	val_348	NULL	NULL
 404348	val_348	NULL	NULL
 405348	val_348	NULL	NULL
 40635	val_35	35	val_35
 40735	val_35	35	val_35
 40835	val_35	35	val_35
 40935	val_35	35	val_35
 41035	val_35	35	val_35
 41135	val_35	35	val_35
 41235	val_35	35	val_35
 41335	val_35	35	val_35
 41435	val_35	35	val_35
 415351	val_351	NULL	NULL
 416353	val_353	NULL	NULL
 417353	val_353	NULL	NULL
 418356	val_356	NULL	NULL
 419360	val_360	NULL	NULL
 420362	val_362	NULL	NULL
 421364	val_364	NULL	NULL
 422365	val_365	NULL	NULL
 423366	val_366	NULL	NULL
 424367	val_367	NULL	NULL
 425367	val_367	NULL	NULL
 426368	val_368	NULL	NULL
 427369	val_369	NULL	NULL
 428369	val_369	NULL	NULL
 429369	val_369	NULL	NULL
 43037	val_37	37	val_37
 43137	val_37	37	val_37
 43237	val_37	37	val_37
 43337	val_37	37	val_37
 434373	val_373	NULL	NULL
 435374	val_374	NULL	NULL
 436375	val_375	NULL	NULL
 437377	val_377	NULL	NULL
 438378	val_378	NULL	NULL
 439379	val_379	NULL	NULL
 440382	val_382	NULL	NULL
 441382	val_382	NULL	NULL
 442384	val_384	NULL	NULL
 443384	val_384	NULL	NULL
 444384	val_384	NULL	NULL
 445386	val_386	NULL	NULL
 446389	val_389	NULL	NULL
 447392	val_392	NULL	NULL
 448393	val_393	NULL	NULL
 449394	val_394	NULL	NULL
 450395	val_395	NULL	NULL
 451395	val_395	NULL	NULL
 452396	val_396	NULL	NULL
 453396	val_396	NULL	NULL
 454396	val_396	NULL	NULL
 455397	val_397	NULL	NULL
 456397	val_397	NULL	NULL
 457399	val_399	NULL	NULL
 458399	val_399	NULL	NULL
 4594	val_4	4	val_4
 460400	val_400	NULL	NULL
 461401	val_401	NULL	NULL
 462401	val_401	NULL	NULL
 463401	val_401	NULL	NULL
 464401	val_401	NULL	NULL
 465401	val_401	NULL	NULL
 466402	val_402	NULL	NULL
 467403	val_403	NULL	NULL
 468403	val_403	NULL	NULL
 469403	val_403	NULL	NULL
 470404	val_404	NULL	NULL
 471404	val_404	NULL	NULL
 472406	val_406	NULL	NULL
 473406	val_406	NULL	NULL
 474406	val_406	NULL	NULL
 475406	val_406	NULL	NULL
 476407	val_407	NULL	NULL
 477409	val_409	NULL	NULL
 478409	val_409	NULL	NULL
 479409	val_409	NULL	NULL
 48041	val_41	41	val_41
 481411	val_411	NULL	NULL
 482413	val_413	NULL	NULL
 483413	val_413	NULL	NULL
 484414	val_414	NULL	NULL
 485414	val_414	NULL	NULL
 486417	val_417	NULL	NULL
 487417	val_417	NULL	NULL
 488417	val_417	NULL	NULL
 489418	val_418	NULL	NULL
 490419	val_419	NULL	NULL
 49142	val_42	42	val_42
 49242	val_42	42	val_42
 49342	val_42	42	val_42
 49442	val_42	42	val_42
 495421	val_421	NULL	NULL
 496424	val_424	NULL	NULL
 497424	val_424	NULL	NULL
 498427	val_427	NULL	NULL
 499429	val_429	NULL	NULL
 500429	val_429	NULL	NULL
 50143	val_43	43	val_43
 502430	val_430	NULL	NULL
 503430	val_430	NULL	NULL
 504430	val_430	NULL	NULL
 505431	val_431	NULL	NULL
 506431	val_431	NULL	NULL
 507431	val_431	NULL	NULL
 508432	val_432	NULL	NULL
 509435	val_435	NULL	NULL
 510436	val_436	NULL	NULL
 511437	val_437	NULL	NULL
 512438	val_438	NULL	NULL
 513438	val_438	NULL	NULL
 514438	val_438	NULL	NULL
 515439	val_439	NULL	NULL
 516439	val_439	NULL	NULL
 51744	val_44	44	val_44
 518443	val_443	NULL	NULL
 519444	val_444	NULL	NULL
 520446	val_446	NULL	NULL
 521448	val_448	NULL	NULL
 522449	val_449	NULL	NULL
 523452	val_452	NULL	NULL
 524453	val_453	NULL	NULL
 525454	val_454	NULL	NULL
 526454	val_454	NULL	NULL
 527454	val_454	NULL	NULL
 528455	val_455	NULL	NULL
 529457	val_457	NULL	NULL
 530458	val_458	NULL	NULL
 531458	val_458	NULL	NULL
 532459	val_459	NULL	NULL
 533459	val_459	NULL	NULL
 534460	val_460	NULL	NULL
 535462	val_462	NULL	NULL
 536462	val_462	NULL	NULL
 537463	val_463	NULL	NULL
 538463	val_463	NULL	NULL
 539466	val_466	NULL	NULL
 540466	val_466	NULL	NULL
 541466	val_466	NULL	NULL
 542467	val_467	NULL	NULL
 543468	val_468	NULL	NULL
 544468	val_468	NULL	NULL
 545468	val_468	NULL	NULL
 546468	val_468	NULL	NULL
 547469	val_469	NULL	NULL
 548469	val_469	NULL	NULL
 549469	val_469	NULL	NULL
 550469	val_469	NULL	NULL
 551469	val_469	NULL	NULL
 55247	val_47	47	val_47
 553470	val_470	NULL	NULL
 554472	val_472	NULL	NULL
 555475	val_475	NULL	NULL
 556477	val_477	NULL	NULL
 557478	val_478	NULL	NULL
 558478	val_478	NULL	NULL
 559479	val_479	NULL	NULL
 560480	val_480	NULL	NULL
 561480	val_480	NULL	NULL
 562480	val_480	NULL	NULL
 563481	val_481	NULL	NULL
 564482	val_482	NULL	NULL
 565483	val_483	NULL	NULL
 566484	val_484	NULL	NULL
 567485	val_485	NULL	NULL
 568487	val_487	NULL	NULL
 569489	val_489	NULL	NULL
 570489	val_489	NULL	NULL
 571489	val_489	NULL	NULL
 572489	val_489	NULL	NULL
 573490	val_490	NULL	NULL
 574491	val_491	NULL	NULL
 575492	val_492	NULL	NULL
 576492	val_492	NULL	NULL
 577493	val_493	NULL	NULL
 578494	val_494	NULL	NULL
 579495	val_495	NULL	NULL
 580496	val_496	NULL	NULL
 581497	val_497	NULL	NULL
 582498	val_498	NULL	NULL
 583498	val_498	NULL	NULL
 584498	val_498	NULL	NULL
 5855	val_5	5	val_5
 5865	val_5	5	val_5
 5875	val_5	5	val_5
 5885	val_5	5	val_5
 5895	val_5	5	val_5
 5905	val_5	5	val_5
 5915	val_5	5	val_5
 5925	val_5	5	val_5
 5935	val_5	5	val_5
 59451	val_51	51	val_51
 59551	val_51	51	val_51
 59651	val_51	51	val_51
 59751	val_51	51	val_51
 59853	val_53	53	val_53
 59954	val_54	54	val_54
 60057	val_57	57	val_57
 60158	val_58	58	val_58
 60258	val_58	58	val_58
 60358	val_58	58	val_58
 60458	val_58	58	val_58
 60564	val_64	64	val_64
 60665	val_65	65	val_65
 60766	val_66	66	val_66
 60867	val_67	67	val_67
 60967	val_67	67	val_67
 61067	val_67	67	val_67
 61167	val_67	67	val_67
 61269	val_69	69	val_69
 61370	val_70	70	val_70
 61470	val_70	70	val_70
 61570	val_70	70	val_70
 61670	val_70	70	val_70
 61770	val_70	70	val_70
 61870	val_70	70	val_70
 61970	val_70	70	val_70
 62070	val_70	70	val_70
 62170	val_70	70	val_70
 62272	val_72	72	val_72
 62372	val_72	72	val_72
 62472	val_72	72	val_72
 62572	val_72	72	val_72
 62674	val_74	74	val_74
 62776	val_76	76	val_76
 62876	val_76	76	val_76
 62976	val_76	76	val_76
 63076	val_76	76	val_76
 63177	val_77	77	val_77
 63278	val_78	78	val_78
 6338	val_8	8	val_8
 63480	val_80	80	val_80
 63582	val_82	82	val_82
 63683	val_83	83	val_83
 63783	val_83	83	val_83
 63883	val_83	83	val_83
 63983	val_83	83	val_83
 64084	val_84	84	val_84
 64184	val_84	84	val_84
 64284	val_84	84	val_84
 64384	val_84	84	val_84
 64485	val_85	85	val_85
 64586	val_86	86	val_86
 64687	val_87	87	val_87
 6479	val_9	9	val_9
 64890	val_90	90	val_90
 64990	val_90	90	val_90
 65090	val_90	90	val_90
 65190	val_90	90	val_90
 65290	val_90	90	val_90
 65390	val_90	90	val_90
 65490	val_90	90	val_90
 65590	val_90	90	val_90
 65690	val_90	90	val_90
 65792	val_92	92	val_92
 65895	val_95	95	val_95
 65995	val_95	95	val_95
 66095	val_95	95	val_95
 66195	val_95	95	val_95
 66296	val_96	96	val_96
 66397	val_97	97	val_97
 66497	val_97	97	val_97
 66597	val_97	97	val_97
 66697	val_97	97	val_97
 66798	val_98	98	val_98
 66898	val_98	98	val_98
 66998	val_98	98	val_98
 67098	val_98	98	val_98
 671PREHOOK: query: EXPLAIN select src1.key, src2.value 
 672FROM src src1 JOIN src src2 ON (src1.key = src2.key)
 673PREHOOK: type: QUERY
 674POSTHOOK: query: EXPLAIN select src1.key, src2.value 
 675FROM src src1 JOIN src src2 ON (src1.key = src2.key)
 676POSTHOOK: type: QUERY
 677ABSTRACT SYNTAX TREE:
 678  (TOK_QUERY (TOK_FROM (TOK_JOIN (TOK_TABREF (TOK_TABNAME src) src1) (TOK_TABREF (TOK_TABNAME src) src2) (= (. (TOK_TABLE_OR_COL src1) key) (. (TOK_TABLE_OR_COL src2) key)))) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR (. (TOK_TABLE_OR_COL src1) key)) (TOK_SELEXPR (. (TOK_TABLE_OR_COL src2) value)))))
 679
 680STAGE DEPENDENCIES:
 681  Stage-1 is a root stage
 682  Stage-0 is a root stage
 683
 684STAGE PLANS:
 685  Stage: Stage-1
 686    Map Reduce
 687      Alias -> Map Operator Tree:
 688        src1 
 689          TableScan
 690            alias: src1
 691            Reduce Output Operator
 692              key expressions:
 693                    expr: key
 694                    type: string
 695              sort order: +
 696              Map-reduce partition columns:
 697                    expr: key
 698                    type: string
 699              tag: 0
 700              value expressions:
 701                    expr: key
 702                    type: string
 703        src2 
 704          TableScan
 705            alias: src2
 706            Reduce Output Operator
 707              key expressions:
 708                    expr: key
 709                    type: string
 710              sort order: +
 711              Map-reduce partition columns:
 712                    expr: key
 713                    type: string
 714              tag: 1
 715              value expressions:
 716                    expr: value
 717                    type: string
 718      Reduce Operator Tree:
 719        Join Operator
 720          condition map:
 721               Inner Join 0 to 1
 722          condition expressions:
 723            0 {VALUE._col0}
 724            1 {VALUE._col1}
 725          handleSkewJoin: false
 726          outputColumnNames: _col0, _col5
 727          Select Operator
 728            expressions:
 729                  expr: _col0
 730                  type: string
 731                  expr: _col5
 732                  type: string
 733            outputColumnNames: _col0, _col1
 734            File Output Operator
 735              compressed: false
 736              GlobalTableId: 0
 737              table:
 738                  input format: org.apache.hadoop.mapred.TextInputFormat
 739                  output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
 740
 741  Stage: Stage-0
 742    Fetch Operator
 743      limit: -1
 744
 745
 746PREHOOK: query: select src1.key, src2.value 
 747FROM src src1 JOIN src src2 ON (src1.key = src2.key)
 748PREHOOK: type: QUERY
 749PREHOOK: Input: default@src
 750PREHOOK: Output: file:/tmp/sdong/hive_2011-02-10_16-07-34_633_2787732427056663675/-mr-10000
 751POSTHOOK: query: select src1.key, src2.value 
 752FROM src src1 JOIN src src2 ON (src1.key = src2.key)
 753POSTHOOK: type: QUERY
 754POSTHOOK: Input: default@src
 755POSTHOOK: Output: file:/tmp/sdong/hive_2011-02-10_16-07-34_633_2787732427056663675/-mr-10000
 7560	val_0
 7570	val_0
 7580	val_0
 7590	val_0
 7600	val_0
 7610	val_0
 7620	val_0
 7630	val_0
 7640	val_0
 76510	val_10
 766100	val_100
 767100	val_100
 768100	val_100
 769100	val_100
 770103	val_103
 771103	val_103
 772103	val_103
 773103	val_103
 774104	val_104
 775104	val_104
 776104	val_104
 777104	val_104
 778105	val_105
 77911	val_11
 780111	val_111
 781113	val_113
 782113	val_113
 783113	val_113
 784113	val_113
 785114	val_114
 786116	val_116
 787118	val_118
 788118	val_118
 789118	val_118
 790118	val_118
 791119	val_119
 792119	val_119
 793119	val_119
 794119	val_119
 795119	val_119
 796119	val_119
 797119	val_119
 798119	val_119
 799119	val_119
 80012	val_12
 80112	val_12
 80212	val_12
 80312	val_12
 804120	val_120
 805120	val_120
 806120	val_120
 807120	val_120
 808125	val_125
 809125	val_125
 810125	val_125
 811125	val_125
 812126	val_126
 813128	val_128
 814128	val_128
 815128	val_128
 816128	val_128
 817128	val_128
 818128	val_128
 819128	val_128
 820128	val_128
 821128	val_128
 822129	val_129
 823129	val_129
 824129	val_129
 825129	val_129
 826131	val_131
 827133	val_133
 828134	val_134
 829134	val_134
 830134	val_134
 831134	val_134
 832136	val_136
 833137	val_137
 834137	val_137
 835137	val_137
 836137	val_137
 837138	val_138
 838138	val_138
 839138	val_138
 840138	val_138
 841138	val_138
 842138	val_138
 843138	val_138
 844138	val_138
 845138	val_138
 846138	val_138
 847138	val_138
 848138	val_138
 849138	val_138
 850138	val_138
 851138	val_138
 852138	val_138
 853143	val_143
 854145	val_145
 855146	val_146
 856146	val_146
 857146	val_146
 858146	val_146
 859149	val_149
 860149	val_149
 861149	val_149
 862149	val_149
 86315	val_15
 86415	val_15
 86515	val_15
 86615	val_15
 867150	val_150
 868152	val_152
 869152	val_152
 870152	val_152
 871152	val_152
 872153	val_153
 873155	val_155
 874156	val_156
 875157	val_157
 876158	val_158
 877160	val_160
 878162	val_162
 879163	val_163
 880164	val_164
 881164	val_164
 882164	val_164
 883164	val_164
 884165	val_165
 885165	val_165
 886165	val_165
 887165	val_165
 888166	val_166
 889167	val_167
 890167	val_167
 891167	val_167
 892167	val_167
 893167	val_167
 894167	val_167
 895167	val_167
 896167	val_167
 897167	val_167
 898168	val_168
 899169	val_169
 900169	val_169
 901169	val_169
 902169	val_169
 903169	val_169
 904169	val_169
 905169	val_169
 906169	val_169
 907169	val_169
 908169	val_169
 909169	val_169
 910169	val_169
 911169	val_169
 912169	val_169
 913169	val_169
 914169	val_169
 91517	val_17
 916170	val_170
 917172	val_172
 918172	val_172
 919172	val_172
 920172	val_172
 921174	val_174
 922174	val_174
 923174	val_174
 924174	val_174
 925175	val_175
 926175	val_175
 927175	val_175
 928175	val_175
 929176	val_176
 930176	val_176
 931176	val_176
 932176	val_176
 933177	val_177
 934178	val_178
 935179	val_179
 936179	val_179
 937179	val_179
 938179	val_179
 93918	val_18
 94018	val_18
 94118	val_18
 94218	val_18
 943180	val_180
 944181	val_181
 945183	val_183
 946186	val_186
 947187	val_187
 948187	val_187
 949187	val_187
 950187	val_187
 951187	val_187
 952187	val_187
 953187	val_187
 954187	val_187
 955187	val_187
 956189	val_189
 95719	val_19
 958190	val_190
 959191	val_191
 960191	val_191
 961191	val_191
 962191	val_191
 963192	val_192
 964193	val_193
 965193	val_193
 966193	val_193
 967193	val_193
 968193	val_193
 969193	val_193
 970193	val_193
 971193	val_193
 972193	val_193
 973194	val_194
 974195	val_195
 975195	val_195
 976195	val_195
 977195	val_195
 978196	val_196
 979197	val_197
 980197	val_197
 981197	val_197
 982197	val_197
 983199	val_199
 984199	val_199
 985199	val_199
 986199	val_199
 987199	val_199
 988199	val_199
 989199	val_199
 990199	val_199
 991199	val_199
 9922	val_2
 99320	val_20
 994200	val_200
 995200	val_200
 996200	val_200
 997200	val_200
 998201	val_201
 999202	val_202
1000203	val_203
1001203	val_203
1002203	val_203
1003203	val_203
1004205	val_205
1005205	val_205
1006205	val_205
1007205	val_205
1008207	val_207
1009207	val_207
1010207	val_207
1011207	val_207
1012208	val_208
1013208	val_208
1014208	val_208
1015208	val_208
1016208	val_208
1017208	val_208
1018208	val_208
1019208	val_208
1020208	val_208
1021209	val_209
1022209	val_209
1023209	val_209
1024209	val_209
1025213	val_213
1026213	val_213
1027213	val_213
1028213	val_213
1029214	val_214
1030216	val_216
1031216	val_216
1032216	val_216
1033216	val_216
1034217	val_217
1035217	val_217
1036217	val_217
1037217	val_217
1038218	val_218
1039219	val_219
1040219	val_219
1041219	val_219
1042219	val_219
1043221	val_221
1044221	val_221
1045221	val_221
1046221	val_221
1047222	val_222
1048223	val_223
1049223	val_223
1050223	val_223
1051223	val_223
1052224	val_224
1053224	val_224
1054224	val_224
1055224	val_224
1056226	val_226
1057228	val_228
1058229	val_229
1059229	val_229
1060229	val_229
1061229	val_229
1062230	val_230
1063230	val_230
1064230	val_230
1065230	val_230
1066230	val_230
1067230	val_230
1068230	val_230
1069230	val_230
1070230	val_230
1071230	val_230
1072230	val_230
1073230	val_230
1074230	val_230
1075230	val_230
1076230	val_230
1077230	val_230
1078230	val_230
1079230	val_230
1080230	val_230
1081230	val_230
1082230	val_230
1083230	val_230
1084230	val_230
1085230	val_230
1086230	val_230
1087233	val_233
1088233	val_233
1089233	val_233
1090233	val_233
1091235	val_235
1092237	val_237
1093237	val_237
1094237	val_237
1095237	val_237
1096238	val_238
1097238	val_238
1098238	val_238
1099238	val_238
1100239	val_239
1101239	val_239
1102239	val_239
1103239	val_239
110424	val_24
110524	val_24
110624	val_24
110724	val_24
1108241	val_241
1109242	val_242
1110242	val_242
1111242	val_242
1112242	val_242
1113244	val_244
1114247	val_247
1115248	val_248
1116249	val_249
1117252	val_252
1118255	val_255
1119255	val_255
1120255	val_255
1121255	val_255
1122256	val_256
1123256	val_256
1124256	val_256
1125256	val_256
1126257	val_257
1127258	val_258
112826	val_26
112926	val_26
113026	val_26
113126	val_26
1132260	val_260
1133262	val_262
1134263	val_263
1135265	val_265
1136265	val_265
1137265	val_265
1138265	val_265
1139266	val_266
114027	val_27
1141272	val_272
1142272	val_272
1143272	val_272
1144272	val_272
1145273	val_273
1146273	val_273
1147273	val_273
1148273	val_273
1149273	val_273
1150273	val_273
1151273	val_273
1152273	val_273
1153273	val_273
1154274	val_274
1155275	val_275
1156277	val_277
1157277	val_277
1158277	val_277
1159277	val_277
1160277	val_277
1161277	val_277
1162277	val_277
1163277	val_277
1164277	val_277
1165277	val_277
1166277	val_277
1167277	val_277
1168277	val_277
1169277	val_277
1170277	val_277
1171277	val_277
1172278	val_278
1173278	val_278
1174278	val_278
1175278	val_278
117628	val_28
1177280	val_280
1178280	val_280
1179280	val_280
1180280	val_280
1181281	val_281
1182281	val_281
1183281	val_281
1184281	val_281
1185282	val_282
1186282	val_282
1187282	val_282
1188282	val_282
1189283	val_283
1190284	val_284
1191285	val_285
1192286	val_286
1193287	val_287
1194288	val_288
1195288	val_288
1196288	val_288
1197288	val_288
1198289	val_289
1199291	val_291
1200292	val_292
1201296	val_296
1202298	val_298
1203298	val_298
1204298	val_298
1205298	val_298
1206298	val_298
1207298	val_298
1208298	val_298
1209298	val_298
1210298	val_298
121130	val_30
1212302	val_302
1213305	val_305
1214306	val_306
1215307	val_307
1216307	val_307
1217307	val_307
1218307	val_307
1219308	val_308
1220309	val_309
1221309	val_309
1222309	val_309
1223309	val_309
1224310	val_310
1225311	val_311
1226311	val_311
1227311	val_311
1228311	val_311
1229311	val_311
1230311	val_311
1231311	val_311
1232311	val_311
1233311	val_311
1234315	val_315
1235316	val_316
1236316	val_316
1237316	val_316
1238316	val_316
1239316	val_316
1240316	val_316
1241316	val_316
1242316	val_316
1243316	val_316
1244317	val_317
1245317	val_317
1246317	val_317
1247317	val_317
1248318	val_318
1249318	val_318
1250318	val_318
1251318	val_318
1252318	val_318
1253318	val_318
1254318	val_318
1255318	val_318
1256318	val_318
1257321	val_321
1258321	val_321
1259321	val_321
1260321	val_321
1261322	val_322
1262322	val_322
1263322	val_322
1264322	val_322
1265323	val_323
1266325	val_325
1267325	val_325
1268325	val_325
1269325	val_325
1270327	val_327
1271327	val_327
1272327	val_327
1273327	val_327
1274327	val_327
1275327	val_327
1276327	val_327
1277327	val_327
1278327	val_327
127933	val_33
1280331	val_331
1281331	val_331
1282331	val_331
1283331	val_331
1284332	val_332
1285333	val_333
1286333	val_333
1287333	val_333
1288333	val_333
1289335	val_335
1290336	val_336
1291338	val_338
1292339	val_339
129334	val_34
1294341	val_341
1295342	val_342
1296342	val_342
1297342	val_342
1298342	val_342
1299344	val_344
1300344	val_344
1301344	val_344
1302344	val_344
1303345	val_345
1304348	val_348
1305348	val_348
1306348	val_348
1307348	val_348
1308348	val_348
1309348	val_348
1310348	val_348
1311348	val_348
1312348	val_348
1313348	val_348
1314348	val_348
1315348	val_348
1316348	val_348
1317348	val_348
1318348	val_348
1319348	val_348
1320348	val_348
1321348	val_348
1322348	val_348
1323348	val_348
1324348	val_348
1325348	val_348
1326348	val_348
1327348	val_348
1328348	val_348
132935	val_35
133035	val_35
133135	val_35
133235	val_35
133335	val_35
133435	val_35
133535	val_35
133635	val_35
133735	val_35
1338351	val_351
1339353	val_353
1340353	val_353
1341353	val_353
1342353	val_353
1343356	val_356
1344360	val_360
1345362	val_362
1346364	val_364
1347365	val_365
1348366	val_366
1349367	val_367
1350367	val_367
1351367	val_367
1352367	val_367
1353368	val_368
1354369	val_369
1355369	val_369
1356369	val_369
1357369	val_369
1358369	val_369
1359369	val_369
1360369	val_369
1361369	val_369
1362369	val_369
136337	val_37
136437	val_37
136537	val_37
136637	val_37
1367373	val_373
1368374	val_374
1369375	val_375
1370377	val_377
1371378	val_378
1372379	val_379
1373382	val_382
1374382	val_382
1375382	val_382
1376382	val_382
1377384	val_384
1378384	val_384
1379384	val_384
1380384	val_384
1381384	val_384
1382384	val_384
1383384	val_384
1384384	val_384
1385384	val_384
1386386	val_386
1387389	val_389
1388392	val_392
1389393	val_393
1390394	val_394
1391395	val_395
1392395	val_395
1393395	val_395
1394395	val_395
1395396	val_396
1396396	val_396
1397396	val_396
1398396	val_396
1399396	val_396
1400396	val_396
1401396	val_396
1402396	val_396
1403396	val_396
1404397	val_397
1405397	val_397
1406397	val_397
1407397	val_397
1408399	val_399
1409399	val_399
1410399	val_399
1411399	val_399
14124	val_4
1413400	val_400
1414401	val_401
1415401	val_401
1416401	val_401
1417401	val_401
1418401	val_401
1419401	val_401
1420401	val_401
1421401	val_401
1422401	val_401
1423401	val_401
1424401	val_401
1425401	val_401
1426401	val_401
1427401	val_401
1428401	val_401
1429401	val_401
1430401	val_401
1431401	val_401
1432401	val_401
1433401	val_401
1434401	val_401
1435401	val_401
1436401	val_401
1437401	val_401
1438401	val_401
1439402	val_402
1440403	val_403
1441403	val_403
1442403	val_403
1443403	val_403
1444403	val_403
1445403	val_403
1446403	val_403
1447403	val_403
1448403	val_403
1449404	val_404
1450404	val_404
1451404	val_404
1452404	val_404
1453406	val_406
1454406	val_406
1455406	val_406
1456406	val_406
1457406	val_406
1458406	val_406
1459406	val_406
1460406	val_406
1461406	val_406
1462406	val_406
1463406	val_406
1464406	val_406
1465406	val_406
1466406	val_406
1467406	val_406
1468406	val_406
1469407	val_407
1470409	val_409
1471409	val_409
1472409	val_409
1473409	val_409
1474409	val_409
1475409	val_409
1476409	val_409
1477409	val_409
1478409	val_409
147941	val_41
1480411	val_411
1481413	val_413
1482413	val_413
1483413	val_413
1484413	val_413
1485414	val_414
1486414	val_414
1487414	val_414
1488414	val_414
1489417	val_417
1490417	val_417
1491417	val_417
1492417	val_417
1493417	val_417
1494417	val_417
1495417	val_417
1496417	val_417
1497417	val_417
1498418	val_418
1499419	val_419
150042	val_42
150142	val_42
150242	val_42
150342	val_42
1504421	val_421
1505424	val_424
1506424	val_424
1507424	val_424
1508424	val_424
1509427	val_427
1510429	val_429
1511429	val_429
1512429	val_429
1513429	val_429
151443	val_43
1515430	val_430
1516430	val_430
1517430	val_430
1518430	val_430
1519430	val_430
1520430	val_430
1521430	val_430
1522430	val_430
1523430	val_430
1524431	val_431
1525431	val_431
1526431	val_431
1527431	val_431
1528431	val_431
1529431	val_431
1530431	val_431
1531431	val_431
1532431	val_431
1533432	val_432
1534435	val_435
1535436	val_436
1536437	val_437
1537438	val_438
1538438	val_438
1539438	val_438
1540438	val_438
1541438	val_438
1542438	val_438
1543438	val_438
1544438	val_438
1545438	val_438
1546439	val_439
1547439	val_439
1548439	val_439
1549439	val_439
155044	val_44
1551443	val_443
1552444	val_444
1553446	val_446
1554448	val_448
1555449	val_449
1556452	val_452
1557453	val_453
1558454	val_454
1559454	val_454
1560454	val_454
1561454	val_454
1562454	val_454
1563454	val_454
1564454	val_454
1565454	val_454
1566454	val_454
1567455	val_455
1568457	val_457
1569458	val_458
1570458	val_458
1571458	val_458
1572458	val_458
1573459	val_459
1574459	val_459
1575459	val_459
1576459	val_459
1577460	val_460
1578462	val_462
1579462	val_462
1580462	val_462
1581462	val_462
1582463	val_463
1583463	val_463
1584463	val_463
1585463	val_463
1586466	val_466
1587466	val_466
1588466	val_466
1589466	val_466
1590466	val_466
1591466	val_466
1592466	val_466
1593466	val_466
1594466	val_466
1595467	val_467
1596468	val_468
1597468	val_468
1598468	val_468
1599468	val_468
1600468	val_468
1601468	val_468
1602468	val_468
1603468	val_468
1604468	val_468
1605468	val_468
1606468	val_468
1607468	val_468
1608468	val_468
1609468	val_468
1610468	val_468
1611468	val_468
1612469	val_469
1613469	val_469
1614469	val_469
1615469	val_469
1616469	val_469
1617469	val_469
1618469	val_469
1619469	val_469
1620469	val_469
1621469	val_469
1622469	val_469
1623469	val_469
1624469	val_469
1625469	val_469
1626469	val_469
1627469	val_469
1628469	val_469
1629469	val_469
1630469	val_469
1631469	val_469
1632469	val_469
1633469	val_469
1634469	val_469
1635469	val_469
1636469	val_469
163747	val_47
1638470	val_470
1639472	val_472
1640475	val_475
1641477	val_477
1642478	val_478
1643478	val_478
1644478	val_478
1645478	val_478
1646479	val_479
1647480	val_480
1648480	val_480
1649480	val_480
1650480	val_480
1651480	val_480
1652480	val_480
1653480	val_480
1654480	val_480
1655480	val_480
1656481	val_481
1657482	val_482
1658483	val_483
1659484	val_484
1660485	val_485
1661487	val_487
1662489	val_489
1663489	val_489
1664489	val_489
1665489	val_489
1666489	val_489
1667489	val_489
1668489	val_489
1669489	val_489
1670489	val_489
1671489	val_489
1672489	val_489
1673489	val_489
1674489	val_489
1675489	val_489
1676489	val_489
1677489	val_489
1678490	val_490
1679491	val_491
1680492	val_492
1681492	val_492
1682492	val_492
1683492	val_492
1684493	val_493
1685494	val_494
1686495	val_495
1687496	val_496
1688497	val_497
1689498	val_498
1690498	val_498
1691498	val_498
1692498	val_498
1693498	val_498
1694498	val_498
1695498	val_498
1696498	val_498
1697498	val_498
16985	val_5
16995	val_5
17005	val_5
17015	val_5
17025	val_5
17035	val_5
17045	val_5
17055	val_5
17065	val_5
170751	val_51
170851	val_51
170951	val_51
171051	val_51
171153	val_53
171254	val_54
171357	val_57
171458	val_58
171558	val_58
171658	val_58
171758	val_58
171864	val_64
171965	val_65
172066	val_66
172167	val_67
172267	val_67
172367	val_67
172467	val_67
172569	val_69
172670	val_70
172770	val_70
172870	val_70
172970	val_70
173070	val_70
173170	val_70
173270	val_70
173370	val_70
173470	val_70
173572	val_72
173672	val_72
173772	val_72
173872	val_72
173974	val_74
174076	val_76
174176	val_76
174276	val_76
174376	val_76
174477	val_77
174578	val_78
17468	val_8
174780	val_80
174882	val_82
174983	val_83
175083	val_83
175183	val_83
175283	val_83
175384	val_84
175484	val_84
175584	val_84
175684	val_84
175785	val_85
175886	val_86
175987	val_87
17609	val_9
176190	val_90
176290	val_90
176390	val_90
176490	val_90
176590	val_90
176690	val_90
176790	val_90
176890	val_90
176990	val_90
177092	val_92
177195	val_95
177295	val_95
177395	val_95
177495	val_95
177596	val_96
177697	val_97
177797	val_97
177897	val_97
177997	val_97
178098	val_98
178198	val_98
178298	val_98
178398	val_98
1784PREHOOK: query: EXPLAIN
1785SELECT * FROM src src1 JOIN src src2 ON (src1.key = src2.key AND src1.key < 10) RIGHT OUTER JOIN src src3 ON (src1.key = src3.key AND src3.key < 20)
1786SORT BY src1.key, src1.value, src2.key, src2.value, src3.key, src3.value
1787PREHOOK: type: QUERY
1788POSTHOOK: query: EXPLAIN
1789SELECT * FROM src src1 JOIN src src2 ON (src1.key = src2.key AND src1.key < 10) RIGHT OUTER JOIN src src3 ON (src1.key = src3.key AND src3.key < 20)
1790SORT BY src1.key, src1.value, src2.key, src2.value, src3.key, src3.value
1791POSTHOOK: type: QUERY
1792ABSTRACT SYNTAX TREE:
1793  (TOK_QUERY (TOK_FROM (TOK_RIGHTOUTERJOIN (TOK_JOIN (TOK_TABREF (TOK_TABNAME src) src1) (TOK_TABREF (TOK_TABNAME src) src2) (AND (= (. (TOK_TABLE_OR_COL src1) key) (. (TOK_TABLE_OR_COL src2) key)) (< (. (TOK_TABLE_OR_COL src1) key) 10))) (TOK_TABREF (TOK_TABNAME src) src3) (AND (= (. (TOK_TABLE_OR_COL src1) key) (. (TOK_TABLE_OR_COL src3) key)) (< (. (TOK_TABLE_OR_COL src3) key) 20)))) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR TOK_ALLCOLREF)) (TOK_SORTBY (TOK_TABSORTCOLNAMEASC (. (TOK_TABLE_OR_COL src1) key)) (TOK_TABSORTCOLNAMEASC (. (TOK_TABLE_OR_COL src1) value)) (TOK_TABSORTCOLNAMEASC (. (TOK_TABLE_OR_COL src2) key)) (TOK_TABSORTCOLNAMEASC (. (TOK_TABLE_OR_COL src2) value)) (TOK_TABSORTCOLNAMEASC (. (TOK_TABLE_OR_COL src3) key)) (TOK_TABSORTCOLNAMEASC (. (TOK_TABLE_OR_COL src3) value)))))
1794
1795STAGE DEPENDENCIES:
1796  Stage-1 is a root stage
1797  Stage-2 depends on stages: Stage-1
1798  Stage-0 is a root stage
1799
1800STAGE PLANS:
1801  Stage: Stage-1
1802    Map Reduce
1803      Alias -> Map Operator Tree:
1804        src1 
1805          TableScan
1806            alias: src1
1807            Filter Operator
1808              predicate:
1809                  expr: (key < 10)
1810                  type: boolean
1811              Reduce Output Operator
1812                key expressions:
1813                      expr: key
1814                      type: string
1815                sort order: +
1816                Map-reduce partition columns:
1817                      expr: key
1818                      type: string
1819                tag: 0
1820                value expressions:
1821                      expr: key
1822                      type: string
1823                      expr: value
1824                      type: string
1825        src2 
1826          TableScan
1827            alias: src2
1828            Reduce Output Operator
1829              key expressions:
1830                    expr: key
1831                    type: string
1832              sort order: +
1833              Map-reduce partition columns:
1834                    expr: key
1835                    type: string
1836              tag: 1
1837              value expressions:
1838                    expr: key
1839                    type: string
1840                    expr: value
1841                    type: string
1842        src3 
1843          TableScan
1844            alias: src3
1845            Reduce Output Operator
1846              key expressions:
1847                    expr: key
1848                    type: string
1849              sort order: +
1850              Map-reduce partition columns:
1851                    expr: key
1852                    type: string
1853              tag: 2
1854              value expressions:
1855                    expr: key
1856                    type: string
1857                    expr: value
1858                    type: string
1859      Reduce Operator Tree:
1860        Join Operator
1861          condition map:
1862               Inner Join 0 to 1
1863               Right Outer Join0 to 2
1864          condition expressions:
1865            0 {VALUE._col0} {VALUE._col1}
1866            1 {VALUE._col0} {VALUE._col1}
1867            2 {VALUE._col0} {VALUE._col1}
1868          filter predicates:
1869            0 
1870            1 
1871            2 {(VALUE._col0 < 20)}
1872          handleSkewJoin: false
1873          outputColumnNames: _col0, _col1, _col4, _col5, _col8, _col9
1874          Select Operator
1875            expressions:
1876                  expr: _col0
1877                  type: string
1878                  expr: _col1
1879                  type: string
1880                  expr: _col4
1881                  type: string
1882                  expr: _col5
1883                  type: string
1884                  expr: _col8
1885                  type: string
1886                  expr: _col9
1887                  type: string
1888            outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5
1889            File Output Operator
1890              compressed: false
1891              GlobalTableId: 0
1892              table:
1893                  input format: org.apache.hadoop.mapred.SequenceFileInputFormat
1894                  output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
1895
1896  Stage: Stage-2
1897    Map Reduce
1898      Alias -> Map Operator Tree:
1899        file:/tmp/sdong/hive_2011-02-10_16-07-44_112_2093169853711368630/-mr-10002 
1900            Reduce Output Operator
1901              key expressions:
1902                    expr: _col0
1903                    type: string
1904                    expr: _col1
1905                    type: string
1906                    expr: _col2
1907                    type: string
1908                    expr: _col3
1909                    type: string
1910                    expr: _col4
1911                    type: string
1912                    expr: _col5
1913                    type: string
1914              sort order: ++++++
1915              tag: -1
1916              value expressions:
1917                    expr: _col0
1918                    type: string
1919                    expr: _col1
1920                    type: string
1921                    expr: _col2
1922                    type: string
1923                    expr: _col3
1924                    type: string
1925                    expr: _col4
1926                    type: string
1927                    expr: _col5
1928                    type: string
1929      Reduce Operator Tree:
1930        Extract
1931          File Output Operator
1932            compressed: false
1933            GlobalTableId: 0
1934            table:
1935                input format: org.apache.hadoop.mapred.TextInputFormat
1936                output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
1937
1938  Stage: Stage-0
1939    Fetch Operator
1940      limit: -1
1941
1942
1943PREHOOK: query: SELECT * FROM src src1 JOIN src src2 ON (src1.key = src2.key AND src1.key < 10) RIGHT OUTER JOIN src src3 ON (src1.key = src3.key AND src3.key < 20)
1944SORT BY src1.key, src1.value, src2.key, src2.value, src3.key, src3.value
1945PREHOOK: type: QUERY
1946PREHOOK: Input: default@src
1947PREHOOK: Output: file:/tmp/sdong/hive_2011-02-10_16-07-44_222_3133440987037406315/-mr-10000
1948POSTHOOK: query: SELECT * FROM src src1 JOIN src src2 ON (src1.key = src2.key AND src1.key < 10) RIGHT OUTER JOIN src src3 ON (src1.key = src3.key AND src3.key < 20)
1949SORT BY src1.key, src1.value, src2.key, src2.value, src3.key, src3.value
1950POSTHOOK: type: QUERY
1951POSTHOOK: Input: default@src
1952POSTHOOK: Output: file:/tmp/sdong/hive_2011-02-10_16-07-44_222_3133440987037406315/-mr-10000
1953NULL	NULL	NULL	NULL	10	val_10
1954NULL	NULL	NULL	NULL	100	val_100
1955NULL	NULL	NULL	NULL	100	val_100
1956NULL	NULL	NULL	NULL	103	val_103
1957NULL	NULL	NULL	NULL	103	val_103
1958NULL	NULL	NULL	NULL	104	val_104
1959NULL	NULL	NULL	NULL	104	val_104
1960NULL	NULL	NULL	NULL	105	val_105
1961NULL	NULL	NULL	NULL	11	val_11
1962NULL	NULL	NULL	NULL	111	val_111
1963NULL	NULL	NULL	NULL	113	val_113
1964NULL	NULL	NULL	NULL	113	val_113
1965NULL	NULL	NULL	NULL	114	val_114
1966NULL	NULL	NULL	NULL	116	val_116
1967NULL	NULL	NULL	NULL	118	val_118
1968NULL	NULL	NULL	NULL	118	val_118
1969NULL	NULL	NULL	NULL	119	val_119
1970NULL	NULL	NULL	NULL	119	val_119
1971NULL	NULL	NULL	NULL	119	val_119
1972NULL	NULL	NULL	NULL	12	val_12
1973NULL	NULL	NULL	NULL	12	val_12
1974NULL	NULL	NULL	NULL	120	val_120
1975NULL	NULL	NULL	NULL	120	val_120
1976NULL	NULL	NULL	NULL	125	val_125
1977NULL	NULL	NULL	NULL	125	val_125
1978NULL	NULL	NULL	NULL	126	val_126
1979NULL	NULL	NULL	NULL	128	val_128
1980NULL	NULL	NULL	NULL	128	val_128
1981NULL	NULL	NULL	NULL	128	val_128
1982NULL	NULL	NULL	NULL	129	val_129
1983NULL	NULL	NULL	NULL	129	val_129
1984NULL	NULL	NULL	NULL	131	val_131
1985NULL	NULL	NULL	NULL	133	val_133
1986NULL	NULL	NULL	NULL	134	val_134
1987NULL	NULL	NULL	NULL	134	val_134
1988NULL	NULL	NULL	NULL	136	val_136
1989NULL	NULL	NULL	NULL	137	val_137
1990NULL	NULL	NULL	NULL	137	val_137
1991NULL	NULL	NULL	NULL	138	val_138
1992NULL	NULL	NULL	NULL	138	val_138
1993NULL	NULL	NULL	NULL	138	val_138
1994NULL	NULL	NULL	NULL	138	val_138
1995NULL	NULL	NULL	NULL	143	val_143
1996NULL	NULL	NULL	NULL	145	val_145
1997NULL	NULL	NULL	NULL	146	val_146
1998NULL	NULL	NULL	NULL	146	val_146
1999NULL	NULL	NULL	NULL	149	val_149
2000NULL	NULL	NULL	NULL	149	val_149
2001NULL	NULL	NULL	NULL	15	val_15
2002NULL	NULL	NULL	NULL	15	val_15
2003NULL	NULL	NULL	NULL	150	val_150
2004NULL	NULL	NULL	NULL	152	val_152
2005NULL	NULL	NULL	NULL	152	val_152
2006NULL	NULL	NULL	NULL	153	val_153
2007NULL	NULL	NULL	NULL	155	val_155
2008NULL	NULL	NULL	NULL	156	val_156
2009NULL	NULL	NULL	NULL	157	val_157
2010NULL	NULL	NULL	NULL	158	val_158
2011NULL	NULL	NULL	NULL	160	val_160
2012NULL	NULL	NULL	NULL	162	val_162
2013NULL	NULL	NULL	NULL	163	val_163
2014NULL	NULL	NULL	NULL	164	val_164
2015NULL	NULL	NULL	NULL	164	val_164
2016NULL	NULL	NULL	NULL	165	val_165
2017NULL	NULL	NULL	NULL	165	val_165
2018NULL	NULL	NULL	NULL	166	val_166
2019NULL	NULL	NULL	NULL	167	val_167
2020NULL	NULL	NULL	NULL	167	val_167
2021NULL	NULL	NULL	NULL	167	val_167
2022NULL	NULL	NULL	NULL	168	val_168
2023NULL	NULL	NULL	NULL	169	val_169
2024NULL	NULL	NULL	NULL	169	val_169
2025NULL	NULL	NULL	NULL	169	val_169
2026NULL	NULL	NULL	NULL	169	val_169
2027NULL	NULL	NULL	NULL	17	val_17
2028NULL	NULL	NULL	NULL	170	val_170
2029NULL	NULL	NULL	NULL	172	val_172
2030NULL	NULL	NULL	NULL	172	val_172
2031NULL	NULL	NULL	NULL	174	val_174
2032NULL	NULL	NULL	NULL	174	val_174
2033NULL	NULL	NULL	NULL	175	val_175
2034NULL	NULL	NULL	NULL	175	val_175
2035NULL	NULL	NULL	NULL	176	val_176
2036NULL	NULL	NULL	NULL	176	val_176
2037NULL	NULL	NULL	NULL	177	val_177
2038NULL	NULL	NULL	NULL	178	val_178
2039NULL	NULL	NULL	NULL	179	val_179
2040NULL	NULL	NULL	NULL	179	val_179
2041NULL	NULL	NULL	NULL	18	val_18
2042NULL	NULL	NULL	NULL	18	val_18
2043NULL	NULL	NULL	NULL	180	val_180
2044NULL	NULL	NULL	NULL	181	val_181
2045NULL	NULL	NULL	NULL	183	val_183
2046NULL	NULL	NULL	NULL	186	val_186
2047NULL	NULL	NULL	NULL	187	val_187
2048NULL	NULL	NULL	NULL	187	val_187
2049NULL	NULL	NULL	NULL	187	val_187
2050NULL	NULL	NULL	NULL	189	val_189
2051NULL	NULL	NULL	NULL	19	val_19
2052NULL	NULL	NULL	NULL	190	val_190
2053NULL	NULL	NULL	NULL	191	val_191
2054NULL	NULL	NULL	NULL	191	val_191
2055NULL	NULL	NULL	NULL	192	val_192
2056NULL	NULL	NULL	NULL	193	val_193
2057NULL	NULL	NULL	NULL	193	val_193
2058NULL	NULL	NULL	NULL	193	val_193
2059NULL	NULL	NULL	NULL	194	val_194
2060NULL	NULL	NULL	NULL	195	val_195
2061NULL	NULL	NULL	NULL	195	val_195
2062NULL	NULL	NULL	NULL	196	val_196
2063NULL	NULL	NULL	NULL	197	val_197
2064NULL	NULL	NULL	NULL	197	val_197
2065NULL	NULL	NULL	NULL	199	val_199
2066NULL	NULL	NULL	NULL	199	val_199
2067NULL	NULL	NULL	NULL	199	val_199
2068NULL	NULL	NULL	NULL	20	val_20
2069NULL	NULL	NULL	NULL	200	val_200
2070NULL	NULL	NULL	NULL	200	val_200
2071NULL	NULL	NULL	NULL	201	val_201
2072NULL	NULL	NULL	NULL	202	val_202
2073NULL	NULL	NULL	NULL	203	val_203
2074NULL	NULL	NULL	NULL	203	val_203
2075NULL	NULL	NULL	NULL	205	val_205
2076NULL	NULL	NULL	NULL	205	val_205
2077NULL	NULL	NULL	NULL	207	val_207
2078NULL	NULL	NULL	NULL	207	val_207
2079NULL	NULL	NULL	NULL	208	val_208
2080NULL	NULL	NULL	NULL	208	val_208
2081NULL	NULL	NULL	NULL	208	val_208
2082NULL	NULL	NULL	NULL	209	val_209
2083NULL	NULL	NULL	NULL	209	val_209
2084NULL	NULL	NULL	NULL	213	val_213
2085NULL	NULL	NULL	NULL	213	val_213
2086NULL	NULL	NULL	NULL	214	val_214
2087NULL	NULL	NULL	NULL	216	val_216
2088NULL	NULL	NULL	NULL	216	val_216
2089NULL	NULL	NULL	NULL	217	val_217
2090NULL	NULL	NULL	NULL	217	val_217
2091NULL	NULL	NULL	NULL	218	val_218
2092NULL	NULL	NULL	NULL	219	val_219
2093NULL	NULL	NULL	NULL	219	val_219
2094NULL	NULL	NULL	NULL	221	val_221
2095NULL	NULL	NULL	NULL	221	val_221
2096NULL	NULL	NULL	NULL	222	val_222
2097NULL	NULL	NULL	NULL	223	val_223
2098NULL	NULL	NULL	NULL	223	val_223
2099NULL	NULL	NULL	NULL	224	val_224
2100NULL	NULL	NULL	NULL	224	val_224
2101NULL	NULL	NULL	NULL	226	val_226
2102NULL	NULL	NULL	NULL	228	val_228
2103NULL	NULL	NULL	NULL	229	val_229
2104NULL	NULL	NULL	NULL	229	val_229
2105NULL	NULL	NULL	NULL	230	val_230
2106NULL	NULL	NULL	NULL	230	val_230
2107NULL	NULL	NULL	NULL	230	val_230
2108NULL	NULL	NULL	NULL	230	val_230
2109NULL	NULL	NULL	NULL	230	val_230
2110NULL	NULL	NULL	NULL	233	val_233
2111NULL	NULL	NULL	NULL	233	val_233
2112NULL	NULL	NULL	NULL	235	val_235
2113NULL	NULL	NULL	NULL	237	val_237
2114NULL	NULL	NULL	NULL	237	val_237
2115NULL	NULL	NULL	NULL	238	val_238
2116NULL	NULL	NULL	NULL	238	val_238
2117NULL	NULL	NULL	NULL	239	val_239
2118NULL	NULL	NULL	NULL	239	val_239
2119NULL	NULL	NULL	NULL	24	val_24
2120NULL	NULL	NULL	NULL	24	val_24
2121NULL	NULL	NULL	NULL	241	val_241
2122NULL	NULL	NULL	NULL	242	val_242
2123NULL	NULL	NULL	NULL	242	val_242
2124NULL	NULL	NULL	NULL	244	val_244
2125NULL	NULL	NULL	NULL	247	val_247
2126NULL	NULL	NULL	NULL	248	val_248
2127NULL	NULL	NULL	NULL	249	val_249
2128NULL	NULL	NULL	NULL	252	val_252
2129NULL	NULL	NULL	NULL	255	val_255
2130NULL	NULL	NULL	NULL	255	val_255
2131NULL	NULL	NULL	NULL	256	val_256
2132NULL	NULL	NULL	NULL	256	val_256
2133NULL	NULL	NULL	NULL	257	val_257
2134NULL	NULL	NULL	NULL	258	val_258
2135NULL	NULL	NULL	NULL	26	val_26
2136NULL	NULL	NULL	NULL	26	val_26
2137NULL	NULL	NULL	NULL	260	val_260
2138NULL	NULL	NULL	NULL	262	val_262
2139NULL	NULL	NULL	NULL	263	val_263
2140NULL	NULL	NULL	NULL	265	val_265
2141NULL	NULL	NULL	NULL	265	val_265
2142NULL	NULL	NULL	NULL	266	val_266
2143NULL	NULL	NULL	NULL	27	val_27
2144NULL	NULL	NULL	NULL	272	val_272
2145NULL	NULL	NULL	NULL	272	val_272
2146NULL	NULL	NULL	NULL	273	val_273
2147NULL	NULL	NULL	NULL	273	val_273
2148NULL	NULL	NULL	NULL	273	val_273
2149NULL	NULL	NULL	NULL	274	val_274
2150NULL	NULL	NULL	NULL	275	val_275
2151NULL	NULL	NULL	NULL	277	val_277
2152NULL	NULL	NULL	NULL	277	val_277
2153NULL	NULL	NULL	NULL	277	val_277
2154NULL	NULL	NULL	NULL	277	val_277
2155NULL	NULL	NULL	NULL	278	val_278
2156NULL	NULL	NULL	NULL	278	val_278
2157NULL	NULL	NULL	NULL	28	val_28
2158NULL	NULL	NULL	NULL	280	val_280
2159NULL	NULL	NULL	NULL	280	val_280
2160NULL	NULL	NULL	NULL	281	val_281
2161NULL	NULL	NULL	NULL	281	val_281
2162NULL	NULL	NULL	NULL	282	val_282
2163NULL	NULL	NULL	NULL	282	val_282
2164NULL	NULL	NULL	NULL	283	val_283
2165NULL	NULL	NULL	NULL	284	val_284
2166NULL	NULL	NULL	NULL	285	val_285
2167NULL	NULL	NULL	NULL	286	val_286
2168NULL	NULL	NULL	NULL	287	val_287
2169NULL	NULL	NULL	NULL	288	val_288
2170NULL	NULL	NULL	NULL	288	val_288
2171NULL	NULL	NULL	NULL	289	val_289
2172NULL	NULL	NULL	NULL	291	val_291
2173NULL	NULL	NULL	NULL	292	val_292
2174NULL	NULL	NULL	NULL	296	val_296
2175NULL	NULL	NULL	NULL	298	val_298
2176NULL	NULL	NULL	NULL	298	val_298
2177NULL	NULL	NULL	NULL	298	val_298
2178NULL	NULL	NULL	NULL	30	val_30
2179NULL	NULL	NULL	NULL	302	val_302
2180NULL	NULL	NULL	NULL	305	val_305
2181NULL	NULL	NULL	NULL	306	val_306
2182NULL	NULL	NULL	NULL	307	val_307
2183NULL	NULL	NULL	NULL	307	val_307
2184NULL	NULL	NULL	NULL	308	val_308
2185NULL	NULL	NULL	NULL	309	val_309
2186NULL	NULL	NULL	NULL	309	val_309
2187NULL	NULL	NULL	NULL	310	val_310
2188NULL	NULL	NULL	NULL	311	val_311
2189NULL	NULL	NULL	NULL	311	val_311
2190NULL	NULL	NULL	NULL	311	val_311
2191NULL	NULL	NULL	NULL	315	val_315
2192NULL	NULL	NULL	NULL	316	val_316
2193NULL	NULL	NULL	NULL	316	val_316
2194NULL	NULL	NULL	NULL	316	val_316
2195NULL	NULL	NULL	NULL	317	val_317
2196NULL	NULL	NULL	NULL	317	val_317
2197NULL	NULL	NULL	NULL	318	val_318
2198NULL	NULL	NULL	NULL	318	val_318
2199NULL	NULL	NULL	NULL	318	val_318
2200NULL	NULL	NULL	NULL	321	val_321
2201NULL	NULL	NULL	NULL	321	val_321
2202NULL	NULL	NULL	NULL	322	val_322
2203NULL	NULL	NULL	NULL	322	val_322
2204NULL	NULL	NULL	NULL	323	val_323
2205NULL	NULL	NULL	NULL	325	val_325
2206NULL	NULL	NULL	NULL	325	val_325
2207NULL	NULL	NULL	NULL	327	val_327
2208NULL	NULL	NULL	NULL	327	val_327
2209NULL	NULL	NULL	NULL	327	val_327
2210NULL	NULL	NULL	NULL	33	val_33
2211NULL	NULL	NULL	NULL	331	val_331
2212NULL	NULL	NULL	NULL	331	val_331
2213NULL	NULL	NULL	NULL	332	val_332
2214NULL	NULL	NULL	NULL	333	val_333
2215NULL	NULL	NULL	NULL	333	val_333
2216NULL	NULL	NULL	NULL	335	val_335
2217NULL	NULL	NULL	NULL	336	val_336
2218NULL	NULL	NULL	NULL	338	val_338
2219NULL	NULL	NULL	NULL	339	val_339
2220NULL	NULL	NULL	NULL	34	val_34
2221NULL	NULL	NULL	NULL	341	val_341
2222NULL	NULL	NULL	NULL	342	val_342
2223NULL	NULL	NULL	NULL	342	val_342
2224NULL	NULL	NULL	NULL	344	val_344
2225NULL	NULL	NULL	NULL	344	val_344
2226NULL	NULL	NULL	NULL	345	val_345
2227NULL	NULL	NULL	NULL	348	val_348
2228NULL	NULL	NULL	NULL	348	val_348
2229NULL	NULL	NULL	NULL	348	val_348
2230NULL	NULL	NULL	NULL	348	val_348
2231NULL	NULL	NULL	NULL	348	val_348
2232NULL	NULL	NULL	NULL	35	val_35
2233NULL	NULL	NULL	NULL	35	val_35
2234NULL	NULL	NULL	NULL	35	val_35
2235NULL	NULL	NULL	NULL	351	val_351
2236NULL	NULL	NULL	NULL	353	val_353
2237NULL	NULL	NULL	NULL	353	val_353
2238NULL	NULL	NULL	NULL	356	val_356
2239NULL	NULL	NULL	NULL	360	val_360
2240NULL	NULL	NULL	NULL	362	val_362
2241NULL	NULL	NULL	NULL	364	val_364
2242NULL	NULL	NULL	NULL	365	val_365
2243NULL	NULL	NULL	NULL	366	val_366
2244NULL	NULL	NULL	NULL	367	val_367
2245NULL	NULL	NULL	NULL	367	val_367
2246NULL	NULL	NULL	NULL	368	val_368
2247NULL	NULL	NULL	NULL	369	val_369
2248NULL	NULL	NULL	NULL	369	val_369
2249NULL	NULL	NULL	NULL	369	val_369
2250NULL	NULL	NULL	NULL	37	val_37
2251NULL	NULL	NULL	NULL	37	val_37
2252NULL	NULL	NULL	NULL	373	val_373
2253NULL	NULL	NULL	NULL	374	val_374
2254NULL	NULL	NULL	NULL	375	val_375
2255NULL	NULL	NULL	NULL	377	val_377
2256NULL	NULL	NULL	NULL	378	val_378
2257NULL	NULL	NULL	NULL	379	val_379
2258NULL	NULL	NULL	NULL	382	val_382
2259NULL	NULL	NULL	NULL	382	val_382
2260NULL	NULL	NULL	NULL	384	val_384
2261NULL	NULL	NULL	NULL	384	val_384
2262NULL	NULL	NULL	NULL	384	val_384
2263NULL	NULL	NULL	NULL	386	val_386
2264NULL	NULL	NULL	NULL	389	val_389
2265NULL	NULL	NULL	NULL	392	val_392
2266NULL	NULL	NULL	NULL	393	val_393
2267NULL	NULL	NULL	NULL	394	val_394
2268NULL	NULL	NULL	NULL	395	val_395
2269NULL	NULL	NULL	NULL	395	val_395
2270NULL	NULL	NULL	NULL	396	val_396
2271NULL	NULL	NULL	NULL	396	val_396
2272NULL	NULL	NULL	NULL	396	val_396
2273NULL	NULL	NULL	NULL	397	val_397
2274NULL	NULL	NULL	NULL	397	val_397
2275NULL	NULL	NULL	NULL	399	val_399
2276NULL	NULL	NULL	NULL	399	val_399
2277NULL	NULL	NULL	NULL	400	val_400
2278NULL	NULL	NULL	NULL	401	val_401
2279NULL	NULL	NULL	NULL	401	val_401
2280NULL	NULL	NULL	NULL	401	val_401
2281NULL	NULL	NULL	NULL	401	val_401
2282NULL	NULL	NULL	NULL	401	val_401
2283NULL	NULL	NULL	NULL	402	val_402
2284NULL	NULL	NULL	NULL	403	val_403
2285NULL	NULL	NULL	NULL	403	val_403
2286NULL	NULL	NULL	NULL	403	val_403
2287NULL	NULL	NULL	NULL	404	val_404
2288NULL	NULL	NULL	NULL	404	val_404
2289NULL	NULL	NULL	NULL	406	val_406
2290NULL	NULL	NULL	NULL	406	val_406
2291NULL	NULL	NULL	NULL	406	val_406
2292NULL	NULL	NULL	NULL	406	val_406
2293NULL	NULL	NULL	NULL	407	val_407
2294NULL	NULL	NULL	NULL	409	val_409
2295NULL	NULL	NULL	NULL	409	val_409
2296NULL	NULL	NULL	NULL	409	val_409
2297NULL	NULL	NULL	NULL	41	val_41
2298NULL	NULL	NULL	NULL	411	val_411
2299NULL	NULL	NULL	NULL	413	val_413
2300NULL	NULL	NULL	NULL	413	val_413
2301NULL	NULL	NULL	NULL	414	val_414
2302NULL	NULL	NULL	NULL	414	val_414
2303NULL	NULL	NULL	NULL	417	val_417
2304NULL	NULL	NULL	NULL	417	val_417
2305NULL	NULL	NULL	NULL	417	val_417
2306NULL	NULL	NULL	NULL	418	val_418
2307NULL	NULL	NULL	NULL	419	val_419
2308NULL	NULL	NULL	NULL	42	val_42
2309NULL	NULL	NULL	NULL	42	val_42
2310NULL	NULL	NULL	NULL	421	val_421
2311NULL	NULL	NULL	NULL	424	val_424
2312NULL	NULL	NULL	NULL	424	val_424
2313NULL	NULL	NULL	NULL	427	val_427
2314NULL	NULL	NULL	NULL	429	val_429
2315NULL	NULL	NULL	NULL	429	val_429
2316NULL	NULL	NULL	NULL	43	val_43
2317NULL	NULL	NULL	NULL	430	val_430
2318NULL	NULL	NULL	NULL	430	val_430
2319NULL	NULL	NULL	NULL	430	val_430
2320NULL	NULL	NULL	NULL	431	val_431
2321NULL	NULL	NULL	NULL	431	val_431
2322NULL	NULL	NULL	NULL	431	val_431
2323NULL	NULL	NULL	NULL	432	val_432
2324NULL	NULL	NULL	NULL	435	val_435
2325NULL	NULL	NULL	NULL	436	val_436
2326NULL	NULL	NULL	NULL	437	val_437
2327NULL	NULL	NULL	NULL	438	val_438
2328NULL	NULL	NULL	NULL	438	val_438
2329NULL	NULL	NULL	NULL	438	val_438
2330NULL	NULL	NULL	NULL	439	val_439
2331NULL	NULL	NULL	NULL	439	val_439
2332NULL	NULL	NULL	NULL	44	val_44
2333NULL	NULL	NULL	NULL	443	v…

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