PREHOOK: query: EXPLAIN
FROM (
  FROM src select src.* WHERE src.key < 100
) unioninput
INSERT OVERWRITE DIRECTORY '../build/ql/test/data/warehouse/union.out' SELECT unioninput.*
PREHOOK: type: QUERY
POSTHOOK: query: EXPLAIN
FROM (
  FROM src select src.* WHERE src.key < 100
) unioninput
INSERT OVERWRITE DIRECTORY '../build/ql/test/data/warehouse/union.out' SELECT unioninput.*
POSTHOOK: type: QUERY
ABSTRACT SYNTAX TREE:
  (TOK_QUERY (TOK_FROM (TOK_SUBQUERY (TOK_QUERY (TOK_FROM (TOK_TABREF src)) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR (TOK_ALLCOLREF src))) (TOK_WHERE (< (. (TOK_TABLE_OR_COL src) key) 100)))) unioninput)) (TOK_INSERT (TOK_DESTINATION (TOK_DIR '../build/ql/test/data/warehouse/union.out')) (TOK_SELECT (TOK_SELEXPR (TOK_ALLCOLREF unioninput)))))

STAGE DEPENDENCIES:
  Stage-1 is a root stage
  Stage-4 depends on stages: Stage-1 , consists of Stage-3, Stage-2
  Stage-3
  Stage-0 depends on stages: Stage-3, Stage-2
  Stage-2

STAGE PLANS:
  Stage: Stage-1
    Map Reduce
      Alias -> Map Operator Tree:
        unioninput:src 
          TableScan
            alias: src
            Filter Operator
              predicate:
                  expr: (key < 100)
                  type: boolean
              Filter Operator
                predicate:
                    expr: (key < 100)
                    type: boolean
                Select Operator
                  expressions:
                        expr: key
                        type: string
                        expr: value
                        type: string
                  outputColumnNames: _col0, _col1
                  Select Operator
                    expressions:
                          expr: _col0
                          type: string
                          expr: _col1
                          type: string
                    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

  Stage: Stage-4
    Conditional Operator

  Stage: Stage-3
    Move Operator
      files:
          hdfs directory: true
          destination: file:/data/users/nzhang/reviews/0.6/branch-0.6/build/ql/scratchdir/hive_2010-08-23_22-19-56_839_8092359288547756739/10000

  Stage: Stage-0
    Move Operator
      files:
          hdfs directory: true
          destination: ../build/ql/test/data/warehouse/union.out

  Stage: Stage-2
    Map Reduce
      Alias -> Map Operator Tree:
        file:/data/users/nzhang/reviews/0.6/branch-0.6/build/ql/scratchdir/hive_2010-08-23_22-19-56_839_8092359288547756739/10001 
            Reduce Output Operator
              sort order: 
              Map-reduce partition columns:
                    expr: rand()
                    type: double
              tag: -1
              value expressions:
                    expr: _col0
                    type: string
                    expr: _col1
                    type: string
      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


PREHOOK: query: FROM (
  FROM src select src.* WHERE src.key < 100
) unioninput
INSERT OVERWRITE DIRECTORY '../build/ql/test/data/warehouse/union.out' SELECT unioninput.*
PREHOOK: type: QUERY
PREHOOK: Input: default@src
PREHOOK: Output: ../build/ql/test/data/warehouse/union.out
POSTHOOK: query: FROM (
  FROM src select src.* WHERE src.key < 100
) unioninput
INSERT OVERWRITE DIRECTORY '../build/ql/test/data/warehouse/union.out' SELECT unioninput.*
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src
POSTHOOK: Output: ../build/ql/test/data/warehouse/union.out
86
val_86
27
val_27
98
val_98
66
val_66
37
val_37
15
val_15
82
val_82
17
val_17
0
val_0
57
val_57
20
val_20
92
val_92
47
val_47
72
val_72
4
val_4
35
val_35
54
val_54
51
val_51
65
val_65
83
val_83
12
val_12
67
val_67
84
val_84
58
val_58
8
val_8
24
val_24
42
val_42
0
val_0
96
val_96
26
val_26
51
val_51
43
val_43
95
val_95
98
val_98
85
val_85
77
val_77
0
val_0
87
val_87
15
val_15
72
val_72
90
val_90
19
val_19
10
val_10
5
val_5
58
val_58
35
val_35
95
val_95
11
val_11
34
val_34
42
val_42
78
val_78
76
val_76
41
val_41
30
val_30
64
val_64
76
val_76
74
val_74
69
val_69
33
val_33
70
val_70
5
val_5
2
val_2
35
val_35
80
val_80
44
val_44
53
val_53
90
val_90
12
val_12
5
val_5
70
val_70
24
val_24
70
val_70
83
val_83
26
val_26
67
val_67
18
val_18
9
val_9
18
val_18
97
val_97
84
val_84
28
val_28
37
val_37
90
val_90
97
val_97