PageRenderTime 38ms CodeModel.GetById 24ms app.highlight 5ms RepoModel.GetById 1ms app.codeStats 0ms

/tags/release-0.0.0-rc0/hive/external/ql/src/test/results/clientpositive/multi_insert.q.out

#
text | 4022 lines | 3879 code | 143 blank | 0 comment | 0 complexity | f4e3ca36cc381eaae35d218bd7205767 MD5 | raw file

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

   1PREHOOK: query: create table src_multi1 like src
   2PREHOOK: type: CREATETABLE
   3POSTHOOK: query: create table src_multi1 like src
   4POSTHOOK: type: CREATETABLE
   5POSTHOOK: Output: default@src_multi1
   6PREHOOK: query: create table src_multi2 like src
   7PREHOOK: type: CREATETABLE
   8POSTHOOK: query: create table src_multi2 like src
   9POSTHOOK: type: CREATETABLE
  10POSTHOOK: Output: default@src_multi2
  11PREHOOK: query: explain
  12from src
  13insert overwrite table src_multi1 select * where key < 10
  14insert overwrite table src_multi2 select * where key > 10 and key < 20
  15PREHOOK: type: QUERY
  16POSTHOOK: query: explain
  17from src
  18insert overwrite table src_multi1 select * where key < 10
  19insert overwrite table src_multi2 select * where key > 10 and key < 20
  20POSTHOOK: type: QUERY
  21ABSTRACT SYNTAX TREE:
  22  (TOK_QUERY (TOK_FROM (TOK_TABREF (TOK_TABNAME src))) (TOK_INSERT (TOK_DESTINATION (TOK_TAB (TOK_TABNAME src_multi1))) (TOK_SELECT (TOK_SELEXPR TOK_ALLCOLREF)) (TOK_WHERE (< (TOK_TABLE_OR_COL key) 10))) (TOK_INSERT (TOK_DESTINATION (TOK_TAB (TOK_TABNAME src_multi2))) (TOK_SELECT (TOK_SELEXPR TOK_ALLCOLREF)) (TOK_WHERE (and (> (TOK_TABLE_OR_COL key) 10) (< (TOK_TABLE_OR_COL key) 20)))))
  23
  24STAGE DEPENDENCIES:
  25  Stage-2 is a root stage
  26  Stage-0 depends on stages: Stage-2
  27  Stage-3 depends on stages: Stage-0
  28  Stage-1 depends on stages: Stage-2
  29  Stage-4 depends on stages: Stage-1
  30
  31STAGE PLANS:
  32  Stage: Stage-2
  33    Map Reduce
  34      Alias -> Map Operator Tree:
  35        src 
  36          TableScan
  37            alias: src
  38            Filter Operator
  39              predicate:
  40                  expr: (key < 10)
  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                File Output Operator
  50                  compressed: false
  51                  GlobalTableId: 1
  52                  table:
  53                      input format: org.apache.hadoop.mapred.TextInputFormat
  54                      output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
  55                      serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
  56                      name: default.src_multi1
  57            Filter Operator
  58              predicate:
  59                  expr: ((key > 10) and (key < 20))
  60                  type: boolean
  61              Select Operator
  62                expressions:
  63                      expr: key
  64                      type: string
  65                      expr: value
  66                      type: string
  67                outputColumnNames: _col0, _col1
  68                File Output Operator
  69                  compressed: false
  70                  GlobalTableId: 2
  71                  table:
  72                      input format: org.apache.hadoop.mapred.TextInputFormat
  73                      output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
  74                      serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
  75                      name: default.src_multi2
  76
  77  Stage: Stage-0
  78    Move Operator
  79      tables:
  80          replace: true
  81          table:
  82              input format: org.apache.hadoop.mapred.TextInputFormat
  83              output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
  84              serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
  85              name: default.src_multi1
  86
  87  Stage: Stage-3
  88    Stats-Aggr Operator
  89
  90  Stage: Stage-1
  91    Move Operator
  92      tables:
  93          replace: true
  94          table:
  95              input format: org.apache.hadoop.mapred.TextInputFormat
  96              output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
  97              serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
  98              name: default.src_multi2
  99
 100  Stage: Stage-4
 101    Stats-Aggr Operator
 102
 103
 104PREHOOK: query: from src
 105insert overwrite table src_multi1 select * where key < 10
 106insert overwrite table src_multi2 select * where key > 10 and key < 20
 107PREHOOK: type: QUERY
 108PREHOOK: Input: default@src
 109PREHOOK: Output: default@src_multi1
 110PREHOOK: Output: default@src_multi2
 111POSTHOOK: query: from src
 112insert overwrite table src_multi1 select * where key < 10
 113insert overwrite table src_multi2 select * where key > 10 and key < 20
 114POSTHOOK: type: QUERY
 115POSTHOOK: Input: default@src
 116POSTHOOK: Output: default@src_multi1
 117POSTHOOK: Output: default@src_multi2
 118POSTHOOK: Lineage: src_multi1.key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
 119POSTHOOK: Lineage: src_multi1.value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
 120POSTHOOK: Lineage: src_multi2.key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
 121POSTHOOK: Lineage: src_multi2.value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
 122PREHOOK: query: select * from src_multi1 order by key, value
 123PREHOOK: type: QUERY
 124PREHOOK: Input: default@src_multi1
 125PREHOOK: Output: file:/tmp/sdong/hive_2011-02-10_16-43-28_145_3241710195767422128/-mr-10000
 126POSTHOOK: query: select * from src_multi1 order by key, value
 127POSTHOOK: type: QUERY
 128POSTHOOK: Input: default@src_multi1
 129POSTHOOK: Output: file:/tmp/sdong/hive_2011-02-10_16-43-28_145_3241710195767422128/-mr-10000
 130POSTHOOK: Lineage: src_multi1.key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
 131POSTHOOK: Lineage: src_multi1.value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
 132POSTHOOK: Lineage: src_multi2.key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
 133POSTHOOK: Lineage: src_multi2.value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
 1340	val_0
 1350	val_0
 1360	val_0
 1372	val_2
 1384	val_4
 1395	val_5
 1405	val_5
 1415	val_5
 1428	val_8
 1439	val_9
 144PREHOOK: query: select * from src_multi2 order by key, value
 145PREHOOK: type: QUERY
 146PREHOOK: Input: default@src_multi2
 147PREHOOK: Output: file:/tmp/sdong/hive_2011-02-10_16-43-31_438_9069228920663463258/-mr-10000
 148POSTHOOK: query: select * from src_multi2 order by key, value
 149POSTHOOK: type: QUERY
 150POSTHOOK: Input: default@src_multi2
 151POSTHOOK: Output: file:/tmp/sdong/hive_2011-02-10_16-43-31_438_9069228920663463258/-mr-10000
 152POSTHOOK: Lineage: src_multi1.key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
 153POSTHOOK: Lineage: src_multi1.value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
 154POSTHOOK: Lineage: src_multi2.key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
 155POSTHOOK: Lineage: src_multi2.value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
 15611	val_11
 15712	val_12
 15812	val_12
 15915	val_15
 16015	val_15
 16117	val_17
 16218	val_18
 16318	val_18
 16419	val_19
 165PREHOOK: query: explain
 166from src
 167insert overwrite table src_multi1 select * where key < 10
 168insert overwrite table src_multi2 select * where key > 10 and key < 20
 169PREHOOK: type: QUERY
 170POSTHOOK: query: explain
 171from src
 172insert overwrite table src_multi1 select * where key < 10
 173insert overwrite table src_multi2 select * where key > 10 and key < 20
 174POSTHOOK: type: QUERY
 175POSTHOOK: Lineage: src_multi1.key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
 176POSTHOOK: Lineage: src_multi1.value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
 177POSTHOOK: Lineage: src_multi2.key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
 178POSTHOOK: Lineage: src_multi2.value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
 179ABSTRACT SYNTAX TREE:
 180  (TOK_QUERY (TOK_FROM (TOK_TABREF (TOK_TABNAME src))) (TOK_INSERT (TOK_DESTINATION (TOK_TAB (TOK_TABNAME src_multi1))) (TOK_SELECT (TOK_SELEXPR TOK_ALLCOLREF)) (TOK_WHERE (< (TOK_TABLE_OR_COL key) 10))) (TOK_INSERT (TOK_DESTINATION (TOK_TAB (TOK_TABNAME src_multi2))) (TOK_SELECT (TOK_SELEXPR TOK_ALLCOLREF)) (TOK_WHERE (and (> (TOK_TABLE_OR_COL key) 10) (< (TOK_TABLE_OR_COL key) 20)))))
 181
 182STAGE DEPENDENCIES:
 183  Stage-2 is a root stage
 184  Stage-6 depends on stages: Stage-2 , consists of Stage-5, Stage-4
 185  Stage-5
 186  Stage-0 depends on stages: Stage-5, Stage-4
 187  Stage-3 depends on stages: Stage-0
 188  Stage-4
 189  Stage-10 depends on stages: Stage-2 , consists of Stage-9, Stage-8
 190  Stage-9
 191  Stage-1 depends on stages: Stage-9, Stage-8
 192  Stage-7 depends on stages: Stage-1
 193  Stage-8
 194
 195STAGE PLANS:
 196  Stage: Stage-2
 197    Map Reduce
 198      Alias -> Map Operator Tree:
 199        src 
 200          TableScan
 201            alias: src
 202            Filter Operator
 203              predicate:
 204                  expr: (key < 10)
 205                  type: boolean
 206              Select Operator
 207                expressions:
 208                      expr: key
 209                      type: string
 210                      expr: value
 211                      type: string
 212                outputColumnNames: _col0, _col1
 213                File Output Operator
 214                  compressed: false
 215                  GlobalTableId: 1
 216                  table:
 217                      input format: org.apache.hadoop.mapred.TextInputFormat
 218                      output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
 219                      serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
 220                      name: default.src_multi1
 221            Filter Operator
 222              predicate:
 223                  expr: ((key > 10) and (key < 20))
 224                  type: boolean
 225              Select Operator
 226                expressions:
 227                      expr: key
 228                      type: string
 229                      expr: value
 230                      type: string
 231                outputColumnNames: _col0, _col1
 232                File Output Operator
 233                  compressed: false
 234                  GlobalTableId: 2
 235                  table:
 236                      input format: org.apache.hadoop.mapred.TextInputFormat
 237                      output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
 238                      serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
 239                      name: default.src_multi2
 240
 241  Stage: Stage-6
 242    Conditional Operator
 243
 244  Stage: Stage-5
 245    Move Operator
 246      files:
 247          hdfs directory: true
 248          destination: pfile:/data/users/sdong/www/open-source-hive1/build/ql/scratchdir/hive_2011-02-10_16-43-34_769_237323934229498156/-ext-10000
 249
 250  Stage: Stage-0
 251    Move Operator
 252      tables:
 253          replace: true
 254          table:
 255              input format: org.apache.hadoop.mapred.TextInputFormat
 256              output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
 257              serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
 258              name: default.src_multi1
 259
 260  Stage: Stage-3
 261    Stats-Aggr Operator
 262
 263  Stage: Stage-4
 264    Map Reduce
 265      Alias -> Map Operator Tree:
 266        pfile:/data/users/sdong/www/open-source-hive1/build/ql/scratchdir/hive_2011-02-10_16-43-34_769_237323934229498156/-ext-10004 
 267            File Output Operator
 268              compressed: false
 269              GlobalTableId: 0
 270              table:
 271                  input format: org.apache.hadoop.mapred.TextInputFormat
 272                  output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
 273                  serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
 274                  name: default.src_multi1
 275
 276  Stage: Stage-10
 277    Conditional Operator
 278
 279  Stage: Stage-9
 280    Move Operator
 281      files:
 282          hdfs directory: true
 283          destination: pfile:/data/users/sdong/www/open-source-hive1/build/ql/scratchdir/hive_2011-02-10_16-43-34_769_237323934229498156/-ext-10002
 284
 285  Stage: Stage-1
 286    Move Operator
 287      tables:
 288          replace: true
 289          table:
 290              input format: org.apache.hadoop.mapred.TextInputFormat
 291              output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
 292              serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
 293              name: default.src_multi2
 294
 295  Stage: Stage-7
 296    Stats-Aggr Operator
 297
 298  Stage: Stage-8
 299    Map Reduce
 300      Alias -> Map Operator Tree:
 301        pfile:/data/users/sdong/www/open-source-hive1/build/ql/scratchdir/hive_2011-02-10_16-43-34_769_237323934229498156/-ext-10005 
 302            File Output Operator
 303              compressed: false
 304              GlobalTableId: 0
 305              table:
 306                  input format: org.apache.hadoop.mapred.TextInputFormat
 307                  output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
 308                  serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
 309                  name: default.src_multi2
 310
 311
 312PREHOOK: query: from src
 313insert overwrite table src_multi1 select * where key < 10
 314insert overwrite table src_multi2 select * where key > 10 and key < 20
 315PREHOOK: type: QUERY
 316PREHOOK: Input: default@src
 317PREHOOK: Output: default@src_multi1
 318PREHOOK: Output: default@src_multi2
 319POSTHOOK: query: from src
 320insert overwrite table src_multi1 select * where key < 10
 321insert overwrite table src_multi2 select * where key > 10 and key < 20
 322POSTHOOK: type: QUERY
 323POSTHOOK: Input: default@src
 324POSTHOOK: Output: default@src_multi1
 325POSTHOOK: Output: default@src_multi2
 326POSTHOOK: Lineage: src_multi1.key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
 327POSTHOOK: Lineage: src_multi1.key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
 328POSTHOOK: Lineage: src_multi1.value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
 329POSTHOOK: Lineage: src_multi1.value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
 330POSTHOOK: Lineage: src_multi2.key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
 331POSTHOOK: Lineage: src_multi2.key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
 332POSTHOOK: Lineage: src_multi2.value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
 333POSTHOOK: Lineage: src_multi2.value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
 334PREHOOK: query: select * from src_multi1 order by key, value
 335PREHOOK: type: QUERY
 336PREHOOK: Input: default@src_multi1
 337PREHOOK: Output: file:/tmp/sdong/hive_2011-02-10_16-43-40_108_540422556150441780/-mr-10000
 338POSTHOOK: query: select * from src_multi1 order by key, value
 339POSTHOOK: type: QUERY
 340POSTHOOK: Input: default@src_multi1
 341POSTHOOK: Output: file:/tmp/sdong/hive_2011-02-10_16-43-40_108_540422556150441780/-mr-10000
 342POSTHOOK: Lineage: src_multi1.key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
 343POSTHOOK: Lineage: src_multi1.key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
 344POSTHOOK: Lineage: src_multi1.value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
 345POSTHOOK: Lineage: src_multi1.value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
 346POSTHOOK: Lineage: src_multi2.key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
 347POSTHOOK: Lineage: src_multi2.key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
 348POSTHOOK: Lineage: src_multi2.value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
 349POSTHOOK: Lineage: src_multi2.value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
 3500	val_0
 3510	val_0
 3520	val_0
 3532	val_2
 3544	val_4
 3555	val_5
 3565	val_5
 3575	val_5
 3588	val_8
 3599	val_9
 360PREHOOK: query: select * from src_multi2 order by key, value
 361PREHOOK: type: QUERY
 362PREHOOK: Input: default@src_multi2
 363PREHOOK: Output: file:/tmp/sdong/hive_2011-02-10_16-43-43_386_4508980303632676768/-mr-10000
 364POSTHOOK: query: select * from src_multi2 order by key, value
 365POSTHOOK: type: QUERY
 366POSTHOOK: Input: default@src_multi2
 367POSTHOOK: Output: file:/tmp/sdong/hive_2011-02-10_16-43-43_386_4508980303632676768/-mr-10000
 368POSTHOOK: Lineage: src_multi1.key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
 369POSTHOOK: Lineage: src_multi1.key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
 370POSTHOOK: Lineage: src_multi1.value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
 371POSTHOOK: Lineage: src_multi1.value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
 372POSTHOOK: Lineage: src_multi2.key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
 373POSTHOOK: Lineage: src_multi2.key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
 374POSTHOOK: Lineage: src_multi2.value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
 375POSTHOOK: Lineage: src_multi2.value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
 37611	val_11
 37712	val_12
 37812	val_12
 37915	val_15
 38015	val_15
 38117	val_17
 38218	val_18
 38318	val_18
 38419	val_19
 385PREHOOK: query: explain
 386from src
 387insert overwrite table src_multi1 select * where key < 10
 388insert overwrite table src_multi2 select * where key > 10 and key < 20
 389PREHOOK: type: QUERY
 390POSTHOOK: query: explain
 391from src
 392insert overwrite table src_multi1 select * where key < 10
 393insert overwrite table src_multi2 select * where key > 10 and key < 20
 394POSTHOOK: type: QUERY
 395POSTHOOK: Lineage: src_multi1.key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
 396POSTHOOK: Lineage: src_multi1.key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
 397POSTHOOK: Lineage: src_multi1.value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
 398POSTHOOK: Lineage: src_multi1.value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
 399POSTHOOK: Lineage: src_multi2.key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
 400POSTHOOK: Lineage: src_multi2.key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
 401POSTHOOK: Lineage: src_multi2.value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
 402POSTHOOK: Lineage: src_multi2.value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
 403ABSTRACT SYNTAX TREE:
 404  (TOK_QUERY (TOK_FROM (TOK_TABREF (TOK_TABNAME src))) (TOK_INSERT (TOK_DESTINATION (TOK_TAB (TOK_TABNAME src_multi1))) (TOK_SELECT (TOK_SELEXPR TOK_ALLCOLREF)) (TOK_WHERE (< (TOK_TABLE_OR_COL key) 10))) (TOK_INSERT (TOK_DESTINATION (TOK_TAB (TOK_TABNAME src_multi2))) (TOK_SELECT (TOK_SELEXPR TOK_ALLCOLREF)) (TOK_WHERE (and (> (TOK_TABLE_OR_COL key) 10) (< (TOK_TABLE_OR_COL key) 20)))))
 405
 406STAGE DEPENDENCIES:
 407  Stage-2 is a root stage
 408  Stage-0 depends on stages: Stage-2
 409  Stage-3 depends on stages: Stage-0
 410  Stage-1 depends on stages: Stage-2
 411  Stage-4 depends on stages: Stage-1
 412
 413STAGE PLANS:
 414  Stage: Stage-2
 415    Map Reduce
 416      Alias -> Map Operator Tree:
 417        src 
 418          TableScan
 419            alias: src
 420            Filter Operator
 421              predicate:
 422                  expr: (key < 10)
 423                  type: boolean
 424              Select Operator
 425                expressions:
 426                      expr: key
 427                      type: string
 428                      expr: value
 429                      type: string
 430                outputColumnNames: _col0, _col1
 431                File Output Operator
 432                  compressed: false
 433                  GlobalTableId: 1
 434                  table:
 435                      input format: org.apache.hadoop.mapred.TextInputFormat
 436                      output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
 437                      serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
 438                      name: default.src_multi1
 439            Filter Operator
 440              predicate:
 441                  expr: ((key > 10) and (key < 20))
 442                  type: boolean
 443              Select Operator
 444                expressions:
 445                      expr: key
 446                      type: string
 447                      expr: value
 448                      type: string
 449                outputColumnNames: _col0, _col1
 450                File Output Operator
 451                  compressed: false
 452                  GlobalTableId: 2
 453                  table:
 454                      input format: org.apache.hadoop.mapred.TextInputFormat
 455                      output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
 456                      serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
 457                      name: default.src_multi2
 458
 459  Stage: Stage-0
 460    Move Operator
 461      tables:
 462          replace: true
 463          table:
 464              input format: org.apache.hadoop.mapred.TextInputFormat
 465              output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
 466              serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
 467              name: default.src_multi1
 468
 469  Stage: Stage-3
 470    Stats-Aggr Operator
 471
 472  Stage: Stage-1
 473    Move Operator
 474      tables:
 475          replace: true
 476          table:
 477              input format: org.apache.hadoop.mapred.TextInputFormat
 478              output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
 479              serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
 480              name: default.src_multi2
 481
 482  Stage: Stage-4
 483    Stats-Aggr Operator
 484
 485
 486PREHOOK: query: from src
 487insert overwrite table src_multi1 select * where key < 10
 488insert overwrite table src_multi2 select * where key > 10 and key < 20
 489PREHOOK: type: QUERY
 490PREHOOK: Input: default@src
 491PREHOOK: Output: default@src_multi1
 492PREHOOK: Output: default@src_multi2
 493POSTHOOK: query: from src
 494insert overwrite table src_multi1 select * where key < 10
 495insert overwrite table src_multi2 select * where key > 10 and key < 20
 496POSTHOOK: type: QUERY
 497POSTHOOK: Input: default@src
 498POSTHOOK: Output: default@src_multi1
 499POSTHOOK: Output: default@src_multi2
 500POSTHOOK: Lineage: src_multi1.key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
 501POSTHOOK: Lineage: src_multi1.key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
 502POSTHOOK: Lineage: src_multi1.key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
 503POSTHOOK: Lineage: src_multi1.value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
 504POSTHOOK: Lineage: src_multi1.value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
 505POSTHOOK: Lineage: src_multi1.value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
 506POSTHOOK: Lineage: src_multi2.key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
 507POSTHOOK: Lineage: src_multi2.key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
 508POSTHOOK: Lineage: src_multi2.key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
 509POSTHOOK: Lineage: src_multi2.value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
 510POSTHOOK: Lineage: src_multi2.value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
 511POSTHOOK: Lineage: src_multi2.value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
 512PREHOOK: query: select * from src_multi1 order by key, value
 513PREHOOK: type: QUERY
 514PREHOOK: Input: default@src_multi1
 515PREHOOK: Output: file:/tmp/sdong/hive_2011-02-10_16-43-52_773_729013797916091277/-mr-10000
 516POSTHOOK: query: select * from src_multi1 order by key, value
 517POSTHOOK: type: QUERY
 518POSTHOOK: Input: default@src_multi1
 519POSTHOOK: Output: file:/tmp/sdong/hive_2011-02-10_16-43-52_773_729013797916091277/-mr-10000
 520POSTHOOK: Lineage: src_multi1.key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
 521POSTHOOK: Lineage: src_multi1.key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
 522POSTHOOK: Lineage: src_multi1.key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
 523POSTHOOK: Lineage: src_multi1.value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
 524POSTHOOK: Lineage: src_multi1.value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
 525POSTHOOK: Lineage: src_multi1.value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
 526POSTHOOK: Lineage: src_multi2.key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
 527POSTHOOK: Lineage: src_multi2.key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
 528POSTHOOK: Lineage: src_multi2.key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
 529POSTHOOK: Lineage: src_multi2.value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
 530POSTHOOK: Lineage: src_multi2.value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
 531POSTHOOK: Lineage: src_multi2.value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
 5320	val_0
 5330	val_0
 5340	val_0
 5352	val_2
 5364	val_4
 5375	val_5
 5385	val_5
 5395	val_5
 5408	val_8
 5419	val_9
 542PREHOOK: query: select * from src_multi2 order by key, value
 543PREHOOK: type: QUERY
 544PREHOOK: Input: default@src_multi2
 545PREHOOK: Output: file:/tmp/sdong/hive_2011-02-10_16-43-56_122_5865497182262054478/-mr-10000
 546POSTHOOK: query: select * from src_multi2 order by key, value
 547POSTHOOK: type: QUERY
 548POSTHOOK: Input: default@src_multi2
 549POSTHOOK: Output: file:/tmp/sdong/hive_2011-02-10_16-43-56_122_5865497182262054478/-mr-10000
 550POSTHOOK: Lineage: src_multi1.key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
 551POSTHOOK: Lineage: src_multi1.key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
 552POSTHOOK: Lineage: src_multi1.key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
 553POSTHOOK: Lineage: src_multi1.value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
 554POSTHOOK: Lineage: src_multi1.value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
 555POSTHOOK: Lineage: src_multi1.value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
 556POSTHOOK: Lineage: src_multi2.key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
 557POSTHOOK: Lineage: src_multi2.key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
 558POSTHOOK: Lineage: src_multi2.key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
 559POSTHOOK: Lineage: src_multi2.value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
 560POSTHOOK: Lineage: src_multi2.value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
 561POSTHOOK: Lineage: src_multi2.value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
 56211	val_11
 56312	val_12
 56412	val_12
 56515	val_15
 56615	val_15
 56717	val_17
 56818	val_18
 56918	val_18
 57019	val_19
 571PREHOOK: query: explain
 572from src
 573insert overwrite table src_multi1 select * where key < 10
 574insert overwrite table src_multi2 select * where key > 10 and key < 20
 575PREHOOK: type: QUERY
 576POSTHOOK: query: explain
 577from src
 578insert overwrite table src_multi1 select * where key < 10
 579insert overwrite table src_multi2 select * where key > 10 and key < 20
 580POSTHOOK: type: QUERY
 581POSTHOOK: Lineage: src_multi1.key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
 582POSTHOOK: Lineage: src_multi1.key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
 583POSTHOOK: Lineage: src_multi1.key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
 584POSTHOOK: Lineage: src_multi1.value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
 585POSTHOOK: Lineage: src_multi1.value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
 586POSTHOOK: Lineage: src_multi1.value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
 587POSTHOOK: Lineage: src_multi2.key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
 588POSTHOOK: Lineage: src_multi2.key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
 589POSTHOOK: Lineage: src_multi2.key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
 590POSTHOOK: Lineage: src_multi2.value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
 591POSTHOOK: Lineage: src_multi2.value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
 592POSTHOOK: Lineage: src_multi2.value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
 593ABSTRACT SYNTAX TREE:
 594  (TOK_QUERY (TOK_FROM (TOK_TABREF (TOK_TABNAME src))) (TOK_INSERT (TOK_DESTINATION (TOK_TAB (TOK_TABNAME src_multi1))) (TOK_SELECT (TOK_SELEXPR TOK_ALLCOLREF)) (TOK_WHERE (< (TOK_TABLE_OR_COL key) 10))) (TOK_INSERT (TOK_DESTINATION (TOK_TAB (TOK_TABNAME src_multi2))) (TOK_SELECT (TOK_SELEXPR TOK_ALLCOLREF)) (TOK_WHERE (and (> (TOK_TABLE_OR_COL key) 10) (< (TOK_TABLE_OR_COL key) 20)))))
 595
 596STAGE DEPENDENCIES:
 597  Stage-2 is a root stage
 598  Stage-6 depends on stages: Stage-2 , consists of Stage-5, Stage-4
 599  Stage-5
 600  Stage-0 depends on stages: Stage-5, Stage-4
 601  Stage-3 depends on stages: Stage-0
 602  Stage-4
 603  Stage-10 depends on stages: Stage-2 , consists of Stage-9, Stage-8
 604  Stage-9
 605  Stage-1 depends on stages: Stage-9, Stage-8
 606  Stage-7 depends on stages: Stage-1
 607  Stage-8
 608
 609STAGE PLANS:
 610  Stage: Stage-2
 611    Map Reduce
 612      Alias -> Map Operator Tree:
 613        src 
 614          TableScan
 615            alias: src
 616            Filter Operator
 617              predicate:
 618                  expr: (key < 10)
 619                  type: boolean
 620              Select Operator
 621                expressions:
 622                      expr: key
 623                      type: string
 624                      expr: value
 625                      type: string
 626                outputColumnNames: _col0, _col1
 627                File Output Operator
 628                  compressed: false
 629                  GlobalTableId: 1
 630                  table:
 631                      input format: org.apache.hadoop.mapred.TextInputFormat
 632                      output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
 633                      serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
 634                      name: default.src_multi1
 635            Filter Operator
 636              predicate:
 637                  expr: ((key > 10) and (key < 20))
 638                  type: boolean
 639              Select Operator
 640                expressions:
 641                      expr: key
 642                      type: string
 643                      expr: value
 644                      type: string
 645                outputColumnNames: _col0, _col1
 646                File Output Operator
 647                  compressed: false
 648                  GlobalTableId: 2
 649                  table:
 650                      input format: org.apache.hadoop.mapred.TextInputFormat
 651                      output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
 652                      serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
 653                      name: default.src_multi2
 654
 655  Stage: Stage-6
 656    Conditional Operator
 657
 658  Stage: Stage-5
 659    Move Operator
 660      files:
 661          hdfs directory: true
 662          destination: pfile:/data/users/sdong/www/open-source-hive1/build/ql/scratchdir/hive_2011-02-10_16-43-59_397_2100362781804635792/-ext-10000
 663
 664  Stage: Stage-0
 665    Move Operator
 666      tables:
 667          replace: true
 668          table:
 669              input format: org.apache.hadoop.mapred.TextInputFormat
 670              output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
 671              serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
 672              name: default.src_multi1
 673
 674  Stage: Stage-3
 675    Stats-Aggr Operator
 676
 677  Stage: Stage-4
 678    Map Reduce
 679      Alias -> Map Operator Tree:
 680        pfile:/data/users/sdong/www/open-source-hive1/build/ql/scratchdir/hive_2011-02-10_16-43-59_397_2100362781804635792/-ext-10004 
 681            File Output Operator
 682              compressed: false
 683              GlobalTableId: 0
 684              table:
 685                  input format: org.apache.hadoop.mapred.TextInputFormat
 686                  output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
 687                  serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
 688                  name: default.src_multi1
 689
 690  Stage: Stage-10
 691    Conditional Operator
 692
 693  Stage: Stage-9
 694    Move Operator
 695      files:
 696          hdfs directory: true
 697          destination: pfile:/data/users/sdong/www/open-source-hive1/build/ql/scratchdir/hive_2011-02-10_16-43-59_397_2100362781804635792/-ext-10002
 698
 699  Stage: Stage-1
 700    Move Operator
 701      tables:
 702          replace: true
 703          table:
 704              input format: org.apache.hadoop.mapred.TextInputFormat
 705              output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
 706              serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
 707              name: default.src_multi2
 708
 709  Stage: Stage-7
 710    Stats-Aggr Operator
 711
 712  Stage: Stage-8
 713    Map Reduce
 714      Alias -> Map Operator Tree:
 715        pfile:/data/users/sdong/www/open-source-hive1/build/ql/scratchdir/hive_2011-02-10_16-43-59_397_2100362781804635792/-ext-10005 
 716            File Output Operator
 717              compressed: false
 718              GlobalTableId: 0
 719              table:
 720                  input format: org.apache.hadoop.mapred.TextInputFormat
 721                  output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
 722                  serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
 723                  name: default.src_multi2
 724
 725
 726PREHOOK: query: from src
 727insert overwrite table src_multi1 select * where key < 10
 728insert overwrite table src_multi2 select * where key > 10 and key < 20
 729PREHOOK: type: QUERY
 730PREHOOK: Input: default@src
 731PREHOOK: Output: default@src_multi1
 732PREHOOK: Output: default@src_multi2
 733POSTHOOK: query: from src
 734insert overwrite table src_multi1 select * where key < 10
 735insert overwrite table src_multi2 select * where key > 10 and key < 20
 736POSTHOOK: type: QUERY
 737POSTHOOK: Input: default@src
 738POSTHOOK: Output: default@src_multi1
 739POSTHOOK: Output: default@src_multi2
 740POSTHOOK: Lineage: src_multi1.key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
 741POSTHOOK: Lineage: src_multi1.key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
 742POSTHOOK: Lineage: src_multi1.key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
 743POSTHOOK: Lineage: src_multi1.key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
 744POSTHOOK: Lineage: src_multi1.value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
 745POSTHOOK: Lineage: src_multi1.value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
 746POSTHOOK: Lineage: src_multi1.value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
 747POSTHOOK: Lineage: src_multi1.value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
 748POSTHOOK: Lineage: src_multi2.key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
 749POSTHOOK: Lineage: src_multi2.key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
 750POSTHOOK: Lineage: src_multi2.key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
 751POSTHOOK: Lineage: src_multi2.key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
 752POSTHOOK: Lineage: src_multi2.value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
 753POSTHOOK: Lineage: src_multi2.value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
 754POSTHOOK: Lineage: src_multi2.value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
 755POSTHOOK: Lineage: src_multi2.value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
 756PREHOOK: query: select * from src_multi1 order by key, value
 757PREHOOK: type: QUERY
 758PREHOOK: Input: default@src_multi1
 759PREHOOK: Output: file:/tmp/sdong/hive_2011-02-10_16-44-04_792_6847429891760050580/-mr-10000
 760POSTHOOK: query: select * from src_multi1 order by key, value
 761POSTHOOK: type: QUERY
 762POSTHOOK: Input: default@src_multi1
 763POSTHOOK: Output: file:/tmp/sdong/hive_2011-02-10_16-44-04_792_6847429891760050580/-mr-10000
 764POSTHOOK: Lineage: src_multi1.key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
 765POSTHOOK: Lineage: src_multi1.key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
 766POSTHOOK: Lineage: src_multi1.key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
 767POSTHOOK: Lineage: src_multi1.key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
 768POSTHOOK: Lineage: src_multi1.value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
 769POSTHOOK: Lineage: src_multi1.value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
 770POSTHOOK: Lineage: src_multi1.value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
 771POSTHOOK: Lineage: src_multi1.value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
 772POSTHOOK: Lineage: src_multi2.key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
 773POSTHOOK: Lineage: src_multi2.key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
 774POSTHOOK: Lineage: src_multi2.key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
 775POSTHOOK: Lineage: src_multi2.key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
 776POSTHOOK: Lineage: src_multi2.value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
 777POSTHOOK: Lineage: src_multi2.value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
 778POSTHOOK: Lineage: src_multi2.value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
 779POSTHOOK: Lineage: src_multi2.value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
 7800	val_0
 7810	val_0
 7820	val_0
 7832	val_2
 7844	val_4
 7855	val_5
 7865	val_5
 7875	val_5
 7888	val_8
 7899	val_9
 790PREHOOK: query: select * from src_multi2 order by key, value
 791PREHOOK: type: QUERY
 792PREHOOK: Input: default@src_multi2
 793PREHOOK: Output: file:/tmp/sdong/hive_2011-02-10_16-44-08_124_6485128554403267461/-mr-10000
 794POSTHOOK: query: select * from src_multi2 order by key, value
 795POSTHOOK: type: QUERY
 796POSTHOOK: Input: default@src_multi2
 797POSTHOOK: Output: file:/tmp/sdong/hive_2011-02-10_16-44-08_124_6485128554403267461/-mr-10000
 798POSTHOOK: Lineage: src_multi1.key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
 799POSTHOOK: Lineage: src_multi1.key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
 800POSTHOOK: Lineage: src_multi1.key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
 801POSTHOOK: Lineage: src_multi1.key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
 802POSTHOOK: Lineage: src_multi1.value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
 803POSTHOOK: Lineage: src_multi1.value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
 804POSTHOOK: Lineage: src_multi1.value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
 805POSTHOOK: Lineage: src_multi1.value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
 806POSTHOOK: Lineage: src_multi2.key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
 807POSTHOOK: Lineage: src_multi2.key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
 808POSTHOOK: Lineage: src_multi2.key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
 809POSTHOOK: Lineage: src_multi2.key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
 810POSTHOOK: Lineage: src_multi2.value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
 811POSTHOOK: Lineage: src_multi2.value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
 812POSTHOOK: Lineage: src_multi2.value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
 813POSTHOOK: Lineage: src_multi2.value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
 81411	val_11
 81512	val_12
 81612	val_12
 81715	val_15
 81815	val_15
 81917	val_17
 82018	val_18
 82118	val_18
 82219	val_19
 823PREHOOK: query: explain
 824from src
 825insert overwrite table src_multi1 select * where key < 10 group by key, value
 826insert overwrite table src_multi2 select * where key > 10 and key < 20 group by key, value
 827PREHOOK: type: QUERY
 828POSTHOOK: query: explain
 829from src
 830insert overwrite table src_multi1 select * where key < 10 group by key, value
 831insert overwrite table src_multi2 select * where key > 10 and key < 20 group by key, value
 832POSTHOOK: type: QUERY
 833POSTHOOK: Lineage: src_multi1.key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
 834POSTHOOK: Lineage: src_multi1.key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
 835POSTHOOK: Lineage: src_multi1.key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
 836POSTHOOK: Lineage: src_multi1.key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
 837POSTHOOK: Lineage: src_multi1.value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
 838POSTHOOK: Lineage: src_multi1.value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
 839POSTHOOK: Lineage: src_multi1.value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
 840POSTHOOK: Lineage: src_multi1.value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
 841POSTHOOK: Lineage: src_multi2.key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
 842POSTHOOK: Lineage: src_multi2.key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
 843POSTHOOK: Lineage: src_multi2.key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
 844POSTHOOK: Lineage: src_multi2.key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
 845POSTHOOK: Lineage: src_multi2.value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
 846POSTHOOK: Lineage: src_multi2.value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
 847POSTHOOK: Lineage: src_multi2.value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
 848POSTHOOK: Lineage: src_multi2.value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
 849ABSTRACT SYNTAX TREE:
 850  (TOK_QUERY (TOK_FROM (TOK_TABREF (TOK_TABNAME src))) (TOK_INSERT (TOK_DESTINATION (TOK_TAB (TOK_TABNAME src_multi1))) (TOK_SELECT (TOK_SELEXPR TOK_ALLCOLREF)) (TOK_WHERE (< (TOK_TABLE_OR_COL key) 10)) (TOK_GROUPBY (TOK_TABLE_OR_COL key) (TOK_TABLE_OR_COL value))) (TOK_INSERT (TOK_DESTINATION (TOK_TAB (TOK_TABNAME src_multi2))) (TOK_SELECT (TOK_SELEXPR TOK_ALLCOLREF)) (TOK_WHERE (and (> (TOK_TABLE_OR_COL key) 10) (< (TOK_TABLE_OR_COL key) 20))) (TOK_GROUPBY (TOK_TABLE_OR_COL key) (TOK_TABLE_OR_COL value))))
 851
 852STAGE DEPENDENCIES:
 853  Stage-2 is a root stage
 854  Stage-0 depends on stages: Stage-2
 855  Stage-3 depends on stages: Stage-0
 856  Stage-4 depends on stages: Stage-2
 857  Stage-1 depends on stages: Stage-4
 858  Stage-5 depends on stages: Stage-1
 859
 860STAGE PLANS:
 861  Stage: Stage-2
 862    Map Reduce
 863      Alias -> Map Operator Tree:
 864        src 
 865          TableScan
 866            alias: src
 867            Filter Operator
 868              predicate:
 869                  expr: (key < 10)
 870                  type: boolean
 871              Select Operator
 872                expressions:
 873                      expr: key
 874                      type: string
 875                      expr: value
 876                      type: string
 877                outputColumnNames: key, value
 878                Group By Operator
 879                  bucketGroup: false
 880                  keys:
 881                        expr: key
 882                        type: string
 883                        expr: value
 884                        type: string
 885                  mode: hash
 886                  outputColumnNames: _col0, _col1
 887                  Reduce Output Operator
 888                    key expressions:
 889                          expr: _col0
 890                          type: string
 891                          expr: _col1
 892                          type: string
 893                    sort order: ++
 894                    Map-reduce partition columns:
 895                          expr: _col0
 896                          type: string
 897                          expr: _col1
 898                          type: string
 899                    tag: -1
 900            Filter Operator
 901              predicate:
 902                  expr: ((key > 10) and (key < 20))
 903                  type: boolean
 904              Select Operator
 905                expressions:
 906                      expr: key
 907                      type: string
 908                      expr: value
 909                      type: string
 910                outputColumnNames: key, value
 911                Group By Operator
 912                  bucketGroup: false
 913                  keys:
 914                        expr: key
 915                        type: string
 916                        expr: value
 917                        type: string
 918                  mode: hash
 919                  outputColumnNames: _col0, _col1
 920                  File Output Operator
 921                    compressed: false
 922                    GlobalTableId: 0
 923                    table:
 924                        input format: org.apache.hadoop.mapred.SequenceFileInputFormat
 925                        output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
 926      Reduce Operator Tree:
 927        Group By Operator
 928          bucketGroup: false
 929          keys:
 930                expr: KEY._col0
 931                type: string
 932                expr: KEY._col1
 933                type: string
 934          mode: mergepartial
 935          outputColumnNames: _col0, _col1
 936          Select Operator
 937            expressions:
 938                  expr: _col0
 939                  type: string
 940                  expr: _col1
 941                  type: string
 942            outputColumnNames: _col0, _col1
 943            File Output Operator
 944              compressed: false
 945              GlobalTableId: 1
 946              table:
 947                  input format: org.apache.hadoop.mapred.TextInputFormat
 948                  output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
 949                  serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
 950                  name: default.src_multi1
 951
 952  Stage: Stage-0
 953    Move Operator
 954      tables:
 955          replace: true
 956          table:
 957              input format: org.apache.hadoop.mapred.TextInputFormat
 958              output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
 959              serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
 960              name: default.src_multi1
 961
 962  Stage: Stage-3
 963    Stats-Aggr Operator
 964
 965  Stage: Stage-4
 966    Map Reduce
 967      Alias -> Map Operator Tree:
 968        file:/tmp/sdong/hive_2011-02-10_16-44-11_407_9168756298659685920/-mr-10004 
 969            Reduce Output Operator
 970              key expressions:
 971                    expr: _col0
 972                    type: string
 973                    expr: _col1
 974                    type: string
 975              sort order: ++
 976              Map-reduce partition columns:
 977                    expr: _col0
 978                    type: string
 979                    expr: _col1
 980                    type: string
 981              tag: -1
 982      Reduce Operator Tree:
 983        Group By Operator
 984          bucketGroup: false
 985          keys:
 986                expr: KEY._col0
 987                type: string
 988                expr: KEY._col1
 989                type: string
 990          mode: mergepartial
 991          outputColumnNames: _col0, _col1
 992          Select Operator
 993            expressions:
 994                  expr: _col0
 995                  type: string
 996                  expr: _col1
 997                  type: string
 998            outputColumnNames: _col0, _col1
 999            File Output Operator
1000              compressed: false
1001              GlobalTableId: 2
1002              table:
1003                  input format: org.apache.hadoop.mapred.TextInputFormat
1004                  output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
1005                  serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
1006                  name: default.src_multi2
1007
1008  Stage: Stage-1
1009    Move Operator
1010      tables:
1011          replace: true
1012          table:
1013              input format: org.apache.hadoop.mapred.TextInputFormat
1014              output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
1015              serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
1016              name: default.src_multi2
1017
1018  Stage: Stage-5
1019    Stats-Aggr Operator
1020
1021
1022PREHOOK: query: from src
1023insert overwrite table src_multi1 select * where key < 10 group by key, value
1024insert overwrite table src_multi2 select * where key > 10 and key < 20 group by key, value
1025PREHOOK: type: QUERY
1026PREHOOK: Input: default@src
1027PREHOOK: Output: default@src_multi1
1028PREHOOK: Output: default@src_multi2
1029POSTHOOK: query: from src
1030insert overwrite table src_multi1 select * where key < 10 group by key, value
1031insert overwrite table src_multi2 select * where key > 10 and key < 20 group by key, value
1032POSTHOOK: type: QUERY
1033POSTHOOK: Input: default@src
1034POSTHOOK: Output: default@src_multi1
1035POSTHOOK: Output: default@src_multi2
1036POSTHOOK: Lineage: src_multi1.key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
1037POSTHOOK: Lineage: src_multi1.key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
1038POSTHOOK: Lineage: src_multi1.key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
1039POSTHOOK: Lineage: src_multi1.key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
1040POSTHOOK: Lineage: src_multi1.key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
1041POSTHOOK: Lineage: src_multi1.value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
1042POSTHOOK: Lineage: src_multi1.value SIMPLE [(src)src.FieldSc…

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