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