PREHOOK: query: CREATE TABLE dest1(key STRING, value STRING) STORED AS TEXTFILE
PREHOOK: type: CREATETABLE
POSTHOOK: query: CREATE TABLE dest1(key STRING, value STRING) STORED AS TEXTFILE
POSTHOOK: type: CREATETABLE
POSTHOOK: Output: default@dest1
PREHOOK: query: EXPLAIN
FROM (
  FROM src
  SELECT TRANSFORM(src.key, src.value, 1+2, 3+4)
         USING 'cat'
) tmap
INSERT OVERWRITE TABLE dest1 SELECT tmap.key, tmap.value
PREHOOK: type: QUERY
POSTHOOK: query: EXPLAIN
FROM (
  FROM src
  SELECT TRANSFORM(src.key, src.value, 1+2, 3+4)
         USING 'cat'
) tmap
INSERT OVERWRITE TABLE dest1 SELECT tmap.key, tmap.value
POSTHOOK: type: QUERY
ABSTRACT SYNTAX TREE:
  (TOK_QUERY (TOK_FROM (TOK_SUBQUERY (TOK_QUERY (TOK_FROM (TOK_TABREF (TOK_TABNAME src))) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR (TOK_TRANSFORM (TOK_EXPLIST (. (TOK_TABLE_OR_COL src) key) (. (TOK_TABLE_OR_COL src) value) (+ 1 2) (+ 3 4)) TOK_SERDE TOK_RECORDWRITER 'cat' TOK_SERDE TOK_RECORDREADER))))) tmap)) (TOK_INSERT (TOK_DESTINATION (TOK_TAB (TOK_TABNAME dest1))) (TOK_SELECT (TOK_SELEXPR (. (TOK_TABLE_OR_COL tmap) key)) (TOK_SELEXPR (. (TOK_TABLE_OR_COL tmap) value)))))

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

STAGE PLANS:
  Stage: Stage-1
    Map Reduce
      Alias -> Map Operator Tree:
        tmap:src 
          TableScan
            alias: src
            Select Operator
              expressions:
                    expr: key
                    type: string
                    expr: value
                    type: string
                    expr: (1 + 2)
                    type: int
                    expr: (3 + 4)
                    type: int
              outputColumnNames: _col0, _col1, _col2, _col3
              Transform Operator
                command: cat
                output info:
                    input format: org.apache.hadoop.mapred.TextInputFormat
                    output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
                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
                        serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
                        name: default.dest1

  Stage: Stage-7
    Conditional Operator

  Stage: Stage-4
    Move Operator
      files:
          hdfs directory: true
#### A masked pattern was here ####

  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.dest1

  Stage: Stage-2
    Stats-Aggr Operator

  Stage: Stage-3
    Map Reduce
      Alias -> Map Operator Tree:
#### A masked pattern was here ####
            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: default.dest1

  Stage: Stage-5
    Map Reduce
      Alias -> Map Operator Tree:
#### A masked pattern was here ####
            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: default.dest1

  Stage: Stage-6
    Move Operator
      files:
          hdfs directory: true
#### A masked pattern was here ####


PREHOOK: query: FROM (
  FROM src
  SELECT TRANSFORM(src.key, src.value, 1+2, 3+4)
         USING 'cat'
) tmap
INSERT OVERWRITE TABLE dest1 SELECT tmap.key, tmap.value
PREHOOK: type: QUERY
PREHOOK: Input: default@src
PREHOOK: Output: default@dest1
POSTHOOK: query: FROM (
  FROM src
  SELECT TRANSFORM(src.key, src.value, 1+2, 3+4)
         USING 'cat'
) tmap
INSERT OVERWRITE TABLE dest1 SELECT tmap.key, tmap.value
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src
POSTHOOK: Output: default@dest1
POSTHOOK: Lineage: dest1.key SCRIPT [(src)src.FieldSchema(name:key, type:string, comment:default), (src)src.FieldSchema(name:value, type:string, comment:default), ]
POSTHOOK: Lineage: dest1.value SCRIPT [(src)src.FieldSchema(name:key, type:string, comment:default), (src)src.FieldSchema(name:value, type:string, comment:default), ]
PREHOOK: query: SELECT dest1.* FROM dest1
PREHOOK: type: QUERY
PREHOOK: Input: default@dest1
#### A masked pattern was here ####
POSTHOOK: query: SELECT dest1.* FROM dest1
POSTHOOK: type: QUERY
POSTHOOK: Input: default@dest1
#### A masked pattern was here ####
POSTHOOK: Lineage: dest1.key SCRIPT [(src)src.FieldSchema(name:key, type:string, comment:default), (src)src.FieldSchema(name:value, type:string, comment:default), ]
POSTHOOK: Lineage: dest1.value SCRIPT [(src)src.FieldSchema(name:key, type:string, comment:default), (src)src.FieldSchema(name:value, type:string, comment:default), ]
238	val_238	3	7
86	val_86	3	7
311	val_311	3	7
27	val_27	3	7
165	val_165	3	7
409	val_409	3	7
255	val_255	3	7
278	val_278	3	7
98	val_98	3	7
484	val_484	3	7
265	val_265	3	7
193	val_193	3	7
401	val_401	3	7
150	val_150	3	7
273	val_273	3	7
224	val_224	3	7
369	val_369	3	7
66	val_66	3	7
128	val_128	3	7
213	val_213	3	7
146	val_146	3	7
406	val_406	3	7
429	val_429	3	7
374	val_374	3	7
152	val_152	3	7
469	val_469	3	7
145	val_145	3	7
495	val_495	3	7
37	val_37	3	7
327	val_327	3	7
281	val_281	3	7
277	val_277	3	7
209	val_209	3	7
15	val_15	3	7
82	val_82	3	7
403	val_403	3	7
166	val_166	3	7
417	val_417	3	7
430	val_430	3	7
252	val_252	3	7
292	val_292	3	7
219	val_219	3	7
287	val_287	3	7
153	val_153	3	7
193	val_193	3	7
338	val_338	3	7
446	val_446	3	7
459	val_459	3	7
394	val_394	3	7
237	val_237	3	7
482	val_482	3	7
174	val_174	3	7
413	val_413	3	7
494	val_494	3	7
207	val_207	3	7
199	val_199	3	7
466	val_466	3	7
208	val_208	3	7
174	val_174	3	7
399	val_399	3	7
396	val_396	3	7
247	val_247	3	7
417	val_417	3	7
489	val_489	3	7
162	val_162	3	7
377	val_377	3	7
397	val_397	3	7
309	val_309	3	7
365	val_365	3	7
266	val_266	3	7
439	val_439	3	7
342	val_342	3	7
367	val_367	3	7
325	val_325	3	7
167	val_167	3	7
195	val_195	3	7
475	val_475	3	7
17	val_17	3	7
113	val_113	3	7
155	val_155	3	7
203	val_203	3	7
339	val_339	3	7
0	val_0	3	7
455	val_455	3	7
128	val_128	3	7
311	val_311	3	7
316	val_316	3	7
57	val_57	3	7
302	val_302	3	7
205	val_205	3	7
149	val_149	3	7
438	val_438	3	7
345	val_345	3	7
129	val_129	3	7
170	val_170	3	7
20	val_20	3	7
489	val_489	3	7
157	val_157	3	7
378	val_378	3	7
221	val_221	3	7
92	val_92	3	7
111	val_111	3	7
47	val_47	3	7
72	val_72	3	7
4	val_4	3	7
280	val_280	3	7
35	val_35	3	7
427	val_427	3	7
277	val_277	3	7
208	val_208	3	7
356	val_356	3	7
399	val_399	3	7
169	val_169	3	7
382	val_382	3	7
498	val_498	3	7
125	val_125	3	7
386	val_386	3	7
437	val_437	3	7
469	val_469	3	7
192	val_192	3	7
286	val_286	3	7
187	val_187	3	7
176	val_176	3	7
54	val_54	3	7
459	val_459	3	7
51	val_51	3	7
138	val_138	3	7
103	val_103	3	7
239	val_239	3	7
213	val_213	3	7
216	val_216	3	7
430	val_430	3	7
278	val_278	3	7
176	val_176	3	7
289	val_289	3	7
221	val_221	3	7
65	val_65	3	7
318	val_318	3	7
332	val_332	3	7
311	val_311	3	7
275	val_275	3	7
137	val_137	3	7
241	val_241	3	7
83	val_83	3	7
333	val_333	3	7
180	val_180	3	7
284	val_284	3	7
12	val_12	3	7
230	val_230	3	7
181	val_181	3	7
67	val_67	3	7
260	val_260	3	7
404	val_404	3	7
384	val_384	3	7
489	val_489	3	7
353	val_353	3	7
373	val_373	3	7
272	val_272	3	7
138	val_138	3	7
217	val_217	3	7
84	val_84	3	7
348	val_348	3	7
466	val_466	3	7
58	val_58	3	7
8	val_8	3	7
411	val_411	3	7
230	val_230	3	7
208	val_208	3	7
348	val_348	3	7
24	val_24	3	7
463	val_463	3	7
431	val_431	3	7
179	val_179	3	7
172	val_172	3	7
42	val_42	3	7
129	val_129	3	7
158	val_158	3	7
119	val_119	3	7
496	val_496	3	7
0	val_0	3	7
322	val_322	3	7
197	val_197	3	7
468	val_468	3	7
393	val_393	3	7
454	val_454	3	7
100	val_100	3	7
298	val_298	3	7
199	val_199	3	7
191	val_191	3	7
418	val_418	3	7
96	val_96	3	7
26	val_26	3	7
165	val_165	3	7
327	val_327	3	7
230	val_230	3	7
205	val_205	3	7
120	val_120	3	7
131	val_131	3	7
51	val_51	3	7
404	val_404	3	7
43	val_43	3	7
436	val_436	3	7
156	val_156	3	7
469	val_469	3	7
468	val_468	3	7
308	val_308	3	7
95	val_95	3	7
196	val_196	3	7
288	val_288	3	7
481	val_481	3	7
457	val_457	3	7
98	val_98	3	7
282	val_282	3	7
197	val_197	3	7
187	val_187	3	7
318	val_318	3	7
318	val_318	3	7
409	val_409	3	7
470	val_470	3	7
137	val_137	3	7
369	val_369	3	7
316	val_316	3	7
169	val_169	3	7
413	val_413	3	7
85	val_85	3	7
77	val_77	3	7
0	val_0	3	7
490	val_490	3	7
87	val_87	3	7
364	val_364	3	7
179	val_179	3	7
118	val_118	3	7
134	val_134	3	7
395	val_395	3	7
282	val_282	3	7
138	val_138	3	7
238	val_238	3	7
419	val_419	3	7
15	val_15	3	7
118	val_118	3	7
72	val_72	3	7
90	val_90	3	7
307	val_307	3	7
19	val_19	3	7
435	val_435	3	7
10	val_10	3	7
277	val_277	3	7
273	val_273	3	7
306	val_306	3	7
224	val_224	3	7
309	val_309	3	7
389	val_389	3	7
327	val_327	3	7
242	val_242	3	7
369	val_369	3	7
392	val_392	3	7
272	val_272	3	7
331	val_331	3	7
401	val_401	3	7
242	val_242	3	7
452	val_452	3	7
177	val_177	3	7
226	val_226	3	7
5	val_5	3	7
497	val_497	3	7
402	val_402	3	7
396	val_396	3	7
317	val_317	3	7
395	val_395	3	7
58	val_58	3	7
35	val_35	3	7
336	val_336	3	7
95	val_95	3	7
11	val_11	3	7
168	val_168	3	7
34	val_34	3	7
229	val_229	3	7
233	val_233	3	7
143	val_143	3	7
472	val_472	3	7
322	val_322	3	7
498	val_498	3	7
160	val_160	3	7
195	val_195	3	7
42	val_42	3	7
321	val_321	3	7
430	val_430	3	7
119	val_119	3	7
489	val_489	3	7
458	val_458	3	7
78	val_78	3	7
76	val_76	3	7
41	val_41	3	7
223	val_223	3	7
492	val_492	3	7
149	val_149	3	7
449	val_449	3	7
218	val_218	3	7
228	val_228	3	7
138	val_138	3	7
453	val_453	3	7
30	val_30	3	7
209	val_209	3	7
64	val_64	3	7
468	val_468	3	7
76	val_76	3	7
74	val_74	3	7
342	val_342	3	7
69	val_69	3	7
230	val_230	3	7
33	val_33	3	7
368	val_368	3	7
103	val_103	3	7
296	val_296	3	7
113	val_113	3	7
216	val_216	3	7
367	val_367	3	7
344	val_344	3	7
167	val_167	3	7
274	val_274	3	7
219	val_219	3	7
239	val_239	3	7
485	val_485	3	7
116	val_116	3	7
223	val_223	3	7
256	val_256	3	7
263	val_263	3	7
70	val_70	3	7
487	val_487	3	7
480	val_480	3	7
401	val_401	3	7
288	val_288	3	7
191	val_191	3	7
5	val_5	3	7
244	val_244	3	7
438	val_438	3	7
128	val_128	3	7
467	val_467	3	7
432	val_432	3	7
202	val_202	3	7
316	val_316	3	7
229	val_229	3	7
469	val_469	3	7
463	val_463	3	7
280	val_280	3	7
2	val_2	3	7
35	val_35	3	7
283	val_283	3	7
331	val_331	3	7
235	val_235	3	7
80	val_80	3	7
44	val_44	3	7
193	val_193	3	7
321	val_321	3	7
335	val_335	3	7
104	val_104	3	7
466	val_466	3	7
366	val_366	3	7
175	val_175	3	7
403	val_403	3	7
483	val_483	3	7
53	val_53	3	7
105	val_105	3	7
257	val_257	3	7
406	val_406	3	7
409	val_409	3	7
190	val_190	3	7
406	val_406	3	7
401	val_401	3	7
114	val_114	3	7
258	val_258	3	7
90	val_90	3	7
203	val_203	3	7
262	val_262	3	7
348	val_348	3	7
424	val_424	3	7
12	val_12	3	7
396	val_396	3	7
201	val_201	3	7
217	val_217	3	7
164	val_164	3	7
431	val_431	3	7
454	val_454	3	7
478	val_478	3	7
298	val_298	3	7
125	val_125	3	7
431	val_431	3	7
164	val_164	3	7
424	val_424	3	7
187	val_187	3	7
382	val_382	3	7
5	val_5	3	7
70	val_70	3	7
397	val_397	3	7
480	val_480	3	7
291	val_291	3	7
24	val_24	3	7
351	val_351	3	7
255	val_255	3	7
104	val_104	3	7
70	val_70	3	7
163	val_163	3	7
438	val_438	3	7
119	val_119	3	7
414	val_414	3	7
200	val_200	3	7
491	val_491	3	7
237	val_237	3	7
439	val_439	3	7
360	val_360	3	7
248	val_248	3	7
479	val_479	3	7
305	val_305	3	7
417	val_417	3	7
199	val_199	3	7
444	val_444	3	7
120	val_120	3	7
429	val_429	3	7
169	val_169	3	7
443	val_443	3	7
323	val_323	3	7
325	val_325	3	7
277	val_277	3	7
230	val_230	3	7
478	val_478	3	7
178	val_178	3	7
468	val_468	3	7
310	val_310	3	7
317	val_317	3	7
333	val_333	3	7
493	val_493	3	7
460	val_460	3	7
207	val_207	3	7
249	val_249	3	7
265	val_265	3	7
480	val_480	3	7
83	val_83	3	7
136	val_136	3	7
353	val_353	3	7
172	val_172	3	7
214	val_214	3	7
462	val_462	3	7
233	val_233	3	7
406	val_406	3	7
133	val_133	3	7
175	val_175	3	7
189	val_189	3	7
454	val_454	3	7
375	val_375	3	7
401	val_401	3	7
421	val_421	3	7
407	val_407	3	7
384	val_384	3	7
256	val_256	3	7
26	val_26	3	7
134	val_134	3	7
67	val_67	3	7
384	val_384	3	7
379	val_379	3	7
18	val_18	3	7
462	val_462	3	7
492	val_492	3	7
100	val_100	3	7
298	val_298	3	7
9	val_9	3	7
341	val_341	3	7
498	val_498	3	7
146	val_146	3	7
458	val_458	3	7
362	val_362	3	7
186	val_186	3	7
285	val_285	3	7
348	val_348	3	7
167	val_167	3	7
18	val_18	3	7
273	val_273	3	7
183	val_183	3	7
281	val_281	3	7
344	val_344	3	7
97	val_97	3	7
469	val_469	3	7
315	val_315	3	7
84	val_84	3	7
28	val_28	3	7
37	val_37	3	7
448	val_448	3	7
152	val_152	3	7
348	val_348	3	7
307	val_307	3	7
194	val_194	3	7
414	val_414	3	7
477	val_477	3	7
222	val_222	3	7
126	val_126	3	7
90	val_90	3	7
169	val_169	3	7
403	val_403	3	7
400	val_400	3	7
200	val_200	3	7
97	val_97	3	7