hadoop-hive-commits mailing list archives

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

Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/rand_partitionpruner1.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/rand_partitionpruner1.q.out?rev=894876&r1=894875&r2=894876&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/rand_partitionpruner1.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/rand_partitionpruner1.q.out Thu Dec 31 16:04:45 2009
@@ -33,7 +33,7 @@
                 File Output Operator
                   compressed: false
                   GlobalTableId: 0
-                  directory: file:/Users/heyongqiang/Documents/workspace/Hive-Test/build/ql/tmp/2004739619/10001
+                  directory: file:/data/users/jsichi/open/hive-trunk/build/ql/tmp/1281920331/10001
                   table:
                       input format: org.apache.hadoop.mapred.TextInputFormat
                       output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
@@ -43,10 +43,11 @@
                         columns.types string:string
       Needs Tagging: false
       Path -> Alias:
-        file:/Users/heyongqiang/Documents/workspace/Hive-Test/build/ql/test/data/warehouse/src [src]
+        file:/data/users/jsichi/open/hive-trunk/build/ql/test/data/warehouse/src [src]
       Path -> Partition:
-        file:/Users/heyongqiang/Documents/workspace/Hive-Test/build/ql/test/data/warehouse/src 
+        file:/data/users/jsichi/open/hive-trunk/build/ql/test/data/warehouse/src 
           Partition
+            base file name: src
             input format: org.apache.hadoop.mapred.TextInputFormat
             output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
             properties:
@@ -59,7 +60,8 @@
               serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
               file.inputformat org.apache.hadoop.mapred.TextInputFormat
               file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
-              location file:/Users/heyongqiang/Documents/workspace/Hive-Test/build/ql/test/data/warehouse/src
+              location file:/data/users/jsichi/open/hive-trunk/build/ql/test/data/warehouse/src
+              transient_lastDdlTime 1262137321
             serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
           
               input format: org.apache.hadoop.mapred.TextInputFormat
@@ -74,8 +76,8 @@
                 serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
                 file.inputformat org.apache.hadoop.mapred.TextInputFormat
                 file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
-                location file:/Users/heyongqiang/Documents/workspace/Hive-Test/build/ql/test/data/warehouse/src
-                transient_lastDdlTime 1258006469
+                location file:/data/users/jsichi/open/hive-trunk/build/ql/test/data/warehouse/src
+                transient_lastDdlTime 1262137321
               serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
               name: src
             name: src
@@ -88,11 +90,11 @@
 PREHOOK: query: select * from src where rand(1) < 0.1
 PREHOOK: type: QUERY
 PREHOOK: Input: default@src
-PREHOOK: Output: file:/Users/heyongqiang/Documents/workspace/Hive-Test/build/ql/tmp/1716777655/10000
+PREHOOK: Output: file:/data/users/jsichi/open/hive-trunk/build/ql/tmp/1343937738/10000
 POSTHOOK: query: select * from src where rand(1) < 0.1
 POSTHOOK: type: QUERY
 POSTHOOK: Input: default@src
-POSTHOOK: Output: file:/Users/heyongqiang/Documents/workspace/Hive-Test/build/ql/tmp/1716777655/10000
+POSTHOOK: Output: file:/data/users/jsichi/open/hive-trunk/build/ql/tmp/1343937738/10000
 409	val_409
 429	val_429
 209	val_209

Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/rand_partitionpruner2.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/rand_partitionpruner2.q.out?rev=894876&r1=894875&r2=894876&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/rand_partitionpruner2.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/rand_partitionpruner2.q.out Thu Dec 31 16:04:45 2009
@@ -51,7 +51,7 @@
                 File Output Operator
                   compressed: false
                   GlobalTableId: 1
-                  directory: file:/Users/heyongqiang/Documents/workspace/Hive-Test/build/ql/tmp/651324075/10002
+                  directory: file:/data/users/jsichi/open/hive-trunk/build/ql/tmp/708123735/10002
                   table:
                       input format: org.apache.hadoop.mapred.TextInputFormat
                       output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
@@ -65,17 +65,18 @@
                         serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
                         file.inputformat org.apache.hadoop.mapred.TextInputFormat
                         file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
-                        location file:/Users/heyongqiang/Documents/workspace/Hive-Test/build/ql/test/data/warehouse/tmptable
-                        transient_lastDdlTime 1258006480
+                        location file:/data/users/jsichi/open/hive-trunk/build/ql/test/data/warehouse/tmptable
+                        transient_lastDdlTime 1262137327
                       serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
                       name: tmptable
       Needs Tagging: false
       Path -> Alias:
-        file:/Users/heyongqiang/Documents/workspace/Hive-Test/build/ql/test/data/warehouse/srcpart/ds=2008-04-08/hr=11 [a]
-        file:/Users/heyongqiang/Documents/workspace/Hive-Test/build/ql/test/data/warehouse/srcpart/ds=2008-04-08/hr=12 [a]
+        file:/data/users/jsichi/open/hive-trunk/build/ql/test/data/warehouse/srcpart/ds=2008-04-08/hr=11 [a]
+        file:/data/users/jsichi/open/hive-trunk/build/ql/test/data/warehouse/srcpart/ds=2008-04-08/hr=12 [a]
       Path -> Partition:
-        file:/Users/heyongqiang/Documents/workspace/Hive-Test/build/ql/test/data/warehouse/srcpart/ds=2008-04-08/hr=11 
+        file:/data/users/jsichi/open/hive-trunk/build/ql/test/data/warehouse/srcpart/ds=2008-04-08/hr=11 
           Partition
+            base file name: hr=11
             input format: org.apache.hadoop.mapred.TextInputFormat
             output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
             partition values:
@@ -92,8 +93,8 @@
               serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
               file.inputformat org.apache.hadoop.mapred.TextInputFormat
               file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
-              location file:/Users/heyongqiang/Documents/workspace/Hive-Test/build/ql/test/data/warehouse/srcpart/ds=2008-04-08/hr=11
-              transient_lastDdlTime 1258006477
+              location file:/data/users/jsichi/open/hive-trunk/build/ql/test/data/warehouse/srcpart
+              transient_lastDdlTime 1262137325
             serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
           
               input format: org.apache.hadoop.mapred.TextInputFormat
@@ -109,13 +110,14 @@
                 serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
                 file.inputformat org.apache.hadoop.mapred.TextInputFormat
                 file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
-                location file:/Users/heyongqiang/Documents/workspace/Hive-Test/build/ql/test/data/warehouse/srcpart
-                transient_lastDdlTime 1258006477
+                location file:/data/users/jsichi/open/hive-trunk/build/ql/test/data/warehouse/srcpart
+                transient_lastDdlTime 1262137325
               serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
               name: srcpart
             name: srcpart
-        file:/Users/heyongqiang/Documents/workspace/Hive-Test/build/ql/test/data/warehouse/srcpart/ds=2008-04-08/hr=12 
+        file:/data/users/jsichi/open/hive-trunk/build/ql/test/data/warehouse/srcpart/ds=2008-04-08/hr=12 
           Partition
+            base file name: hr=12
             input format: org.apache.hadoop.mapred.TextInputFormat
             output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
             partition values:
@@ -132,8 +134,8 @@
               serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
               file.inputformat org.apache.hadoop.mapred.TextInputFormat
               file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
-              location file:/Users/heyongqiang/Documents/workspace/Hive-Test/build/ql/test/data/warehouse/srcpart/ds=2008-04-08/hr=12
-              transient_lastDdlTime 1258006477
+              location file:/data/users/jsichi/open/hive-trunk/build/ql/test/data/warehouse/srcpart
+              transient_lastDdlTime 1262137325
             serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
           
               input format: org.apache.hadoop.mapred.TextInputFormat
@@ -149,8 +151,8 @@
                 serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
                 file.inputformat org.apache.hadoop.mapred.TextInputFormat
                 file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
-                location file:/Users/heyongqiang/Documents/workspace/Hive-Test/build/ql/test/data/warehouse/srcpart
-                transient_lastDdlTime 1258006477
+                location file:/data/users/jsichi/open/hive-trunk/build/ql/test/data/warehouse/srcpart
+                transient_lastDdlTime 1262137325
               serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
               name: srcpart
             name: srcpart
@@ -161,11 +163,11 @@
           Move Operator
             files:
                 hdfs directory: true
-                source: file:/Users/heyongqiang/Documents/workspace/Hive-Test/build/ql/tmp/651324075/10002
-                destination: file:/Users/heyongqiang/Documents/workspace/Hive-Test/build/ql/tmp/795015032/10000
+                source: file:/data/users/jsichi/open/hive-trunk/build/ql/tmp/708123735/10002
+                destination: file:/data/users/jsichi/open/hive-trunk/build/ql/tmp/1978884338/10000
           Map Reduce
             Alias -> Map Operator Tree:
-              file:/Users/heyongqiang/Documents/workspace/Hive-Test/build/ql/tmp/651324075/10002 
+              file:/data/users/jsichi/open/hive-trunk/build/ql/tmp/708123735/10002 
                   Reduce Output Operator
                     sort order: 
                     Map-reduce partition columns:
@@ -183,10 +185,11 @@
                           type: string
             Needs Tagging: false
             Path -> Alias:
-              file:/Users/heyongqiang/Documents/workspace/Hive-Test/build/ql/tmp/651324075/10002 [file:/Users/heyongqiang/Documents/workspace/Hive-Test/build/ql/tmp/651324075/10002]
+              file:/data/users/jsichi/open/hive-trunk/build/ql/tmp/708123735/10002 [file:/data/users/jsichi/open/hive-trunk/build/ql/tmp/708123735/10002]
             Path -> Partition:
-              file:/Users/heyongqiang/Documents/workspace/Hive-Test/build/ql/tmp/651324075/10002 
+              file:/data/users/jsichi/open/hive-trunk/build/ql/tmp/708123735/10002 
                 Partition
+                  base file name: 10002
                   input format: org.apache.hadoop.mapred.TextInputFormat
                   output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
                   properties:
@@ -199,8 +202,8 @@
                     serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
                     file.inputformat org.apache.hadoop.mapred.TextInputFormat
                     file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
-                    location file:/Users/heyongqiang/Documents/workspace/Hive-Test/build/ql/test/data/warehouse/tmptable
-                    transient_lastDdlTime 1258006480
+                    location file:/data/users/jsichi/open/hive-trunk/build/ql/test/data/warehouse/tmptable
+                    transient_lastDdlTime 1262137327
                   serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
                 
                     input format: org.apache.hadoop.mapred.TextInputFormat
@@ -215,8 +218,8 @@
                       serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
                       file.inputformat org.apache.hadoop.mapred.TextInputFormat
                       file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
-                      location file:/Users/heyongqiang/Documents/workspace/Hive-Test/build/ql/test/data/warehouse/tmptable
-                      transient_lastDdlTime 1258006480
+                      location file:/data/users/jsichi/open/hive-trunk/build/ql/test/data/warehouse/tmptable
+                      transient_lastDdlTime 1262137327
                     serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
                     name: tmptable
                   name: tmptable
@@ -225,7 +228,7 @@
                 File Output Operator
                   compressed: false
                   GlobalTableId: 0
-                  directory: file:/Users/heyongqiang/Documents/workspace/Hive-Test/build/ql/tmp/795015032/10000
+                  directory: file:/data/users/jsichi/open/hive-trunk/build/ql/tmp/1978884338/10000
                   table:
                       input format: org.apache.hadoop.mapred.TextInputFormat
                       output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
@@ -238,9 +241,9 @@
                         bucket_count -1
                         serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
                         file.inputformat org.apache.hadoop.mapred.TextInputFormat
-                        location file:/Users/heyongqiang/Documents/workspace/Hive-Test/build/ql/test/data/warehouse/tmptable
+                        location file:/data/users/jsichi/open/hive-trunk/build/ql/test/data/warehouse/tmptable
                         file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
-                        transient_lastDdlTime 1258006480
+                        transient_lastDdlTime 1262137327
                       serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
                       name: tmptable
 
@@ -248,7 +251,7 @@
     Move Operator
       tables:
           replace: true
-          source: file:/Users/heyongqiang/Documents/workspace/Hive-Test/build/ql/tmp/795015032/10000
+          source: file:/data/users/jsichi/open/hive-trunk/build/ql/tmp/1978884338/10000
           table:
               input format: org.apache.hadoop.mapred.TextInputFormat
               output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
@@ -262,11 +265,11 @@
                 serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
                 file.inputformat org.apache.hadoop.mapred.TextInputFormat
                 file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
-                location file:/Users/heyongqiang/Documents/workspace/Hive-Test/build/ql/test/data/warehouse/tmptable
-                transient_lastDdlTime 1258006480
+                location file:/data/users/jsichi/open/hive-trunk/build/ql/test/data/warehouse/tmptable
+                transient_lastDdlTime 1262137327
               serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
               name: tmptable
-          tmp directory: file:/Users/heyongqiang/Documents/workspace/Hive-Test/build/ql/tmp/795015032/10001
+          tmp directory: file:/data/users/jsichi/open/hive-trunk/build/ql/tmp/1978884338/10001
 
 
 PREHOOK: query: insert overwrite table tmptable
@@ -284,11 +287,11 @@
 PREHOOK: query: select * from tmptable x sort by x.key,x.value,x.ds,x.hr
 PREHOOK: type: QUERY
 PREHOOK: Input: default@tmptable
-PREHOOK: Output: file:/Users/heyongqiang/Documents/workspace/Hive-Test/build/ql/tmp/1958926056/10000
+PREHOOK: Output: file:/data/users/jsichi/open/hive-trunk/build/ql/tmp/1574792529/10000
 POSTHOOK: query: select * from tmptable x sort by x.key,x.value,x.ds,x.hr
 POSTHOOK: type: QUERY
 POSTHOOK: Input: default@tmptable
-POSTHOOK: Output: file:/Users/heyongqiang/Documents/workspace/Hive-Test/build/ql/tmp/1958926056/10000
+POSTHOOK: Output: file:/data/users/jsichi/open/hive-trunk/build/ql/tmp/1574792529/10000
 103	val_103	2008-04-08	11
 103	val_103	2008-04-08	12
 133	val_133	2008-04-08	11

Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/rand_partitionpruner3.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/rand_partitionpruner3.q.out?rev=894876&r1=894875&r2=894876&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/rand_partitionpruner3.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/rand_partitionpruner3.q.out Thu Dec 31 16:04:45 2009
@@ -39,7 +39,7 @@
                 File Output Operator
                   compressed: false
                   GlobalTableId: 0
-                  directory: file:/Users/heyongqiang/Documents/workspace/Hive-Test/build/ql/tmp/780091764/10001
+                  directory: file:/data/users/jsichi/open/hive-trunk/build/ql/tmp/124088894/10001
                   table:
                       input format: org.apache.hadoop.mapred.TextInputFormat
                       output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
@@ -49,10 +49,11 @@
                         columns.types string:string:string:string
       Needs Tagging: false
       Path -> Alias:
-        file:/Users/heyongqiang/Documents/workspace/Hive-Test/build/ql/test/data/warehouse/srcpart/ds=2008-04-08/hr=12 [a]
+        file:/data/users/jsichi/open/hive-trunk/build/ql/test/data/warehouse/srcpart/ds=2008-04-08/hr=12 [a]
       Path -> Partition:
-        file:/Users/heyongqiang/Documents/workspace/Hive-Test/build/ql/test/data/warehouse/srcpart/ds=2008-04-08/hr=12 
+        file:/data/users/jsichi/open/hive-trunk/build/ql/test/data/warehouse/srcpart/ds=2008-04-08/hr=12 
           Partition
+            base file name: hr=12
             input format: org.apache.hadoop.mapred.TextInputFormat
             output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
             partition values:
@@ -69,8 +70,8 @@
               serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
               file.inputformat org.apache.hadoop.mapred.TextInputFormat
               file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
-              location file:/Users/heyongqiang/Documents/workspace/Hive-Test/build/ql/test/data/warehouse/srcpart/ds=2008-04-08/hr=12
-              transient_lastDdlTime 1258006498
+              location file:/data/users/jsichi/open/hive-trunk/build/ql/test/data/warehouse/srcpart
+              transient_lastDdlTime 1262137336
             serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
           
               input format: org.apache.hadoop.mapred.TextInputFormat
@@ -86,8 +87,8 @@
                 serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
                 file.inputformat org.apache.hadoop.mapred.TextInputFormat
                 file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
-                location file:/Users/heyongqiang/Documents/workspace/Hive-Test/build/ql/test/data/warehouse/srcpart
-                transient_lastDdlTime 1258006497
+                location file:/data/users/jsichi/open/hive-trunk/build/ql/test/data/warehouse/srcpart
+                transient_lastDdlTime 1262137336
               serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
               name: srcpart
             name: srcpart
@@ -100,11 +101,11 @@
 PREHOOK: query: select a.* from srcpart a where rand(1) < 0.1 and a.ds = '2008-04-08' and not(key > 50 or key < 10) and a.hr like '%2'
 PREHOOK: type: QUERY
 PREHOOK: Input: default@srcpart@ds=2008-04-08/hr=12
-PREHOOK: Output: file:/Users/heyongqiang/Documents/workspace/Hive-Test/build/ql/tmp/816468025/10000
+PREHOOK: Output: file:/data/users/jsichi/open/hive-trunk/build/ql/tmp/1944369228/10000
 POSTHOOK: query: select a.* from srcpart a where rand(1) < 0.1 and a.ds = '2008-04-08' and not(key > 50 or key < 10) and a.hr like '%2'
 POSTHOOK: type: QUERY
 POSTHOOK: Input: default@srcpart@ds=2008-04-08/hr=12
-POSTHOOK: Output: file:/Users/heyongqiang/Documents/workspace/Hive-Test/build/ql/tmp/816468025/10000
+POSTHOOK: Output: file:/data/users/jsichi/open/hive-trunk/build/ql/tmp/1944369228/10000
 42	val_42	2008-04-08	12
 44	val_44	2008-04-08	12
 26	val_26	2008-04-08	12
@@ -154,7 +155,7 @@
                   File Output Operator
                     compressed: false
                     GlobalTableId: 0
-                    directory: file:/Users/heyongqiang/Documents/workspace/Hive-Test/build/ql/tmp/1939062935/10001
+                    directory: file:/data/users/jsichi/open/hive-trunk/build/ql/tmp/1956461194/10001
                     table:
                         input format: org.apache.hadoop.mapred.TextInputFormat
                         output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
@@ -164,10 +165,11 @@
                           columns.types string:string:string:string
       Needs Tagging: false
       Path -> Alias:
-        file:/Users/heyongqiang/Documents/workspace/Hive-Test/build/ql/test/data/warehouse/srcpart/ds=2008-04-08/hr=12 [a]
+        file:/data/users/jsichi/open/hive-trunk/build/ql/test/data/warehouse/srcpart/ds=2008-04-08/hr=12 [a]
       Path -> Partition:
-        file:/Users/heyongqiang/Documents/workspace/Hive-Test/build/ql/test/data/warehouse/srcpart/ds=2008-04-08/hr=12 
+        file:/data/users/jsichi/open/hive-trunk/build/ql/test/data/warehouse/srcpart/ds=2008-04-08/hr=12 
           Partition
+            base file name: hr=12
             input format: org.apache.hadoop.mapred.TextInputFormat
             output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
             partition values:
@@ -184,8 +186,8 @@
               serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
               file.inputformat org.apache.hadoop.mapred.TextInputFormat
               file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
-              location file:/Users/heyongqiang/Documents/workspace/Hive-Test/build/ql/test/data/warehouse/srcpart/ds=2008-04-08/hr=12
-              transient_lastDdlTime 1258006498
+              location file:/data/users/jsichi/open/hive-trunk/build/ql/test/data/warehouse/srcpart
+              transient_lastDdlTime 1262137336
             serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
           
               input format: org.apache.hadoop.mapred.TextInputFormat
@@ -201,8 +203,8 @@
                 serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
                 file.inputformat org.apache.hadoop.mapred.TextInputFormat
                 file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
-                location file:/Users/heyongqiang/Documents/workspace/Hive-Test/build/ql/test/data/warehouse/srcpart
-                transient_lastDdlTime 1258006497
+                location file:/data/users/jsichi/open/hive-trunk/build/ql/test/data/warehouse/srcpart
+                transient_lastDdlTime 1262137336
               serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
               name: srcpart
             name: srcpart
@@ -215,11 +217,11 @@
 PREHOOK: query: select a.* from srcpart a where a.ds = '2008-04-08' and not(key > 50 or key < 10) and a.hr like '%2'
 PREHOOK: type: QUERY
 PREHOOK: Input: default@srcpart@ds=2008-04-08/hr=12
-PREHOOK: Output: file:/Users/heyongqiang/Documents/workspace/Hive-Test/build/ql/tmp/1002353747/10000
+PREHOOK: Output: file:/data/users/jsichi/open/hive-trunk/build/ql/tmp/1681163814/10000
 POSTHOOK: query: select a.* from srcpart a where a.ds = '2008-04-08' and not(key > 50 or key < 10) and a.hr like '%2'
 POSTHOOK: type: QUERY
 POSTHOOK: Input: default@srcpart@ds=2008-04-08/hr=12
-POSTHOOK: Output: file:/Users/heyongqiang/Documents/workspace/Hive-Test/build/ql/tmp/1002353747/10000
+POSTHOOK: Output: file:/data/users/jsichi/open/hive-trunk/build/ql/tmp/1681163814/10000
 27	val_27	2008-04-08	12
 37	val_37	2008-04-08	12
 15	val_15	2008-04-08	12

Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/regexp_extract.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/regexp_extract.q.out?rev=894876&r1=894875&r2=894876&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/regexp_extract.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/regexp_extract.q.out Thu Dec 31 16:04:45 2009
@@ -68,10 +68,11 @@
                         type: string
       Needs Tagging: false
       Path -> Alias:
-        file:/data/users/nzhang/work/870/apache-hive/build/ql/test/data/warehouse/src [tmap:src]
+        file:/data/users/jsichi/open/hive-trunk/build/ql/test/data/warehouse/src [tmap:src]
       Path -> Partition:
-        file:/data/users/nzhang/work/870/apache-hive/build/ql/test/data/warehouse/src 
+        file:/data/users/jsichi/open/hive-trunk/build/ql/test/data/warehouse/src 
           Partition
+            base file name: src
             input format: org.apache.hadoop.mapred.TextInputFormat
             output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
             properties:
@@ -84,8 +85,8 @@
               serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
               file.inputformat org.apache.hadoop.mapred.TextInputFormat
               file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
-              location file:/data/users/nzhang/work/870/apache-hive/build/ql/test/data/warehouse/src
-              transient_lastDdlTime 1261529841
+              location file:/data/users/jsichi/open/hive-trunk/build/ql/test/data/warehouse/src
+              transient_lastDdlTime 1262137436
             serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
           
               input format: org.apache.hadoop.mapred.TextInputFormat
@@ -100,8 +101,8 @@
                 serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
                 file.inputformat org.apache.hadoop.mapred.TextInputFormat
                 file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
-                location file:/data/users/nzhang/work/870/apache-hive/build/ql/test/data/warehouse/src
-                transient_lastDdlTime 1261529841
+                location file:/data/users/jsichi/open/hive-trunk/build/ql/test/data/warehouse/src
+                transient_lastDdlTime 1262137436
               serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
               name: src
             name: src
@@ -122,7 +123,7 @@
               File Output Operator
                 compressed: false
                 GlobalTableId: 0
-                directory: file:/data/users/nzhang/work/870/apache-hive/build/ql/tmp/1967522222/10001
+                directory: file:/data/users/jsichi/open/hive-trunk/build/ql/tmp/237484840/10001
                 table:
                     input format: org.apache.hadoop.mapred.TextInputFormat
                     output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
@@ -145,7 +146,7 @@
 SELECT tmap.key, regexp_extract(tmap.value, 'val_(\\d+\\t\\d+)',1) WHERE tmap.key < 100
 PREHOOK: type: QUERY
 PREHOOK: Input: default@src
-PREHOOK: Output: file:/data/users/nzhang/work/870/apache-hive/build/ql/tmp/1689304784/10000
+PREHOOK: Output: file:/data/users/jsichi/open/hive-trunk/build/ql/tmp/687662347/10000
 POSTHOOK: query: FROM (
   FROM src
   SELECT TRANSFORM(src.key, src.value, 1+2, 3+4)
@@ -155,7 +156,7 @@
 SELECT tmap.key, regexp_extract(tmap.value, 'val_(\\d+\\t\\d+)',1) WHERE tmap.key < 100
 POSTHOOK: type: QUERY
 POSTHOOK: Input: default@src
-POSTHOOK: Output: file:/data/users/nzhang/work/870/apache-hive/build/ql/tmp/1689304784/10000
+POSTHOOK: Output: file:/data/users/jsichi/open/hive-trunk/build/ql/tmp/687662347/10000
 0	0	3
 0	0	3
 0	0	3
@@ -310,10 +311,11 @@
                         type: string
       Needs Tagging: false
       Path -> Alias:
-        file:/data/users/nzhang/work/870/apache-hive/build/ql/test/data/warehouse/src [tmap:src]
+        file:/data/users/jsichi/open/hive-trunk/build/ql/test/data/warehouse/src [tmap:src]
       Path -> Partition:
-        file:/data/users/nzhang/work/870/apache-hive/build/ql/test/data/warehouse/src 
+        file:/data/users/jsichi/open/hive-trunk/build/ql/test/data/warehouse/src 
           Partition
+            base file name: src
             input format: org.apache.hadoop.mapred.TextInputFormat
             output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
             properties:
@@ -326,8 +328,8 @@
               serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
               file.inputformat org.apache.hadoop.mapred.TextInputFormat
               file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
-              location file:/data/users/nzhang/work/870/apache-hive/build/ql/test/data/warehouse/src
-              transient_lastDdlTime 1261529841
+              location file:/data/users/jsichi/open/hive-trunk/build/ql/test/data/warehouse/src
+              transient_lastDdlTime 1262137436
             serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
           
               input format: org.apache.hadoop.mapred.TextInputFormat
@@ -342,8 +344,8 @@
                 serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
                 file.inputformat org.apache.hadoop.mapred.TextInputFormat
                 file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
-                location file:/data/users/nzhang/work/870/apache-hive/build/ql/test/data/warehouse/src
-                transient_lastDdlTime 1261529841
+                location file:/data/users/jsichi/open/hive-trunk/build/ql/test/data/warehouse/src
+                transient_lastDdlTime 1262137436
               serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
               name: src
             name: src
@@ -364,7 +366,7 @@
               File Output Operator
                 compressed: false
                 GlobalTableId: 0
-                directory: file:/data/users/nzhang/work/870/apache-hive/build/ql/tmp/837479572/10001
+                directory: file:/data/users/jsichi/open/hive-trunk/build/ql/tmp/1239765305/10001
                 table:
                     input format: org.apache.hadoop.mapred.TextInputFormat
                     output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
@@ -387,7 +389,7 @@
 SELECT tmap.key, regexp_extract(tmap.value, 'val_(\\d+\\t\\d+)') WHERE tmap.key < 100
 PREHOOK: type: QUERY
 PREHOOK: Input: default@src
-PREHOOK: Output: file:/data/users/nzhang/work/870/apache-hive/build/ql/tmp/209947857/10000
+PREHOOK: Output: file:/data/users/jsichi/open/hive-trunk/build/ql/tmp/1514486187/10000
 POSTHOOK: query: FROM (
   FROM src
   SELECT TRANSFORM(src.key, src.value, 1+2, 3+4)
@@ -397,7 +399,7 @@
 SELECT tmap.key, regexp_extract(tmap.value, 'val_(\\d+\\t\\d+)') WHERE tmap.key < 100
 POSTHOOK: type: QUERY
 POSTHOOK: Input: default@src
-POSTHOOK: Output: file:/data/users/nzhang/work/870/apache-hive/build/ql/tmp/209947857/10000
+POSTHOOK: Output: file:/data/users/jsichi/open/hive-trunk/build/ql/tmp/1514486187/10000
 0	0	3
 0	0	3
 0	0	3



Mime
View raw message