query: CREATE TABLE dest1(c1 DOUBLE, c2 INT) STORED AS TEXTFILE
query: EXPLAIN
FROM src1
INSERT OVERWRITE TABLE dest1 SELECT NULL, src1.key
ABSTRACT SYNTAX TREE:
  (TOK_QUERY (TOK_FROM (TOK_TABREF src1)) (TOK_INSERT (TOK_DESTINATION (TOK_TAB dest1)) (TOK_SELECT (TOK_SELEXPR TOK_NULL) (TOK_SELEXPR (. (TOK_TABLE_OR_COL src1) key)))))

STAGE DEPENDENCIES:
  Stage-1 is a root stage
  Stage-4 depends on stages: Stage-1
  Stage-0 depends on stages: Stage-4

STAGE PLANS:
  Stage: Stage-1
    Map Reduce
      Alias -> Map Operator Tree:
        src1 
          TableScan
            alias: src1
            Select Operator
              expressions:
                    expr: null
                    type: string
                    expr: key
                    type: string
              outputColumnNames: _col0, _col1
              Select Operator
                expressions:
                      expr: UDFToDouble(_col0)
                      type: double
                      expr: UDFToInteger(_col1)
                      type: int
                outputColumnNames: _col0, _col1
                File Output Operator
                  compressed: false
                  GlobalTableId: 1
                  table:
                      input format: org.apache.hadoop.mapred.TextInputFormat
                      output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
                      serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
                      name: dest1

  Stage: Stage-4
    Conditional Operator
      list of dependent Tasks:
          Move Operator
            files:
                hdfs directory: true
                destination: file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/1105502435/10000
          Map Reduce
            Alias -> Map Operator Tree:
              file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/1662408362/10002 
                  Reduce Output Operator
                    sort order: 
                    Map-reduce partition columns:
                          expr: rand()
                          type: double
                    tag: -1
                    value expressions:
                          expr: c1
                          type: double
                          expr: c2
                          type: int
            Reduce Operator Tree:
              Extract
                File Output Operator
                  compressed: false
                  GlobalTableId: 0
                  table:
                      input format: org.apache.hadoop.mapred.TextInputFormat
                      output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
                      serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
                      name: dest1

  Stage: Stage-0
    Move Operator
      tables:
          replace: true
          table:
              input format: org.apache.hadoop.mapred.TextInputFormat
              output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
              serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
              name: dest1


query: FROM src1
INSERT OVERWRITE TABLE dest1 SELECT NULL, src1.key
Input: default/src1
Output: default/dest1
query: SELECT dest1.* FROM dest1
Input: default/dest1
Output: file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/136163075/10000
NULL	238
NULL	NULL
NULL	311
NULL	NULL
NULL	NULL
NULL	NULL
NULL	255
NULL	278
NULL	98
NULL	NULL
NULL	NULL
NULL	NULL
NULL	401
NULL	150
NULL	273
NULL	224
NULL	369
NULL	66
NULL	128
NULL	213
NULL	146
NULL	406
NULL	NULL
NULL	NULL
NULL	NULL