PREHOOK: query: CREATE TABLE mi1(key INT, value STRING) STORED AS TEXTFILE
PREHOOK: type: CREATETABLE
POSTHOOK: query: CREATE TABLE mi1(key INT, value STRING) STORED AS TEXTFILE
POSTHOOK: type: CREATETABLE
POSTHOOK: Output: default@mi1
PREHOOK: query: CREATE TABLE mi2(key INT, value STRING) STORED AS TEXTFILE
PREHOOK: type: CREATETABLE
POSTHOOK: query: CREATE TABLE mi2(key INT, value STRING) STORED AS TEXTFILE
POSTHOOK: type: CREATETABLE
POSTHOOK: Output: default@mi2
PREHOOK: query: CREATE TABLE mi3(key INT) PARTITIONED BY(ds STRING, hr STRING) STORED AS TEXTFILE
PREHOOK: type: CREATETABLE
POSTHOOK: query: CREATE TABLE mi3(key INT) PARTITIONED BY(ds STRING, hr STRING) STORED AS TEXTFILE
POSTHOOK: type: CREATETABLE
POSTHOOK: Output: default@mi3
PREHOOK: query: EXPLAIN
FROM src a JOIN src b ON (a.key = b.key)
INSERT OVERWRITE TABLE mi1 SELECT a.* WHERE a.key < 100
INSERT OVERWRITE TABLE mi2 SELECT a.key, a.value WHERE a.key >= 100 and a.key < 200
INSERT OVERWRITE TABLE mi3 PARTITION(ds='2008-04-08', hr='12') SELECT a.key WHERE a.key >= 200 and a.key < 300
INSERT OVERWRITE DIRECTORY '../build/ql/test/data/warehouse/mi4.out' SELECT a.value WHERE a.key >= 300
PREHOOK: type: QUERY
POSTHOOK: query: EXPLAIN
FROM src a JOIN src b ON (a.key = b.key)
INSERT OVERWRITE TABLE mi1 SELECT a.* WHERE a.key < 100
INSERT OVERWRITE TABLE mi2 SELECT a.key, a.value WHERE a.key >= 100 and a.key < 200
INSERT OVERWRITE TABLE mi3 PARTITION(ds='2008-04-08', hr='12') SELECT a.key WHERE a.key >= 200 and a.key < 300
INSERT OVERWRITE DIRECTORY '../build/ql/test/data/warehouse/mi4.out' SELECT a.value WHERE a.key >= 300
POSTHOOK: type: QUERY
ABSTRACT SYNTAX TREE:
  (TOK_QUERY (TOK_FROM (TOK_JOIN (TOK_TABREF (TOK_TABNAME src) a) (TOK_TABREF (TOK_TABNAME src) b) (= (. (TOK_TABLE_OR_COL a) key) (. (TOK_TABLE_OR_COL b) key)))) (TOK_INSERT (TOK_DESTINATION (TOK_TAB (TOK_TABNAME mi1))) (TOK_SELECT (TOK_SELEXPR (TOK_ALLCOLREF (TOK_TABNAME a)))) (TOK_WHERE (< (. (TOK_TABLE_OR_COL a) key) 100))) (TOK_INSERT (TOK_DESTINATION (TOK_TAB (TOK_TABNAME mi2))) (TOK_SELECT (TOK_SELEXPR (. (TOK_TABLE_OR_COL a) key)) (TOK_SELEXPR (. (TOK_TABLE_OR_COL a) value))) (TOK_WHERE (and (>= (. (TOK_TABLE_OR_COL a) key) 100) (< (. (TOK_TABLE_OR_COL a) key) 200)))) (TOK_INSERT (TOK_DESTINATION (TOK_TAB (TOK_TABNAME mi3) (TOK_PARTSPEC (TOK_PARTVAL ds '2008-04-08') (TOK_PARTVAL hr '12')))) (TOK_SELECT (TOK_SELEXPR (. (TOK_TABLE_OR_COL a) key))) (TOK_WHERE (and (>= (. (TOK_TABLE_OR_COL a) key) 200) (< (. (TOK_TABLE_OR_COL a) key) 300)))) (TOK_INSERT (TOK_DESTINATION (TOK_DIR '../build/ql/test/data/warehouse/mi4.out')) (TOK_SELECT (TOK_SELEXPR (. (TOK_TABLE_OR_COL a) value))) (TOK_WHERE (>= (. (TOK_TABLE_OR_COL a) key) 300))))

STAGE DEPENDENCIES:
  Stage-4 is a root stage
  Stage-0 depends on stages: Stage-4
  Stage-5 depends on stages: Stage-0
  Stage-1 depends on stages: Stage-4
  Stage-6 depends on stages: Stage-1
  Stage-2 depends on stages: Stage-4
  Stage-7 depends on stages: Stage-2
  Stage-3 depends on stages: Stage-4

STAGE PLANS:
  Stage: Stage-4
    Map Reduce
      Alias -> Map Operator Tree:
        a 
          TableScan
            alias: a
            Reduce Output Operator
              key expressions:
                    expr: key
                    type: string
              sort order: +
              Map-reduce partition columns:
                    expr: key
                    type: string
              tag: 0
              value expressions:
                    expr: key
                    type: string
                    expr: value
                    type: string
        b 
          TableScan
            alias: b
            Reduce Output Operator
              key expressions:
                    expr: key
                    type: string
              sort order: +
              Map-reduce partition columns:
                    expr: key
                    type: string
              tag: 1
      Reduce Operator Tree:
        Join Operator
          condition map:
               Inner Join 0 to 1
          condition expressions:
            0 {VALUE._col0} {VALUE._col1}
            1 
          handleSkewJoin: false
          outputColumnNames: _col0, _col1
          Filter Operator
            predicate:
                expr: (_col0 < 100)
                type: boolean
            Select Operator
              expressions:
                    expr: UDFToInteger(_col0)
                    type: int
                    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
                    serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
                    name: default.mi1
          Filter Operator
            predicate:
                expr: ((_col0 >= 100) and (_col0 < 200))
                type: boolean
            Select Operator
              expressions:
                    expr: UDFToInteger(_col0)
                    type: int
                    expr: _col1
                    type: string
              outputColumnNames: _col0, _col1
              File Output Operator
                compressed: false
                GlobalTableId: 2
                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: default.mi2
          Filter Operator
            predicate:
                expr: ((_col0 >= 200) and (_col0 < 300))
                type: boolean
            Select Operator
              expressions:
                    expr: UDFToInteger(_col0)
                    type: int
              outputColumnNames: _col0
              File Output Operator
                compressed: false
                GlobalTableId: 3
                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: default.mi3
          Filter Operator
            predicate:
                expr: (_col0 >= 300)
                type: boolean
            Select Operator
              expressions:
                    expr: _col1
                    type: string
              outputColumnNames: _col0
              File Output Operator
                compressed: false
                GlobalTableId: 4
                table:
                    input format: org.apache.hadoop.mapred.TextInputFormat
                    output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat

  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: default.mi1

  Stage: Stage-5
    Stats-Aggr Operator

  Stage: Stage-1
    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: default.mi2

  Stage: Stage-6
    Stats-Aggr Operator

  Stage: Stage-2
    Move Operator
      tables:
          partition:
            ds 2008-04-08
            hr 12
          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: default.mi3

  Stage: Stage-7
    Stats-Aggr Operator

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


PREHOOK: query: FROM src a JOIN src b ON (a.key = b.key)
INSERT OVERWRITE TABLE mi1 SELECT a.* WHERE a.key < 100
INSERT OVERWRITE TABLE mi2 SELECT a.key, a.value WHERE a.key >= 100 and a.key < 200
INSERT OVERWRITE TABLE mi3 PARTITION(ds='2008-04-08', hr='12') SELECT a.key WHERE a.key >= 200 and a.key < 300
INSERT OVERWRITE DIRECTORY '../build/ql/test/data/warehouse/mi4.out' SELECT a.value WHERE a.key >= 300
PREHOOK: type: QUERY
PREHOOK: Input: default@src
PREHOOK: Output: ../build/ql/test/data/warehouse/mi4.out
PREHOOK: Output: default@mi1
PREHOOK: Output: default@mi2
PREHOOK: Output: default@mi3@ds=2008-04-08/hr=12
POSTHOOK: query: FROM src a JOIN src b ON (a.key = b.key)
INSERT OVERWRITE TABLE mi1 SELECT a.* WHERE a.key < 100
INSERT OVERWRITE TABLE mi2 SELECT a.key, a.value WHERE a.key >= 100 and a.key < 200
INSERT OVERWRITE TABLE mi3 PARTITION(ds='2008-04-08', hr='12') SELECT a.key WHERE a.key >= 200 and a.key < 300
INSERT OVERWRITE DIRECTORY '../build/ql/test/data/warehouse/mi4.out' SELECT a.value WHERE a.key >= 300
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src
POSTHOOK: Output: ../build/ql/test/data/warehouse/mi4.out
POSTHOOK: Output: default@mi1
POSTHOOK: Output: default@mi2
POSTHOOK: Output: default@mi3@ds=2008-04-08/hr=12
POSTHOOK: Lineage: mi1.key EXPRESSION [(src)a.FieldSchema(name:key, type:string, comment:default), ]
POSTHOOK: Lineage: mi1.value SIMPLE [(src)a.FieldSchema(name:value, type:string, comment:default), ]
POSTHOOK: Lineage: mi2.key EXPRESSION [(src)a.FieldSchema(name:key, type:string, comment:default), ]
POSTHOOK: Lineage: mi2.value SIMPLE [(src)a.FieldSchema(name:value, type:string, comment:default), ]
POSTHOOK: Lineage: mi3 PARTITION(ds=2008-04-08,hr=12).key EXPRESSION [(src)a.FieldSchema(name:key, type:string, comment:default), ]
PREHOOK: query: SELECT mi1.* FROM mi1
PREHOOK: type: QUERY
PREHOOK: Input: default@mi1
#### A masked pattern was here ####
POSTHOOK: query: SELECT mi1.* FROM mi1
POSTHOOK: type: QUERY
POSTHOOK: Input: default@mi1
#### A masked pattern was here ####
POSTHOOK: Lineage: mi1.key EXPRESSION [(src)a.FieldSchema(name:key, type:string, comment:default), ]
POSTHOOK: Lineage: mi1.value SIMPLE [(src)a.FieldSchema(name:value, type:string, comment:default), ]
POSTHOOK: Lineage: mi2.key EXPRESSION [(src)a.FieldSchema(name:key, type:string, comment:default), ]
POSTHOOK: Lineage: mi2.value SIMPLE [(src)a.FieldSchema(name:value, type:string, comment:default), ]
POSTHOOK: Lineage: mi3 PARTITION(ds=2008-04-08,hr=12).key EXPRESSION [(src)a.FieldSchema(name:key, type:string, comment:default), ]
0	val_0
0	val_0
0	val_0
0	val_0
0	val_0
0	val_0
0	val_0
0	val_0
0	val_0
10	val_10
11	val_11
12	val_12
12	val_12
12	val_12
12	val_12
15	val_15
15	val_15
15	val_15
15	val_15
17	val_17
18	val_18
18	val_18
18	val_18
18	val_18
19	val_19
2	val_2
20	val_20
24	val_24
24	val_24
24	val_24
24	val_24
26	val_26
26	val_26
26	val_26
26	val_26
27	val_27
28	val_28
30	val_30
33	val_33
34	val_34
35	val_35
35	val_35
35	val_35
35	val_35
35	val_35
35	val_35
35	val_35
35	val_35
35	val_35
37	val_37
37	val_37
37	val_37
37	val_37
4	val_4
41	val_41
42	val_42
42	val_42
42	val_42
42	val_42
43	val_43
44	val_44
47	val_47
5	val_5
5	val_5
5	val_5
5	val_5
5	val_5
5	val_5
5	val_5
5	val_5
5	val_5
51	val_51
51	val_51
51	val_51
51	val_51
53	val_53
54	val_54
57	val_57
58	val_58
58	val_58
58	val_58
58	val_58
64	val_64
65	val_65
66	val_66
67	val_67
67	val_67
67	val_67
67	val_67
69	val_69
70	val_70
70	val_70
70	val_70
70	val_70
70	val_70
70	val_70
70	val_70
70	val_70
70	val_70
72	val_72
72	val_72
72	val_72
72	val_72
74	val_74
76	val_76
76	val_76
76	val_76
76	val_76
77	val_77
78	val_78
8	val_8
80	val_80
82	val_82
83	val_83
83	val_83
83	val_83
83	val_83
84	val_84
84	val_84
84	val_84
84	val_84
85	val_85
86	val_86
87	val_87
9	val_9
90	val_90
90	val_90
90	val_90
90	val_90
90	val_90
90	val_90
90	val_90
90	val_90
90	val_90
92	val_92
95	val_95
95	val_95
95	val_95
95	val_95
96	val_96
97	val_97
97	val_97
97	val_97
97	val_97
98	val_98
98	val_98
98	val_98
98	val_98
PREHOOK: query: SELECT mi2.* FROM mi2
PREHOOK: type: QUERY
PREHOOK: Input: default@mi2
#### A masked pattern was here ####
POSTHOOK: query: SELECT mi2.* FROM mi2
POSTHOOK: type: QUERY
POSTHOOK: Input: default@mi2
#### A masked pattern was here ####
POSTHOOK: Lineage: mi1.key EXPRESSION [(src)a.FieldSchema(name:key, type:string, comment:default), ]
POSTHOOK: Lineage: mi1.value SIMPLE [(src)a.FieldSchema(name:value, type:string, comment:default), ]
POSTHOOK: Lineage: mi2.key EXPRESSION [(src)a.FieldSchema(name:key, type:string, comment:default), ]
POSTHOOK: Lineage: mi2.value SIMPLE [(src)a.FieldSchema(name:value, type:string, comment:default), ]
POSTHOOK: Lineage: mi3 PARTITION(ds=2008-04-08,hr=12).key EXPRESSION [(src)a.FieldSchema(name:key, type:string, comment:default), ]
100	val_100
100	val_100
100	val_100
100	val_100
103	val_103
103	val_103
103	val_103
103	val_103
104	val_104
104	val_104
104	val_104
104	val_104
105	val_105
111	val_111
113	val_113
113	val_113
113	val_113
113	val_113
114	val_114
116	val_116
118	val_118
118	val_118
118	val_118
118	val_118
119	val_119
119	val_119
119	val_119
119	val_119
119	val_119
119	val_119
119	val_119
119	val_119
119	val_119
120	val_120
120	val_120
120	val_120
120	val_120
125	val_125
125	val_125
125	val_125
125	val_125
126	val_126
128	val_128
128	val_128
128	val_128
128	val_128
128	val_128
128	val_128
128	val_128
128	val_128
128	val_128
129	val_129
129	val_129
129	val_129
129	val_129
131	val_131
133	val_133
134	val_134
134	val_134
134	val_134
134	val_134
136	val_136
137	val_137
137	val_137
137	val_137
137	val_137
138	val_138
138	val_138
138	val_138
138	val_138
138	val_138
138	val_138
138	val_138
138	val_138
138	val_138
138	val_138
138	val_138
138	val_138
138	val_138
138	val_138
138	val_138
138	val_138
143	val_143
145	val_145
146	val_146
146	val_146
146	val_146
146	val_146
149	val_149
149	val_149
149	val_149
149	val_149
150	val_150
152	val_152
152	val_152
152	val_152
152	val_152
153	val_153
155	val_155
156	val_156
157	val_157
158	val_158
160	val_160
162	val_162
163	val_163
164	val_164
164	val_164
164	val_164
164	val_164
165	val_165
165	val_165
165	val_165
165	val_165
166	val_166
167	val_167
167	val_167
167	val_167
167	val_167
167	val_167
167	val_167
167	val_167
167	val_167
167	val_167
168	val_168
169	val_169
169	val_169
169	val_169
169	val_169
169	val_169
169	val_169
169	val_169
169	val_169
169	val_169
169	val_169
169	val_169
169	val_169
169	val_169
169	val_169
169	val_169
169	val_169
170	val_170
172	val_172
172	val_172
172	val_172
172	val_172
174	val_174
174	val_174
174	val_174
174	val_174
175	val_175
175	val_175
175	val_175
175	val_175
176	val_176
176	val_176
176	val_176
176	val_176
177	val_177
178	val_178
179	val_179
179	val_179
179	val_179
179	val_179
180	val_180
181	val_181
183	val_183
186	val_186
187	val_187
187	val_187
187	val_187
187	val_187
187	val_187
187	val_187
187	val_187
187	val_187
187	val_187
189	val_189
190	val_190
191	val_191
191	val_191
191	val_191
191	val_191
192	val_192
193	val_193
193	val_193
193	val_193
193	val_193
193	val_193
193	val_193
193	val_193
193	val_193
193	val_193
194	val_194
195	val_195
195	val_195
195	val_195
195	val_195
196	val_196
197	val_197
197	val_197
197	val_197
197	val_197
199	val_199
199	val_199
199	val_199
199	val_199
199	val_199
199	val_199
199	val_199
199	val_199
199	val_199
PREHOOK: query: SELECT mi3.* FROM mi3
PREHOOK: type: QUERY
PREHOOK: Input: default@mi3
PREHOOK: Input: default@mi3@ds=2008-04-08/hr=12
#### A masked pattern was here ####
POSTHOOK: query: SELECT mi3.* FROM mi3
POSTHOOK: type: QUERY
POSTHOOK: Input: default@mi3
POSTHOOK: Input: default@mi3@ds=2008-04-08/hr=12
#### A masked pattern was here ####
POSTHOOK: Lineage: mi1.key EXPRESSION [(src)a.FieldSchema(name:key, type:string, comment:default), ]
POSTHOOK: Lineage: mi1.value SIMPLE [(src)a.FieldSchema(name:value, type:string, comment:default), ]
POSTHOOK: Lineage: mi2.key EXPRESSION [(src)a.FieldSchema(name:key, type:string, comment:default), ]
POSTHOOK: Lineage: mi2.value SIMPLE [(src)a.FieldSchema(name:value, type:string, comment:default), ]
POSTHOOK: Lineage: mi3 PARTITION(ds=2008-04-08,hr=12).key EXPRESSION [(src)a.FieldSchema(name:key, type:string, comment:default), ]
200	2008-04-08	12
200	2008-04-08	12
200	2008-04-08	12
200	2008-04-08	12
201	2008-04-08	12
202	2008-04-08	12
203	2008-04-08	12
203	2008-04-08	12
203	2008-04-08	12
203	2008-04-08	12
205	2008-04-08	12
205	2008-04-08	12
205	2008-04-08	12
205	2008-04-08	12
207	2008-04-08	12
207	2008-04-08	12
207	2008-04-08	12
207	2008-04-08	12
208	2008-04-08	12
208	2008-04-08	12
208	2008-04-08	12
208	2008-04-08	12
208	2008-04-08	12
208	2008-04-08	12
208	2008-04-08	12
208	2008-04-08	12
208	2008-04-08	12
209	2008-04-08	12
209	2008-04-08	12
209	2008-04-08	12
209	2008-04-08	12
213	2008-04-08	12
213	2008-04-08	12
213	2008-04-08	12
213	2008-04-08	12
214	2008-04-08	12
216	2008-04-08	12
216	2008-04-08	12
216	2008-04-08	12
216	2008-04-08	12
217	2008-04-08	12
217	2008-04-08	12
217	2008-04-08	12
217	2008-04-08	12
218	2008-04-08	12
219	2008-04-08	12
219	2008-04-08	12
219	2008-04-08	12
219	2008-04-08	12
221	2008-04-08	12
221	2008-04-08	12
221	2008-04-08	12
221	2008-04-08	12
222	2008-04-08	12
223	2008-04-08	12
223	2008-04-08	12
223	2008-04-08	12
223	2008-04-08	12
224	2008-04-08	12
224	2008-04-08	12
224	2008-04-08	12
224	2008-04-08	12
226	2008-04-08	12
228	2008-04-08	12
229	2008-04-08	12
229	2008-04-08	12
229	2008-04-08	12
229	2008-04-08	12
230	2008-04-08	12
230	2008-04-08	12
230	2008-04-08	12
230	2008-04-08	12
230	2008-04-08	12
230	2008-04-08	12
230	2008-04-08	12
230	2008-04-08	12
230	2008-04-08	12
230	2008-04-08	12
230	2008-04-08	12
230	2008-04-08	12
230	2008-04-08	12
230	2008-04-08	12
230	2008-04-08	12
230	2008-04-08	12
230	2008-04-08	12
230	2008-04-08	12
230	2008-04-08	12
230	2008-04-08	12
230	2008-04-08	12
230	2008-04-08	12
230	2008-04-08	12
230	2008-04-08	12
230	2008-04-08	12
233	2008-04-08	12
233	2008-04-08	12
233	2008-04-08	12
233	2008-04-08	12
235	2008-04-08	12
237	2008-04-08	12
237	2008-04-08	12
237	2008-04-08	12
237	2008-04-08	12
238	2008-04-08	12
238	2008-04-08	12
238	2008-04-08	12
238	2008-04-08	12
239	2008-04-08	12
239	2008-04-08	12
239	2008-04-08	12
239	2008-04-08	12
241	2008-04-08	12
242	2008-04-08	12
242	2008-04-08	12
242	2008-04-08	12
242	2008-04-08	12
244	2008-04-08	12
247	2008-04-08	12
248	2008-04-08	12
249	2008-04-08	12
252	2008-04-08	12
255	2008-04-08	12
255	2008-04-08	12
255	2008-04-08	12
255	2008-04-08	12
256	2008-04-08	12
256	2008-04-08	12
256	2008-04-08	12
256	2008-04-08	12
257	2008-04-08	12
258	2008-04-08	12
260	2008-04-08	12
262	2008-04-08	12
263	2008-04-08	12
265	2008-04-08	12
265	2008-04-08	12
265	2008-04-08	12
265	2008-04-08	12
266	2008-04-08	12
272	2008-04-08	12
272	2008-04-08	12
272	2008-04-08	12
272	2008-04-08	12
273	2008-04-08	12
273	2008-04-08	12
273	2008-04-08	12
273	2008-04-08	12
273	2008-04-08	12
273	2008-04-08	12
273	2008-04-08	12
273	2008-04-08	12
273	2008-04-08	12
274	2008-04-08	12
275	2008-04-08	12
277	2008-04-08	12
277	2008-04-08	12
277	2008-04-08	12
277	2008-04-08	12
277	2008-04-08	12
277	2008-04-08	12
277	2008-04-08	12
277	2008-04-08	12
277	2008-04-08	12
277	2008-04-08	12
277	2008-04-08	12
277	2008-04-08	12
277	2008-04-08	12
277	2008-04-08	12
277	2008-04-08	12
277	2008-04-08	12
278	2008-04-08	12
278	2008-04-08	12
278	2008-04-08	12
278	2008-04-08	12
280	2008-04-08	12
280	2008-04-08	12
280	2008-04-08	12
280	2008-04-08	12
281	2008-04-08	12
281	2008-04-08	12
281	2008-04-08	12
281	2008-04-08	12
282	2008-04-08	12
282	2008-04-08	12
282	2008-04-08	12
282	2008-04-08	12
283	2008-04-08	12
284	2008-04-08	12
285	2008-04-08	12
286	2008-04-08	12
287	2008-04-08	12
288	2008-04-08	12
288	2008-04-08	12
288	2008-04-08	12
288	2008-04-08	12
289	2008-04-08	12
291	2008-04-08	12
292	2008-04-08	12
296	2008-04-08	12
298	2008-04-08	12
298	2008-04-08	12
298	2008-04-08	12
298	2008-04-08	12
298	2008-04-08	12
298	2008-04-08	12
298	2008-04-08	12
298	2008-04-08	12
298	2008-04-08	12
val_302
val_305
val_306
val_307
val_307
val_307
val_307
val_308
val_309
val_309
val_309
val_309
val_310
val_311
val_311
val_311
val_311
val_311
val_311
val_311
val_311
val_311
val_315
val_316
val_316
val_316
val_316
val_316
val_316
val_316
val_316
val_316
val_317
val_317
val_317
val_317
val_318
val_318
val_318
val_318
val_318
val_318
val_318
val_318
val_318
val_321
val_321
val_321
val_321
val_322
val_322
val_322
val_322
val_323
val_325
val_325
val_325
val_325
val_327
val_327
val_327
val_327
val_327
val_327
val_327
val_327
val_327
val_331
val_331
val_331
val_331
val_332
val_333
val_333
val_333
val_333
val_335
val_336
val_338
val_339
val_341
val_342
val_342
val_342
val_342
val_344
val_344
val_344
val_344
val_345
val_348
val_348
val_348
val_348
val_348
val_348
val_348
val_348
val_348
val_348
val_348
val_348
val_348
val_348
val_348
val_348
val_348
val_348
val_348
val_348
val_348
val_348
val_348
val_348
val_348
val_351
val_353
val_353
val_353
val_353
val_356
val_360
val_362
val_364
val_365
val_366
val_367
val_367
val_367
val_367
val_368
val_369
val_369
val_369
val_369
val_369
val_369
val_369
val_369
val_369
val_373
val_374
val_375
val_377
val_378
val_379
val_382
val_382
val_382
val_382
val_384
val_384
val_384
val_384
val_384
val_384
val_384
val_384
val_384
val_386
val_389
val_392
val_393
val_394
val_395
val_395
val_395
val_395
val_396
val_396
val_396
val_396
val_396
val_396
val_396
val_396
val_396
val_397
val_397
val_397
val_397
val_399
val_399
val_399
val_399
val_400
val_401
val_401
val_401
val_401
val_401
val_401
val_401
val_401
val_401
val_401
val_401
val_401
val_401
val_401
val_401
val_401
val_401
val_401
val_401
val_401
val_401
val_401
val_401
val_401
val_401
val_402
val_403
val_403
val_403
val_403
val_403
val_403
val_403
val_403
val_403
val_404
val_404
val_404
val_404
val_406
val_406
val_406
val_406
val_406
val_406
val_406
val_406
val_406
val_406
val_406
val_406
val_406
val_406
val_406
val_406
val_407
val_409
val_409
val_409
val_409
val_409
val_409
val_409
val_409
val_409
val_411
val_413
val_413
val_413
val_413
val_414
val_414
val_414
val_414
val_417
val_417
val_417
val_417
val_417
val_417
val_417
val_417
val_417
val_418
val_419
val_421
val_424
val_424
val_424
val_424
val_427
val_429
val_429
val_429
val_429
val_430
val_430
val_430
val_430
val_430
val_430
val_430
val_430
val_430
val_431
val_431
val_431
val_431
val_431
val_431
val_431
val_431
val_431
val_432
val_435
val_436
val_437
val_438
val_438
val_438
val_438
val_438
val_438
val_438
val_438
val_438
val_439
val_439
val_439
val_439
val_443
val_444
val_446
val_448
val_449
val_452
val_453
val_454
val_454
val_454
val_454
val_454
val_454
val_454
val_454
val_454
val_455
val_457
val_458
val_458
val_458
val_458
val_459
val_459
val_459
val_459
val_460
val_462
val_462
val_462
val_462
val_463
val_463
val_463
val_463
val_466
val_466
val_466
val_466
val_466
val_466
val_466
val_466
val_466
val_467
val_468
val_468
val_468
val_468
val_468
val_468
val_468
val_468
val_468
val_468
val_468
val_468
val_468
val_468
val_468
val_468
val_469
val_469
val_469
val_469
val_469
val_469
val_469
val_469
val_469
val_469
val_469
val_469
val_469
val_469
val_469
val_469
val_469
val_469
val_469
val_469
val_469
val_469
val_469
val_469
val_469
val_470
val_472
val_475
val_477
val_478
val_478
val_478
val_478
val_479
val_480
val_480
val_480
val_480
val_480
val_480
val_480
val_480
val_480
val_481
val_482
val_483
val_484
val_485
val_487
val_489
val_489
val_489
val_489
val_489
val_489
val_489
val_489
val_489
val_489
val_489
val_489
val_489
val_489
val_489
val_489
val_490
val_491
val_492
val_492
val_492
val_492
val_493
val_494
val_495
val_496
val_497
val_498
val_498
val_498
val_498
val_498
val_498
val_498
val_498
val_498
PREHOOK: query: EXPLAIN
FROM src a JOIN src b ON (a.key = b.key)
INSERT OVERWRITE TABLE mi1 SELECT a.* WHERE a.key < 100
INSERT OVERWRITE TABLE mi2 SELECT a.key, a.value WHERE a.key >= 100 and a.key < 200
INSERT OVERWRITE TABLE mi3 PARTITION(ds='2008-04-08', hr='12') SELECT a.key WHERE a.key >= 200 and a.key < 300
INSERT OVERWRITE DIRECTORY '../build/ql/test/data/warehouse/mi4.out' SELECT a.value WHERE a.key >= 300
PREHOOK: type: QUERY
POSTHOOK: query: EXPLAIN
FROM src a JOIN src b ON (a.key = b.key)
INSERT OVERWRITE TABLE mi1 SELECT a.* WHERE a.key < 100
INSERT OVERWRITE TABLE mi2 SELECT a.key, a.value WHERE a.key >= 100 and a.key < 200
INSERT OVERWRITE TABLE mi3 PARTITION(ds='2008-04-08', hr='12') SELECT a.key WHERE a.key >= 200 and a.key < 300
INSERT OVERWRITE DIRECTORY '../build/ql/test/data/warehouse/mi4.out' SELECT a.value WHERE a.key >= 300
POSTHOOK: type: QUERY
POSTHOOK: Lineage: mi1.key EXPRESSION [(src)a.FieldSchema(name:key, type:string, comment:default), ]
POSTHOOK: Lineage: mi1.value SIMPLE [(src)a.FieldSchema(name:value, type:string, comment:default), ]
POSTHOOK: Lineage: mi2.key EXPRESSION [(src)a.FieldSchema(name:key, type:string, comment:default), ]
POSTHOOK: Lineage: mi2.value SIMPLE [(src)a.FieldSchema(name:value, type:string, comment:default), ]
POSTHOOK: Lineage: mi3 PARTITION(ds=2008-04-08,hr=12).key EXPRESSION [(src)a.FieldSchema(name:key, type:string, comment:default), ]
ABSTRACT SYNTAX TREE:
  (TOK_QUERY (TOK_FROM (TOK_JOIN (TOK_TABREF (TOK_TABNAME src) a) (TOK_TABREF (TOK_TABNAME src) b) (= (. (TOK_TABLE_OR_COL a) key) (. (TOK_TABLE_OR_COL b) key)))) (TOK_INSERT (TOK_DESTINATION (TOK_TAB (TOK_TABNAME mi1))) (TOK_SELECT (TOK_SELEXPR (TOK_ALLCOLREF (TOK_TABNAME a)))) (TOK_WHERE (< (. (TOK_TABLE_OR_COL a) key) 100))) (TOK_INSERT (TOK_DESTINATION (TOK_TAB (TOK_TABNAME mi2))) (TOK_SELECT (TOK_SELEXPR (. (TOK_TABLE_OR_COL a) key)) (TOK_SELEXPR (. (TOK_TABLE_OR_COL a) value))) (TOK_WHERE (and (>= (. (TOK_TABLE_OR_COL a) key) 100) (< (. (TOK_TABLE_OR_COL a) key) 200)))) (TOK_INSERT (TOK_DESTINATION (TOK_TAB (TOK_TABNAME mi3) (TOK_PARTSPEC (TOK_PARTVAL ds '2008-04-08') (TOK_PARTVAL hr '12')))) (TOK_SELECT (TOK_SELEXPR (. (TOK_TABLE_OR_COL a) key))) (TOK_WHERE (and (>= (. (TOK_TABLE_OR_COL a) key) 200) (< (. (TOK_TABLE_OR_COL a) key) 300)))) (TOK_INSERT (TOK_DESTINATION (TOK_DIR '../build/ql/test/data/warehouse/mi4.out')) (TOK_SELECT (TOK_SELEXPR (. (TOK_TABLE_OR_COL a) value))) (TOK_WHERE (>= (. (TOK_TABLE_OR_COL a) key) 300))))

STAGE DEPENDENCIES:
  Stage-4 is a root stage
  Stage-0 depends on stages: Stage-4
  Stage-5 depends on stages: Stage-0
  Stage-1 depends on stages: Stage-4
  Stage-6 depends on stages: Stage-1
  Stage-2 depends on stages: Stage-4
  Stage-7 depends on stages: Stage-2
  Stage-3 depends on stages: Stage-4

STAGE PLANS:
  Stage: Stage-4
    Map Reduce
      Alias -> Map Operator Tree:
        a 
          TableScan
            alias: a
            Reduce Output Operator
              key expressions:
                    expr: key
                    type: string
              sort order: +
              Map-reduce partition columns:
                    expr: key
                    type: string
              tag: 0
              value expressions:
                    expr: key
                    type: string
                    expr: value
                    type: string
        b 
          TableScan
            alias: b
            Reduce Output Operator
              key expressions:
                    expr: key
                    type: string
              sort order: +
              Map-reduce partition columns:
                    expr: key
                    type: string
              tag: 1
      Reduce Operator Tree:
        Join Operator
          condition map:
               Inner Join 0 to 1
          condition expressions:
            0 {VALUE._col0} {VALUE._col1}
            1 
          handleSkewJoin: false
          outputColumnNames: _col0, _col1
          Filter Operator
            predicate:
                expr: (_col0 < 100)
                type: boolean
            Select Operator
              expressions:
                    expr: UDFToInteger(_col0)
                    type: int
                    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
                    serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
                    name: default.mi1
          Filter Operator
            predicate:
                expr: ((_col0 >= 100) and (_col0 < 200))
                type: boolean
            Select Operator
              expressions:
                    expr: UDFToInteger(_col0)
                    type: int
                    expr: _col1
                    type: string
              outputColumnNames: _col0, _col1
              File Output Operator
                compressed: false
                GlobalTableId: 2
                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: default.mi2
          Filter Operator
            predicate:
                expr: ((_col0 >= 200) and (_col0 < 300))
                type: boolean
            Select Operator
              expressions:
                    expr: UDFToInteger(_col0)
                    type: int
              outputColumnNames: _col0
              File Output Operator
                compressed: false
                GlobalTableId: 3
                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: default.mi3
          Filter Operator
            predicate:
                expr: (_col0 >= 300)
                type: boolean
            Select Operator
              expressions:
                    expr: _col1
                    type: string
              outputColumnNames: _col0
              File Output Operator
                compressed: false
                GlobalTableId: 4
                table:
                    input format: org.apache.hadoop.mapred.TextInputFormat
                    output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat

  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: default.mi1

  Stage: Stage-5
    Stats-Aggr Operator

  Stage: Stage-1
    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: default.mi2

  Stage: Stage-6
    Stats-Aggr Operator

  Stage: Stage-2
    Move Operator
      tables:
          partition:
            ds 2008-04-08
            hr 12
          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: default.mi3

  Stage: Stage-7
    Stats-Aggr Operator

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


PREHOOK: query: FROM src a JOIN src b ON (a.key = b.key)
INSERT OVERWRITE TABLE mi1 SELECT a.* WHERE a.key < 100
INSERT OVERWRITE TABLE mi2 SELECT a.key, a.value WHERE a.key >= 100 and a.key < 200
INSERT OVERWRITE TABLE mi3 PARTITION(ds='2008-04-08', hr='12') SELECT a.key WHERE a.key >= 200 and a.key < 300
INSERT OVERWRITE DIRECTORY '../build/ql/test/data/warehouse/mi4.out' SELECT a.value WHERE a.key >= 300
PREHOOK: type: QUERY
PREHOOK: Input: default@src
PREHOOK: Output: ../build/ql/test/data/warehouse/mi4.out
PREHOOK: Output: default@mi1
PREHOOK: Output: default@mi2
PREHOOK: Output: default@mi3@ds=2008-04-08/hr=12
POSTHOOK: query: FROM src a JOIN src b ON (a.key = b.key)
INSERT OVERWRITE TABLE mi1 SELECT a.* WHERE a.key < 100
INSERT OVERWRITE TABLE mi2 SELECT a.key, a.value WHERE a.key >= 100 and a.key < 200
INSERT OVERWRITE TABLE mi3 PARTITION(ds='2008-04-08', hr='12') SELECT a.key WHERE a.key >= 200 and a.key < 300
INSERT OVERWRITE DIRECTORY '../build/ql/test/data/warehouse/mi4.out' SELECT a.value WHERE a.key >= 300
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src
POSTHOOK: Output: ../build/ql/test/data/warehouse/mi4.out
POSTHOOK: Output: default@mi1
POSTHOOK: Output: default@mi2
POSTHOOK: Output: default@mi3@ds=2008-04-08/hr=12
POSTHOOK: Lineage: mi1.key EXPRESSION [(src)a.FieldSchema(name:key, type:string, comment:default), ]
POSTHOOK: Lineage: mi1.key EXPRESSION [(src)a.FieldSchema(name:key, type:string, comment:default), ]
POSTHOOK: Lineage: mi1.value SIMPLE [(src)a.FieldSchema(name:value, type:string, comment:default), ]
POSTHOOK: Lineage: mi1.value SIMPLE [(src)a.FieldSchema(name:value, type:string, comment:default), ]
POSTHOOK: Lineage: mi2.key EXPRESSION [(src)a.FieldSchema(name:key, type:string, comment:default), ]
POSTHOOK: Lineage: mi2.key EXPRESSION [(src)a.FieldSchema(name:key, type:string, comment:default), ]
POSTHOOK: Lineage: mi2.value SIMPLE [(src)a.FieldSchema(name:value, type:string, comment:default), ]
POSTHOOK: Lineage: mi2.value SIMPLE [(src)a.FieldSchema(name:value, type:string, comment:default), ]
POSTHOOK: Lineage: mi3 PARTITION(ds=2008-04-08,hr=12).key EXPRESSION [(src)a.FieldSchema(name:key, type:string, comment:default), ]
POSTHOOK: Lineage: mi3 PARTITION(ds=2008-04-08,hr=12).key EXPRESSION [(src)a.FieldSchema(name:key, type:string, comment:default), ]
PREHOOK: query: SELECT mi1.* FROM mi1
PREHOOK: type: QUERY
PREHOOK: Input: default@mi1
#### A masked pattern was here ####
POSTHOOK: query: SELECT mi1.* FROM mi1
POSTHOOK: type: QUERY
POSTHOOK: Input: default@mi1
#### A masked pattern was here ####
POSTHOOK: Lineage: mi1.key EXPRESSION [(src)a.FieldSchema(name:key, type:string, comment:default), ]
POSTHOOK: Lineage: mi1.key EXPRESSION [(src)a.FieldSchema(name:key, type:string, comment:default), ]
POSTHOOK: Lineage: mi1.value SIMPLE [(src)a.FieldSchema(name:value, type:string, comment:default), ]
POSTHOOK: Lineage: mi1.value SIMPLE [(src)a.FieldSchema(name:value, type:string, comment:default), ]
POSTHOOK: Lineage: mi2.key EXPRESSION [(src)a.FieldSchema(name:key, type:string, comment:default), ]
POSTHOOK: Lineage: mi2.key EXPRESSION [(src)a.FieldSchema(name:key, type:string, comment:default), ]
POSTHOOK: Lineage: mi2.value SIMPLE [(src)a.FieldSchema(name:value, type:string, comment:default), ]
POSTHOOK: Lineage: mi2.value SIMPLE [(src)a.FieldSchema(name:value, type:string, comment:default), ]
POSTHOOK: Lineage: mi3 PARTITION(ds=2008-04-08,hr=12).key EXPRESSION [(src)a.FieldSchema(name:key, type:string, comment:default), ]
POSTHOOK: Lineage: mi3 PARTITION(ds=2008-04-08,hr=12).key EXPRESSION [(src)a.FieldSchema(name:key, type:string, comment:default), ]
0	val_0
0	val_0
0	val_0
0	val_0
0	val_0
0	val_0
0	val_0
0	val_0
0	val_0
10	val_10
11	val_11
12	val_12
12	val_12
12	val_12
12	val_12
15	val_15
15	val_15
15	val_15
15	val_15
17	val_17
18	val_18
18	val_18
18	val_18
18	val_18
19	val_19
2	val_2
20	val_20
24	val_24
24	val_24
24	val_24
24	val_24
26	val_26
26	val_26
26	val_26
26	val_26
27	val_27
28	val_28
30	val_30
33	val_33
34	val_34
35	val_35
35	val_35
35	val_35
35	val_35
35	val_35
35	val_35
35	val_35
35	val_35
35	val_35
37	val_37
37	val_37
37	val_37
37	val_37
4	val_4
41	val_41
42	val_42
42	val_42
42	val_42
42	val_42
43	val_43
44	val_44
47	val_47
5	val_5
5	val_5
5	val_5
5	val_5
5	val_5
5	val_5
5	val_5
5	val_5
5	val_5
51	val_51
51	val_51
51	val_51
51	val_51
53	val_53
54	val_54
57	val_57
58	val_58
58	val_58
58	val_58
58	val_58
64	val_64
65	val_65
66	val_66
67	val_67
67	val_67
67	val_67
67	val_67
69	val_69
70	val_70
70	val_70
70	val_70
70	val_70
70	val_70
70	val_70
70	val_70
70	val_70
70	val_70
72	val_72
72	val_72
72	val_72
72	val_72
74	val_74
76	val_76
76	val_76
76	val_76
76	val_76
77	val_77
78	val_78
8	val_8
80	val_80
82	val_82
83	val_83
83	val_83
83	val_83
83	val_83
84	val_84
84	val_84
84	val_84
84	val_84
85	val_85
86	val_86
87	val_87
9	val_9
90	val_90
90	val_90
90	val_90
90	val_90
90	val_90
90	val_90
90	val_90
90	val_90
90	val_90
92	val_92
95	val_95
95	val_95
95	val_95
95	val_95
96	val_96
97	val_97
97	val_97
97	val_97
97	val_97
98	val_98
98	val_98
98	val_98
98	val_98
PREHOOK: query: SELECT mi2.* FROM mi2
PREHOOK: type: QUERY
PREHOOK: Input: default@mi2
#### A masked pattern was here ####
POSTHOOK: query: SELECT mi2.* FROM mi2
POSTHOOK: type: QUERY
POSTHOOK: Input: default@mi2
#### A masked pattern was here ####
POSTHOOK: Lineage: mi1.key EXPRESSION [(src)a.FieldSchema(name:key, type:string, comment:default), ]
POSTHOOK: Lineage: mi1.key EXPRESSION [(src)a.FieldSchema(name:key, type:string, comment:default), ]
POSTHOOK: Lineage: mi1.value SIMPLE [(src)a.FieldSchema(name:value, type:string, comment:default), ]
POSTHOOK: Lineage: mi1.value SIMPLE [(src)a.FieldSchema(name:value, type:string, comment:default), ]
POSTHOOK: Lineage: mi2.key EXPRESSION [(src)a.FieldSchema(name:key, type:string, comment:default), ]
POSTHOOK: Lineage: mi2.key EXPRESSION [(src)a.FieldSchema(name:key, type:string, comment:default), ]
POSTHOOK: Lineage: mi2.value SIMPLE [(src)a.FieldSchema(name:value, type:string, comment:default), ]
POSTHOOK: Lineage: mi2.value SIMPLE [(src)a.FieldSchema(name:value, type:string, comment:default), ]
POSTHOOK: Lineage: mi3 PARTITION(ds=2008-04-08,hr=12).key EXPRESSION [(src)a.FieldSchema(name:key, type:string, comment:default), ]
POSTHOOK: Lineage: mi3 PARTITION(ds=2008-04-08,hr=12).key EXPRESSION [(src)a.FieldSchema(name:key, type:string, comment:default), ]
100	val_100
100	val_100
100	val_100
100	val_100
103	val_103
103	val_103
103	val_103
103	val_103
104	val_104
104	val_104
104	val_104
104	val_104
105	val_105
111	val_111
113	val_113
113	val_113
113	val_113
113	val_113
114	val_114
116	val_116
118	val_118
118	val_118
118	val_118
118	val_118
119	val_119
119	val_119
119	val_119
119	val_119
119	val_119
119	val_119
119	val_119
119	val_119
119	val_119
120	val_120
120	val_120
120	val_120
120	val_120
125	val_125
125	val_125
125	val_125
125	val_125
126	val_126
128	val_128
128	val_128
128	val_128
128	val_128
128	val_128
128	val_128
128	val_128
128	val_128
128	val_128
129	val_129
129	val_129
129	val_129
129	val_129
131	val_131
133	val_133
134	val_134
134	val_134
134	val_134
134	val_134
136	val_136
137	val_137
137	val_137
137	val_137
137	val_137
138	val_138
138	val_138
138	val_138
138	val_138
138	val_138
138	val_138
138	val_138
138	val_138
138	val_138
138	val_138
138	val_138
138	val_138
138	val_138
138	val_138
138	val_138
138	val_138
143	val_143
145	val_145
146	val_146
146	val_146
146	val_146
146	val_146
149	val_149
149	val_149
149	val_149
149	val_149
150	val_150
152	val_152
152	val_152
152	val_152
152	val_152
153	val_153
155	val_155
156	val_156
157	val_157
158	val_158
160	val_160
162	val_162
163	val_163
164	val_164
164	val_164
164	val_164
164	val_164
165	val_165
165	val_165
165	val_165
165	val_165
166	val_166
167	val_167
167	val_167
167	val_167
167	val_167
167	val_167
167	val_167
167	val_167
167	val_167
167	val_167
168	val_168
169	val_169
169	val_169
169	val_169
169	val_169
169	val_169
169	val_169
169	val_169
169	val_169
169	val_169
169	val_169
169	val_169
169	val_169
169	val_169
169	val_169
169	val_169
169	val_169
170	val_170
172	val_172
172	val_172
172	val_172
172	val_172
174	val_174
174	val_174
174	val_174
174	val_174
175	val_175
175	val_175
175	val_175
175	val_175
176	val_176
176	val_176
176	val_176
176	val_176
177	val_177
178	val_178
179	val_179
179	val_179
179	val_179
179	val_179
180	val_180
181	val_181
183	val_183
186	val_186
187	val_187
187	val_187
187	val_187
187	val_187
187	val_187
187	val_187
187	val_187
187	val_187
187	val_187
189	val_189
190	val_190
191	val_191
191	val_191
191	val_191
191	val_191
192	val_192
193	val_193
193	val_193
193	val_193
193	val_193
193	val_193
193	val_193
193	val_193
193	val_193
193	val_193
194	val_194
195	val_195
195	val_195
195	val_195
195	val_195
196	val_196
197	val_197
197	val_197
197	val_197
197	val_197
199	val_199
199	val_199
199	val_199
199	val_199
199	val_199
199	val_199
199	val_199
199	val_199
199	val_199
PREHOOK: query: SELECT mi3.* FROM mi3
PREHOOK: type: QUERY
PREHOOK: Input: default@mi3
PREHOOK: Input: default@mi3@ds=2008-04-08/hr=12
#### A masked pattern was here ####
POSTHOOK: query: SELECT mi3.* FROM mi3
POSTHOOK: type: QUERY
POSTHOOK: Input: default@mi3
POSTHOOK: Input: default@mi3@ds=2008-04-08/hr=12
#### A masked pattern was here ####
POSTHOOK: Lineage: mi1.key EXPRESSION [(src)a.FieldSchema(name:key, type:string, comment:default), ]
POSTHOOK: Lineage: mi1.key EXPRESSION [(src)a.FieldSchema(name:key, type:string, comment:default), ]
POSTHOOK: Lineage: mi1.value SIMPLE [(src)a.FieldSchema(name:value, type:string, comment:default), ]
POSTHOOK: Lineage: mi1.value SIMPLE [(src)a.FieldSchema(name:value, type:string, comment:default), ]
POSTHOOK: Lineage: mi2.key EXPRESSION [(src)a.FieldSchema(name:key, type:string, comment:default), ]
POSTHOOK: Lineage: mi2.key EXPRESSION [(src)a.FieldSchema(name:key, type:string, comment:default), ]
POSTHOOK: Lineage: mi2.value SIMPLE [(src)a.FieldSchema(name:value, type:string, comment:default), ]
POSTHOOK: Lineage: mi2.value SIMPLE [(src)a.FieldSchema(name:value, type:string, comment:default), ]
POSTHOOK: Lineage: mi3 PARTITION(ds=2008-04-08,hr=12).key EXPRESSION [(src)a.FieldSchema(name:key, type:string, comment:default), ]
POSTHOOK: Lineage: mi3 PARTITION(ds=2008-04-08,hr=12).key EXPRESSION [(src)a.FieldSchema(name:key, type:string, comment:default), ]
200	2008-04-08	12
200	2008-04-08	12
200	2008-04-08	12
200	2008-04-08	12
201	2008-04-08	12
202	2008-04-08	12
203	2008-04-08	12
203	2008-04-08	12
203	2008-04-08	12
203	2008-04-08	12
205	2008-04-08	12
205	2008-04-08	12
205	2008-04-08	12
205	2008-04-08	12
207	2008-04-08	12
207	2008-04-08	12
207	2008-04-08	12
207	2008-04-08	12
208	2008-04-08	12
208	2008-04-08	12
208	2008-04-08	12
208	2008-04-08	12
208	2008-04-08	12
208	2008-04-08	12
208	2008-04-08	12
208	2008-04-08	12
208	2008-04-08	12
209	2008-04-08	12
209	2008-04-08	12
209	2008-04-08	12
209	2008-04-08	12
213	2008-04-08	12
213	2008-04-08	12
213	2008-04-08	12
213	2008-04-08	12
214	2008-04-08	12
216	2008-04-08	12
216	2008-04-08	12
216	2008-04-08	12
216	2008-04-08	12
217	2008-04-08	12
217	2008-04-08	12
217	2008-04-08	12
217	2008-04-08	12
218	2008-04-08	12
219	2008-04-08	12
219	2008-04-08	12
219	2008-04-08	12
219	2008-04-08	12
221	2008-04-08	12
221	2008-04-08	12
221	2008-04-08	12
221	2008-04-08	12
222	2008-04-08	12
223	2008-04-08	12
223	2008-04-08	12
223	2008-04-08	12
223	2008-04-08	12
224	2008-04-08	12
224	2008-04-08	12
224	2008-04-08	12
224	2008-04-08	12
226	2008-04-08	12
228	2008-04-08	12
229	2008-04-08	12
229	2008-04-08	12
229	2008-04-08	12
229	2008-04-08	12
230	2008-04-08	12
230	2008-04-08	12
230	2008-04-08	12
230	2008-04-08	12
230	2008-04-08	12
230	2008-04-08	12
230	2008-04-08	12
230	2008-04-08	12
230	2008-04-08	12
230	2008-04-08	12
230	2008-04-08	12
230	2008-04-08	12
230	2008-04-08	12
230	2008-04-08	12
230	2008-04-08	12
230	2008-04-08	12
230	2008-04-08	12
230	2008-04-08	12
230	2008-04-08	12
230	2008-04-08	12
230	2008-04-08	12
230	2008-04-08	12
230	2008-04-08	12
230	2008-04-08	12
230	2008-04-08	12
233	2008-04-08	12
233	2008-04-08	12
233	2008-04-08	12
233	2008-04-08	12
235	2008-04-08	12
237	2008-04-08	12
237	2008-04-08	12
237	2008-04-08	12
237	2008-04-08	12
238	2008-04-08	12
238	2008-04-08	12
238	2008-04-08	12
238	2008-04-08	12
239	2008-04-08	12
239	2008-04-08	12
239	2008-04-08	12
239	2008-04-08	12
241	2008-04-08	12
242	2008-04-08	12
242	2008-04-08	12
242	2008-04-08	12
242	2008-04-08	12
244	2008-04-08	12
247	2008-04-08	12
248	2008-04-08	12
249	2008-04-08	12
252	2008-04-08	12
255	2008-04-08	12
255	2008-04-08	12
255	2008-04-08	12
255	2008-04-08	12
256	2008-04-08	12
256	2008-04-08	12
256	2008-04-08	12
256	2008-04-08	12
257	2008-04-08	12
258	2008-04-08	12
260	2008-04-08	12
262	2008-04-08	12
263	2008-04-08	12
265	2008-04-08	12
265	2008-04-08	12
265	2008-04-08	12
265	2008-04-08	12
266	2008-04-08	12
272	2008-04-08	12
272	2008-04-08	12
272	2008-04-08	12
272	2008-04-08	12
273	2008-04-08	12
273	2008-04-08	12
273	2008-04-08	12
273	2008-04-08	12
273	2008-04-08	12
273	2008-04-08	12
273	2008-04-08	12
273	2008-04-08	12
273	2008-04-08	12
274	2008-04-08	12
275	2008-04-08	12
277	2008-04-08	12
277	2008-04-08	12
277	2008-04-08	12
277	2008-04-08	12
277	2008-04-08	12
277	2008-04-08	12
277	2008-04-08	12
277	2008-04-08	12
277	2008-04-08	12
277	2008-04-08	12
277	2008-04-08	12
277	2008-04-08	12
277	2008-04-08	12
277	2008-04-08	12
277	2008-04-08	12
277	2008-04-08	12
278	2008-04-08	12
278	2008-04-08	12
278	2008-04-08	12
278	2008-04-08	12
280	2008-04-08	12
280	2008-04-08	12
280	2008-04-08	12
280	2008-04-08	12
281	2008-04-08	12
281	2008-04-08	12
281	2008-04-08	12
281	2008-04-08	12
282	2008-04-08	12
282	2008-04-08	12
282	2008-04-08	12
282	2008-04-08	12
283	2008-04-08	12
284	2008-04-08	12
285	2008-04-08	12
286	2008-04-08	12
287	2008-04-08	12
288	2008-04-08	12
288	2008-04-08	12
288	2008-04-08	12
288	2008-04-08	12
289	2008-04-08	12
291	2008-04-08	12
292	2008-04-08	12
296	2008-04-08	12
298	2008-04-08	12
298	2008-04-08	12
298	2008-04-08	12
298	2008-04-08	12
298	2008-04-08	12
298	2008-04-08	12
298	2008-04-08	12
298	2008-04-08	12
298	2008-04-08	12
val_302
val_305
val_306
val_307
val_307
val_307
val_307
val_308
val_309
val_309
val_309
val_309
val_310
val_311
val_311
val_311
val_311
val_311
val_311
val_311
val_311
val_311
val_315
val_316
val_316
val_316
val_316
val_316
val_316
val_316
val_316
val_316
val_317
val_317
val_317
val_317
val_318
val_318
val_318
val_318
val_318
val_318
val_318
val_318
val_318
val_321
val_321
val_321
val_321
val_322
val_322
val_322
val_322
val_323
val_325
val_325
val_325
val_325
val_327
val_327
val_327
val_327
val_327
val_327
val_327
val_327
val_327
val_331
val_331
val_331
val_331
val_332
val_333
val_333
val_333
val_333
val_335
val_336
val_338
val_339
val_341
val_342
val_342
val_342
val_342
val_344
val_344
val_344
val_344
val_345
val_348
val_348
val_348
val_348
val_348
val_348
val_348
val_348
val_348
val_348
val_348
val_348
val_348
val_348
val_348
val_348
val_348
val_348
val_348
val_348
val_348
val_348
val_348
val_348
val_348
val_351
val_353
val_353
val_353
val_353
val_356
val_360
val_362
val_364
val_365
val_366
val_367
val_367
val_367
val_367
val_368
val_369
val_369
val_369
val_369
val_369
val_369
val_369
val_369
val_369
val_373
val_374
val_375
val_377
val_378
val_379
val_382
val_382
val_382
val_382
val_384
val_384
val_384
val_384
val_384
val_384
val_384
val_384
val_384
val_386
val_389
val_392
val_393
val_394
val_395
val_395
val_395
val_395
val_396
val_396
val_396
val_396
val_396
val_396
val_396
val_396
val_396
val_397
val_397
val_397
val_397
val_399
val_399
val_399
val_399
val_400
val_401
val_401
val_401
val_401
val_401
val_401
val_401
val_401
val_401
val_401
val_401
val_401
val_401
val_401
val_401
val_401
val_401
val_401
val_401
val_401
val_401
val_401
val_401
val_401
val_401
val_402
val_403
val_403
val_403
val_403
val_403
val_403
val_403
val_403
val_403
val_404
val_404
val_404
val_404
val_406
val_406
val_406
val_406
val_406
val_406
val_406
val_406
val_406
val_406
val_406
val_406
val_406
val_406
val_406
val_406
val_407
val_409
val_409
val_409
val_409
val_409
val_409
val_409
val_409
val_409
val_411
val_413
val_413
val_413
val_413
val_414
val_414
val_414
val_414
val_417
val_417
val_417
val_417
val_417
val_417
val_417
val_417
val_417
val_418
val_419
val_421
val_424
val_424
val_424
val_424
val_427
val_429
val_429
val_429
val_429
val_430
val_430
val_430
val_430
val_430
val_430
val_430
val_430
val_430
val_431
val_431
val_431
val_431
val_431
val_431
val_431
val_431
val_431
val_432
val_435
val_436
val_437
val_438
val_438
val_438
val_438
val_438
val_438
val_438
val_438
val_438
val_439
val_439
val_439
val_439
val_443
val_444
val_446
val_448
val_449
val_452
val_453
val_454
val_454
val_454
val_454
val_454
val_454
val_454
val_454
val_454
val_455
val_457
val_458
val_458
val_458
val_458
val_459
val_459
val_459
val_459
val_460
val_462
val_462
val_462
val_462
val_463
val_463
val_463
val_463
val_466
val_466
val_466
val_466
val_466
val_466
val_466
val_466
val_466
val_467
val_468
val_468
val_468
val_468
val_468
val_468
val_468
val_468
val_468
val_468
val_468
val_468
val_468
val_468
val_468
val_468
val_469
val_469
val_469
val_469
val_469
val_469
val_469
val_469
val_469
val_469
val_469
val_469
val_469
val_469
val_469
val_469
val_469
val_469
val_469
val_469
val_469
val_469
val_469
val_469
val_469
val_470
val_472
val_475
val_477
val_478
val_478
val_478
val_478
val_479
val_480
val_480
val_480
val_480
val_480
val_480
val_480
val_480
val_480
val_481
val_482
val_483
val_484
val_485
val_487
val_489
val_489
val_489
val_489
val_489
val_489
val_489
val_489
val_489
val_489
val_489
val_489
val_489
val_489
val_489
val_489
val_490
val_491
val_492
val_492
val_492
val_492
val_493
val_494
val_495
val_496
val_497
val_498
val_498
val_498
val_498
val_498
val_498
val_498
val_498
val_498