hadoop-common-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From dhr...@apache.org
Subject svn commit: r706704 [9/23] - in /hadoop/core/trunk: ./ src/contrib/hive/ src/contrib/hive/bin/ src/contrib/hive/cli/src/java/org/apache/hadoop/hive/cli/ src/contrib/hive/common/src/java/org/apache/hadoop/hive/conf/ src/contrib/hive/conf/ src/contrib/hi...
Date Tue, 21 Oct 2008 18:11:18 GMT
Modified: hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/sample4.q.out
URL: http://svn.apache.org/viewvc/hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/sample4.q.out?rev=706704&r1=706703&r2=706704&view=diff
==============================================================================
--- hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/sample4.q.out (original)
+++ hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/sample4.q.out Tue Oct 21 11:11:05 2008
@@ -8,32 +8,11 @@
 STAGE PLANS:
   Stage: Stage-1
     Map Reduce
-      Path -> Alias:
-        file:/data/zshao/trunk/VENDOR/hadoop-0.17/build/contrib/hive/ql/test/data/warehouse/srcbucket 
-      Path -> Partition:
-        file:/data/zshao/trunk/VENDOR/hadoop-0.17/build/contrib/hive/ql/test/data/warehouse/srcbucket 
-          Partition
-          
-              properties:
-                name srcbucket
-                bucket_field_name 
-                serialization.format 1
-                columns key,value
-                field_to_dimension 
-                bucket_count 2
-                serialization.lib simple_meta
-                file.inputformat org.apache.hadoop.mapred.TextInputFormat
-                file.outputformat org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
-                location file:/data/zshao/trunk/VENDOR/hadoop-0.17/build/contrib/hive/ql/test/data/warehouse/srcbucket
-              name: srcbucket
-              serde: simple_meta
-              input format: org.apache.hadoop.mapred.TextInputFormat
-              output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
       Alias -> Map Operator Tree:
         s 
             Filter Operator
               predicate:
-                  expr: (((default_sample_hashfn(key) & 2147483647) % 2) = 1)
+                  expr: (((default_sample_hashfn(key) & 2147483647) % 2) = 0)
                   type: Boolean
               Select Operator
                 expressions:
@@ -42,551 +21,563 @@
                       expr: value
                       type: string
                 File Output Operator
+                  directory: /tmp/hive-njain/594156852/317367185.10000.insclause-0
                   table:
+                      input format: org.apache.hadoop.mapred.TextInputFormat
+                      output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
                       properties:
                         name dest1
-                        bucket_field_name 
+                        serialization.ddl struct dest1 { i32 key, string value}
                         serialization.format 1
                         columns key,value
                         SORTBUCKETCOLSPREFIX TRUE
-                        field_to_dimension 
                         bucket_count -1
-                        serialization.lib simple_meta
+                        serialization.lib org.apache.hadoop.hive.serde2.MetadataTypedColumnsetSerDe
                         file.inputformat org.apache.hadoop.mapred.TextInputFormat
                         file.outputformat org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
-                        location file:/data/zshao/trunk/VENDOR/hadoop-0.17/build/contrib/hive/ql/test/data/warehouse/dest1
+                        location file:/home/njain/workspace/hadoop-0.17/build/contrib/hive/ql/test/data/warehouse/dest1
+                      serde: org.apache.hadoop.hive.serde2.MetadataTypedColumnsetSerDe
                       name: dest1
-                      serde: simple_meta
-                      input format: org.apache.hadoop.mapred.TextInputFormat
-                      output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
-                  directory: /tmp/hive-zshao/4031240.10000.insclause-0
       Needs Tagging:
+      Path -> Alias:
+        file:/home/njain/workspace/hadoop-0.17/build/contrib/hive/ql/test/data/warehouse/srcbucket 
+      Path -> Partition:
+        file:/home/njain/workspace/hadoop-0.17/build/contrib/hive/ql/test/data/warehouse/srcbucket 
+          Partition
+          
+              input format: org.apache.hadoop.mapred.TextInputFormat
+              output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
+              properties:
+                name srcbucket
+                serialization.ddl struct srcbucket { string key, string value}
+                serialization.format 1
+                columns key,value
+                bucket_count 2
+                serialization.lib org.apache.hadoop.hive.serde2.MetadataTypedColumnsetSerDe
+                file.inputformat org.apache.hadoop.mapred.TextInputFormat
+                file.outputformat org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
+                location file:/home/njain/workspace/hadoop-0.17/build/contrib/hive/ql/test/data/warehouse/srcbucket
+              serde: org.apache.hadoop.hive.serde2.MetadataTypedColumnsetSerDe
+              name: srcbucket
 
   Stage: Stage-0
     Move Operator
       tables:
+            replace:
+            source: /tmp/hive-njain/594156852/317367185.10000.insclause-0
             table:
+                input format: org.apache.hadoop.mapred.TextInputFormat
+                output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
                 properties:
                   name dest1
-                  bucket_field_name 
+                  serialization.ddl struct dest1 { i32 key, string value}
                   serialization.format 1
                   columns key,value
                   SORTBUCKETCOLSPREFIX TRUE
-                  field_to_dimension 
                   bucket_count -1
-                  serialization.lib simple_meta
+                  serialization.lib org.apache.hadoop.hive.serde2.MetadataTypedColumnsetSerDe
                   file.inputformat org.apache.hadoop.mapred.TextInputFormat
                   file.outputformat org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
-                  location file:/data/zshao/trunk/VENDOR/hadoop-0.17/build/contrib/hive/ql/test/data/warehouse/dest1
+                  location file:/home/njain/workspace/hadoop-0.17/build/contrib/hive/ql/test/data/warehouse/dest1
+                serde: org.apache.hadoop.hive.serde2.MetadataTypedColumnsetSerDe
                 name: dest1
-                serde: simple_meta
-                input format: org.apache.hadoop.mapred.TextInputFormat
-                output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
-            replace:
-            source: /tmp/hive-zshao/4031240.10000.insclause-0
-
-
-238	val_238
-311	val_311
-27	val_27
-409	val_409
-278	val_278
-98	val_98
-265	val_265
-193	val_193
-401	val_401
-128	val_128
-146	val_146
-429	val_429
-469	val_469
-281	val_281
-209	val_209
-403	val_403
-166	val_166
-430	val_430
-252	val_252
-292	val_292
-287	val_287
-153	val_153
-193	val_193
-494	val_494
-207	val_207
-199	val_199
-399	val_399
-247	val_247
-489	val_489
-162	val_162
-377	val_377
-397	val_397
-342	val_342
-195	val_195
-113	val_113
-155	val_155
-203	val_203
-339	val_339
-128	val_128
-311	val_311
-302	val_302
-205	val_205
-438	val_438
-489	val_489
-157	val_157
-221	val_221
-92	val_92
-111	val_111
-47	val_47
-72	val_72
-427	val_427
-399	val_399
-382	val_382
-498	val_498
-386	val_386
-469	val_469
-54	val_54
-216	val_216
-430	val_430
-278	val_278
-289	val_289
-221	val_221
-65	val_65
-311	val_311
-137	val_137
-241	val_241
-83	val_83
-333	val_333
-180	val_180
-12	val_12
-230	val_230
-67	val_67
-384	val_384
-489	val_489
-353	val_353
-373	val_373
-272	val_272
-348	val_348
-58	val_58
-230	val_230
-348	val_348
-463	val_463
-179	val_179
-119	val_119
-496	val_496
-322	val_322
-197	val_197
-393	val_393
-454	val_454
-100	val_100
-298	val_298
-199	val_199
-191	val_191
-418	val_418
-96	val_96
-230	val_230
-205	val_205
-120	val_120
-131	val_131
-43	val_43
-436	val_436
-469	val_469
-308	val_308
-481	val_481
-98	val_98
-197	val_197
-409	val_409
-470	val_470
-137	val_137
-85	val_85
-490	val_490
-87	val_87
-364	val_364
-179	val_179
-395	val_395
-238	val_238
-72	val_72
-90	val_90
-10	val_10
-306	val_306
-272	val_272
-331	val_331
-401	val_401
-452	val_452
-177	val_177
-5	val_5
-317	val_317
-395	val_395
-58	val_58
-168	val_168
-34	val_34
-229	val_229
-472	val_472
-322	val_322
-498	val_498
-160	val_160
-195	val_195
-430	val_430
-119	val_119
-489	val_489
-458	val_458
-78	val_78
-76	val_76
-41	val_41
-223	val_223
-492	val_492
-449	val_449
-218	val_218
-30	val_30
-209	val_209
-76	val_76
-74	val_74
-342	val_342
-69	val_69
-230	val_230
-368	val_368
-296	val_296
-113	val_113
-216	val_216
-344	val_344
-274	val_274
-485	val_485
-223	val_223
-256	val_256
-263	val_263
-70	val_70
-487	val_487
-401	val_401
-191	val_191
-5	val_5
-438	val_438
-128	val_128
-467	val_467
-432	val_432
-229	val_229
-469	val_469
-463	val_463
-283	val_283
-331	val_331
-193	val_193
-335	val_335
-104	val_104
-366	val_366
-175	val_175
-403	val_403
-483	val_483
-409	val_409
-401	val_401
-258	val_258
-90	val_90
-203	val_203
-348	val_348
-12	val_12
-201	val_201
-164	val_164
-454	val_454
-478	val_478
-298	val_298
-164	val_164
-382	val_382
-5	val_5
-70	val_70
-397	val_397
-351	val_351
-104	val_104
-70	val_70
-438	val_438
-119	val_119
-414	val_414
-360	val_360
-199	val_199
-120	val_120
-429	val_429
-443	val_443
-230	val_230
-478	val_478
-317	val_317
-333	val_333
-207	val_207
-249	val_249
-265	val_265
-83	val_83
-353	val_353
-214	val_214
-133	val_133
-175	val_175
-454	val_454
-375	val_375
-401	val_401
-421	val_421
-407	val_407
-384	val_384
-256	val_256
-67	val_67
-384	val_384
-379	val_379
-18	val_18
-492	val_492
-100	val_100
-298	val_298
-9	val_9
-498	val_498
-146	val_146
-458	val_458
-362	val_362
-186	val_186
-285	val_285
-348	val_348
-18	val_18
-281	val_281
-344	val_344
-469	val_469
-315	val_315
-348	val_348
-414	val_414
-126	val_126
-90	val_90
-403	val_403
 
-474	val_475
-281	val_282
-179	val_180
-135	val_136
-423	val_424
-245	val_246
-425	val_426
-241	val_242
-177	val_178
-272	val_273
-287	val_288
-373	val_374
-447	val_448
-443	val_444
-175	val_176
-278	val_279
-296	val_297
-126	val_127
-249	val_250
-21	val_22
-441	val_442
-106	val_107
-371	val_372
-153	val_154
-490	val_491
-421	val_422
-243	val_244
-128	val_129
-10	val_11
-133	val_134
-333	val_334
-391	val_392
-485	val_486
-241	val_242
-85	val_86
-335	val_336
-476	val_477
-494	val_495
-94	val_95
-485	val_486
-393	val_394
-409	val_410
-50	val_51
-265	val_266
-128	val_129
-63	val_64
-344	val_345
-135	val_136
-3	val_4
-331	val_332
-209	val_210
-281	val_282
-56	val_57
-254	val_255
-304	val_305
-238	val_239
-492	val_493
-289	val_290
-421	val_422
-58	val_59
-5	val_6
-249	val_250
-438	val_439
-360	val_361
-467	val_468
-175	val_176
-429	val_430
-281	val_282
-16	val_17
-119	val_120
-492	val_493
-120	val_121
-306	val_307
-393	val_394
-427	val_428
-386	val_387
-65	val_66
-388	val_389
-184	val_185
-375	val_376
-191	val_192
-197	val_198
-122	val_123
-438	val_439
-351	val_352
-23	val_24
-328	val_329
-382	val_383
-342	val_343
-102	val_103
-487	val_488
-331	val_332
-409	val_410
-463	val_464
-177	val_178
-399	val_400
-476	val_477
-258	val_259
-252	val_253
-87	val_88
-340	val_341
-443	val_444
-407	val_408
-355	val_356
-164	val_165
-104	val_105
-117	val_118
-326	val_327
-47	val_48
-241	val_242
-450	val_451
-140	val_141
-212	val_213
-308	val_309
-30	val_31
-405	val_406
-119	val_120
-49	val_50
-153	val_154
-21	val_22
-157	val_158
-416	val_417
-199	val_200
-375	val_376
-89	val_90
-395	val_396
-386	val_387
-454	val_455
-364	val_365
-89	val_90
-461	val_462
-52	val_53
-168	val_169
-384	val_385
-313	val_314
-324	val_325
-69	val_70
-245	val_246
-328	val_329
-322	val_323
-122	val_123
-241	val_242
-469	val_470
-384	val_385
-76	val_77
-104	val_105
-481	val_482
-32	val_33
-58	val_59
-351	val_352
-70	val_71
-443	val_444
-399	val_400
-205	val_206
-52	val_53
-21	val_22
-317	val_318
-209	val_210
-429	val_430
-160	val_161
-267	val_268
-454	val_455
-76	val_77
-412	val_413
-16	val_17
-375	val_376
-489	val_490
-126	val_127
-274	val_275
-494	val_495
-216	val_217
-470	val_471
-302	val_303
-119	val_120
-375	val_376
-391	val_392
-287	val_288
-450	val_451
-375	val_376
-12	val_13
-384	val_385
-29	val_30
-151	val_152
-52	val_53
-300	val_301
-21	val_22
-104	val_105
-436	val_437
-61	val_62
-407	val_408
-335	val_336
-164	val_165
-371	val_372
-432	val_433
-496	val_497
-355	val_356
-144	val_145
-87	val_88
-382	val_383
-348	val_349
-122	val_123
-427	val_428
-292	val_293
-182	val_183
-474	val_475
-353	val_354
-52	val_53
-414	val_415
-261	val_262
-65	val_66
-371	val_372
-256	val_257
-292	val_293
-412	val_413
-49	val_50
-478	val_479
-243	val_244
-151	val_152
-100	val_101
-401	val_402
-117	val_118
-137	val_138
-162	val_163
-276	val_277
-78	val_79
-379	val_380
-410	val_411
-157	val_158
-100	val_101
-407	val_408
-371	val_372
-308	val_309
-430	val_431
-135	val_136
-76	val_77
-300	val_301
-337	val_338
-478	val_479
-1	val_2
-89	val_90
-29	val_30
-285	val_286
-227	val_228
-395	val_396
 
+86	val_86
+165	val_165
+255	val_255
+484	val_484
+150	val_150
+273	val_273
+224	val_224
+369	val_369
+66	val_66
+213	val_213
+406	val_406
+374	val_374
+152	val_152
+145	val_145
+495	val_495
+37	val_37
+327	val_327
+277	val_277
+15	val_15
+82	val_82
+417	val_417
+219	val_219
+338	val_338
+446	val_446
+459	val_459
+394	val_394
+237	val_237
+482	val_482
+174	val_174
+413	val_413
+466	val_466
+208	val_208
+174	val_174
+396	val_396
+417	val_417
+309	val_309
+365	val_365
+266	val_266
+439	val_439
+367	val_367
+325	val_325
+167	val_167
+475	val_475
+17	val_17
+0	val_0
+455	val_455
+316	val_316
+57	val_57
+149	val_149
+345	val_345
+129	val_129
+170	val_170
+20	val_20
+378	val_378
+4	val_4
+280	val_280
+35	val_35
+277	val_277
+208	val_208
+356	val_356
+169	val_169
+125	val_125
+437	val_437
+192	val_192
+286	val_286
+187	val_187
+176	val_176
+459	val_459
+51	val_51
+138	val_138
+103	val_103
+239	val_239
+213	val_213
+176	val_176
+318	val_318
+332	val_332
+275	val_275
+284	val_284
+181	val_181
+260	val_260
+404	val_404
+138	val_138
+217	val_217
+84	val_84
+466	val_466
+8	val_8
+411	val_411
+208	val_208
+24	val_24
+431	val_431
+172	val_172
+42	val_42
+129	val_129
+158	val_158
+0	val_0
+468	val_468
+26	val_26
+165	val_165
+327	val_327
+51	val_51
+404	val_404
+156	val_156
+468	val_468
+95	val_95
+196	val_196
+288	val_288
+457	val_457
+282	val_282
+187	val_187
+318	val_318
+318	val_318
+369	val_369
+316	val_316
+169	val_169
+413	val_413
+77	val_77
+0	val_0
+118	val_118
+134	val_134
+282	val_282
+138	val_138
+419	val_419
+15	val_15
+118	val_118
+307	val_307
+19	val_19
+435	val_435
+277	val_277
+273	val_273
+224	val_224
+309	val_309
+389	val_389
+327	val_327
+242	val_242
+369	val_369
+392	val_392
+242	val_242
+226	val_226
+497	val_497
+402	val_402
+396	val_396
+35	val_35
+336	val_336
+95	val_95
+11	val_11
+233	val_233
+143	val_143
+42	val_42
+321	val_321
+149	val_149
+228	val_228
+138	val_138
+453	val_453
+64	val_64
+468	val_468
+33	val_33
+103	val_103
+367	val_367
+167	val_167
+219	val_219
+239	val_239
+116	val_116
+480	val_480
+288	val_288
+244	val_244
+202	val_202
+316	val_316
+280	val_280
+2	val_2
+35	val_35
+235	val_235
+80	val_80
+44	val_44
+321	val_321
+466	val_466
+53	val_53
+105	val_105
+257	val_257
+406	val_406
+190	val_190
+406	val_406
+114	val_114
+262	val_262
+424	val_424
+396	val_396
+217	val_217
+431	val_431
+125	val_125
+431	val_431
+424	val_424
+187	val_187
+480	val_480
+291	val_291
+24	val_24
+255	val_255
+163	val_163
+200	val_200
+491	val_491
+237	val_237
+439	val_439
+248	val_248
+479	val_479
+305	val_305
+417	val_417
+444	val_444
+169	val_169
+323	val_323
+325	val_325
+277	val_277
+178	val_178
+468	val_468
+310	val_310
+493	val_493
+460	val_460
+480	val_480
+136	val_136
+172	val_172
+462	val_462
+233	val_233
+406	val_406
+189	val_189
+26	val_26
+134	val_134
+462	val_462
+341	val_341
+167	val_167
+273	val_273
+183	val_183
+97	val_97
+84	val_84
+28	val_28
+37	val_37
+448	val_448
+152	val_152
+307	val_307
+194	val_194
+477	val_477
+222	val_222
+169	val_169
+400	val_400
+200	val_200
+97	val_97
+291	val_292
+62	val_63
+271	val_272
+217	val_218
+167	val_168
+468	val_469
+413	val_414
+455	val_456
+231	val_232
+448	val_449
+246	val_247
+440	val_441
+31	val_32
+147	val_148
+428	val_429
+273	val_274
+356	val_357
+217	val_218
+33	val_34
+35	val_36
+402	val_403
+226	val_227
+15	val_16
+110	val_111
+343	val_344
+275	val_276
+0	val_1
+293	val_294
+240	val_241
+286	val_287
+408	val_409
+477	val_478
+455	val_456
+99	val_100
+482	val_483
+367	val_368
+59	val_60
+48	val_49
+424	val_425
+226	val_227
+488	val_489
+349	val_350
+11	val_12
+161	val_162
+123	val_124
+402	val_403
+468	val_469
+314	val_315
+497	val_498
+224	val_225
+4	val_5
+277	val_278
+206	val_207
+101	val_102
+114	val_115
+239	val_240
+389	val_390
+114	val_115
+235	val_236
+390	val_391
+165	val_166
+264	val_265
+196	val_197
+20	val_21
+11	val_12
+129	val_130
+257	val_258
+71	val_72
+453	val_454
+82	val_83
+86	val_87
+323	val_324
+222	val_223
+42	val_43
+411	val_412
+338	val_339
+68	val_69
+185	val_186
+147	val_148
+473	val_474
+376	val_377
+347	val_348
+213	val_214
+291	val_292
+426	val_427
+132	val_133
+446	val_447
+121	val_122
+284	val_285
+129	val_130
+246	val_247
+491	val_492
+369	val_370
+262	val_263
+390	val_391
+352	val_353
+226	val_227
+349	val_350
+480	val_481
+497	val_498
+480	val_481
+475	val_476
+183	val_184
+15	val_16
+318	val_319
+149	val_150
+392	val_393
+77	val_78
+275	val_276
+174	val_175
+114	val_115
+161	val_162
+75	val_76
+264	val_265
+48	val_49
+336	val_337
+390	val_391
+484	val_485
+189	val_190
+305	val_306
+367	val_368
+6	val_7
+260	val_261
+2	val_3
+349	val_350
+170	val_171
+51	val_52
+363	val_364
+118	val_119
+310	val_311
+19	val_20
+80	val_81
+121	val_122
+239	val_240
+358	val_359
+11	val_12
+143	val_144
+341	val_342
+105	val_106
+42	val_43
+363	val_364
+347	val_348
+77	val_78
+293	val_294
+20	val_21
+40	val_41
+8	val_9
+310	val_311
+206	val_207
+381	val_382
+404	val_405
+206	val_207
+385	val_386
+259	val_260
+226	val_227
+262	val_263
+303	val_304
+260	val_261
+404	val_405
+116	val_117
+42	val_43
+303	val_304
+93	val_94
+277	val_278
+406	val_407
+451	val_452
+53	val_54
+132	val_133
+192	val_193
+356	val_357
+352	val_353
+330	val_331
+138	val_139
+257	val_258
+174	val_175
+295	val_296
+105	val_106
+204	val_205
+439	val_440
+374	val_375
+457	val_458
+93	val_94
+196	val_197
+437	val_438
+398	val_399
+35	val_36
+334	val_335
+435	val_436
+60	val_61
+442	val_443
+404	val_405
+446	val_447
+0	val_1
+268	val_269
+491	val_492
+392	val_393
+295	val_296
+93	val_94
+439	val_440
+156	val_157
+341	val_342
+118	val_119
+172	val_173
+244	val_245
+6	val_7
+284	val_285
+136	val_137
+349	val_350
+462	val_463
+123	val_124
+408	val_409
+152	val_153
+310	val_311
+486	val_487
+152	val_153
+378	val_379
+97	val_98
+495	val_496
+385	val_386
+40	val_41
+389	val_390
+259	val_260
+97	val_98
+125	val_126
+178	val_179
+415	val_416
+156	val_157
+228	val_229
+363	val_364
+22	val_23
+248	val_249
+459	val_460
+402	val_403
+62	val_63
+244	val_245
+46	val_47
+341	val_342
+215	val_216
+134	val_135
+196	val_197
+431	val_432
+82	val_83
+440	val_441
+309	val_310
+161	val_162
+468	val_469
+152	val_153
+138	val_139
+161	val_162
+91	val_92
+118	val_119
+178	val_179
+457	val_458
+242	val_243
+35	val_36
+244	val_245

Modified: hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/sample5.q.out
URL: http://svn.apache.org/viewvc/hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/sample5.q.out?rev=706704&r1=706703&r2=706704&view=diff
==============================================================================
--- hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/sample5.q.out (original)
+++ hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/sample5.q.out Tue Oct 21 11:11:05 2008
@@ -8,32 +8,11 @@
 STAGE PLANS:
   Stage: Stage-1
     Map Reduce
-      Path -> Alias:
-        file:/data/zshao/trunk/VENDOR/hadoop-0.17/build/contrib/hive/ql/test/data/warehouse/srcbucket 
-      Path -> Partition:
-        file:/data/zshao/trunk/VENDOR/hadoop-0.17/build/contrib/hive/ql/test/data/warehouse/srcbucket 
-          Partition
-          
-              properties:
-                name srcbucket
-                bucket_field_name 
-                serialization.format 1
-                columns key,value
-                field_to_dimension 
-                bucket_count 2
-                serialization.lib simple_meta
-                file.inputformat org.apache.hadoop.mapred.TextInputFormat
-                file.outputformat org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
-                location file:/data/zshao/trunk/VENDOR/hadoop-0.17/build/contrib/hive/ql/test/data/warehouse/srcbucket
-              name: srcbucket
-              serde: simple_meta
-              input format: org.apache.hadoop.mapred.TextInputFormat
-              output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
       Alias -> Map Operator Tree:
         s 
             Filter Operator
               predicate:
-                  expr: (((default_sample_hashfn(key) & 2147483647) % 5) = 1)
+                  expr: (((default_sample_hashfn(key) & 2147483647) % 5) = 0)
                   type: Boolean
               Select Operator
                 expressions:
@@ -42,241 +21,272 @@
                       expr: value
                       type: string
                 File Output Operator
+                  directory: /tmp/hive-njain/535229973/587370170.10000.insclause-0
                   table:
+                      input format: org.apache.hadoop.mapred.TextInputFormat
+                      output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
                       properties:
                         name dest1
-                        bucket_field_name 
+                        serialization.ddl struct dest1 { i32 key, string value}
                         serialization.format 1
                         columns key,value
                         SORTBUCKETCOLSPREFIX TRUE
-                        field_to_dimension 
                         bucket_count -1
-                        serialization.lib simple_meta
+                        serialization.lib org.apache.hadoop.hive.serde2.MetadataTypedColumnsetSerDe
                         file.inputformat org.apache.hadoop.mapred.TextInputFormat
                         file.outputformat org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
-                        location file:/data/zshao/trunk/VENDOR/hadoop-0.17/build/contrib/hive/ql/test/data/warehouse/dest1
+                        location file:/home/njain/workspace/hadoop-0.17/build/contrib/hive/ql/test/data/warehouse/dest1
+                      serde: org.apache.hadoop.hive.serde2.MetadataTypedColumnsetSerDe
                       name: dest1
-                      serde: simple_meta
-                      input format: org.apache.hadoop.mapred.TextInputFormat
-                      output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
-                  directory: /tmp/hive-zshao/824052972.10000.insclause-0
       Needs Tagging:
+      Path -> Alias:
+        file:/home/njain/workspace/hadoop-0.17/build/contrib/hive/ql/test/data/warehouse/srcbucket 
+      Path -> Partition:
+        file:/home/njain/workspace/hadoop-0.17/build/contrib/hive/ql/test/data/warehouse/srcbucket 
+          Partition
+          
+              input format: org.apache.hadoop.mapred.TextInputFormat
+              output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
+              properties:
+                name srcbucket
+                serialization.ddl struct srcbucket { string key, string value}
+                serialization.format 1
+                columns key,value
+                bucket_count 2
+                serialization.lib org.apache.hadoop.hive.serde2.MetadataTypedColumnsetSerDe
+                file.inputformat org.apache.hadoop.mapred.TextInputFormat
+                file.outputformat org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
+                location file:/home/njain/workspace/hadoop-0.17/build/contrib/hive/ql/test/data/warehouse/srcbucket
+              serde: org.apache.hadoop.hive.serde2.MetadataTypedColumnsetSerDe
+              name: srcbucket
 
   Stage: Stage-0
     Move Operator
       tables:
+            replace:
+            source: /tmp/hive-njain/535229973/587370170.10000.insclause-0
             table:
+                input format: org.apache.hadoop.mapred.TextInputFormat
+                output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
                 properties:
                   name dest1
-                  bucket_field_name 
+                  serialization.ddl struct dest1 { i32 key, string value}
                   serialization.format 1
                   columns key,value
                   SORTBUCKETCOLSPREFIX TRUE
-                  field_to_dimension 
                   bucket_count -1
-                  serialization.lib simple_meta
+                  serialization.lib org.apache.hadoop.hive.serde2.MetadataTypedColumnsetSerDe
                   file.inputformat org.apache.hadoop.mapred.TextInputFormat
                   file.outputformat org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
-                  location file:/data/zshao/trunk/VENDOR/hadoop-0.17/build/contrib/hive/ql/test/data/warehouse/dest1
+                  location file:/home/njain/workspace/hadoop-0.17/build/contrib/hive/ql/test/data/warehouse/dest1
+                serde: org.apache.hadoop.hive.serde2.MetadataTypedColumnsetSerDe
                 name: dest1
-                serde: simple_meta
-                input format: org.apache.hadoop.mapred.TextInputFormat
-                output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
-            replace:
-            source: /tmp/hive-zshao/824052972.10000.insclause-0
-
-
-165	val_165
-255	val_255
-278	val_278
-273	val_273
-37	val_37
-327	val_327
-82	val_82
-403	val_403
-417	val_417
-430	val_430
-219	val_219
-287	val_287
-237	val_237
-174	val_174
-494	val_494
-174	val_174
-417	val_417
-377	val_377
-309	val_309
-205	val_205
-345	val_345
-129	val_129
-386	val_386
-192	val_192
-138	val_138
-430	val_430
-278	val_278
-318	val_318
-241	val_241
-138	val_138
-8	val_8
-179	val_179
-129	val_129
-322	val_322
-197	val_197
-96	val_96
-165	val_165
-327	val_327
-205	val_205
-156	val_156
-282	val_282
-197	val_197
-318	val_318
-318	val_318
-87	val_87
-179	val_179
-395	val_395
-282	val_282
-138	val_138
-19	val_19
-435	val_435
-273	val_273
-309	val_309
-327	val_327
-331	val_331
-395	val_395
-336	val_336
-322	val_322
-160	val_160
-430	val_430
-458	val_458
-78	val_78
-41	val_41
-223	val_223
-449	val_449
-228	val_228
-138	val_138
-453	val_453
-64	val_64
-69	val_69
-368	val_368
-296	val_296
-219	val_219
-485	val_485
-223	val_223
-480	val_480
-467	val_467
-331	val_331
-403	val_403
-480	val_480
-291	val_291
-255	val_255
-200	val_200
-237	val_237
-417	val_417
-444	val_444
-480	val_480
-214	val_214
-462	val_462
-133	val_133
-421	val_421
-462	val_462
-458	val_458
-273	val_273
-183	val_183
-28	val_28
-37	val_37
-403	val_403
-200	val_200
 
-179	val_180
-291	val_292
-241	val_242
-287	val_288
-246	val_247
-278	val_279
-296	val_297
-147	val_148
-273	val_274
-106	val_107
-421	val_422
-133	val_134
-110	val_111
-485	val_486
-241	val_242
-408	val_409
-476	val_477
-494	val_495
-485	val_486
-50	val_51
-3	val_4
-101	val_102
-331	val_332
-390	val_391
-165	val_166
-304	val_305
-264	val_265
-129	val_130
-453	val_454
-421	val_422
-82	val_83
-467	val_468
-147	val_148
-291	val_292
-426	val_427
-386	val_387
-129	val_130
-246	val_247
-197	val_198
-390	val_391
-23	val_24
-480	val_481
-480	val_481
-331	val_332
-183	val_184
-318	val_319
-476	val_477
-174	val_175
-87	val_88
-264	val_265
-336	val_337
-340	val_341
-390	val_391
-363	val_364
-19	val_20
-241	val_242
-363	val_364
-395	val_396
-386	val_387
-8	val_9
-313	val_314
-381	val_382
-69	val_70
-322	val_323
-241	val_242
-32	val_33
-192	val_193
-205	val_206
-138	val_139
-160	val_161
-174	val_175
-412	val_413
-494	val_495
-287	val_288
-435	val_436
-151	val_152
-156	val_157
-462	val_463
-87	val_88
-408	val_409
-412	val_413
-151	val_152
-156	val_157
-228	val_229
-363	val_364
-46	val_47
-78	val_79
-82	val_83
-430	val_431
-309	val_310
-138	val_139
-91	val_92
-395	val_396
 
+86	val_86
+27	val_27
+484	val_484
+150	val_150
+128	val_128
+213	val_213
+146	val_146
+281	val_281
+277	val_277
+209	val_209
+394	val_394
+466	val_466
+399	val_399
+489	val_489
+439	val_439
+367	val_367
+475	val_475
+155	val_155
+128	val_128
+489	val_489
+72	val_72
+277	val_277
+399	val_399
+169	val_169
+498	val_498
+286	val_286
+187	val_187
+54	val_54
+213	val_213
+137	val_137
+489	val_489
+353	val_353
+272	val_272
+466	val_466
+411	val_411
+119	val_119
+100	val_100
+191	val_191
+308	val_308
+95	val_95
+196	val_196
+457	val_457
+187	val_187
+470	val_470
+137	val_137
+169	val_169
+77	val_77
+72	val_72
+90	val_90
+277	val_277
+272	val_272
+452	val_452
+402	val_402
+317	val_317
+95	val_95
+498	val_498
+321	val_321
+119	val_119
+489	val_489
+218	val_218
+209	val_209
+367	val_367
+344	val_344
+263	val_263
+191	val_191
+128	val_128
+2	val_2
+321	val_321
+335	val_335
+466	val_466
+105	val_105
+114	val_114
+90	val_90
+164	val_164
+164	val_164
+187	val_187
+119	val_119
+439	val_439
+169	val_169
+443	val_443
+277	val_277
+178	val_178
+317	val_317
+493	val_493
+353	val_353
+407	val_407
+18	val_18
+100	val_100
+498	val_498
+146	val_146
+362	val_362
+18	val_18
+281	val_281
+344	val_344
+448	val_448
+222	val_222
+90	val_90
+169	val_169
+281	val_282
+245	val_246
+425	val_426
+272	val_273
+231	val_232
+448	val_449
+31	val_32
+443	val_444
+371	val_372
+402	val_403
+128	val_129
+240	val_241
+286	val_287
+335	val_336
+367	val_368
+59	val_60
+349	val_350
+123	val_124
+402	val_403
+128	val_129
+63	val_64
+344	val_345
+277	val_278
+114	val_115
+209	val_210
+281	val_282
+114	val_115
+254	val_255
+196	val_197
+86	val_87
+222	val_223
+411	val_412
+281	val_282
+68	val_69
+119	val_120
+376	val_377
+213	val_214
+132	val_133
+191	val_192
+349	val_350
+475	val_476
+399	val_400
+77	val_78
+114	val_115
+443	val_444
+484	val_485
+407	val_408
+367	val_368
+2	val_3
+349	val_350
+164	val_165
+326	val_327
+308	val_309
+119	val_120
+358	val_359
+105	val_106
+416	val_417
+77	val_78
+461	val_462
+40	val_41
+385	val_386
+259	val_260
+303	val_304
+245	val_246
+303	val_304
+277	val_278
+132	val_133
+443	val_444
+399	val_400
+317	val_318
+330	val_331
+209	val_210
+489	val_490
+295	val_296
+105	val_106
+204	val_205
+439	val_440
+457	val_458
+470	val_471
+196	val_197
+119	val_120
+268	val_269
+295	val_296
+407	val_408
+439	val_440
+335	val_336
+164	val_165
+349	val_350
+371	val_372
+123	val_124
+182	val_183
+353	val_354
+371	val_372
+385	val_386
+40	val_41
+259	val_260
+178	val_179
+100	val_101
+22	val_23
+402	val_403
+137	val_138
+196	val_197
+100	val_101
+407	val_408
+371	val_372
+308	val_309
+178	val_179
+457	val_458
+227	val_228

Modified: hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/sample6.q.out
URL: http://svn.apache.org/viewvc/hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/sample6.q.out?rev=706704&r1=706703&r2=706704&view=diff
==============================================================================
--- hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/sample6.q.out (original)
+++ hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/sample6.q.out Tue Oct 21 11:11:05 2008
@@ -8,32 +8,11 @@
 STAGE PLANS:
   Stage: Stage-1
     Map Reduce
-      Path -> Alias:
-        file:/data/zshao/trunk/VENDOR/hadoop-0.17/build/contrib/hive/ql/test/data/warehouse/srcbucket 
-      Path -> Partition:
-        file:/data/zshao/trunk/VENDOR/hadoop-0.17/build/contrib/hive/ql/test/data/warehouse/srcbucket 
-          Partition
-          
-              properties:
-                name srcbucket
-                bucket_field_name 
-                serialization.format 1
-                columns key,value
-                field_to_dimension 
-                bucket_count 2
-                serialization.lib simple_meta
-                file.inputformat org.apache.hadoop.mapred.TextInputFormat
-                file.outputformat org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
-                location file:/data/zshao/trunk/VENDOR/hadoop-0.17/build/contrib/hive/ql/test/data/warehouse/srcbucket
-              name: srcbucket
-              serde: simple_meta
-              input format: org.apache.hadoop.mapred.TextInputFormat
-              output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
       Alias -> Map Operator Tree:
         s 
             Filter Operator
               predicate:
-                  expr: (((default_sample_hashfn(key) & 2147483647) % 4) = 1)
+                  expr: (((default_sample_hashfn(key) & 2147483647) % 4) = 0)
                   type: Boolean
               Select Operator
                 expressions:
@@ -42,284 +21,318 @@
                       expr: value
                       type: string
                 File Output Operator
+                  directory: /tmp/hive-njain/391691394/413823912.10000.insclause-0
                   table:
+                      input format: org.apache.hadoop.mapred.TextInputFormat
+                      output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
                       properties:
                         name dest1
-                        bucket_field_name 
+                        serialization.ddl struct dest1 { i32 key, string value}
                         serialization.format 1
                         columns key,value
                         SORTBUCKETCOLSPREFIX TRUE
-                        field_to_dimension 
                         bucket_count -1
-                        serialization.lib simple_meta
+                        serialization.lib org.apache.hadoop.hive.serde2.MetadataTypedColumnsetSerDe
                         file.inputformat org.apache.hadoop.mapred.TextInputFormat
                         file.outputformat org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
-                        location file:/data/zshao/trunk/VENDOR/hadoop-0.17/build/contrib/hive/ql/test/data/warehouse/dest1
+                        location file:/home/njain/workspace/hadoop-0.17/build/contrib/hive/ql/test/data/warehouse/dest1
+                      serde: org.apache.hadoop.hive.serde2.MetadataTypedColumnsetSerDe
                       name: dest1
-                      serde: simple_meta
-                      input format: org.apache.hadoop.mapred.TextInputFormat
-                      output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
-                  directory: /tmp/hive-zshao/6950986.10000.insclause-0
       Needs Tagging:
+      Path -> Alias:
+        file:/home/njain/workspace/hadoop-0.17/build/contrib/hive/ql/test/data/warehouse/srcbucket 
+      Path -> Partition:
+        file:/home/njain/workspace/hadoop-0.17/build/contrib/hive/ql/test/data/warehouse/srcbucket 
+          Partition
+          
+              input format: org.apache.hadoop.mapred.TextInputFormat
+              output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
+              properties:
+                name srcbucket
+                serialization.ddl struct srcbucket { string key, string value}
+                serialization.format 1
+                columns key,value
+                bucket_count 2
+                serialization.lib org.apache.hadoop.hive.serde2.MetadataTypedColumnsetSerDe
+                file.inputformat org.apache.hadoop.mapred.TextInputFormat
+                file.outputformat org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
+                location file:/home/njain/workspace/hadoop-0.17/build/contrib/hive/ql/test/data/warehouse/srcbucket
+              serde: org.apache.hadoop.hive.serde2.MetadataTypedColumnsetSerDe
+              name: srcbucket
 
   Stage: Stage-0
     Move Operator
       tables:
+            replace:
+            source: /tmp/hive-njain/391691394/413823912.10000.insclause-0
             table:
+                input format: org.apache.hadoop.mapred.TextInputFormat
+                output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
                 properties:
                   name dest1
-                  bucket_field_name 
+                  serialization.ddl struct dest1 { i32 key, string value}
                   serialization.format 1
                   columns key,value
                   SORTBUCKETCOLSPREFIX TRUE
-                  field_to_dimension 
                   bucket_count -1
-                  serialization.lib simple_meta
+                  serialization.lib org.apache.hadoop.hive.serde2.MetadataTypedColumnsetSerDe
                   file.inputformat org.apache.hadoop.mapred.TextInputFormat
                   file.outputformat org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
-                  location file:/data/zshao/trunk/VENDOR/hadoop-0.17/build/contrib/hive/ql/test/data/warehouse/dest1
+                  location file:/home/njain/workspace/hadoop-0.17/build/contrib/hive/ql/test/data/warehouse/dest1
+                serde: org.apache.hadoop.hive.serde2.MetadataTypedColumnsetSerDe
                 name: dest1
-                serde: simple_meta
-                input format: org.apache.hadoop.mapred.TextInputFormat
-                output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
-            replace:
-            source: /tmp/hive-zshao/6950986.10000.insclause-0
-
-
-27	val_27
-409	val_409
-265	val_265
-401	val_401
-166	val_166
-430	val_430
-287	val_287
-207	val_207
-199	val_199
-247	val_247
-489	val_489
-162	val_162
-397	val_397
-342	val_342
-195	val_195
-155	val_155
-203	val_203
-339	val_339
-302	val_302
-438	val_438
-489	val_489
-221	val_221
-92	val_92
-111	val_111
-427	val_427
-382	val_382
-386	val_386
-430	val_430
-221	val_221
-137	val_137
-180	val_180
-12	val_12
-67	val_67
-489	val_489
-353	val_353
-272	val_272
-463	val_463
-119	val_119
-496	val_496
-393	val_393
-100	val_100
-298	val_298
-199	val_199
-191	val_191
-96	val_96
-481	val_481
-409	val_409
-470	val_470
-137	val_137
-85	val_85
-364	val_364
-306	val_306
-272	val_272
-331	val_331
-401	val_401
-452	val_452
-177	val_177
-5	val_5
-317	val_317
-34	val_34
-229	val_229
-195	val_195
-430	val_430
-119	val_119
-489	val_489
-78	val_78
-41	val_41
-492	val_492
-449	val_449
-218	val_218
-30	val_30
-74	val_74
-342	val_342
-368	val_368
-485	val_485
-70	val_70
-401	val_401
-191	val_191
-5	val_5
-438	val_438
-467	val_467
-229	val_229
-463	val_463
-283	val_283
-331	val_331
-335	val_335
-104	val_104
-409	val_409
-401	val_401
-258	val_258
-203	val_203
-12	val_12
-478	val_478
-298	val_298
-382	val_382
-5	val_5
-70	val_70
-397	val_397
-104	val_104
-70	val_70
-438	val_438
-119	val_119
-360	val_360
-199	val_199
-478	val_478
-317	val_317
-207	val_207
-265	val_265
-353	val_353
-214	val_214
-133	val_133
-375	val_375
-401	val_401
-67	val_67
-379	val_379
-492	val_492
-100	val_100
-298	val_298
-9	val_9
-126	val_126
 
-474	val_475
-423	val_424
-177	val_178
-272	val_273
-287	val_288
-126	val_127
-441	val_442
-371	val_372
-243	val_244
-133	val_134
-485	val_486
-85	val_86
-335	val_336
-485	val_486
-393	val_394
-409	val_410
-265	val_266
-63	val_64
-331	val_332
-56	val_57
-254	val_255
-492	val_493
-5	val_6
-438	val_439
-360	val_361
-467	val_468
-16	val_17
-119	val_120
-492	val_493
-306	val_307
-393	val_394
-427	val_428
-386	val_387
-184	val_185
-375	val_376
-191	val_192
-122	val_123
-438	val_439
-23	val_24
-328	val_329
-382	val_383
-342	val_343
-331	val_332
-409	val_410
-463	val_464
-177	val_178
-258	val_259
-104	val_105
-140	val_141
-30	val_31
-405	val_406
-119	val_120
-49	val_50
-416	val_417
-199	val_200
-375	val_376
-89	val_90
-386	val_387
-364	val_365
-89	val_90
-52	val_53
-313	val_314
-324	val_325
-328	val_329
-122	val_123
-104	val_105
-481	val_482
-70	val_71
-52	val_53
-317	val_318
-412	val_413
-16	val_17
-375	val_376
-489	val_490
-126	val_127
-470	val_471
-302	val_303
-119	val_120
-375	val_376
-287	val_288
-375	val_376
-12	val_13
-151	val_152
-52	val_53
-104	val_105
-335	val_336
-371	val_372
-496	val_497
-144	val_145
-382	val_383
-122	val_123
-427	val_428
-474	val_475
-353	val_354
-52	val_53
-261	val_262
-371	val_372
-412	val_413
-49	val_50
-478	val_479
-243	val_244
-151	val_152
-100	val_101
-401	val_402
-137	val_138
-162	val_163
-276	val_277
-78	val_79
-379	val_380
-100	val_101
-371	val_372
-430	val_431
-478	val_479
-1	val_2
-89	val_90
 
+165	val_165
+484	val_484
+150	val_150
+224	val_224
+66	val_66
+213	val_213
+374	val_374
+495	val_495
+37	val_37
+327	val_327
+15	val_15
+338	val_338
+459	val_459
+466	val_466
+396	val_396
+309	val_309
+367	val_367
+0	val_0
+455	val_455
+316	val_316
+345	val_345
+129	val_129
+378	val_378
+4	val_4
+356	val_356
+169	val_169
+125	val_125
+437	val_437
+286	val_286
+187	val_187
+176	val_176
+459	val_459
+51	val_51
+103	val_103
+239	val_239
+213	val_213
+176	val_176
+275	val_275
+260	val_260
+404	val_404
+217	val_217
+84	val_84
+466	val_466
+8	val_8
+411	val_411
+172	val_172
+129	val_129
+158	val_158
+0	val_0
+26	val_26
+165	val_165
+327	val_327
+51	val_51
+404	val_404
+95	val_95
+282	val_282
+187	val_187
+316	val_316
+169	val_169
+77	val_77
+0	val_0
+118	val_118
+282	val_282
+419	val_419
+15	val_15
+118	val_118
+19	val_19
+224	val_224
+309	val_309
+389	val_389
+327	val_327
+242	val_242
+392	val_392
+242	val_242
+396	val_396
+95	val_95
+11	val_11
+143	val_143
+228	val_228
+33	val_33
+103	val_103
+367	val_367
+239	val_239
+480	val_480
+202	val_202
+316	val_316
+235	val_235
+80	val_80
+44	val_44
+466	val_466
+257	val_257
+190	val_190
+114	val_114
+396	val_396
+217	val_217
+125	val_125
+187	val_187
+480	val_480
+491	val_491
+305	val_305
+444	val_444
+169	val_169
+323	val_323
+480	val_480
+136	val_136
+172	val_172
+462	val_462
+26	val_26
+462	val_462
+341	val_341
+183	val_183
+84	val_84
+37	val_37
+448	val_448
+194	val_194
+477	val_477
+169	val_169
+400	val_400
+62	val_63
+271	val_272
+217	val_218
+455	val_456
+231	val_232
+448	val_449
+246	val_247
+440	val_441
+147	val_148
+356	val_357
+217	val_218
+33	val_34
+15	val_16
+110	val_111
+275	val_276
+0	val_1
+293	val_294
+286	val_287
+408	val_409
+477	val_478
+455	val_456
+99	val_100
+367	val_368
+59	val_60
+48	val_49
+488	val_489
+349	val_350
+11	val_12
+161	val_162
+224	val_225
+4	val_5
+206	val_207
+114	val_115
+239	val_240
+389	val_390
+114	val_115
+235	val_236
+165	val_166
+264	val_265
+11	val_12
+129	val_130
+257	val_258
+323	val_324
+411	val_412
+338	val_339
+147	val_148
+473	val_474
+213	val_214
+426	val_427
+132	val_133
+121	val_122
+129	val_130
+246	val_247
+491	val_492
+352	val_353
+349	val_350
+480	val_481
+480	val_481
+183	val_184
+15	val_16
+392	val_393
+77	val_78
+275	val_276
+114	val_115
+161	val_162
+264	val_265
+48	val_49
+484	val_485
+305	val_306
+367	val_368
+260	val_261
+349	val_350
+51	val_52
+363	val_364
+118	val_119
+19	val_20
+80	val_81
+121	val_122
+239	val_240
+11	val_12
+143	val_144
+341	val_342
+363	val_364
+77	val_78
+293	val_294
+40	val_41
+8	val_9
+206	val_207
+381	val_382
+404	val_405
+206	val_207
+385	val_386
+260	val_261
+404	val_405
+451	val_452
+132	val_133
+356	val_357
+352	val_353
+330	val_331
+257	val_258
+374	val_375
+437	val_438
+334	val_335
+404	val_405
+0	val_1
+268	val_269
+491	val_492
+392	val_393
+341	val_342
+118	val_119
+172	val_173
+136	val_137
+349	val_350
+462	val_463
+408	val_409
+378	val_379
+495	val_496
+385	val_386
+40	val_41
+389	val_390
+125	val_126
+415	val_416
+228	val_229
+363	val_364
+22	val_23
+459	val_460
+62	val_63
+341	val_342
+440	val_441
+309	val_310
+161	val_162
+161	val_162
+91	val_92
+118	val_119
+242	val_243

Modified: hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/sample7.q.out
URL: http://svn.apache.org/viewvc/hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/sample7.q.out?rev=706704&r1=706703&r2=706704&view=diff
==============================================================================
--- hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/sample7.q.out (original)
+++ hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/sample7.q.out Tue Oct 21 11:11:05 2008
@@ -8,32 +8,11 @@
 STAGE PLANS:
   Stage: Stage-1
     Map Reduce
-      Path -> Alias:
-        file:/data/zshao/trunk/VENDOR/hadoop-0.17/build/contrib/hive/ql/test/data/warehouse/srcbucket 
-      Path -> Partition:
-        file:/data/zshao/trunk/VENDOR/hadoop-0.17/build/contrib/hive/ql/test/data/warehouse/srcbucket 
-          Partition
-          
-              properties:
-                name srcbucket
-                bucket_field_name 
-                serialization.format 1
-                columns key,value
-                field_to_dimension 
-                bucket_count 2
-                serialization.lib simple_meta
-                file.inputformat org.apache.hadoop.mapred.TextInputFormat
-                file.outputformat org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
-                location file:/data/zshao/trunk/VENDOR/hadoop-0.17/build/contrib/hive/ql/test/data/warehouse/srcbucket
-              name: srcbucket
-              serde: simple_meta
-              input format: org.apache.hadoop.mapred.TextInputFormat
-              output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
       Alias -> Map Operator Tree:
         s 
             Filter Operator
               predicate:
-                  expr: (((default_sample_hashfn(key) & 2147483647) % 4) = 1)
+                  expr: (((default_sample_hashfn(key) & 2147483647) % 4) = 0)
                   type: Boolean
               Filter Operator
                 predicate:
@@ -46,239 +25,269 @@
                         expr: value
                         type: string
                   File Output Operator
+                    directory: /tmp/hive-njain/1265167991/144531187.10000.insclause-0
                     table:
+                        input format: org.apache.hadoop.mapred.TextInputFormat
+                        output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
                         properties:
                           name dest1
-                          bucket_field_name 
+                          serialization.ddl struct dest1 { i32 key, string value}
                           serialization.format 1
                           columns key,value
                           SORTBUCKETCOLSPREFIX TRUE
-                          field_to_dimension 
                           bucket_count -1
-                          serialization.lib simple_meta
+                          serialization.lib org.apache.hadoop.hive.serde2.MetadataTypedColumnsetSerDe
                           file.inputformat org.apache.hadoop.mapred.TextInputFormat
                           file.outputformat org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
-                          location file:/data/zshao/trunk/VENDOR/hadoop-0.17/build/contrib/hive/ql/test/data/warehouse/dest1
+                          location file:/home/njain/workspace/hadoop-0.17/build/contrib/hive/ql/test/data/warehouse/dest1
+                        serde: org.apache.hadoop.hive.serde2.MetadataTypedColumnsetSerDe
                         name: dest1
-                        serde: simple_meta
-                        input format: org.apache.hadoop.mapred.TextInputFormat
-                        output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
-                    directory: /tmp/hive-zshao/484898228.10000.insclause-0
       Needs Tagging:
+      Path -> Alias:
+        file:/home/njain/workspace/hadoop-0.17/build/contrib/hive/ql/test/data/warehouse/srcbucket 
+      Path -> Partition:
+        file:/home/njain/workspace/hadoop-0.17/build/contrib/hive/ql/test/data/warehouse/srcbucket 
+          Partition
+          
+              input format: org.apache.hadoop.mapred.TextInputFormat
+              output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
+              properties:
+                name srcbucket
+                serialization.ddl struct srcbucket { string key, string value}
+                serialization.format 1
+                columns key,value
+                bucket_count 2
+                serialization.lib org.apache.hadoop.hive.serde2.MetadataTypedColumnsetSerDe
+                file.inputformat org.apache.hadoop.mapred.TextInputFormat
+                file.outputformat org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
+                location file:/home/njain/workspace/hadoop-0.17/build/contrib/hive/ql/test/data/warehouse/srcbucket
+              serde: org.apache.hadoop.hive.serde2.MetadataTypedColumnsetSerDe
+              name: srcbucket
 
   Stage: Stage-0
     Move Operator
       tables:
+            replace:
+            source: /tmp/hive-njain/1265167991/144531187.10000.insclause-0
             table:
+                input format: org.apache.hadoop.mapred.TextInputFormat
+                output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
                 properties:
                   name dest1
-                  bucket_field_name 
+                  serialization.ddl struct dest1 { i32 key, string value}
                   serialization.format 1
                   columns key,value
                   SORTBUCKETCOLSPREFIX TRUE
-                  field_to_dimension 
                   bucket_count -1
-                  serialization.lib simple_meta
+                  serialization.lib org.apache.hadoop.hive.serde2.MetadataTypedColumnsetSerDe
                   file.inputformat org.apache.hadoop.mapred.TextInputFormat
                   file.outputformat org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
-                  location file:/data/zshao/trunk/VENDOR/hadoop-0.17/build/contrib/hive/ql/test/data/warehouse/dest1
+                  location file:/home/njain/workspace/hadoop-0.17/build/contrib/hive/ql/test/data/warehouse/dest1
+                serde: org.apache.hadoop.hive.serde2.MetadataTypedColumnsetSerDe
                 name: dest1
-                serde: simple_meta
-                input format: org.apache.hadoop.mapred.TextInputFormat
-                output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
-            replace:
-            source: /tmp/hive-zshao/484898228.10000.insclause-0
-
-
-409	val_409
-265	val_265
-401	val_401
-166	val_166
-430	val_430
-287	val_287
-207	val_207
-199	val_199
-247	val_247
-489	val_489
-162	val_162
-397	val_397
-342	val_342
-195	val_195
-155	val_155
-203	val_203
-339	val_339
-302	val_302
-438	val_438
-489	val_489
-221	val_221
-111	val_111
-427	val_427
-382	val_382
-386	val_386
-430	val_430
-221	val_221
-137	val_137
-180	val_180
-489	val_489
-353	val_353
-272	val_272
-463	val_463
-119	val_119
-496	val_496
-393	val_393
-298	val_298
-199	val_199
-191	val_191
-481	val_481
-409	val_409
-470	val_470
-137	val_137
-364	val_364
-306	val_306
-272	val_272
-331	val_331
-401	val_401
-452	val_452
-177	val_177
-317	val_317
-229	val_229
-195	val_195
-430	val_430
-119	val_119
-489	val_489
-492	val_492
-449	val_449
-218	val_218
-342	val_342
-368	val_368
-485	val_485
-401	val_401
-191	val_191
-438	val_438
-467	val_467
-229	val_229
-463	val_463
-283	val_283
-331	val_331
-335	val_335
-104	val_104
-409	val_409
-401	val_401
-258	val_258
-203	val_203
-478	val_478
-298	val_298
-382	val_382
-397	val_397
-104	val_104
-438	val_438
-119	val_119
-360	val_360
-199	val_199
-478	val_478
-317	val_317
-207	val_207
-265	val_265
-353	val_353
-214	val_214
-133	val_133
-375	val_375
-401	val_401
-379	val_379
-492	val_492
-298	val_298
-126	val_126
 
-474	val_475
-423	val_424
-177	val_178
-272	val_273
-287	val_288
-126	val_127
-441	val_442
-371	val_372
-243	val_244
-133	val_134
-485	val_486
-335	val_336
-485	val_486
-393	val_394
-409	val_410
-265	val_266
-331	val_332
-254	val_255
-492	val_493
-438	val_439
-360	val_361
-467	val_468
-119	val_120
-492	val_493
-306	val_307
-393	val_394
-427	val_428
-386	val_387
-184	val_185
-375	val_376
-191	val_192
-122	val_123
-438	val_439
-328	val_329
-382	val_383
-342	val_343
-331	val_332
-409	val_410
-463	val_464
-177	val_178
-258	val_259
-104	val_105
-140	val_141
-405	val_406
-119	val_120
-416	val_417
-199	val_200
-375	val_376
-386	val_387
-364	val_365
-313	val_314
-324	val_325
-328	val_329
-122	val_123
-104	val_105
-481	val_482
-317	val_318
-412	val_413
-375	val_376
-489	val_490
-126	val_127
-470	val_471
-302	val_303
-119	val_120
-375	val_376
-287	val_288
-375	val_376
-151	val_152
-104	val_105
-335	val_336
-371	val_372
-496	val_497
-144	val_145
-382	val_383
-122	val_123
-427	val_428
-474	val_475
-353	val_354
-261	val_262
-371	val_372
-412	val_413
-478	val_479
-243	val_244
-151	val_152
-401	val_402
-137	val_138
-162	val_163
-276	val_277
-379	val_380
-371	val_372
-430	val_431
-478	val_479
 
+165	val_165
+484	val_484
+150	val_150
+224	val_224
+213	val_213
+374	val_374
+495	val_495
+327	val_327
+338	val_338
+459	val_459
+466	val_466
+396	val_396
+309	val_309
+367	val_367
+455	val_455
+316	val_316
+345	val_345
+129	val_129
+378	val_378
+356	val_356
+169	val_169
+125	val_125
+437	val_437
+286	val_286
+187	val_187
+176	val_176
+459	val_459
+103	val_103
+239	val_239
+213	val_213
+176	val_176
+275	val_275
+260	val_260
+404	val_404
+217	val_217
+466	val_466
+411	val_411
+172	val_172
+129	val_129
+158	val_158
+165	val_165
+327	val_327
+404	val_404
+282	val_282
+187	val_187
+316	val_316
+169	val_169
+118	val_118
+282	val_282
+419	val_419
+118	val_118
+224	val_224
+309	val_309
+389	val_389
+327	val_327
+242	val_242
+392	val_392
+242	val_242
+396	val_396
+143	val_143
+228	val_228
+103	val_103
+367	val_367
+239	val_239
+480	val_480
+202	val_202
+316	val_316
+235	val_235
+466	val_466
+257	val_257
+190	val_190
+114	val_114
+396	val_396
+217	val_217
+125	val_125
+187	val_187
+480	val_480
+491	val_491
+305	val_305
+444	val_444
+169	val_169
+323	val_323
+480	val_480
+136	val_136
+172	val_172
+462	val_462
+462	val_462
+341	val_341
+183	val_183
+448	val_448
+194	val_194
+477	val_477
+169	val_169
+400	val_400
+271	val_272
+217	val_218
+455	val_456
+231	val_232
+448	val_449
+246	val_247
+440	val_441
+147	val_148
+356	val_357
+217	val_218
+110	val_111
+275	val_276
+293	val_294
+286	val_287
+408	val_409
+477	val_478
+455	val_456
+367	val_368
+488	val_489
+349	val_350
+161	val_162
+224	val_225
+206	val_207
+114	val_115
+239	val_240
+389	val_390
+114	val_115
+235	val_236
+165	val_166
+264	val_265
+129	val_130
+257	val_258
+323	val_324
+411	val_412
+338	val_339
+147	val_148
+473	val_474
+213	val_214
+426	val_427
+132	val_133
+121	val_122
+129	val_130
+246	val_247
+491	val_492
+352	val_353
+349	val_350
+480	val_481
+480	val_481
+183	val_184
+392	val_393
+275	val_276
+114	val_115
+161	val_162
+264	val_265
+484	val_485
+305	val_306
+367	val_368
+260	val_261
+349	val_350
+363	val_364
+118	val_119
+121	val_122
+239	val_240
+143	val_144
+341	val_342
+363	val_364
+293	val_294
+206	val_207
+381	val_382
+404	val_405
+206	val_207
+385	val_386
+260	val_261
+404	val_405
+451	val_452
+132	val_133
+356	val_357
+352	val_353
+330	val_331
+257	val_258
+374	val_375
+437	val_438
+334	val_335
+404	val_405
+268	val_269
+491	val_492
+392	val_393
+341	val_342
+118	val_119
+172	val_173
+136	val_137
+349	val_350
+462	val_463
+408	val_409
+378	val_379
+495	val_496
+385	val_386
+389	val_390
+125	val_126
+415	val_416
+228	val_229
+363	val_364
+459	val_460
+341	val_342
+440	val_441
+309	val_310
+161	val_162
+161	val_162
+118	val_119
+242	val_243

Added: hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/show_tables.q.out
URL: http://svn.apache.org/viewvc/hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/show_tables.q.out?rev=706704&view=auto
==============================================================================
--- hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/show_tables.q.out (added)
+++ hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/show_tables.q.out Tue Oct 21 11:11:05 2008
@@ -0,0 +1,28 @@
+ABSTRACT SYNTAX TREE:
+  (TOK_SHOWTABLES 'shtb_*')
+
+STAGE DEPENDENCIES:
+  Stage-0 is a root stage
+
+STAGE PLANS:
+  Stage: Stage-0
+      Show Table Operator:
+        Show Tables
+          pattern: shtb_*
+
+
+shtb_test1	shtb_test2
+ABSTRACT SYNTAX TREE:
+  (TOK_SHOWTABLES 'shtb_test1|shtb_test2')
+
+STAGE DEPENDENCIES:
+  Stage-0 is a root stage
+
+STAGE PLANS:
+  Stage: Stage-0
+      Show Table Operator:
+        Show Tables
+          pattern: shtb_test1|shtb_test2
+
+
+shtb_test1	shtb_test2

Added: hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/showparts.q.out
URL: http://svn.apache.org/viewvc/hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/showparts.q.out?rev=706704&view=auto
==============================================================================
--- hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/showparts.q.out (added)
+++ hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/showparts.q.out Tue Oct 21 11:11:05 2008
@@ -0,0 +1,17 @@
+ABSTRACT SYNTAX TREE:
+  (TOK_SHOWPARTITIONS srcpart)
+
+STAGE DEPENDENCIES:
+  Stage-0 is a root stage
+
+STAGE PLANS:
+  Stage: Stage-0
+      Show Partitions Operator:
+        Show Partitions
+          table: srcpart
+
+
+ds=2008-04-08/hr=11
+ds=2008-04-08/hr=12
+ds=2008-04-09/hr=11
+ds=2008-04-09/hr=12

Modified: hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/subq.q.out
URL: http://svn.apache.org/viewvc/hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/subq.q.out?rev=706704&r1=706703&r2=706704&view=diff
==============================================================================
--- hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/subq.q.out (original)
+++ hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/subq.q.out Tue Oct 21 11:11:05 2008
@@ -34,8 +34,8 @@
   Stage: Stage-0
     Move Operator
       files:
-            destination: ../../../../build/contrib/hive/ql/test/data/warehouse/union.out
             hdfs directory:
+            destination: ../../../../build/contrib/hive/ql/test/data/warehouse/union.out
 
 
 86val_86

Added: hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/subq2.q.out
URL: http://svn.apache.org/viewvc/hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/subq2.q.out?rev=706704&view=auto
==============================================================================
--- hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/subq2.q.out (added)
+++ hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/subq2.q.out Tue Oct 21 11:11:05 2008
@@ -0,0 +1,340 @@
+ABSTRACT SYNTAX TREE:
+  (TOK_QUERY (TOK_FROM (TOK_SUBQUERY (TOK_QUERY (TOK_FROM (TOK_TABREF src b)) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR (TOK_COLREF b key) k) (TOK_SELEXPR (TOK_FUNCTION count 1) c)) (TOK_GROUPBY (TOK_COLREF b key)))) a)) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR (TOK_COLREF a k)) (TOK_SELEXPR (TOK_COLREF a c))) (TOK_WHERE (>= (TOK_COLREF a k) 90))))
+
+STAGE DEPENDENCIES:
+  Stage-1 is a root stage
+  Stage-2 depends on stages: Stage-1
+  Stage-0 is a root stage
+
+STAGE PLANS:
+  Stage: Stage-1
+    Map Reduce
+      Alias -> Map Operator Tree:
+        a:b 
+            Reduce Output Operator
+              key expressions:
+                    expr: key
+                    type: string
+              # partition fields: -1
+              tag: -1
+              value expressions:
+                    expr: 1
+                    type: int
+      Reduce Operator Tree:
+        Group By Operator
+        
+              expr: count(VALUE.0)
+          keys:
+                expr: KEY.0
+                type: string
+          mode: partial1
+          File Output Operator
+            table:
+                input format: org.apache.hadoop.mapred.TextInputFormat
+                output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
+
+  Stage: Stage-2
+    Map Reduce
+      Alias -> Map Operator Tree:
+        /tmp/hive-njain/57219117/75379653.10002 
+          Reduce Output Operator
+            key expressions:
+                  expr: 0
+                  type: string
+            # partition fields: 1
+            tag: -1
+            value expressions:
+                  expr: 1
+                  type: string
+      Reduce Operator Tree:
+        Group By Operator
+        
+              expr: count(VALUE.0)
+          keys:
+                expr: KEY.0
+                type: string
+          mode: partial2
+          Select Operator
+            expressions:
+                  expr: 0
+                  type: string
+                  expr: 1
+                  type: string
+            Filter Operator
+              predicate:
+                  expr: (0 >= 90)
+                  type: Boolean
+              Select Operator
+                expressions:
+                      expr: 0
+                      type: string
+                      expr: 1
+                      type: string
+                File Output Operator
+                  table:
+                      input format: org.apache.hadoop.mapred.TextInputFormat
+                      output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
+
+  Stage: Stage-0
+    Fetch Operator
+      limit: -1
+
+
+100	2
+103	2
+104	2
+105	1
+111	1
+113	2
+114	1
+116	1
+118	2
+119	3
+120	2
+125	2
+126	1
+128	3
+129	2
+131	1
+133	1
+134	2
+136	1
+137	2
+138	4
+143	1
+145	1
+146	2
+149	2
+150	1
+152	2
+153	1
+155	1
+156	1
+157	1
+158	1
+160	1
+162	1
+163	1
+164	2
+165	2
+166	1
+167	3
+168	1
+169	4
+170	1
+172	2
+174	2
+175	2
+176	2
+177	1
+178	1
+179	2
+180	1
+181	1
+183	1
+186	1
+187	3
+189	1
+190	1
+191	2
+192	1
+193	3
+194	1
+195	2
+196	1
+197	2
+199	3
+200	2
+201	1
+202	1
+203	2
+205	2
+207	2
+208	3
+209	2
+213	2
+214	1
+216	2
+217	2
+218	1
+219	2
+221	2
+222	1
+223	2
+224	2
+226	1
+228	1
+229	2
+230	5
+233	2
+235	1
+237	2
+238	2
+239	2
+241	1
+242	2
+244	1
+247	1
+248	1
+249	1
+252	1
+255	2
+256	2
+257	1
+258	1
+260	1
+262	1
+263	1
+265	2
+266	1
+272	2
+273	3
+274	1
+275	1
+277	4
+278	2
+280	2
+281	2
+282	2
+283	1
+284	1
+285	1
+286	1
+287	1
+288	2
+289	1
+291	1
+292	1
+296	1
+298	3
+302	1
+305	1
+306	1
+307	2
+308	1
+309	2
+310	1
+311	3
+315	1
+316	3
+317	2
+318	3
+321	2
+322	2
+323	1
+325	2
+327	3
+331	2
+332	1
+333	2
+335	1
+336	1
+338	1
+339	1
+341	1
+342	2
+344	2
+345	1
+348	5
+351	1
+353	2
+356	1
+360	1
+362	1
+364	1
+365	1
+366	1
+367	2
+368	1
+369	3
+373	1
+374	1
+375	1
+377	1
+378	1
+379	1
+382	2
+384	3
+386	1
+389	1
+392	1
+393	1
+394	1
+395	2
+396	3
+397	2
+399	2
+400	1
+401	5
+402	1
+403	3
+404	2
+406	4
+407	1
+409	3
+411	1
+413	2
+414	2
+417	3
+418	1
+419	1
+421	1
+424	2
+427	1
+429	2
+430	3
+431	3
+432	1
+435	1
+436	1
+437	1
+438	3
+439	2
+443	1
+444	1
+446	1
+448	1
+449	1
+452	1
+453	1
+454	3
+455	1
+457	1
+458	2
+459	2
+460	1
+462	2
+463	2
+466	3
+467	1
+468	4
+469	5
+470	1
+472	1
+475	1
+477	1
+478	2
+479	1
+480	3
+481	1
+482	1
+483	1
+484	1
+485	1
+487	1
+489	4
+490	1
+491	1
+492	2
+493	1
+494	1
+495	1
+496	1
+497	1
+498	3
+90	3
+92	1
+95	2
+96	1
+97	2
+98	2

Modified: hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/udf1.q.out
URL: http://svn.apache.org/viewvc/hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/udf1.q.out?rev=706704&r1=706703&r2=706704&view=diff
==============================================================================
--- hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/udf1.q.out (original)
+++ hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/udf1.q.out Tue Oct 21 11:11:05 2008
@@ -52,21 +52,20 @@
                       type: string
                 File Output Operator
                   table:
-                      name: dest1
-                      serde: simple_meta
                       input format: org.apache.hadoop.mapred.TextInputFormat
                       output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
+                      serde: org.apache.hadoop.hive.serde2.MetadataTypedColumnsetSerDe
+                      name: dest1
 
   Stage: Stage-0
     Move Operator
       tables:
+            replace:
             table:
-                name: dest1
-                serde: simple_meta
                 input format: org.apache.hadoop.mapred.TextInputFormat
                 output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
-            replace:
+                serde: org.apache.hadoop.hive.serde2.MetadataTypedColumnsetSerDe
+                name: dest1
 
 
 true	false	true	true	true	false	false	false	true	true	false	true	false	acc	abc	abb	hive
-

Modified: hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/udf2.q.out
URL: http://svn.apache.org/viewvc/hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/udf2.q.out?rev=706704&r1=706703&r2=706704&view=diff
==============================================================================
--- hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/udf2.q.out (original)
+++ hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/udf2.q.out Tue Oct 21 11:11:05 2008
@@ -1,509 +1,39 @@
-ABSTRACT SYNTAX TREE:	
-  (TOK_CREATEFUNCTION testlength 'org.apache.hadoop.hive.ql.udf.UDFTestLength')	
-	
-STAGE DEPENDENCIES:	
-  Stage-0 is a root stage	
-	
-STAGE PLANS:	
-  Stage: Stage-0	
-	
-7	
-6	
-7	
-6	
-7	
-7	
-7	
-7	
-6	
-7	
-7	
-7	
-7	
-7	
-7	
-7	
-7	
-6	
-7	
-7	
-7	
-7	
-7	
-7	
-7	
-7	
-7	
-7	
-6	
-7	
-7	
-7	
-7	
-6	
-6	
-7	
-7	
-7	
-7	
-7	
-7	
-7	
-7	
-7	
-7	
-7	
-7	
-7	
-7	
-7	
-7	
-7	
-7	
-7	
-7	
-7	
-7	
-7	
-7	
-7	
-7	
-7	
-7	
-7	
-7	
-7	
-7	
-7	
-7	
-7	
-7	
-7	
-7	
-7	
-7	
-7	
-7	
-6	
-7	
-7	
-7	
-7	
-5	
-7	
-7	
-7	
-7	
-6	
-7	
-7	
-7	
-7	
-7	
-7	
-7	
-6	
-7	
-7	
-7	
-7	
-6	
-7	
-6	
-6	
-5	
-7	
-6	
-7	
-7	
-7	
-7	
-7	
-7	
-7	
-7	
-7	
-7	
-7	
-7	
-7	
-7	
-7	
-7	
-6	
-7	
-6	
-7	
-7	
-7	
-7	
-7	
-7	
-7	
-7	
-7	
-7	
-6	
-7	
-7	
-7	
-7	
-7	
-7	
-6	
-7	
-7	
-7	
-6	
-7	
-7	
-6	
-7	
-7	
-7	
-7	
-7	
-7	
-7	
-7	
-7	
-6	
-7	
-7	
-6	
-5	
-7	
-7	
-7	
-7	
-6	
-7	
-7	
-7	
-7	
-6	
-7	
-7	
-7	
-7	
-5	
-7	
-7	
-7	
-7	
-7	
-7	
-7	
-7	
-7	
-7	
-6	
-6	
-7	
-7	
-7	
-7	
-7	
-7	
-6	
-7	
-6	
-7	
-7	
-7	
-7	
-7	
-6	
-7	
-7	
-7	
-7	
-6	
-7	
-7	
-7	
-7	
-7	
-7	
-7	
-7	
-7	
-7	
-7	
-7	
-6	
-6	
-5	
-7	
-6	
-7	
-7	
-7	
-7	
-7	
-7	
-7	
-7	
-7	
-6	
-7	
-6	
-6	
-7	
-6	
-7	
-6	
-7	
-7	
-7	
-7	
-7	
-7	
-7	
-7	
-7	
-7	
-7	
-7	
-7	
-7	
-7	
-7	
-7	
-5	
-7	
-7	
-7	
-7	
-7	
-6	
-6	
-7	
-6	
-6	
-7	
-6	
-7	
-7	
-7	
-7	
-7	
-7	
-7	
-7	
-6	
-7	
-7	
-7	
-7	
-7	
-6	
-6	
-6	
-7	
-7	
-7	
-7	
-7	
-7	
-7	
-7	
-6	
-7	
-6	
-7	
-6	
-6	
-7	
-6	
-7	
-6	
-7	
-7	
-7	
-7	
-7	
-7	
-7	
-7	
-7	
-7	
-7	
-7	
-7	
-7	
-7	
-7	
-6	
-7	
-7	
-7	
-7	
-7	
-5	
-7	
-7	
-7	
-7	
-7	
-7	
-7	
-7	
-7	
-7	
-7	
-5	
-6	
-7	
-7	
-7	
-6	
-6	
-7	
-7	
-7	
-7	
-7	
-7	
-7	
-7	
-7	
-6	
-7	
-7	
-7	
-7	
-7	
-7	
-7	
-7	
-7	
-6	
-7	
-7	
-7	
-7	
-6	
-7	
-7	
-7	
-7	
-7	
-7	
-7	
-7	
-7	
-7	
-7	
-7	
-7	
-7	
-5	
-6	
-7	
-7	
-7	
-6	
-7	
-7	
-7	
-6	
-7	
-7	
-7	
-7	
-7	
-7	
-7	
-7	
-7	
-7	
-7	
-7	
-7	
-7	
-7	
-7	
-7	
-7	
-7	
-7	
-7	
-7	
-7	
-7	
-7	
-7	
-7	
-7	
-7	
-7	
-7	
-7	
-7	
-7	
-7	
-6	
-7	
-7	
-7	
-7	
-7	
-7	
-7	
-7	
-7	
-7	
-7	
-7	
-7	
-7	
-7	
-7	
-7	
-6	
-7	
-6	
-7	
-7	
-6	
-7	
-7	
-7	
-7	
-5	
-7	
-7	
-7	
-7	
-7	
-7	
-7	
-7	
-7	
-6	
-7	
-7	
-7	
-7	
-6	
-7	
-7	
-6	
-6	
-6	
-7	
-7	
-7	
-7	
-7	
-7	
-7	
-7	
-7	
-6	
-7	
-7	
-7	
-7	
-6	
+ABSTRACT SYNTAX TREE:
+  (TOK_QUERY (TOK_FROM (TOK_TABREF dest1)) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR '|') (TOK_SELEXPR (TOK_FUNCTION trim (TOK_COLREF dest1 c1))) (TOK_SELEXPR '|') (TOK_SELEXPR (TOK_FUNCTION rtrim (TOK_COLREF dest1 c1))) (TOK_SELEXPR '|') (TOK_SELEXPR (TOK_FUNCTION ltrim (TOK_COLREF dest1 c1))) (TOK_SELEXPR '|'))))
+
+STAGE DEPENDENCIES:
+  Stage-1 is a root stage
+  Stage-0 is a root stage
+
+STAGE PLANS:
+  Stage: Stage-1
+    Map Reduce
+      Alias -> Map Operator Tree:
+        dest1 
+            Select Operator
+              expressions:
+                    expr: '|'
+                    type: string
+                    expr: trim(c1)
+                    type: string
+                    expr: '|'
+                    type: string
+                    expr: rtrim(c1)
+                    type: string
+                    expr: '|'
+                    type: string
+                    expr: ltrim(c1)
+                    type: string
+                    expr: '|'
+                    type: string
+              File Output Operator
+                table:
+                    input format: org.apache.hadoop.mapred.TextInputFormat
+                    output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
+
+  Stage: Stage-0
+    Fetch Operator
+      limit: -1
+
+
+|	abc	|	  abc	|	abc  	|

Added: hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/udf3.q.out
URL: http://svn.apache.org/viewvc/hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/udf3.q.out?rev=706704&view=auto
==============================================================================
--- hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/udf3.q.out (added)
+++ hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/udf3.q.out Tue Oct 21 11:11:05 2008
@@ -0,0 +1,91 @@
+ABSTRACT SYNTAX TREE:
+  (TOK_QUERY (TOK_FROM (TOK_TABREF src)) (TOK_INSERT (TOK_DESTINATION (TOK_TAB dest1)) (TOK_SELECT (TOK_SELEXPR (TOK_FUNCTION count (TOK_FUNCTION TOK_INT ''))) (TOK_SELEXPR (TOK_FUNCTION sum (TOK_FUNCTION TOK_INT ''))) (TOK_SELEXPR (TOK_FUNCTION avg (TOK_FUNCTION TOK_INT ''))) (TOK_SELEXPR (TOK_FUNCTION min (TOK_FUNCTION TOK_INT ''))) (TOK_SELEXPR (TOK_FUNCTION max (TOK_FUNCTION TOK_INT ''))))))
+
+STAGE DEPENDENCIES:
+  Stage-1 is a root stage
+  Stage-2 depends on stages: Stage-1
+  Stage-0 depends on stages: Stage-2
+
+STAGE PLANS:
+  Stage: Stage-1
+    Map Reduce
+      Alias -> Map Operator Tree:
+        src 
+            Reduce Output Operator
+              # partition fields: -1
+              tag: -1
+              value expressions:
+                    expr: UDFToInteger('')
+                    type: int
+      Reduce Operator Tree:
+        Group By Operator
+        
+              expr: max(VALUE.0)
+              expr: avg(VALUE.0)
+              expr: count(VALUE.0)
+              expr: sum(VALUE.0)
+              expr: min(VALUE.0)
+          mode: partial1
+          File Output Operator
+            table:
+                input format: org.apache.hadoop.mapred.TextInputFormat
+                output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
+
+  Stage: Stage-2
+    Map Reduce
+      Alias -> Map Operator Tree:
+        /tmp/hive-njain/159338588/98912587.10001 
+          Reduce Output Operator
+            # partition fields: 0
+            tag: -1
+            value expressions:
+                  expr: 0
+                  type: string
+                  expr: 1
+                  type: string
+                  expr: 2
+                  type: string
+                  expr: 3
+                  type: string
+                  expr: 4
+                  type: string
+      Reduce Operator Tree:
+        Group By Operator
+        
+              expr: max(VALUE.0)
+              expr: avg(VALUE.1)
+              expr: count(VALUE.2)
+              expr: sum(VALUE.3)
+              expr: min(VALUE.4)
+          mode: partial2
+          Select Operator
+            expressions:
+                  expr: 2
+                  type: string
+                  expr: 3
+                  type: string
+                  expr: 1
+                  type: string
+                  expr: 4
+                  type: string
+                  expr: 0
+                  type: string
+            File Output Operator
+              table:
+                  input format: org.apache.hadoop.mapred.TextInputFormat
+                  output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
+                  serde: org.apache.hadoop.hive.serde2.MetadataTypedColumnsetSerDe
+                  name: dest1
+
+  Stage: Stage-0
+    Move Operator
+      tables:
+            replace:
+            table:
+                input format: org.apache.hadoop.mapred.TextInputFormat
+                output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
+                serde: org.apache.hadoop.hive.serde2.MetadataTypedColumnsetSerDe
+                name: dest1
+
+
+0	NULL	NULL	NULL	NULL

Added: hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/udf4.q.out
URL: http://svn.apache.org/viewvc/hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/udf4.q.out?rev=706704&view=auto
==============================================================================
--- hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/udf4.q.out (added)
+++ hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/udf4.q.out Tue Oct 21 11:11:05 2008
@@ -0,0 +1,57 @@
+ABSTRACT SYNTAX TREE:
+  (TOK_QUERY (TOK_FROM (TOK_TABREF dest1)) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR (TOK_FUNCTION round 1.0)) (TOK_SELEXPR (TOK_FUNCTION round 1.5)) (TOK_SELEXPR (TOK_FUNCTION round (- 1.5))) (TOK_SELEXPR (TOK_FUNCTION floor 1.0)) (TOK_SELEXPR (TOK_FUNCTION floor 1.5)) (TOK_SELEXPR (TOK_FUNCTION floor (- 1.5))) (TOK_SELEXPR (TOK_FUNCTION ceil 1.0)) (TOK_SELEXPR (TOK_FUNCTION ceil 1.5)) (TOK_SELEXPR (TOK_FUNCTION ceil (- 1.5))) (TOK_SELEXPR (TOK_FUNCTION ceiling 1.0)) (TOK_SELEXPR (TOK_FUNCTION rand 3)) (TOK_SELEXPR (+ 3)) (TOK_SELEXPR (- 3)) (TOK_SELEXPR (+ 1 (+ 2))) (TOK_SELEXPR (+ 1 (- 2))) (TOK_SELEXPR (~ 1)))))
+
+STAGE DEPENDENCIES:
+  Stage-1 is a root stage
+  Stage-0 is a root stage
+
+STAGE PLANS:
+  Stage: Stage-1
+    Map Reduce
+      Alias -> Map Operator Tree:
+        dest1 
+            Select Operator
+              expressions:
+                    expr: round(1.0)
+                    type: bigint
+                    expr: round(1.5)
+                    type: bigint
+                    expr: round(- 1.5)
+                    type: bigint
+                    expr: floor(1.0)
+                    type: bigint
+                    expr: floor(1.5)
+                    type: bigint
+                    expr: floor(- 1.5)
+                    type: bigint
+                    expr: ceiling(1.0)
+                    type: bigint
+                    expr: ceiling(1.5)
+                    type: bigint
+                    expr: ceiling(- 1.5)
+                    type: bigint
+                    expr: ceiling(1.0)
+                    type: bigint
+                    expr: rand(UDFToLong(3))
+                    type: double
+                    expr: 3
+                    type: int
+                    expr: - 3
+                    type: int
+                    expr: (1 + 2)
+                    type: int
+                    expr: (1 + - 2)
+                    type: int
+                    expr: ~ 1
+                    type: int
+              File Output Operator
+                table:
+                    input format: org.apache.hadoop.mapred.TextInputFormat
+                    output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
+
+  Stage: Stage-0
+    Fetch Operator
+      limit: -1
+
+
+1	2	-1	1	1	-2	1	2	-1	1	0.731057369148862	3	-3	3	-1	-2

Modified: hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/union.q.out
URL: http://svn.apache.org/viewvc/hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/union.q.out?rev=706704&r1=706703&r2=706704&view=diff
==============================================================================
--- hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/union.q.out (original)
+++ hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/union.q.out Tue Oct 21 11:11:05 2008
@@ -55,8 +55,8 @@
   Stage: Stage-0
     Move Operator
       files:
-            destination: ../../../../build/contrib/hive/ql/test/data/warehouse/union.out
             hdfs directory:
+            destination: ../../../../build/contrib/hive/ql/test/data/warehouse/union.out
 
 
 238val_238

Added: hadoop/core/trunk/src/contrib/hive/ql/src/test/results/compiler/errors/invalid_dot.q.out
URL: http://svn.apache.org/viewvc/hadoop/core/trunk/src/contrib/hive/ql/src/test/results/compiler/errors/invalid_dot.q.out?rev=706704&view=auto
==============================================================================
--- hadoop/core/trunk/src/contrib/hive/ql/src/test/results/compiler/errors/invalid_dot.q.out (added)
+++ hadoop/core/trunk/src/contrib/hive/ql/src/test/results/compiler/errors/invalid_dot.q.out Tue Oct 21 11:11:05 2008
@@ -0,0 +1,2 @@
+Semantic Exception: 
+line 2:36 . operator is only supported on struct or list of struct types member
\ No newline at end of file

Added: hadoop/core/trunk/src/contrib/hive/ql/src/test/results/compiler/errors/invalid_index.q.out
URL: http://svn.apache.org/viewvc/hadoop/core/trunk/src/contrib/hive/ql/src/test/results/compiler/errors/invalid_index.q.out?rev=706704&view=auto
==============================================================================
--- hadoop/core/trunk/src/contrib/hive/ql/src/test/results/compiler/errors/invalid_index.q.out (added)
+++ hadoop/core/trunk/src/contrib/hive/ql/src/test/results/compiler/errors/invalid_index.q.out Tue Oct 21 11:11:05 2008
@@ -0,0 +1,2 @@
+Semantic Exception: 
+line 2:36 [] not Valid on Non Collection Types 0
\ No newline at end of file

Added: hadoop/core/trunk/src/contrib/hive/ql/src/test/results/compiler/errors/invalid_list_index.q.out
URL: http://svn.apache.org/viewvc/hadoop/core/trunk/src/contrib/hive/ql/src/test/results/compiler/errors/invalid_list_index.q.out?rev=706704&view=auto
==============================================================================
--- hadoop/core/trunk/src/contrib/hive/ql/src/test/results/compiler/errors/invalid_list_index.q.out (added)
+++ hadoop/core/trunk/src/contrib/hive/ql/src/test/results/compiler/errors/invalid_list_index.q.out Tue Oct 21 11:11:05 2008
@@ -0,0 +1,2 @@
+Semantic Exception: 
+line 2:56 Non Constant Expressions for Array Indexes not Supported 'abc'
\ No newline at end of file

Added: hadoop/core/trunk/src/contrib/hive/ql/src/test/results/compiler/errors/invalid_list_index2.q.out
URL: http://svn.apache.org/viewvc/hadoop/core/trunk/src/contrib/hive/ql/src/test/results/compiler/errors/invalid_list_index2.q.out?rev=706704&view=auto
==============================================================================
--- hadoop/core/trunk/src/contrib/hive/ql/src/test/results/compiler/errors/invalid_list_index2.q.out (added)
+++ hadoop/core/trunk/src/contrib/hive/ql/src/test/results/compiler/errors/invalid_list_index2.q.out Tue Oct 21 11:11:05 2008
@@ -0,0 +1,2 @@
+Semantic Exception: 
+line 2:56 Non Constant Expressions for Array Indexes not Supported 2
\ No newline at end of file

Added: hadoop/core/trunk/src/contrib/hive/ql/src/test/results/compiler/errors/invalid_map_index.q.out
URL: http://svn.apache.org/viewvc/hadoop/core/trunk/src/contrib/hive/ql/src/test/results/compiler/errors/invalid_map_index.q.out?rev=706704&view=auto
==============================================================================
--- hadoop/core/trunk/src/contrib/hive/ql/src/test/results/compiler/errors/invalid_map_index.q.out (added)
+++ hadoop/core/trunk/src/contrib/hive/ql/src/test/results/compiler/errors/invalid_map_index.q.out Tue Oct 21 11:11:05 2008
@@ -0,0 +1,2 @@
+Semantic Exception: 
+line 2:56 Map Key Type does not Match Index Expression Type 0
\ No newline at end of file

Added: hadoop/core/trunk/src/contrib/hive/ql/src/test/results/compiler/errors/invalid_map_index2.q.out
URL: http://svn.apache.org/viewvc/hadoop/core/trunk/src/contrib/hive/ql/src/test/results/compiler/errors/invalid_map_index2.q.out?rev=706704&view=auto
==============================================================================
--- hadoop/core/trunk/src/contrib/hive/ql/src/test/results/compiler/errors/invalid_map_index2.q.out (added)
+++ hadoop/core/trunk/src/contrib/hive/ql/src/test/results/compiler/errors/invalid_map_index2.q.out Tue Oct 21 11:11:05 2008
@@ -0,0 +1,2 @@
+Semantic Exception: 
+line 2:56 Non Constant Expression for Map Indexes not Supported 'abc'
\ No newline at end of file

Added: hadoop/core/trunk/src/contrib/hive/ql/src/test/results/compiler/parse/case_sensitivity.q.out
URL: http://svn.apache.org/viewvc/hadoop/core/trunk/src/contrib/hive/ql/src/test/results/compiler/parse/case_sensitivity.q.out?rev=706704&view=auto
==============================================================================
--- hadoop/core/trunk/src/contrib/hive/ql/src/test/results/compiler/parse/case_sensitivity.q.out (added)
+++ hadoop/core/trunk/src/contrib/hive/ql/src/test/results/compiler/parse/case_sensitivity.q.out Tue Oct 21 11:11:05 2008
@@ -0,0 +1 @@
+(TOK_QUERY (TOK_FROM (TOK_TABREF SRC_THRIFT)) (TOK_INSERT (TOK_DESTINATION (TOK_TAB dest1)) (TOK_SELECT (TOK_SELEXPR ([ (TOK_COLREF src_Thrift LINT) 1)) (TOK_SELEXPR (. ([ (TOK_COLREF src_thrift lintstring) 0) MYSTRING))) (TOK_WHERE (> ([ (TOK_COLREF src_thrift liNT) 0) 0)))) null
\ No newline at end of file

Modified: hadoop/core/trunk/src/contrib/hive/ql/src/test/results/compiler/parse/input_testxpath.q.out
URL: http://svn.apache.org/viewvc/hadoop/core/trunk/src/contrib/hive/ql/src/test/results/compiler/parse/input_testxpath.q.out?rev=706704&r1=706703&r2=706704&view=diff
==============================================================================
--- hadoop/core/trunk/src/contrib/hive/ql/src/test/results/compiler/parse/input_testxpath.q.out (original)
+++ hadoop/core/trunk/src/contrib/hive/ql/src/test/results/compiler/parse/input_testxpath.q.out Tue Oct 21 11:11:05 2008
@@ -1 +1 @@
-(TOK_QUERY (TOK_FROM (TOK_TABREF src_thrift)) (TOK_INSERT (TOK_DESTINATION (TOK_TAB dest1)) (TOK_SELECT (TOK_SELEXPR ([ (TOK_COLREF src_thrift lint) 1)) (TOK_SELEXPR (. ([ (TOK_COLREF src_thrift lintstring) 0) mystring))))) null
\ No newline at end of file
+(TOK_QUERY (TOK_FROM (TOK_TABREF src_thrift)) (TOK_INSERT (TOK_DESTINATION (TOK_TAB dest1)) (TOK_SELECT (TOK_SELEXPR ([ (TOK_COLREF src_thrift lint) 1)) (TOK_SELEXPR (. ([ (TOK_COLREF src_thrift lintstring) 0) mystring)) (TOK_SELEXPR ([ (TOK_COLREF src_thrift mstringstring) 'key_2'))))) null
\ No newline at end of file

Added: hadoop/core/trunk/src/contrib/hive/ql/src/test/results/compiler/parse/input_testxpath2.q.out
URL: http://svn.apache.org/viewvc/hadoop/core/trunk/src/contrib/hive/ql/src/test/results/compiler/parse/input_testxpath2.q.out?rev=706704&view=auto
==============================================================================
--- hadoop/core/trunk/src/contrib/hive/ql/src/test/results/compiler/parse/input_testxpath2.q.out (added)
+++ hadoop/core/trunk/src/contrib/hive/ql/src/test/results/compiler/parse/input_testxpath2.q.out Tue Oct 21 11:11:05 2008
@@ -0,0 +1 @@
+(TOK_QUERY (TOK_FROM (TOK_TABREF src_thrift)) (TOK_INSERT (TOK_DESTINATION (TOK_TAB dest1)) (TOK_SELECT (TOK_SELEXPR (TOK_FUNCTION size (TOK_COLREF src_thrift lint))) (TOK_SELEXPR (TOK_FUNCTION size (TOK_COLREF src_thrift lintstring))) (TOK_SELEXPR (TOK_FUNCTION size (TOK_COLREF src_thrift mstringstring)))) (TOK_WHERE (AND (TOK_FUNCTION TOK_ISNOTNULL (TOK_COLREF src_thrift lint)) (NOT (TOK_FUNCTION TOK_ISNULL (TOK_COLREF src_thrift mstringstring))))))) null
\ No newline at end of file

Added: hadoop/core/trunk/src/contrib/hive/ql/src/test/results/compiler/parse/udf4.q.out
URL: http://svn.apache.org/viewvc/hadoop/core/trunk/src/contrib/hive/ql/src/test/results/compiler/parse/udf4.q.out?rev=706704&view=auto
==============================================================================
--- hadoop/core/trunk/src/contrib/hive/ql/src/test/results/compiler/parse/udf4.q.out (added)
+++ hadoop/core/trunk/src/contrib/hive/ql/src/test/results/compiler/parse/udf4.q.out Tue Oct 21 11:11:05 2008
@@ -0,0 +1 @@
+(TOK_QUERY (TOK_FROM (TOK_TABREF dest1)) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR (TOK_FUNCTION round 1.0)) (TOK_SELEXPR (TOK_FUNCTION round 1.5)) (TOK_SELEXPR (TOK_FUNCTION round (- 1.5))) (TOK_SELEXPR (TOK_FUNCTION floor 1.0)) (TOK_SELEXPR (TOK_FUNCTION floor 1.5)) (TOK_SELEXPR (TOK_FUNCTION floor (- 1.5))) (TOK_SELEXPR (TOK_FUNCTION ceil 1.0)) (TOK_SELEXPR (TOK_FUNCTION ceil 1.5)) (TOK_SELEXPR (TOK_FUNCTION ceil (- 1.5))) (TOK_SELEXPR (TOK_FUNCTION ceiling 1.0)) (TOK_SELEXPR (TOK_FUNCTION rand 3)) (TOK_SELEXPR (+ 3)) (TOK_SELEXPR (- 3)) (TOK_SELEXPR (+ 1 (+ 2))) (TOK_SELEXPR (+ 1 (- 2))) (TOK_SELEXPR (~ 1))))) null
\ No newline at end of file



Mime
View raw message