You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@spark.apache.org by pw...@apache.org on 2014/03/21 23:08:46 UTC

[44/51] [partial] Add hive test files to repository. Remove download script.

http://git-wip-us.apache.org/repos/asf/spark/blob/7e17fe69/sql/hive/src/test/resources/golden/Partition pruning: with filter on int partition key - query test-0-4e4d2651e1e6e3c224242078d0201190
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/golden/Partition pruning: with filter on int partition key - query test-0-4e4d2651e1e6e3c224242078d0201190 b/sql/hive/src/test/resources/golden/Partition pruning: with filter on int partition key - query test-0-4e4d2651e1e6e3c224242078d0201190
new file mode 100644
index 0000000..d83d8b6
--- /dev/null
+++ b/sql/hive/src/test/resources/golden/Partition pruning: with filter on int partition key - query test-0-4e4d2651e1e6e3c224242078d0201190	
@@ -0,0 +1,1000 @@
+val_238	11
+val_86	11
+val_311	11
+val_27	11
+val_165	11
+val_409	11
+val_255	11
+val_278	11
+val_98	11
+val_484	11
+val_265	11
+val_193	11
+val_401	11
+val_150	11
+val_273	11
+val_224	11
+val_369	11
+val_66	11
+val_128	11
+val_213	11
+val_146	11
+val_406	11
+val_429	11
+val_374	11
+val_152	11
+val_469	11
+val_145	11
+val_495	11
+val_37	11
+val_327	11
+val_281	11
+val_277	11
+val_209	11
+val_15	11
+val_82	11
+val_403	11
+val_166	11
+val_417	11
+val_430	11
+val_252	11
+val_292	11
+val_219	11
+val_287	11
+val_153	11
+val_193	11
+val_338	11
+val_446	11
+val_459	11
+val_394	11
+val_237	11
+val_482	11
+val_174	11
+val_413	11
+val_494	11
+val_207	11
+val_199	11
+val_466	11
+val_208	11
+val_174	11
+val_399	11
+val_396	11
+val_247	11
+val_417	11
+val_489	11
+val_162	11
+val_377	11
+val_397	11
+val_309	11
+val_365	11
+val_266	11
+val_439	11
+val_342	11
+val_367	11
+val_325	11
+val_167	11
+val_195	11
+val_475	11
+val_17	11
+val_113	11
+val_155	11
+val_203	11
+val_339	11
+val_0	11
+val_455	11
+val_128	11
+val_311	11
+val_316	11
+val_57	11
+val_302	11
+val_205	11
+val_149	11
+val_438	11
+val_345	11
+val_129	11
+val_170	11
+val_20	11
+val_489	11
+val_157	11
+val_378	11
+val_221	11
+val_92	11
+val_111	11
+val_47	11
+val_72	11
+val_4	11
+val_280	11
+val_35	11
+val_427	11
+val_277	11
+val_208	11
+val_356	11
+val_399	11
+val_169	11
+val_382	11
+val_498	11
+val_125	11
+val_386	11
+val_437	11
+val_469	11
+val_192	11
+val_286	11
+val_187	11
+val_176	11
+val_54	11
+val_459	11
+val_51	11
+val_138	11
+val_103	11
+val_239	11
+val_213	11
+val_216	11
+val_430	11
+val_278	11
+val_176	11
+val_289	11
+val_221	11
+val_65	11
+val_318	11
+val_332	11
+val_311	11
+val_275	11
+val_137	11
+val_241	11
+val_83	11
+val_333	11
+val_180	11
+val_284	11
+val_12	11
+val_230	11
+val_181	11
+val_67	11
+val_260	11
+val_404	11
+val_384	11
+val_489	11
+val_353	11
+val_373	11
+val_272	11
+val_138	11
+val_217	11
+val_84	11
+val_348	11
+val_466	11
+val_58	11
+val_8	11
+val_411	11
+val_230	11
+val_208	11
+val_348	11
+val_24	11
+val_463	11
+val_431	11
+val_179	11
+val_172	11
+val_42	11
+val_129	11
+val_158	11
+val_119	11
+val_496	11
+val_0	11
+val_322	11
+val_197	11
+val_468	11
+val_393	11
+val_454	11
+val_100	11
+val_298	11
+val_199	11
+val_191	11
+val_418	11
+val_96	11
+val_26	11
+val_165	11
+val_327	11
+val_230	11
+val_205	11
+val_120	11
+val_131	11
+val_51	11
+val_404	11
+val_43	11
+val_436	11
+val_156	11
+val_469	11
+val_468	11
+val_308	11
+val_95	11
+val_196	11
+val_288	11
+val_481	11
+val_457	11
+val_98	11
+val_282	11
+val_197	11
+val_187	11
+val_318	11
+val_318	11
+val_409	11
+val_470	11
+val_137	11
+val_369	11
+val_316	11
+val_169	11
+val_413	11
+val_85	11
+val_77	11
+val_0	11
+val_490	11
+val_87	11
+val_364	11
+val_179	11
+val_118	11
+val_134	11
+val_395	11
+val_282	11
+val_138	11
+val_238	11
+val_419	11
+val_15	11
+val_118	11
+val_72	11
+val_90	11
+val_307	11
+val_19	11
+val_435	11
+val_10	11
+val_277	11
+val_273	11
+val_306	11
+val_224	11
+val_309	11
+val_389	11
+val_327	11
+val_242	11
+val_369	11
+val_392	11
+val_272	11
+val_331	11
+val_401	11
+val_242	11
+val_452	11
+val_177	11
+val_226	11
+val_5	11
+val_497	11
+val_402	11
+val_396	11
+val_317	11
+val_395	11
+val_58	11
+val_35	11
+val_336	11
+val_95	11
+val_11	11
+val_168	11
+val_34	11
+val_229	11
+val_233	11
+val_143	11
+val_472	11
+val_322	11
+val_498	11
+val_160	11
+val_195	11
+val_42	11
+val_321	11
+val_430	11
+val_119	11
+val_489	11
+val_458	11
+val_78	11
+val_76	11
+val_41	11
+val_223	11
+val_492	11
+val_149	11
+val_449	11
+val_218	11
+val_228	11
+val_138	11
+val_453	11
+val_30	11
+val_209	11
+val_64	11
+val_468	11
+val_76	11
+val_74	11
+val_342	11
+val_69	11
+val_230	11
+val_33	11
+val_368	11
+val_103	11
+val_296	11
+val_113	11
+val_216	11
+val_367	11
+val_344	11
+val_167	11
+val_274	11
+val_219	11
+val_239	11
+val_485	11
+val_116	11
+val_223	11
+val_256	11
+val_263	11
+val_70	11
+val_487	11
+val_480	11
+val_401	11
+val_288	11
+val_191	11
+val_5	11
+val_244	11
+val_438	11
+val_128	11
+val_467	11
+val_432	11
+val_202	11
+val_316	11
+val_229	11
+val_469	11
+val_463	11
+val_280	11
+val_2	11
+val_35	11
+val_283	11
+val_331	11
+val_235	11
+val_80	11
+val_44	11
+val_193	11
+val_321	11
+val_335	11
+val_104	11
+val_466	11
+val_366	11
+val_175	11
+val_403	11
+val_483	11
+val_53	11
+val_105	11
+val_257	11
+val_406	11
+val_409	11
+val_190	11
+val_406	11
+val_401	11
+val_114	11
+val_258	11
+val_90	11
+val_203	11
+val_262	11
+val_348	11
+val_424	11
+val_12	11
+val_396	11
+val_201	11
+val_217	11
+val_164	11
+val_431	11
+val_454	11
+val_478	11
+val_298	11
+val_125	11
+val_431	11
+val_164	11
+val_424	11
+val_187	11
+val_382	11
+val_5	11
+val_70	11
+val_397	11
+val_480	11
+val_291	11
+val_24	11
+val_351	11
+val_255	11
+val_104	11
+val_70	11
+val_163	11
+val_438	11
+val_119	11
+val_414	11
+val_200	11
+val_491	11
+val_237	11
+val_439	11
+val_360	11
+val_248	11
+val_479	11
+val_305	11
+val_417	11
+val_199	11
+val_444	11
+val_120	11
+val_429	11
+val_169	11
+val_443	11
+val_323	11
+val_325	11
+val_277	11
+val_230	11
+val_478	11
+val_178	11
+val_468	11
+val_310	11
+val_317	11
+val_333	11
+val_493	11
+val_460	11
+val_207	11
+val_249	11
+val_265	11
+val_480	11
+val_83	11
+val_136	11
+val_353	11
+val_172	11
+val_214	11
+val_462	11
+val_233	11
+val_406	11
+val_133	11
+val_175	11
+val_189	11
+val_454	11
+val_375	11
+val_401	11
+val_421	11
+val_407	11
+val_384	11
+val_256	11
+val_26	11
+val_134	11
+val_67	11
+val_384	11
+val_379	11
+val_18	11
+val_462	11
+val_492	11
+val_100	11
+val_298	11
+val_9	11
+val_341	11
+val_498	11
+val_146	11
+val_458	11
+val_362	11
+val_186	11
+val_285	11
+val_348	11
+val_167	11
+val_18	11
+val_273	11
+val_183	11
+val_281	11
+val_344	11
+val_97	11
+val_469	11
+val_315	11
+val_84	11
+val_28	11
+val_37	11
+val_448	11
+val_152	11
+val_348	11
+val_307	11
+val_194	11
+val_414	11
+val_477	11
+val_222	11
+val_126	11
+val_90	11
+val_169	11
+val_403	11
+val_400	11
+val_200	11
+val_97	11
+val_238	11
+val_86	11
+val_311	11
+val_27	11
+val_165	11
+val_409	11
+val_255	11
+val_278	11
+val_98	11
+val_484	11
+val_265	11
+val_193	11
+val_401	11
+val_150	11
+val_273	11
+val_224	11
+val_369	11
+val_66	11
+val_128	11
+val_213	11
+val_146	11
+val_406	11
+val_429	11
+val_374	11
+val_152	11
+val_469	11
+val_145	11
+val_495	11
+val_37	11
+val_327	11
+val_281	11
+val_277	11
+val_209	11
+val_15	11
+val_82	11
+val_403	11
+val_166	11
+val_417	11
+val_430	11
+val_252	11
+val_292	11
+val_219	11
+val_287	11
+val_153	11
+val_193	11
+val_338	11
+val_446	11
+val_459	11
+val_394	11
+val_237	11
+val_482	11
+val_174	11
+val_413	11
+val_494	11
+val_207	11
+val_199	11
+val_466	11
+val_208	11
+val_174	11
+val_399	11
+val_396	11
+val_247	11
+val_417	11
+val_489	11
+val_162	11
+val_377	11
+val_397	11
+val_309	11
+val_365	11
+val_266	11
+val_439	11
+val_342	11
+val_367	11
+val_325	11
+val_167	11
+val_195	11
+val_475	11
+val_17	11
+val_113	11
+val_155	11
+val_203	11
+val_339	11
+val_0	11
+val_455	11
+val_128	11
+val_311	11
+val_316	11
+val_57	11
+val_302	11
+val_205	11
+val_149	11
+val_438	11
+val_345	11
+val_129	11
+val_170	11
+val_20	11
+val_489	11
+val_157	11
+val_378	11
+val_221	11
+val_92	11
+val_111	11
+val_47	11
+val_72	11
+val_4	11
+val_280	11
+val_35	11
+val_427	11
+val_277	11
+val_208	11
+val_356	11
+val_399	11
+val_169	11
+val_382	11
+val_498	11
+val_125	11
+val_386	11
+val_437	11
+val_469	11
+val_192	11
+val_286	11
+val_187	11
+val_176	11
+val_54	11
+val_459	11
+val_51	11
+val_138	11
+val_103	11
+val_239	11
+val_213	11
+val_216	11
+val_430	11
+val_278	11
+val_176	11
+val_289	11
+val_221	11
+val_65	11
+val_318	11
+val_332	11
+val_311	11
+val_275	11
+val_137	11
+val_241	11
+val_83	11
+val_333	11
+val_180	11
+val_284	11
+val_12	11
+val_230	11
+val_181	11
+val_67	11
+val_260	11
+val_404	11
+val_384	11
+val_489	11
+val_353	11
+val_373	11
+val_272	11
+val_138	11
+val_217	11
+val_84	11
+val_348	11
+val_466	11
+val_58	11
+val_8	11
+val_411	11
+val_230	11
+val_208	11
+val_348	11
+val_24	11
+val_463	11
+val_431	11
+val_179	11
+val_172	11
+val_42	11
+val_129	11
+val_158	11
+val_119	11
+val_496	11
+val_0	11
+val_322	11
+val_197	11
+val_468	11
+val_393	11
+val_454	11
+val_100	11
+val_298	11
+val_199	11
+val_191	11
+val_418	11
+val_96	11
+val_26	11
+val_165	11
+val_327	11
+val_230	11
+val_205	11
+val_120	11
+val_131	11
+val_51	11
+val_404	11
+val_43	11
+val_436	11
+val_156	11
+val_469	11
+val_468	11
+val_308	11
+val_95	11
+val_196	11
+val_288	11
+val_481	11
+val_457	11
+val_98	11
+val_282	11
+val_197	11
+val_187	11
+val_318	11
+val_318	11
+val_409	11
+val_470	11
+val_137	11
+val_369	11
+val_316	11
+val_169	11
+val_413	11
+val_85	11
+val_77	11
+val_0	11
+val_490	11
+val_87	11
+val_364	11
+val_179	11
+val_118	11
+val_134	11
+val_395	11
+val_282	11
+val_138	11
+val_238	11
+val_419	11
+val_15	11
+val_118	11
+val_72	11
+val_90	11
+val_307	11
+val_19	11
+val_435	11
+val_10	11
+val_277	11
+val_273	11
+val_306	11
+val_224	11
+val_309	11
+val_389	11
+val_327	11
+val_242	11
+val_369	11
+val_392	11
+val_272	11
+val_331	11
+val_401	11
+val_242	11
+val_452	11
+val_177	11
+val_226	11
+val_5	11
+val_497	11
+val_402	11
+val_396	11
+val_317	11
+val_395	11
+val_58	11
+val_35	11
+val_336	11
+val_95	11
+val_11	11
+val_168	11
+val_34	11
+val_229	11
+val_233	11
+val_143	11
+val_472	11
+val_322	11
+val_498	11
+val_160	11
+val_195	11
+val_42	11
+val_321	11
+val_430	11
+val_119	11
+val_489	11
+val_458	11
+val_78	11
+val_76	11
+val_41	11
+val_223	11
+val_492	11
+val_149	11
+val_449	11
+val_218	11
+val_228	11
+val_138	11
+val_453	11
+val_30	11
+val_209	11
+val_64	11
+val_468	11
+val_76	11
+val_74	11
+val_342	11
+val_69	11
+val_230	11
+val_33	11
+val_368	11
+val_103	11
+val_296	11
+val_113	11
+val_216	11
+val_367	11
+val_344	11
+val_167	11
+val_274	11
+val_219	11
+val_239	11
+val_485	11
+val_116	11
+val_223	11
+val_256	11
+val_263	11
+val_70	11
+val_487	11
+val_480	11
+val_401	11
+val_288	11
+val_191	11
+val_5	11
+val_244	11
+val_438	11
+val_128	11
+val_467	11
+val_432	11
+val_202	11
+val_316	11
+val_229	11
+val_469	11
+val_463	11
+val_280	11
+val_2	11
+val_35	11
+val_283	11
+val_331	11
+val_235	11
+val_80	11
+val_44	11
+val_193	11
+val_321	11
+val_335	11
+val_104	11
+val_466	11
+val_366	11
+val_175	11
+val_403	11
+val_483	11
+val_53	11
+val_105	11
+val_257	11
+val_406	11
+val_409	11
+val_190	11
+val_406	11
+val_401	11
+val_114	11
+val_258	11
+val_90	11
+val_203	11
+val_262	11
+val_348	11
+val_424	11
+val_12	11
+val_396	11
+val_201	11
+val_217	11
+val_164	11
+val_431	11
+val_454	11
+val_478	11
+val_298	11
+val_125	11
+val_431	11
+val_164	11
+val_424	11
+val_187	11
+val_382	11
+val_5	11
+val_70	11
+val_397	11
+val_480	11
+val_291	11
+val_24	11
+val_351	11
+val_255	11
+val_104	11
+val_70	11
+val_163	11
+val_438	11
+val_119	11
+val_414	11
+val_200	11
+val_491	11
+val_237	11
+val_439	11
+val_360	11
+val_248	11
+val_479	11
+val_305	11
+val_417	11
+val_199	11
+val_444	11
+val_120	11
+val_429	11
+val_169	11
+val_443	11
+val_323	11
+val_325	11
+val_277	11
+val_230	11
+val_478	11
+val_178	11
+val_468	11
+val_310	11
+val_317	11
+val_333	11
+val_493	11
+val_460	11
+val_207	11
+val_249	11
+val_265	11
+val_480	11
+val_83	11
+val_136	11
+val_353	11
+val_172	11
+val_214	11
+val_462	11
+val_233	11
+val_406	11
+val_133	11
+val_175	11
+val_189	11
+val_454	11
+val_375	11
+val_401	11
+val_421	11
+val_407	11
+val_384	11
+val_256	11
+val_26	11
+val_134	11
+val_67	11
+val_384	11
+val_379	11
+val_18	11
+val_462	11
+val_492	11
+val_100	11
+val_298	11
+val_9	11
+val_341	11
+val_498	11
+val_146	11
+val_458	11
+val_362	11
+val_186	11
+val_285	11
+val_348	11
+val_167	11
+val_18	11
+val_273	11
+val_183	11
+val_281	11
+val_344	11
+val_97	11
+val_469	11
+val_315	11
+val_84	11
+val_28	11
+val_37	11
+val_448	11
+val_152	11
+val_348	11
+val_307	11
+val_194	11
+val_414	11
+val_477	11
+val_222	11
+val_126	11
+val_90	11
+val_169	11
+val_403	11
+val_400	11
+val_200	11
+val_97	11

http://git-wip-us.apache.org/repos/asf/spark/blob/7e17fe69/sql/hive/src/test/resources/golden/Partition pruning: with filter on string partition key - query test-0-b6e59464383591f02408f8765ac6a5d5
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/golden/Partition pruning: with filter on string partition key - query test-0-b6e59464383591f02408f8765ac6a5d5 b/sql/hive/src/test/resources/golden/Partition pruning: with filter on string partition key - query test-0-b6e59464383591f02408f8765ac6a5d5
new file mode 100644
index 0000000..83bc625
--- /dev/null
+++ b/sql/hive/src/test/resources/golden/Partition pruning: with filter on string partition key - query test-0-b6e59464383591f02408f8765ac6a5d5	
@@ -0,0 +1,1000 @@
+val_238	11
+val_86	11
+val_311	11
+val_27	11
+val_165	11
+val_409	11
+val_255	11
+val_278	11
+val_98	11
+val_484	11
+val_265	11
+val_193	11
+val_401	11
+val_150	11
+val_273	11
+val_224	11
+val_369	11
+val_66	11
+val_128	11
+val_213	11
+val_146	11
+val_406	11
+val_429	11
+val_374	11
+val_152	11
+val_469	11
+val_145	11
+val_495	11
+val_37	11
+val_327	11
+val_281	11
+val_277	11
+val_209	11
+val_15	11
+val_82	11
+val_403	11
+val_166	11
+val_417	11
+val_430	11
+val_252	11
+val_292	11
+val_219	11
+val_287	11
+val_153	11
+val_193	11
+val_338	11
+val_446	11
+val_459	11
+val_394	11
+val_237	11
+val_482	11
+val_174	11
+val_413	11
+val_494	11
+val_207	11
+val_199	11
+val_466	11
+val_208	11
+val_174	11
+val_399	11
+val_396	11
+val_247	11
+val_417	11
+val_489	11
+val_162	11
+val_377	11
+val_397	11
+val_309	11
+val_365	11
+val_266	11
+val_439	11
+val_342	11
+val_367	11
+val_325	11
+val_167	11
+val_195	11
+val_475	11
+val_17	11
+val_113	11
+val_155	11
+val_203	11
+val_339	11
+val_0	11
+val_455	11
+val_128	11
+val_311	11
+val_316	11
+val_57	11
+val_302	11
+val_205	11
+val_149	11
+val_438	11
+val_345	11
+val_129	11
+val_170	11
+val_20	11
+val_489	11
+val_157	11
+val_378	11
+val_221	11
+val_92	11
+val_111	11
+val_47	11
+val_72	11
+val_4	11
+val_280	11
+val_35	11
+val_427	11
+val_277	11
+val_208	11
+val_356	11
+val_399	11
+val_169	11
+val_382	11
+val_498	11
+val_125	11
+val_386	11
+val_437	11
+val_469	11
+val_192	11
+val_286	11
+val_187	11
+val_176	11
+val_54	11
+val_459	11
+val_51	11
+val_138	11
+val_103	11
+val_239	11
+val_213	11
+val_216	11
+val_430	11
+val_278	11
+val_176	11
+val_289	11
+val_221	11
+val_65	11
+val_318	11
+val_332	11
+val_311	11
+val_275	11
+val_137	11
+val_241	11
+val_83	11
+val_333	11
+val_180	11
+val_284	11
+val_12	11
+val_230	11
+val_181	11
+val_67	11
+val_260	11
+val_404	11
+val_384	11
+val_489	11
+val_353	11
+val_373	11
+val_272	11
+val_138	11
+val_217	11
+val_84	11
+val_348	11
+val_466	11
+val_58	11
+val_8	11
+val_411	11
+val_230	11
+val_208	11
+val_348	11
+val_24	11
+val_463	11
+val_431	11
+val_179	11
+val_172	11
+val_42	11
+val_129	11
+val_158	11
+val_119	11
+val_496	11
+val_0	11
+val_322	11
+val_197	11
+val_468	11
+val_393	11
+val_454	11
+val_100	11
+val_298	11
+val_199	11
+val_191	11
+val_418	11
+val_96	11
+val_26	11
+val_165	11
+val_327	11
+val_230	11
+val_205	11
+val_120	11
+val_131	11
+val_51	11
+val_404	11
+val_43	11
+val_436	11
+val_156	11
+val_469	11
+val_468	11
+val_308	11
+val_95	11
+val_196	11
+val_288	11
+val_481	11
+val_457	11
+val_98	11
+val_282	11
+val_197	11
+val_187	11
+val_318	11
+val_318	11
+val_409	11
+val_470	11
+val_137	11
+val_369	11
+val_316	11
+val_169	11
+val_413	11
+val_85	11
+val_77	11
+val_0	11
+val_490	11
+val_87	11
+val_364	11
+val_179	11
+val_118	11
+val_134	11
+val_395	11
+val_282	11
+val_138	11
+val_238	11
+val_419	11
+val_15	11
+val_118	11
+val_72	11
+val_90	11
+val_307	11
+val_19	11
+val_435	11
+val_10	11
+val_277	11
+val_273	11
+val_306	11
+val_224	11
+val_309	11
+val_389	11
+val_327	11
+val_242	11
+val_369	11
+val_392	11
+val_272	11
+val_331	11
+val_401	11
+val_242	11
+val_452	11
+val_177	11
+val_226	11
+val_5	11
+val_497	11
+val_402	11
+val_396	11
+val_317	11
+val_395	11
+val_58	11
+val_35	11
+val_336	11
+val_95	11
+val_11	11
+val_168	11
+val_34	11
+val_229	11
+val_233	11
+val_143	11
+val_472	11
+val_322	11
+val_498	11
+val_160	11
+val_195	11
+val_42	11
+val_321	11
+val_430	11
+val_119	11
+val_489	11
+val_458	11
+val_78	11
+val_76	11
+val_41	11
+val_223	11
+val_492	11
+val_149	11
+val_449	11
+val_218	11
+val_228	11
+val_138	11
+val_453	11
+val_30	11
+val_209	11
+val_64	11
+val_468	11
+val_76	11
+val_74	11
+val_342	11
+val_69	11
+val_230	11
+val_33	11
+val_368	11
+val_103	11
+val_296	11
+val_113	11
+val_216	11
+val_367	11
+val_344	11
+val_167	11
+val_274	11
+val_219	11
+val_239	11
+val_485	11
+val_116	11
+val_223	11
+val_256	11
+val_263	11
+val_70	11
+val_487	11
+val_480	11
+val_401	11
+val_288	11
+val_191	11
+val_5	11
+val_244	11
+val_438	11
+val_128	11
+val_467	11
+val_432	11
+val_202	11
+val_316	11
+val_229	11
+val_469	11
+val_463	11
+val_280	11
+val_2	11
+val_35	11
+val_283	11
+val_331	11
+val_235	11
+val_80	11
+val_44	11
+val_193	11
+val_321	11
+val_335	11
+val_104	11
+val_466	11
+val_366	11
+val_175	11
+val_403	11
+val_483	11
+val_53	11
+val_105	11
+val_257	11
+val_406	11
+val_409	11
+val_190	11
+val_406	11
+val_401	11
+val_114	11
+val_258	11
+val_90	11
+val_203	11
+val_262	11
+val_348	11
+val_424	11
+val_12	11
+val_396	11
+val_201	11
+val_217	11
+val_164	11
+val_431	11
+val_454	11
+val_478	11
+val_298	11
+val_125	11
+val_431	11
+val_164	11
+val_424	11
+val_187	11
+val_382	11
+val_5	11
+val_70	11
+val_397	11
+val_480	11
+val_291	11
+val_24	11
+val_351	11
+val_255	11
+val_104	11
+val_70	11
+val_163	11
+val_438	11
+val_119	11
+val_414	11
+val_200	11
+val_491	11
+val_237	11
+val_439	11
+val_360	11
+val_248	11
+val_479	11
+val_305	11
+val_417	11
+val_199	11
+val_444	11
+val_120	11
+val_429	11
+val_169	11
+val_443	11
+val_323	11
+val_325	11
+val_277	11
+val_230	11
+val_478	11
+val_178	11
+val_468	11
+val_310	11
+val_317	11
+val_333	11
+val_493	11
+val_460	11
+val_207	11
+val_249	11
+val_265	11
+val_480	11
+val_83	11
+val_136	11
+val_353	11
+val_172	11
+val_214	11
+val_462	11
+val_233	11
+val_406	11
+val_133	11
+val_175	11
+val_189	11
+val_454	11
+val_375	11
+val_401	11
+val_421	11
+val_407	11
+val_384	11
+val_256	11
+val_26	11
+val_134	11
+val_67	11
+val_384	11
+val_379	11
+val_18	11
+val_462	11
+val_492	11
+val_100	11
+val_298	11
+val_9	11
+val_341	11
+val_498	11
+val_146	11
+val_458	11
+val_362	11
+val_186	11
+val_285	11
+val_348	11
+val_167	11
+val_18	11
+val_273	11
+val_183	11
+val_281	11
+val_344	11
+val_97	11
+val_469	11
+val_315	11
+val_84	11
+val_28	11
+val_37	11
+val_448	11
+val_152	11
+val_348	11
+val_307	11
+val_194	11
+val_414	11
+val_477	11
+val_222	11
+val_126	11
+val_90	11
+val_169	11
+val_403	11
+val_400	11
+val_200	11
+val_97	11
+val_238	12
+val_86	12
+val_311	12
+val_27	12
+val_165	12
+val_409	12
+val_255	12
+val_278	12
+val_98	12
+val_484	12
+val_265	12
+val_193	12
+val_401	12
+val_150	12
+val_273	12
+val_224	12
+val_369	12
+val_66	12
+val_128	12
+val_213	12
+val_146	12
+val_406	12
+val_429	12
+val_374	12
+val_152	12
+val_469	12
+val_145	12
+val_495	12
+val_37	12
+val_327	12
+val_281	12
+val_277	12
+val_209	12
+val_15	12
+val_82	12
+val_403	12
+val_166	12
+val_417	12
+val_430	12
+val_252	12
+val_292	12
+val_219	12
+val_287	12
+val_153	12
+val_193	12
+val_338	12
+val_446	12
+val_459	12
+val_394	12
+val_237	12
+val_482	12
+val_174	12
+val_413	12
+val_494	12
+val_207	12
+val_199	12
+val_466	12
+val_208	12
+val_174	12
+val_399	12
+val_396	12
+val_247	12
+val_417	12
+val_489	12
+val_162	12
+val_377	12
+val_397	12
+val_309	12
+val_365	12
+val_266	12
+val_439	12
+val_342	12
+val_367	12
+val_325	12
+val_167	12
+val_195	12
+val_475	12
+val_17	12
+val_113	12
+val_155	12
+val_203	12
+val_339	12
+val_0	12
+val_455	12
+val_128	12
+val_311	12
+val_316	12
+val_57	12
+val_302	12
+val_205	12
+val_149	12
+val_438	12
+val_345	12
+val_129	12
+val_170	12
+val_20	12
+val_489	12
+val_157	12
+val_378	12
+val_221	12
+val_92	12
+val_111	12
+val_47	12
+val_72	12
+val_4	12
+val_280	12
+val_35	12
+val_427	12
+val_277	12
+val_208	12
+val_356	12
+val_399	12
+val_169	12
+val_382	12
+val_498	12
+val_125	12
+val_386	12
+val_437	12
+val_469	12
+val_192	12
+val_286	12
+val_187	12
+val_176	12
+val_54	12
+val_459	12
+val_51	12
+val_138	12
+val_103	12
+val_239	12
+val_213	12
+val_216	12
+val_430	12
+val_278	12
+val_176	12
+val_289	12
+val_221	12
+val_65	12
+val_318	12
+val_332	12
+val_311	12
+val_275	12
+val_137	12
+val_241	12
+val_83	12
+val_333	12
+val_180	12
+val_284	12
+val_12	12
+val_230	12
+val_181	12
+val_67	12
+val_260	12
+val_404	12
+val_384	12
+val_489	12
+val_353	12
+val_373	12
+val_272	12
+val_138	12
+val_217	12
+val_84	12
+val_348	12
+val_466	12
+val_58	12
+val_8	12
+val_411	12
+val_230	12
+val_208	12
+val_348	12
+val_24	12
+val_463	12
+val_431	12
+val_179	12
+val_172	12
+val_42	12
+val_129	12
+val_158	12
+val_119	12
+val_496	12
+val_0	12
+val_322	12
+val_197	12
+val_468	12
+val_393	12
+val_454	12
+val_100	12
+val_298	12
+val_199	12
+val_191	12
+val_418	12
+val_96	12
+val_26	12
+val_165	12
+val_327	12
+val_230	12
+val_205	12
+val_120	12
+val_131	12
+val_51	12
+val_404	12
+val_43	12
+val_436	12
+val_156	12
+val_469	12
+val_468	12
+val_308	12
+val_95	12
+val_196	12
+val_288	12
+val_481	12
+val_457	12
+val_98	12
+val_282	12
+val_197	12
+val_187	12
+val_318	12
+val_318	12
+val_409	12
+val_470	12
+val_137	12
+val_369	12
+val_316	12
+val_169	12
+val_413	12
+val_85	12
+val_77	12
+val_0	12
+val_490	12
+val_87	12
+val_364	12
+val_179	12
+val_118	12
+val_134	12
+val_395	12
+val_282	12
+val_138	12
+val_238	12
+val_419	12
+val_15	12
+val_118	12
+val_72	12
+val_90	12
+val_307	12
+val_19	12
+val_435	12
+val_10	12
+val_277	12
+val_273	12
+val_306	12
+val_224	12
+val_309	12
+val_389	12
+val_327	12
+val_242	12
+val_369	12
+val_392	12
+val_272	12
+val_331	12
+val_401	12
+val_242	12
+val_452	12
+val_177	12
+val_226	12
+val_5	12
+val_497	12
+val_402	12
+val_396	12
+val_317	12
+val_395	12
+val_58	12
+val_35	12
+val_336	12
+val_95	12
+val_11	12
+val_168	12
+val_34	12
+val_229	12
+val_233	12
+val_143	12
+val_472	12
+val_322	12
+val_498	12
+val_160	12
+val_195	12
+val_42	12
+val_321	12
+val_430	12
+val_119	12
+val_489	12
+val_458	12
+val_78	12
+val_76	12
+val_41	12
+val_223	12
+val_492	12
+val_149	12
+val_449	12
+val_218	12
+val_228	12
+val_138	12
+val_453	12
+val_30	12
+val_209	12
+val_64	12
+val_468	12
+val_76	12
+val_74	12
+val_342	12
+val_69	12
+val_230	12
+val_33	12
+val_368	12
+val_103	12
+val_296	12
+val_113	12
+val_216	12
+val_367	12
+val_344	12
+val_167	12
+val_274	12
+val_219	12
+val_239	12
+val_485	12
+val_116	12
+val_223	12
+val_256	12
+val_263	12
+val_70	12
+val_487	12
+val_480	12
+val_401	12
+val_288	12
+val_191	12
+val_5	12
+val_244	12
+val_438	12
+val_128	12
+val_467	12
+val_432	12
+val_202	12
+val_316	12
+val_229	12
+val_469	12
+val_463	12
+val_280	12
+val_2	12
+val_35	12
+val_283	12
+val_331	12
+val_235	12
+val_80	12
+val_44	12
+val_193	12
+val_321	12
+val_335	12
+val_104	12
+val_466	12
+val_366	12
+val_175	12
+val_403	12
+val_483	12
+val_53	12
+val_105	12
+val_257	12
+val_406	12
+val_409	12
+val_190	12
+val_406	12
+val_401	12
+val_114	12
+val_258	12
+val_90	12
+val_203	12
+val_262	12
+val_348	12
+val_424	12
+val_12	12
+val_396	12
+val_201	12
+val_217	12
+val_164	12
+val_431	12
+val_454	12
+val_478	12
+val_298	12
+val_125	12
+val_431	12
+val_164	12
+val_424	12
+val_187	12
+val_382	12
+val_5	12
+val_70	12
+val_397	12
+val_480	12
+val_291	12
+val_24	12
+val_351	12
+val_255	12
+val_104	12
+val_70	12
+val_163	12
+val_438	12
+val_119	12
+val_414	12
+val_200	12
+val_491	12
+val_237	12
+val_439	12
+val_360	12
+val_248	12
+val_479	12
+val_305	12
+val_417	12
+val_199	12
+val_444	12
+val_120	12
+val_429	12
+val_169	12
+val_443	12
+val_323	12
+val_325	12
+val_277	12
+val_230	12
+val_478	12
+val_178	12
+val_468	12
+val_310	12
+val_317	12
+val_333	12
+val_493	12
+val_460	12
+val_207	12
+val_249	12
+val_265	12
+val_480	12
+val_83	12
+val_136	12
+val_353	12
+val_172	12
+val_214	12
+val_462	12
+val_233	12
+val_406	12
+val_133	12
+val_175	12
+val_189	12
+val_454	12
+val_375	12
+val_401	12
+val_421	12
+val_407	12
+val_384	12
+val_256	12
+val_26	12
+val_134	12
+val_67	12
+val_384	12
+val_379	12
+val_18	12
+val_462	12
+val_492	12
+val_100	12
+val_298	12
+val_9	12
+val_341	12
+val_498	12
+val_146	12
+val_458	12
+val_362	12
+val_186	12
+val_285	12
+val_348	12
+val_167	12
+val_18	12
+val_273	12
+val_183	12
+val_281	12
+val_344	12
+val_97	12
+val_469	12
+val_315	12
+val_84	12
+val_28	12
+val_37	12
+val_448	12
+val_152	12
+val_348	12
+val_307	12
+val_194	12
+val_414	12
+val_477	12
+val_222	12
+val_126	12
+val_90	12
+val_169	12
+val_403	12
+val_400	12
+val_200	12
+val_97	12

http://git-wip-us.apache.org/repos/asf/spark/blob/7e17fe69/sql/hive/src/test/resources/golden/Partiton pruning: non-partitioned table - query test-0-681332efaff7b12e3ca12d9f021cd344
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/golden/Partiton pruning: non-partitioned table - query test-0-681332efaff7b12e3ca12d9f021cd344 b/sql/hive/src/test/resources/golden/Partiton pruning: non-partitioned table - query test-0-681332efaff7b12e3ca12d9f021cd344
new file mode 100644
index 0000000..7ba6caf
--- /dev/null
+++ b/sql/hive/src/test/resources/golden/Partiton pruning: non-partitioned table - query test-0-681332efaff7b12e3ca12d9f021cd344	
@@ -0,0 +1,500 @@
+val_238
+val_86
+val_311
+val_27
+val_165
+val_409
+val_255
+val_278
+val_98
+val_484
+val_265
+val_193
+val_401
+val_150
+val_273
+val_224
+val_369
+val_66
+val_128
+val_213
+val_146
+val_406
+val_429
+val_374
+val_152
+val_469
+val_145
+val_495
+val_37
+val_327
+val_281
+val_277
+val_209
+val_15
+val_82
+val_403
+val_166
+val_417
+val_430
+val_252
+val_292
+val_219
+val_287
+val_153
+val_193
+val_338
+val_446
+val_459
+val_394
+val_237
+val_482
+val_174
+val_413
+val_494
+val_207
+val_199
+val_466
+val_208
+val_174
+val_399
+val_396
+val_247
+val_417
+val_489
+val_162
+val_377
+val_397
+val_309
+val_365
+val_266
+val_439
+val_342
+val_367
+val_325
+val_167
+val_195
+val_475
+val_17
+val_113
+val_155
+val_203
+val_339
+val_0
+val_455
+val_128
+val_311
+val_316
+val_57
+val_302
+val_205
+val_149
+val_438
+val_345
+val_129
+val_170
+val_20
+val_489
+val_157
+val_378
+val_221
+val_92
+val_111
+val_47
+val_72
+val_4
+val_280
+val_35
+val_427
+val_277
+val_208
+val_356
+val_399
+val_169
+val_382
+val_498
+val_125
+val_386
+val_437
+val_469
+val_192
+val_286
+val_187
+val_176
+val_54
+val_459
+val_51
+val_138
+val_103
+val_239
+val_213
+val_216
+val_430
+val_278
+val_176
+val_289
+val_221
+val_65
+val_318
+val_332
+val_311
+val_275
+val_137
+val_241
+val_83
+val_333
+val_180
+val_284
+val_12
+val_230
+val_181
+val_67
+val_260
+val_404
+val_384
+val_489
+val_353
+val_373
+val_272
+val_138
+val_217
+val_84
+val_348
+val_466
+val_58
+val_8
+val_411
+val_230
+val_208
+val_348
+val_24
+val_463
+val_431
+val_179
+val_172
+val_42
+val_129
+val_158
+val_119
+val_496
+val_0
+val_322
+val_197
+val_468
+val_393
+val_454
+val_100
+val_298
+val_199
+val_191
+val_418
+val_96
+val_26
+val_165
+val_327
+val_230
+val_205
+val_120
+val_131
+val_51
+val_404
+val_43
+val_436
+val_156
+val_469
+val_468
+val_308
+val_95
+val_196
+val_288
+val_481
+val_457
+val_98
+val_282
+val_197
+val_187
+val_318
+val_318
+val_409
+val_470
+val_137
+val_369
+val_316
+val_169
+val_413
+val_85
+val_77
+val_0
+val_490
+val_87
+val_364
+val_179
+val_118
+val_134
+val_395
+val_282
+val_138
+val_238
+val_419
+val_15
+val_118
+val_72
+val_90
+val_307
+val_19
+val_435
+val_10
+val_277
+val_273
+val_306
+val_224
+val_309
+val_389
+val_327
+val_242
+val_369
+val_392
+val_272
+val_331
+val_401
+val_242
+val_452
+val_177
+val_226
+val_5
+val_497
+val_402
+val_396
+val_317
+val_395
+val_58
+val_35
+val_336
+val_95
+val_11
+val_168
+val_34
+val_229
+val_233
+val_143
+val_472
+val_322
+val_498
+val_160
+val_195
+val_42
+val_321
+val_430
+val_119
+val_489
+val_458
+val_78
+val_76
+val_41
+val_223
+val_492
+val_149
+val_449
+val_218
+val_228
+val_138
+val_453
+val_30
+val_209
+val_64
+val_468
+val_76
+val_74
+val_342
+val_69
+val_230
+val_33
+val_368
+val_103
+val_296
+val_113
+val_216
+val_367
+val_344
+val_167
+val_274
+val_219
+val_239
+val_485
+val_116
+val_223
+val_256
+val_263
+val_70
+val_487
+val_480
+val_401
+val_288
+val_191
+val_5
+val_244
+val_438
+val_128
+val_467
+val_432
+val_202
+val_316
+val_229
+val_469
+val_463
+val_280
+val_2
+val_35
+val_283
+val_331
+val_235
+val_80
+val_44
+val_193
+val_321
+val_335
+val_104
+val_466
+val_366
+val_175
+val_403
+val_483
+val_53
+val_105
+val_257
+val_406
+val_409
+val_190
+val_406
+val_401
+val_114
+val_258
+val_90
+val_203
+val_262
+val_348
+val_424
+val_12
+val_396
+val_201
+val_217
+val_164
+val_431
+val_454
+val_478
+val_298
+val_125
+val_431
+val_164
+val_424
+val_187
+val_382
+val_5
+val_70
+val_397
+val_480
+val_291
+val_24
+val_351
+val_255
+val_104
+val_70
+val_163
+val_438
+val_119
+val_414
+val_200
+val_491
+val_237
+val_439
+val_360
+val_248
+val_479
+val_305
+val_417
+val_199
+val_444
+val_120
+val_429
+val_169
+val_443
+val_323
+val_325
+val_277
+val_230
+val_478
+val_178
+val_468
+val_310
+val_317
+val_333
+val_493
+val_460
+val_207
+val_249
+val_265
+val_480
+val_83
+val_136
+val_353
+val_172
+val_214
+val_462
+val_233
+val_406
+val_133
+val_175
+val_189
+val_454
+val_375
+val_401
+val_421
+val_407
+val_384
+val_256
+val_26
+val_134
+val_67
+val_384
+val_379
+val_18
+val_462
+val_492
+val_100
+val_298
+val_9
+val_341
+val_498
+val_146
+val_458
+val_362
+val_186
+val_285
+val_348
+val_167
+val_18
+val_273
+val_183
+val_281
+val_344
+val_97
+val_469
+val_315
+val_84
+val_28
+val_37
+val_448
+val_152
+val_348
+val_307
+val_194
+val_414
+val_477
+val_222
+val_126
+val_90
+val_169
+val_403
+val_400
+val_200
+val_97

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

http://git-wip-us.apache.org/repos/asf/spark/blob/7e17fe69/sql/hive/src/test/resources/golden/Read with AvroSerDe-0-805f15ffbb03db90ec5757b328666d04
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/golden/Read with AvroSerDe-0-805f15ffbb03db90ec5757b328666d04 b/sql/hive/src/test/resources/golden/Read with AvroSerDe-0-805f15ffbb03db90ec5757b328666d04
new file mode 100644
index 0000000..ee2a405
--- /dev/null
+++ b/sql/hive/src/test/resources/golden/Read with AvroSerDe-0-805f15ffbb03db90ec5757b328666d04	
@@ -0,0 +1,8 @@
+The Eleventh Hour	3 April 2010	11
+The Doctor's Wife	14 May 2011	11
+Horror of Fang Rock	3 September 1977	4
+An Unearthly Child	23 November 1963	1
+The Mysterious Planet	6 September 1986	6
+Rose	26 March 2005	9
+The Power of the Daleks	5 November 1966	2
+Castrolava	4 January 1982	5

http://git-wip-us.apache.org/repos/asf/spark/blob/7e17fe69/sql/hive/src/test/resources/golden/Read with RegexSerDe-0-9b96fab8d55a0e19fae00d8adb57ffaa
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/golden/Read with RegexSerDe-0-9b96fab8d55a0e19fae00d8adb57ffaa b/sql/hive/src/test/resources/golden/Read with RegexSerDe-0-9b96fab8d55a0e19fae00d8adb57ffaa
new file mode 100644
index 0000000..6407b72
--- /dev/null
+++ b/sql/hive/src/test/resources/golden/Read with RegexSerDe-0-9b96fab8d55a0e19fae00d8adb57ffaa	
@@ -0,0 +1,2 @@
+Joe	2
+Hank	2

http://git-wip-us.apache.org/repos/asf/spark/blob/7e17fe69/sql/hive/src/test/resources/golden/Simple Average + 1 with group-0-f52ca483a3e5eadc1b20ba8320d029a7
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/golden/Simple Average + 1 with group-0-f52ca483a3e5eadc1b20ba8320d029a7 b/sql/hive/src/test/resources/golden/Simple Average + 1 with group-0-f52ca483a3e5eadc1b20ba8320d029a7
new file mode 100644
index 0000000..595d7af
--- /dev/null
+++ b/sql/hive/src/test/resources/golden/Simple Average + 1 with group-0-f52ca483a3e5eadc1b20ba8320d029a7	
@@ -0,0 +1,309 @@
+1.0	val_0
+11.0	val_10
+101.0	val_100
+104.0	val_103
+105.0	val_104
+106.0	val_105
+12.0	val_11
+112.0	val_111
+114.0	val_113
+115.0	val_114
+117.0	val_116
+119.0	val_118
+120.0	val_119
+13.0	val_12
+121.0	val_120
+126.0	val_125
+127.0	val_126
+129.0	val_128
+130.0	val_129
+132.0	val_131
+134.0	val_133
+135.0	val_134
+137.0	val_136
+138.0	val_137
+139.0	val_138
+144.0	val_143
+146.0	val_145
+147.0	val_146
+150.0	val_149
+16.0	val_15
+151.0	val_150
+153.0	val_152
+154.0	val_153
+156.0	val_155
+157.0	val_156
+158.0	val_157
+159.0	val_158
+161.0	val_160
+163.0	val_162
+164.0	val_163
+165.0	val_164
+166.0	val_165
+167.0	val_166
+168.0	val_167
+169.0	val_168
+170.0	val_169
+18.0	val_17
+171.0	val_170
+173.0	val_172
+175.0	val_174
+176.0	val_175
+177.0	val_176
+178.0	val_177
+179.0	val_178
+180.0	val_179
+19.0	val_18
+181.0	val_180
+182.0	val_181
+184.0	val_183
+187.0	val_186
+188.0	val_187
+190.0	val_189
+20.0	val_19
+191.0	val_190
+192.0	val_191
+193.0	val_192
+194.0	val_193
+195.0	val_194
+196.0	val_195
+197.0	val_196
+198.0	val_197
+200.0	val_199
+3.0	val_2
+21.0	val_20
+201.0	val_200
+202.0	val_201
+203.0	val_202
+204.0	val_203
+206.0	val_205
+208.0	val_207
+209.0	val_208
+210.0	val_209
+214.0	val_213
+215.0	val_214
+217.0	val_216
+218.0	val_217
+219.0	val_218
+220.0	val_219
+222.0	val_221
+223.0	val_222
+224.0	val_223
+225.0	val_224
+227.0	val_226
+229.0	val_228
+230.0	val_229
+231.0	val_230
+234.0	val_233
+236.0	val_235
+238.0	val_237
+239.0	val_238
+240.0	val_239
+25.0	val_24
+242.0	val_241
+243.0	val_242
+245.0	val_244
+248.0	val_247
+249.0	val_248
+250.0	val_249
+253.0	val_252
+256.0	val_255
+257.0	val_256
+258.0	val_257
+259.0	val_258
+27.0	val_26
+261.0	val_260
+263.0	val_262
+264.0	val_263
+266.0	val_265
+267.0	val_266
+28.0	val_27
+273.0	val_272
+274.0	val_273
+275.0	val_274
+276.0	val_275
+278.0	val_277
+279.0	val_278
+29.0	val_28
+281.0	val_280
+282.0	val_281
+283.0	val_282
+284.0	val_283
+285.0	val_284
+286.0	val_285
+287.0	val_286
+288.0	val_287
+289.0	val_288
+290.0	val_289
+292.0	val_291
+293.0	val_292
+297.0	val_296
+299.0	val_298
+31.0	val_30
+303.0	val_302
+306.0	val_305
+307.0	val_306
+308.0	val_307
+309.0	val_308
+310.0	val_309
+311.0	val_310
+312.0	val_311
+316.0	val_315
+317.0	val_316
+318.0	val_317
+319.0	val_318
+322.0	val_321
+323.0	val_322
+324.0	val_323
+326.0	val_325
+328.0	val_327
+34.0	val_33
+332.0	val_331
+333.0	val_332
+334.0	val_333
+336.0	val_335
+337.0	val_336
+339.0	val_338
+340.0	val_339
+35.0	val_34
+342.0	val_341
+343.0	val_342
+345.0	val_344
+346.0	val_345
+349.0	val_348
+36.0	val_35
+352.0	val_351
+354.0	val_353
+357.0	val_356
+361.0	val_360
+363.0	val_362
+365.0	val_364
+366.0	val_365
+367.0	val_366
+368.0	val_367
+369.0	val_368
+370.0	val_369
+38.0	val_37
+374.0	val_373
+375.0	val_374
+376.0	val_375
+378.0	val_377
+379.0	val_378
+380.0	val_379
+383.0	val_382
+385.0	val_384
+387.0	val_386
+390.0	val_389
+393.0	val_392
+394.0	val_393
+395.0	val_394
+396.0	val_395
+397.0	val_396
+398.0	val_397
+400.0	val_399
+5.0	val_4
+401.0	val_400
+402.0	val_401
+403.0	val_402
+404.0	val_403
+405.0	val_404
+407.0	val_406
+408.0	val_407
+410.0	val_409
+42.0	val_41
+412.0	val_411
+414.0	val_413
+415.0	val_414
+418.0	val_417
+419.0	val_418
+420.0	val_419
+43.0	val_42
+422.0	val_421
+425.0	val_424
+428.0	val_427
+430.0	val_429
+44.0	val_43
+431.0	val_430
+432.0	val_431
+433.0	val_432
+436.0	val_435
+437.0	val_436
+438.0	val_437
+439.0	val_438
+440.0	val_439
+45.0	val_44
+444.0	val_443
+445.0	val_444
+447.0	val_446
+449.0	val_448
+450.0	val_449
+453.0	val_452
+454.0	val_453
+455.0	val_454
+456.0	val_455
+458.0	val_457
+459.0	val_458
+460.0	val_459
+461.0	val_460
+463.0	val_462
+464.0	val_463
+467.0	val_466
+468.0	val_467
+469.0	val_468
+470.0	val_469
+48.0	val_47
+471.0	val_470
+473.0	val_472
+476.0	val_475
+478.0	val_477
+479.0	val_478
+480.0	val_479
+481.0	val_480
+482.0	val_481
+483.0	val_482
+484.0	val_483
+485.0	val_484
+486.0	val_485
+488.0	val_487
+490.0	val_489
+491.0	val_490
+492.0	val_491
+493.0	val_492
+494.0	val_493
+495.0	val_494
+496.0	val_495
+497.0	val_496
+498.0	val_497
+499.0	val_498
+6.0	val_5
+52.0	val_51
+54.0	val_53
+55.0	val_54
+58.0	val_57
+59.0	val_58
+65.0	val_64
+66.0	val_65
+67.0	val_66
+68.0	val_67
+70.0	val_69
+71.0	val_70
+73.0	val_72
+75.0	val_74
+77.0	val_76
+78.0	val_77
+79.0	val_78
+9.0	val_8
+81.0	val_80
+83.0	val_82
+84.0	val_83
+85.0	val_84
+86.0	val_85
+87.0	val_86
+88.0	val_87
+10.0	val_9
+91.0	val_90
+93.0	val_92
+96.0	val_95
+97.0	val_96
+98.0	val_97
+99.0	val_98
\ No newline at end of file

http://git-wip-us.apache.org/repos/asf/spark/blob/7e17fe69/sql/hive/src/test/resources/golden/Simple Average + 1-0-5e296b921c470f0f0b5d099f28bd5935
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/golden/Simple Average + 1-0-5e296b921c470f0f0b5d099f28bd5935 b/sql/hive/src/test/resources/golden/Simple Average + 1-0-5e296b921c470f0f0b5d099f28bd5935
new file mode 100644
index 0000000..3d2dbbd
--- /dev/null
+++ b/sql/hive/src/test/resources/golden/Simple Average + 1-0-5e296b921c470f0f0b5d099f28bd5935	
@@ -0,0 +1 @@
+261.182
\ No newline at end of file

http://git-wip-us.apache.org/repos/asf/spark/blob/7e17fe69/sql/hive/src/test/resources/golden/Simple Average-0-c197ea78c4d8f85f1a317805b6da07e5
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/golden/Simple Average-0-c197ea78c4d8f85f1a317805b6da07e5 b/sql/hive/src/test/resources/golden/Simple Average-0-c197ea78c4d8f85f1a317805b6da07e5
new file mode 100644
index 0000000..cbc70c8
--- /dev/null
+++ b/sql/hive/src/test/resources/golden/Simple Average-0-c197ea78c4d8f85f1a317805b6da07e5	
@@ -0,0 +1 @@
+260.182
\ No newline at end of file

http://git-wip-us.apache.org/repos/asf/spark/blob/7e17fe69/sql/hive/src/test/resources/golden/add_part_exist-0-e58d09864bc6898e44fae80abe328702
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/golden/add_part_exist-0-e58d09864bc6898e44fae80abe328702 b/sql/hive/src/test/resources/golden/add_part_exist-0-e58d09864bc6898e44fae80abe328702
new file mode 100644
index 0000000..e69de29

http://git-wip-us.apache.org/repos/asf/spark/blob/7e17fe69/sql/hive/src/test/resources/golden/add_part_exist-1-d824f22606f48dfca48ce241a7505f5b
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/golden/add_part_exist-1-d824f22606f48dfca48ce241a7505f5b b/sql/hive/src/test/resources/golden/add_part_exist-1-d824f22606f48dfca48ce241a7505f5b
new file mode 100644
index 0000000..e69de29

http://git-wip-us.apache.org/repos/asf/spark/blob/7e17fe69/sql/hive/src/test/resources/golden/add_part_exist-10-ecb27eb754e731429659224b5b6ac583
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/golden/add_part_exist-10-ecb27eb754e731429659224b5b6ac583 b/sql/hive/src/test/resources/golden/add_part_exist-10-ecb27eb754e731429659224b5b6ac583
new file mode 100644
index 0000000..e69de29

http://git-wip-us.apache.org/repos/asf/spark/blob/7e17fe69/sql/hive/src/test/resources/golden/add_part_exist-11-9c36cac1372650b703400c60dd29042c
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/golden/add_part_exist-11-9c36cac1372650b703400c60dd29042c b/sql/hive/src/test/resources/golden/add_part_exist-11-9c36cac1372650b703400c60dd29042c
new file mode 100644
index 0000000..ecafeae
--- /dev/null
+++ b/sql/hive/src/test/resources/golden/add_part_exist-11-9c36cac1372650b703400c60dd29042c
@@ -0,0 +1,2 @@
+src
+srcpart
\ No newline at end of file

http://git-wip-us.apache.org/repos/asf/spark/blob/7e17fe69/sql/hive/src/test/resources/golden/add_part_exist-12-2900a5065dd3adbb0b56a712bf848750
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/golden/add_part_exist-12-2900a5065dd3adbb0b56a712bf848750 b/sql/hive/src/test/resources/golden/add_part_exist-12-2900a5065dd3adbb0b56a712bf848750
new file mode 100644
index 0000000..e69de29

http://git-wip-us.apache.org/repos/asf/spark/blob/7e17fe69/sql/hive/src/test/resources/golden/add_part_exist-13-d69279050a0f44c3f8b775698fd29be0
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/golden/add_part_exist-13-d69279050a0f44c3f8b775698fd29be0 b/sql/hive/src/test/resources/golden/add_part_exist-13-d69279050a0f44c3f8b775698fd29be0
new file mode 100644
index 0000000..e69de29

http://git-wip-us.apache.org/repos/asf/spark/blob/7e17fe69/sql/hive/src/test/resources/golden/add_part_exist-14-9c36cac1372650b703400c60dd29042c
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/golden/add_part_exist-14-9c36cac1372650b703400c60dd29042c b/sql/hive/src/test/resources/golden/add_part_exist-14-9c36cac1372650b703400c60dd29042c
new file mode 100644
index 0000000..e69de29

http://git-wip-us.apache.org/repos/asf/spark/blob/7e17fe69/sql/hive/src/test/resources/golden/add_part_exist-15-e58d09864bc6898e44fae80abe328702
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/golden/add_part_exist-15-e58d09864bc6898e44fae80abe328702 b/sql/hive/src/test/resources/golden/add_part_exist-15-e58d09864bc6898e44fae80abe328702
new file mode 100644
index 0000000..e69de29

http://git-wip-us.apache.org/repos/asf/spark/blob/7e17fe69/sql/hive/src/test/resources/golden/add_part_exist-16-d824f22606f48dfca48ce241a7505f5b
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/golden/add_part_exist-16-d824f22606f48dfca48ce241a7505f5b b/sql/hive/src/test/resources/golden/add_part_exist-16-d824f22606f48dfca48ce241a7505f5b
new file mode 100644
index 0000000..e69de29

http://git-wip-us.apache.org/repos/asf/spark/blob/7e17fe69/sql/hive/src/test/resources/golden/add_part_exist-17-3432935e802ae46c6b2151cc4ebf783b
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/golden/add_part_exist-17-3432935e802ae46c6b2151cc4ebf783b b/sql/hive/src/test/resources/golden/add_part_exist-17-3432935e802ae46c6b2151cc4ebf783b
new file mode 100644
index 0000000..e69de29

http://git-wip-us.apache.org/repos/asf/spark/blob/7e17fe69/sql/hive/src/test/resources/golden/add_part_exist-18-d824f22606f48dfca48ce241a7505f5b
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/golden/add_part_exist-18-d824f22606f48dfca48ce241a7505f5b b/sql/hive/src/test/resources/golden/add_part_exist-18-d824f22606f48dfca48ce241a7505f5b
new file mode 100644
index 0000000..f1ea8b0
--- /dev/null
+++ b/sql/hive/src/test/resources/golden/add_part_exist-18-d824f22606f48dfca48ce241a7505f5b
@@ -0,0 +1 @@
+ds=2010-01-01
\ No newline at end of file

http://git-wip-us.apache.org/repos/asf/spark/blob/7e17fe69/sql/hive/src/test/resources/golden/add_part_exist-19-83cecdbfddb070a417050f9a18fff752
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/golden/add_part_exist-19-83cecdbfddb070a417050f9a18fff752 b/sql/hive/src/test/resources/golden/add_part_exist-19-83cecdbfddb070a417050f9a18fff752
new file mode 100644
index 0000000..e69de29

http://git-wip-us.apache.org/repos/asf/spark/blob/7e17fe69/sql/hive/src/test/resources/golden/add_part_exist-2-3432935e802ae46c6b2151cc4ebf783b
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/golden/add_part_exist-2-3432935e802ae46c6b2151cc4ebf783b b/sql/hive/src/test/resources/golden/add_part_exist-2-3432935e802ae46c6b2151cc4ebf783b
new file mode 100644
index 0000000..e69de29

http://git-wip-us.apache.org/repos/asf/spark/blob/7e17fe69/sql/hive/src/test/resources/golden/add_part_exist-20-d824f22606f48dfca48ce241a7505f5b
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/golden/add_part_exist-20-d824f22606f48dfca48ce241a7505f5b b/sql/hive/src/test/resources/golden/add_part_exist-20-d824f22606f48dfca48ce241a7505f5b
new file mode 100644
index 0000000..f1ea8b0
--- /dev/null
+++ b/sql/hive/src/test/resources/golden/add_part_exist-20-d824f22606f48dfca48ce241a7505f5b
@@ -0,0 +1 @@
+ds=2010-01-01
\ No newline at end of file

http://git-wip-us.apache.org/repos/asf/spark/blob/7e17fe69/sql/hive/src/test/resources/golden/add_part_exist-21-2df4b20f67e7f15d3f4150bcfea43b0f
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/golden/add_part_exist-21-2df4b20f67e7f15d3f4150bcfea43b0f b/sql/hive/src/test/resources/golden/add_part_exist-21-2df4b20f67e7f15d3f4150bcfea43b0f
new file mode 100644
index 0000000..e69de29

http://git-wip-us.apache.org/repos/asf/spark/blob/7e17fe69/sql/hive/src/test/resources/golden/add_part_exist-22-d824f22606f48dfca48ce241a7505f5b
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/golden/add_part_exist-22-d824f22606f48dfca48ce241a7505f5b b/sql/hive/src/test/resources/golden/add_part_exist-22-d824f22606f48dfca48ce241a7505f5b
new file mode 100644
index 0000000..121aebd
--- /dev/null
+++ b/sql/hive/src/test/resources/golden/add_part_exist-22-d824f22606f48dfca48ce241a7505f5b
@@ -0,0 +1,2 @@
+ds=2010-01-01
+ds=2010-01-02
\ No newline at end of file

http://git-wip-us.apache.org/repos/asf/spark/blob/7e17fe69/sql/hive/src/test/resources/golden/add_part_exist-23-a3859b63665ce3bbfd19683e6e694dcb
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/golden/add_part_exist-23-a3859b63665ce3bbfd19683e6e694dcb b/sql/hive/src/test/resources/golden/add_part_exist-23-a3859b63665ce3bbfd19683e6e694dcb
new file mode 100644
index 0000000..e69de29

http://git-wip-us.apache.org/repos/asf/spark/blob/7e17fe69/sql/hive/src/test/resources/golden/add_part_exist-24-d824f22606f48dfca48ce241a7505f5b
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/golden/add_part_exist-24-d824f22606f48dfca48ce241a7505f5b b/sql/hive/src/test/resources/golden/add_part_exist-24-d824f22606f48dfca48ce241a7505f5b
new file mode 100644
index 0000000..64467c1
--- /dev/null
+++ b/sql/hive/src/test/resources/golden/add_part_exist-24-d824f22606f48dfca48ce241a7505f5b
@@ -0,0 +1,3 @@
+ds=2010-01-01
+ds=2010-01-02
+ds=2010-01-03
\ No newline at end of file

http://git-wip-us.apache.org/repos/asf/spark/blob/7e17fe69/sql/hive/src/test/resources/golden/add_part_exist-3-d824f22606f48dfca48ce241a7505f5b
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/golden/add_part_exist-3-d824f22606f48dfca48ce241a7505f5b b/sql/hive/src/test/resources/golden/add_part_exist-3-d824f22606f48dfca48ce241a7505f5b
new file mode 100644
index 0000000..f1ea8b0
--- /dev/null
+++ b/sql/hive/src/test/resources/golden/add_part_exist-3-d824f22606f48dfca48ce241a7505f5b
@@ -0,0 +1 @@
+ds=2010-01-01
\ No newline at end of file

http://git-wip-us.apache.org/repos/asf/spark/blob/7e17fe69/sql/hive/src/test/resources/golden/add_part_exist-4-83cecdbfddb070a417050f9a18fff752
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/golden/add_part_exist-4-83cecdbfddb070a417050f9a18fff752 b/sql/hive/src/test/resources/golden/add_part_exist-4-83cecdbfddb070a417050f9a18fff752
new file mode 100644
index 0000000..e69de29

http://git-wip-us.apache.org/repos/asf/spark/blob/7e17fe69/sql/hive/src/test/resources/golden/add_part_exist-5-d824f22606f48dfca48ce241a7505f5b
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/golden/add_part_exist-5-d824f22606f48dfca48ce241a7505f5b b/sql/hive/src/test/resources/golden/add_part_exist-5-d824f22606f48dfca48ce241a7505f5b
new file mode 100644
index 0000000..f1ea8b0
--- /dev/null
+++ b/sql/hive/src/test/resources/golden/add_part_exist-5-d824f22606f48dfca48ce241a7505f5b
@@ -0,0 +1 @@
+ds=2010-01-01
\ No newline at end of file

http://git-wip-us.apache.org/repos/asf/spark/blob/7e17fe69/sql/hive/src/test/resources/golden/add_part_exist-6-2df4b20f67e7f15d3f4150bcfea43b0f
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/golden/add_part_exist-6-2df4b20f67e7f15d3f4150bcfea43b0f b/sql/hive/src/test/resources/golden/add_part_exist-6-2df4b20f67e7f15d3f4150bcfea43b0f
new file mode 100644
index 0000000..e69de29

http://git-wip-us.apache.org/repos/asf/spark/blob/7e17fe69/sql/hive/src/test/resources/golden/add_part_exist-7-d824f22606f48dfca48ce241a7505f5b
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/golden/add_part_exist-7-d824f22606f48dfca48ce241a7505f5b b/sql/hive/src/test/resources/golden/add_part_exist-7-d824f22606f48dfca48ce241a7505f5b
new file mode 100644
index 0000000..121aebd
--- /dev/null
+++ b/sql/hive/src/test/resources/golden/add_part_exist-7-d824f22606f48dfca48ce241a7505f5b
@@ -0,0 +1,2 @@
+ds=2010-01-01
+ds=2010-01-02
\ No newline at end of file

http://git-wip-us.apache.org/repos/asf/spark/blob/7e17fe69/sql/hive/src/test/resources/golden/add_part_exist-8-a3859b63665ce3bbfd19683e6e694dcb
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/golden/add_part_exist-8-a3859b63665ce3bbfd19683e6e694dcb b/sql/hive/src/test/resources/golden/add_part_exist-8-a3859b63665ce3bbfd19683e6e694dcb
new file mode 100644
index 0000000..e69de29

http://git-wip-us.apache.org/repos/asf/spark/blob/7e17fe69/sql/hive/src/test/resources/golden/add_part_exist-9-d824f22606f48dfca48ce241a7505f5b
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/golden/add_part_exist-9-d824f22606f48dfca48ce241a7505f5b b/sql/hive/src/test/resources/golden/add_part_exist-9-d824f22606f48dfca48ce241a7505f5b
new file mode 100644
index 0000000..64467c1
--- /dev/null
+++ b/sql/hive/src/test/resources/golden/add_part_exist-9-d824f22606f48dfca48ce241a7505f5b
@@ -0,0 +1,3 @@
+ds=2010-01-01
+ds=2010-01-02
+ds=2010-01-03
\ No newline at end of file

http://git-wip-us.apache.org/repos/asf/spark/blob/7e17fe69/sql/hive/src/test/resources/golden/add_part_multiple-0-9c55143a4c92f0cfe7669f7681d7aa98
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/golden/add_part_multiple-0-9c55143a4c92f0cfe7669f7681d7aa98 b/sql/hive/src/test/resources/golden/add_part_multiple-0-9c55143a4c92f0cfe7669f7681d7aa98
new file mode 100644
index 0000000..e69de29

http://git-wip-us.apache.org/repos/asf/spark/blob/7e17fe69/sql/hive/src/test/resources/golden/add_part_multiple-1-4d9d4efbabc9fffef8841cc049f479c1
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/golden/add_part_multiple-1-4d9d4efbabc9fffef8841cc049f479c1 b/sql/hive/src/test/resources/golden/add_part_multiple-1-4d9d4efbabc9fffef8841cc049f479c1
new file mode 100644
index 0000000..da21345
--- /dev/null
+++ b/sql/hive/src/test/resources/golden/add_part_multiple-1-4d9d4efbabc9fffef8841cc049f479c1
@@ -0,0 +1,29 @@
+ABSTRACT SYNTAX TREE:
+  (TOK_ALTERTABLE_ADDPARTS add_part_test TOK_IFNOTEXISTS (TOK_PARTSPEC (TOK_PARTVAL ds '2010-01-01')) (TOK_PARTITIONLOCATION 'A') (TOK_PARTSPEC (TOK_PARTVAL ds '2010-02-01')) (TOK_PARTITIONLOCATION 'B') (TOK_PARTSPEC (TOK_PARTVAL ds '2010-03-01')) (TOK_PARTSPEC (TOK_PARTVAL ds '2010-04-01')) (TOK_PARTITIONLOCATION 'C'))
+
+STAGE DEPENDENCIES:
+  Stage-0 is a root stage
+  Stage-1 is a root stage
+  Stage-2 is a root stage
+  Stage-3 is a root stage
+
+STAGE PLANS:
+  Stage: Stage-0
+      Add Partition Operator:
+          Location: A
+          Spec: {ds=2010-01-01}
+
+  Stage: Stage-1
+      Add Partition Operator:
+          Location: B
+          Spec: {ds=2010-02-01}
+
+  Stage: Stage-2
+      Add Partition Operator:
+          Spec: {ds=2010-03-01}
+
+  Stage: Stage-3
+      Add Partition Operator:
+          Location: C
+          Spec: {ds=2010-04-01}
+

http://git-wip-us.apache.org/repos/asf/spark/blob/7e17fe69/sql/hive/src/test/resources/golden/add_part_multiple-2-187930e0daa44eed17e092e961ab7955
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/golden/add_part_multiple-2-187930e0daa44eed17e092e961ab7955 b/sql/hive/src/test/resources/golden/add_part_multiple-2-187930e0daa44eed17e092e961ab7955
new file mode 100644
index 0000000..e69de29

http://git-wip-us.apache.org/repos/asf/spark/blob/7e17fe69/sql/hive/src/test/resources/golden/add_part_multiple-3-59fb141ee5c3e8f9463fe0478dbfd7ef
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/golden/add_part_multiple-3-59fb141ee5c3e8f9463fe0478dbfd7ef b/sql/hive/src/test/resources/golden/add_part_multiple-3-59fb141ee5c3e8f9463fe0478dbfd7ef
new file mode 100644
index 0000000..e69de29

http://git-wip-us.apache.org/repos/asf/spark/blob/7e17fe69/sql/hive/src/test/resources/golden/add_part_multiple-4-7950c676506564b085b41426ed41747c
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/golden/add_part_multiple-4-7950c676506564b085b41426ed41747c b/sql/hive/src/test/resources/golden/add_part_multiple-4-7950c676506564b085b41426ed41747c
new file mode 100644
index 0000000..fc4021c
--- /dev/null
+++ b/sql/hive/src/test/resources/golden/add_part_multiple-4-7950c676506564b085b41426ed41747c
@@ -0,0 +1,4 @@
+100	100	2010-01-01
+200	200	2010-02-01
+400	300	2010-03-01
+500	400	2010-04-01
\ No newline at end of file

http://git-wip-us.apache.org/repos/asf/spark/blob/7e17fe69/sql/hive/src/test/resources/golden/add_partition_no_whitelist-0-3806584ff765bca682594008b90fc304
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/golden/add_partition_no_whitelist-0-3806584ff765bca682594008b90fc304 b/sql/hive/src/test/resources/golden/add_partition_no_whitelist-0-3806584ff765bca682594008b90fc304
new file mode 100644
index 0000000..c227083
--- /dev/null
+++ b/sql/hive/src/test/resources/golden/add_partition_no_whitelist-0-3806584ff765bca682594008b90fc304
@@ -0,0 +1 @@
+0
\ No newline at end of file

http://git-wip-us.apache.org/repos/asf/spark/blob/7e17fe69/sql/hive/src/test/resources/golden/add_partition_no_whitelist-1-22eb96fe7d338e488182b5755c90d5af
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/golden/add_partition_no_whitelist-1-22eb96fe7d338e488182b5755c90d5af b/sql/hive/src/test/resources/golden/add_partition_no_whitelist-1-22eb96fe7d338e488182b5755c90d5af
new file mode 100644
index 0000000..e69de29

http://git-wip-us.apache.org/repos/asf/spark/blob/7e17fe69/sql/hive/src/test/resources/golden/add_partition_no_whitelist-2-923fa18234ae73103c43722f70e000c0
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/golden/add_partition_no_whitelist-2-923fa18234ae73103c43722f70e000c0 b/sql/hive/src/test/resources/golden/add_partition_no_whitelist-2-923fa18234ae73103c43722f70e000c0
new file mode 100644
index 0000000..e69de29

http://git-wip-us.apache.org/repos/asf/spark/blob/7e17fe69/sql/hive/src/test/resources/golden/add_partition_no_whitelist-3-b7c0bb09609fabad407feb6fdf2c748f
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/golden/add_partition_no_whitelist-3-b7c0bb09609fabad407feb6fdf2c748f b/sql/hive/src/test/resources/golden/add_partition_no_whitelist-3-b7c0bb09609fabad407feb6fdf2c748f
new file mode 100644
index 0000000..e69de29

http://git-wip-us.apache.org/repos/asf/spark/blob/7e17fe69/sql/hive/src/test/resources/golden/add_partition_with_whitelist-0-3c23ae800b2f6fb93620890da2dba196
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/golden/add_partition_with_whitelist-0-3c23ae800b2f6fb93620890da2dba196 b/sql/hive/src/test/resources/golden/add_partition_with_whitelist-0-3c23ae800b2f6fb93620890da2dba196
new file mode 100644
index 0000000..c227083
--- /dev/null
+++ b/sql/hive/src/test/resources/golden/add_partition_with_whitelist-0-3c23ae800b2f6fb93620890da2dba196
@@ -0,0 +1 @@
+0
\ No newline at end of file

http://git-wip-us.apache.org/repos/asf/spark/blob/7e17fe69/sql/hive/src/test/resources/golden/add_partition_with_whitelist-1-67a0dbca9fecb7d34cceeecf2184c484
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/golden/add_partition_with_whitelist-1-67a0dbca9fecb7d34cceeecf2184c484 b/sql/hive/src/test/resources/golden/add_partition_with_whitelist-1-67a0dbca9fecb7d34cceeecf2184c484
new file mode 100644
index 0000000..e69de29

http://git-wip-us.apache.org/repos/asf/spark/blob/7e17fe69/sql/hive/src/test/resources/golden/add_partition_with_whitelist-2-e6a91be97431de63e372088d370c6d36
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/golden/add_partition_with_whitelist-2-e6a91be97431de63e372088d370c6d36 b/sql/hive/src/test/resources/golden/add_partition_with_whitelist-2-e6a91be97431de63e372088d370c6d36
new file mode 100644
index 0000000..e69de29

http://git-wip-us.apache.org/repos/asf/spark/blob/7e17fe69/sql/hive/src/test/resources/golden/add_partition_with_whitelist-3-b9a6b4e8acbfea5e1938eda085c4b893
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/golden/add_partition_with_whitelist-3-b9a6b4e8acbfea5e1938eda085c4b893 b/sql/hive/src/test/resources/golden/add_partition_with_whitelist-3-b9a6b4e8acbfea5e1938eda085c4b893
new file mode 100644
index 0000000..e69de29

http://git-wip-us.apache.org/repos/asf/spark/blob/7e17fe69/sql/hive/src/test/resources/golden/alias.*-0-7bdb861d11e895aaea545810cdac316d
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/golden/alias.*-0-7bdb861d11e895aaea545810cdac316d b/sql/hive/src/test/resources/golden/alias.*-0-7bdb861d11e895aaea545810cdac316d
new file mode 100644
index 0000000..5f4de85
--- /dev/null
+++ b/sql/hive/src/test/resources/golden/alias.*-0-7bdb861d11e895aaea545810cdac316d
@@ -0,0 +1 @@
+0	val_0
\ No newline at end of file

http://git-wip-us.apache.org/repos/asf/spark/blob/7e17fe69/sql/hive/src/test/resources/golden/alias.attr-0-42104e7e35985f4504c6d9a79b1bb4b8
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/golden/alias.attr-0-42104e7e35985f4504c6d9a79b1bb4b8 b/sql/hive/src/test/resources/golden/alias.attr-0-42104e7e35985f4504c6d9a79b1bb4b8
new file mode 100644
index 0000000..c227083
--- /dev/null
+++ b/sql/hive/src/test/resources/golden/alias.attr-0-42104e7e35985f4504c6d9a79b1bb4b8
@@ -0,0 +1 @@
+0
\ No newline at end of file

http://git-wip-us.apache.org/repos/asf/spark/blob/7e17fe69/sql/hive/src/test/resources/golden/alias_casted_column-0-f69b60c6e896fcd1a69d9525fd988c66
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/golden/alias_casted_column-0-f69b60c6e896fcd1a69d9525fd988c66 b/sql/hive/src/test/resources/golden/alias_casted_column-0-f69b60c6e896fcd1a69d9525fd988c66
new file mode 100644
index 0000000..e69de29

http://git-wip-us.apache.org/repos/asf/spark/blob/7e17fe69/sql/hive/src/test/resources/golden/alias_casted_column-1-4432aec015f9423ed991b08cfb2af0e1
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/golden/alias_casted_column-1-4432aec015f9423ed991b08cfb2af0e1 b/sql/hive/src/test/resources/golden/alias_casted_column-1-4432aec015f9423ed991b08cfb2af0e1
new file mode 100644
index 0000000..e69de29

http://git-wip-us.apache.org/repos/asf/spark/blob/7e17fe69/sql/hive/src/test/resources/golden/alter2-0-85e494848d1525843a3ff9b2b77f92
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/golden/alter2-0-85e494848d1525843a3ff9b2b77f92 b/sql/hive/src/test/resources/golden/alter2-0-85e494848d1525843a3ff9b2b77f92
new file mode 100644
index 0000000..e69de29

http://git-wip-us.apache.org/repos/asf/spark/blob/7e17fe69/sql/hive/src/test/resources/golden/alter2-1-aac9c2c7033fd7264c9a107a88ff591
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/golden/alter2-1-aac9c2c7033fd7264c9a107a88ff591 b/sql/hive/src/test/resources/golden/alter2-1-aac9c2c7033fd7264c9a107a88ff591
new file mode 100644
index 0000000..62a8ea1
--- /dev/null
+++ b/sql/hive/src/test/resources/golden/alter2-1-aac9c2c7033fd7264c9a107a88ff591
@@ -0,0 +1,10 @@
+a                   	int                 	None                
+b                   	int                 	None                
+insertdate          	string              	None                
+	 	 
+# Partition Information	 	 
+# col_name            	data_type           	comment             
+	 	 
+insertdate          	string              	None                
+	 	 
+Detailed Table Information	Table(tableName:alter2, dbName:default, owner:marmbrus, createTime:1389728471, lastAccessTime:0, retention:0, sd:StorageDescriptor(cols:[FieldSchema(name:a, type:int, comment:null), FieldSchema(name:b, type:int, comment:null), FieldSchema(name:insertdate, type:string, comment:null)], location:file:/private/var/folders/36/cjkbrr953xg2p_krwrmn8h_r0000gn/T/sharkWarehouse545253106736176469/alter2, inputFormat:org.apache.hadoop.mapred.TextInputFormat, outputFormat:org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat, compressed:false, numBuckets:-1, serdeInfo:SerDeInfo(name:null, serializationLib:org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe, parameters:{serialization.format=1}), bucketCols:[], sortCols:[], parameters:{}, skewedInfo:SkewedInfo(skewedColNames:[], skewedColValues:[], skewedColValueLocationMaps:{}), storedAsSubDirectories:false), partitionKeys:[FieldSchema(name:insertdate, type:string, comment:null)], parameters:{transient_lastDdlTime=1
 389728471}, viewOriginalText:null, viewExpandedText:null, tableType:MANAGED_TABLE)	
\ No newline at end of file

http://git-wip-us.apache.org/repos/asf/spark/blob/7e17fe69/sql/hive/src/test/resources/golden/alter2-10-2d1f665a92fe72bd253ae57c46d7b9da
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/golden/alter2-10-2d1f665a92fe72bd253ae57c46d7b9da b/sql/hive/src/test/resources/golden/alter2-10-2d1f665a92fe72bd253ae57c46d7b9da
new file mode 100644
index 0000000..e69de29

http://git-wip-us.apache.org/repos/asf/spark/blob/7e17fe69/sql/hive/src/test/resources/golden/alter2-11-aac9c2c7033fd7264c9a107a88ff591
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/golden/alter2-11-aac9c2c7033fd7264c9a107a88ff591 b/sql/hive/src/test/resources/golden/alter2-11-aac9c2c7033fd7264c9a107a88ff591
new file mode 100644
index 0000000..72621ad
--- /dev/null
+++ b/sql/hive/src/test/resources/golden/alter2-11-aac9c2c7033fd7264c9a107a88ff591
@@ -0,0 +1,10 @@
+a                   	int                 	None                
+b                   	int                 	None                
+insertdate          	string              	None                
+	 	 
+# Partition Information	 	 
+# col_name            	data_type           	comment             
+	 	 
+insertdate          	string              	None                
+	 	 
+Detailed Table Information	Table(tableName:alter2, dbName:default, owner:marmbrus, createTime:1389728473, lastAccessTime:0, retention:0, sd:StorageDescriptor(cols:[FieldSchema(name:a, type:int, comment:null), FieldSchema(name:b, type:int, comment:null), FieldSchema(name:insertdate, type:string, comment:null)], location:file:/private/var/folders/36/cjkbrr953xg2p_krwrmn8h_r0000gn/T/sharkWarehouse545253106736176469/alter2, inputFormat:org.apache.hadoop.mapred.TextInputFormat, outputFormat:org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat, compressed:false, numBuckets:-1, serdeInfo:SerDeInfo(name:null, serializationLib:org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe, parameters:{serialization.format=1}), bucketCols:[], sortCols:[], parameters:{}, skewedInfo:SkewedInfo(skewedColNames:[], skewedColValues:[], skewedColValueLocationMaps:{}), storedAsSubDirectories:false), partitionKeys:[FieldSchema(name:insertdate, type:string, comment:null)], parameters:{EXTERNAL=TRUE, transien
 t_lastDdlTime=1389728473}, viewOriginalText:null, viewExpandedText:null, tableType:EXTERNAL_TABLE)	
\ No newline at end of file

http://git-wip-us.apache.org/repos/asf/spark/blob/7e17fe69/sql/hive/src/test/resources/golden/alter2-12-75a213649242c2410ea6846f08c91d75
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/golden/alter2-12-75a213649242c2410ea6846f08c91d75 b/sql/hive/src/test/resources/golden/alter2-12-75a213649242c2410ea6846f08c91d75
new file mode 100644
index 0000000..e69de29

http://git-wip-us.apache.org/repos/asf/spark/blob/7e17fe69/sql/hive/src/test/resources/golden/alter2-13-ca51e03a3de391983429b6ad877e573c
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/golden/alter2-13-ca51e03a3de391983429b6ad877e573c b/sql/hive/src/test/resources/golden/alter2-13-ca51e03a3de391983429b6ad877e573c
new file mode 100644
index 0000000..e69de29

http://git-wip-us.apache.org/repos/asf/spark/blob/7e17fe69/sql/hive/src/test/resources/golden/alter2-14-aac9c2c7033fd7264c9a107a88ff591
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/golden/alter2-14-aac9c2c7033fd7264c9a107a88ff591 b/sql/hive/src/test/resources/golden/alter2-14-aac9c2c7033fd7264c9a107a88ff591
new file mode 100644
index 0000000..72621ad
--- /dev/null
+++ b/sql/hive/src/test/resources/golden/alter2-14-aac9c2c7033fd7264c9a107a88ff591
@@ -0,0 +1,10 @@
+a                   	int                 	None                
+b                   	int                 	None                
+insertdate          	string              	None                
+	 	 
+# Partition Information	 	 
+# col_name            	data_type           	comment             
+	 	 
+insertdate          	string              	None                
+	 	 
+Detailed Table Information	Table(tableName:alter2, dbName:default, owner:marmbrus, createTime:1389728473, lastAccessTime:0, retention:0, sd:StorageDescriptor(cols:[FieldSchema(name:a, type:int, comment:null), FieldSchema(name:b, type:int, comment:null), FieldSchema(name:insertdate, type:string, comment:null)], location:file:/private/var/folders/36/cjkbrr953xg2p_krwrmn8h_r0000gn/T/sharkWarehouse545253106736176469/alter2, inputFormat:org.apache.hadoop.mapred.TextInputFormat, outputFormat:org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat, compressed:false, numBuckets:-1, serdeInfo:SerDeInfo(name:null, serializationLib:org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe, parameters:{serialization.format=1}), bucketCols:[], sortCols:[], parameters:{}, skewedInfo:SkewedInfo(skewedColNames:[], skewedColValues:[], skewedColValueLocationMaps:{}), storedAsSubDirectories:false), partitionKeys:[FieldSchema(name:insertdate, type:string, comment:null)], parameters:{EXTERNAL=TRUE, transien
 t_lastDdlTime=1389728473}, viewOriginalText:null, viewExpandedText:null, tableType:EXTERNAL_TABLE)	
\ No newline at end of file

http://git-wip-us.apache.org/repos/asf/spark/blob/7e17fe69/sql/hive/src/test/resources/golden/alter2-15-75a213649242c2410ea6846f08c91d75
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/golden/alter2-15-75a213649242c2410ea6846f08c91d75 b/sql/hive/src/test/resources/golden/alter2-15-75a213649242c2410ea6846f08c91d75
new file mode 100644
index 0000000..15e6bc8
--- /dev/null
+++ b/sql/hive/src/test/resources/golden/alter2-15-75a213649242c2410ea6846f08c91d75
@@ -0,0 +1 @@
+insertdate=2008-01-01
\ No newline at end of file

http://git-wip-us.apache.org/repos/asf/spark/blob/7e17fe69/sql/hive/src/test/resources/golden/alter2-16-77500c83ffcece95511a4b21d67382dd
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/golden/alter2-16-77500c83ffcece95511a4b21d67382dd b/sql/hive/src/test/resources/golden/alter2-16-77500c83ffcece95511a4b21d67382dd
new file mode 100644
index 0000000..e69de29

http://git-wip-us.apache.org/repos/asf/spark/blob/7e17fe69/sql/hive/src/test/resources/golden/alter2-17-aac9c2c7033fd7264c9a107a88ff591
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/golden/alter2-17-aac9c2c7033fd7264c9a107a88ff591 b/sql/hive/src/test/resources/golden/alter2-17-aac9c2c7033fd7264c9a107a88ff591
new file mode 100644
index 0000000..72621ad
--- /dev/null
+++ b/sql/hive/src/test/resources/golden/alter2-17-aac9c2c7033fd7264c9a107a88ff591
@@ -0,0 +1,10 @@
+a                   	int                 	None                
+b                   	int                 	None                
+insertdate          	string              	None                
+	 	 
+# Partition Information	 	 
+# col_name            	data_type           	comment             
+	 	 
+insertdate          	string              	None                
+	 	 
+Detailed Table Information	Table(tableName:alter2, dbName:default, owner:marmbrus, createTime:1389728473, lastAccessTime:0, retention:0, sd:StorageDescriptor(cols:[FieldSchema(name:a, type:int, comment:null), FieldSchema(name:b, type:int, comment:null), FieldSchema(name:insertdate, type:string, comment:null)], location:file:/private/var/folders/36/cjkbrr953xg2p_krwrmn8h_r0000gn/T/sharkWarehouse545253106736176469/alter2, inputFormat:org.apache.hadoop.mapred.TextInputFormat, outputFormat:org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat, compressed:false, numBuckets:-1, serdeInfo:SerDeInfo(name:null, serializationLib:org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe, parameters:{serialization.format=1}), bucketCols:[], sortCols:[], parameters:{}, skewedInfo:SkewedInfo(skewedColNames:[], skewedColValues:[], skewedColValueLocationMaps:{}), storedAsSubDirectories:false), partitionKeys:[FieldSchema(name:insertdate, type:string, comment:null)], parameters:{EXTERNAL=TRUE, transien
 t_lastDdlTime=1389728473}, viewOriginalText:null, viewExpandedText:null, tableType:EXTERNAL_TABLE)	
\ No newline at end of file

http://git-wip-us.apache.org/repos/asf/spark/blob/7e17fe69/sql/hive/src/test/resources/golden/alter2-18-75a213649242c2410ea6846f08c91d75
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/golden/alter2-18-75a213649242c2410ea6846f08c91d75 b/sql/hive/src/test/resources/golden/alter2-18-75a213649242c2410ea6846f08c91d75
new file mode 100644
index 0000000..d31318a
--- /dev/null
+++ b/sql/hive/src/test/resources/golden/alter2-18-75a213649242c2410ea6846f08c91d75
@@ -0,0 +1,2 @@
+insertdate=2008-01-01
+insertdate=2008-01-02
\ No newline at end of file

http://git-wip-us.apache.org/repos/asf/spark/blob/7e17fe69/sql/hive/src/test/resources/golden/alter2-19-3d80bb2d1c541460b5b17c4124fa647
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/golden/alter2-19-3d80bb2d1c541460b5b17c4124fa647 b/sql/hive/src/test/resources/golden/alter2-19-3d80bb2d1c541460b5b17c4124fa647
new file mode 100644
index 0000000..e69de29

http://git-wip-us.apache.org/repos/asf/spark/blob/7e17fe69/sql/hive/src/test/resources/golden/alter2-2-75a213649242c2410ea6846f08c91d75
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/golden/alter2-2-75a213649242c2410ea6846f08c91d75 b/sql/hive/src/test/resources/golden/alter2-2-75a213649242c2410ea6846f08c91d75
new file mode 100644
index 0000000..e69de29

http://git-wip-us.apache.org/repos/asf/spark/blob/7e17fe69/sql/hive/src/test/resources/golden/alter2-20-9c36cac1372650b703400c60dd29042c
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/golden/alter2-20-9c36cac1372650b703400c60dd29042c b/sql/hive/src/test/resources/golden/alter2-20-9c36cac1372650b703400c60dd29042c
new file mode 100644
index 0000000..ecafeae
--- /dev/null
+++ b/sql/hive/src/test/resources/golden/alter2-20-9c36cac1372650b703400c60dd29042c
@@ -0,0 +1,2 @@
+src
+srcpart
\ No newline at end of file

http://git-wip-us.apache.org/repos/asf/spark/blob/7e17fe69/sql/hive/src/test/resources/golden/alter2-21-a6ea9efed3b9c680fca93588019ac5e3
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/golden/alter2-21-a6ea9efed3b9c680fca93588019ac5e3 b/sql/hive/src/test/resources/golden/alter2-21-a6ea9efed3b9c680fca93588019ac5e3
new file mode 100644
index 0000000..e69de29

http://git-wip-us.apache.org/repos/asf/spark/blob/7e17fe69/sql/hive/src/test/resources/golden/alter2-22-ea07b8f664208f93a1a8b97fd486d226
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/golden/alter2-22-ea07b8f664208f93a1a8b97fd486d226 b/sql/hive/src/test/resources/golden/alter2-22-ea07b8f664208f93a1a8b97fd486d226
new file mode 100644
index 0000000..e69de29

http://git-wip-us.apache.org/repos/asf/spark/blob/7e17fe69/sql/hive/src/test/resources/golden/alter2-23-9c36cac1372650b703400c60dd29042c
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/golden/alter2-23-9c36cac1372650b703400c60dd29042c b/sql/hive/src/test/resources/golden/alter2-23-9c36cac1372650b703400c60dd29042c
new file mode 100644
index 0000000..e69de29

http://git-wip-us.apache.org/repos/asf/spark/blob/7e17fe69/sql/hive/src/test/resources/golden/alter2-24-775d69742a1c07df8da87e8a017d955
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/golden/alter2-24-775d69742a1c07df8da87e8a017d955 b/sql/hive/src/test/resources/golden/alter2-24-775d69742a1c07df8da87e8a017d955
new file mode 100644
index 0000000..e69de29

http://git-wip-us.apache.org/repos/asf/spark/blob/7e17fe69/sql/hive/src/test/resources/golden/alter2-25-4ef75e12575453225738ea167c4617e5
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/golden/alter2-25-4ef75e12575453225738ea167c4617e5 b/sql/hive/src/test/resources/golden/alter2-25-4ef75e12575453225738ea167c4617e5
new file mode 100644
index 0000000..8318497
--- /dev/null
+++ b/sql/hive/src/test/resources/golden/alter2-25-4ef75e12575453225738ea167c4617e5
@@ -0,0 +1,10 @@
+a                   	int                 	None                
+b                   	int                 	None                
+insertdate          	string              	None                
+	 	 
+# Partition Information	 	 
+# col_name            	data_type           	comment             
+	 	 
+insertdate          	string              	None                
+	 	 
+Detailed Table Information	Table(tableName:alter2, dbName:alter2_db, owner:marmbrus, createTime:1389728475, lastAccessTime:0, retention:0, sd:StorageDescriptor(cols:[FieldSchema(name:a, type:int, comment:null), FieldSchema(name:b, type:int, comment:null), FieldSchema(name:insertdate, type:string, comment:null)], location:file:/private/var/folders/36/cjkbrr953xg2p_krwrmn8h_r0000gn/T/sharkWarehouse545253106736176469/alter2_db.db/alter2, inputFormat:org.apache.hadoop.mapred.TextInputFormat, outputFormat:org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat, compressed:false, numBuckets:-1, serdeInfo:SerDeInfo(name:null, serializationLib:org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe, parameters:{serialization.format=1}), bucketCols:[], sortCols:[], parameters:{}, skewedInfo:SkewedInfo(skewedColNames:[], skewedColValues:[], skewedColValueLocationMaps:{}), storedAsSubDirectories:false), partitionKeys:[FieldSchema(name:insertdate, type:string, comment:null)], parameters:{transien
 t_lastDdlTime=1389728475}, viewOriginalText:null, viewExpandedText:null, tableType:MANAGED_TABLE)	
\ No newline at end of file

http://git-wip-us.apache.org/repos/asf/spark/blob/7e17fe69/sql/hive/src/test/resources/golden/alter2-26-63f13c364546ddce5d2176c6604a948f
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/golden/alter2-26-63f13c364546ddce5d2176c6604a948f b/sql/hive/src/test/resources/golden/alter2-26-63f13c364546ddce5d2176c6604a948f
new file mode 100644
index 0000000..e69de29

http://git-wip-us.apache.org/repos/asf/spark/blob/7e17fe69/sql/hive/src/test/resources/golden/alter2-27-ba521286c12ba29329bfa71bb185c62f
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/golden/alter2-27-ba521286c12ba29329bfa71bb185c62f b/sql/hive/src/test/resources/golden/alter2-27-ba521286c12ba29329bfa71bb185c62f
new file mode 100644
index 0000000..e69de29

http://git-wip-us.apache.org/repos/asf/spark/blob/7e17fe69/sql/hive/src/test/resources/golden/alter2-28-4ef75e12575453225738ea167c4617e5
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/golden/alter2-28-4ef75e12575453225738ea167c4617e5 b/sql/hive/src/test/resources/golden/alter2-28-4ef75e12575453225738ea167c4617e5
new file mode 100644
index 0000000..8318497
--- /dev/null
+++ b/sql/hive/src/test/resources/golden/alter2-28-4ef75e12575453225738ea167c4617e5
@@ -0,0 +1,10 @@
+a                   	int                 	None                
+b                   	int                 	None                
+insertdate          	string              	None                
+	 	 
+# Partition Information	 	 
+# col_name            	data_type           	comment             
+	 	 
+insertdate          	string              	None                
+	 	 
+Detailed Table Information	Table(tableName:alter2, dbName:alter2_db, owner:marmbrus, createTime:1389728475, lastAccessTime:0, retention:0, sd:StorageDescriptor(cols:[FieldSchema(name:a, type:int, comment:null), FieldSchema(name:b, type:int, comment:null), FieldSchema(name:insertdate, type:string, comment:null)], location:file:/private/var/folders/36/cjkbrr953xg2p_krwrmn8h_r0000gn/T/sharkWarehouse545253106736176469/alter2_db.db/alter2, inputFormat:org.apache.hadoop.mapred.TextInputFormat, outputFormat:org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat, compressed:false, numBuckets:-1, serdeInfo:SerDeInfo(name:null, serializationLib:org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe, parameters:{serialization.format=1}), bucketCols:[], sortCols:[], parameters:{}, skewedInfo:SkewedInfo(skewedColNames:[], skewedColValues:[], skewedColValueLocationMaps:{}), storedAsSubDirectories:false), partitionKeys:[FieldSchema(name:insertdate, type:string, comment:null)], parameters:{transien
 t_lastDdlTime=1389728475}, viewOriginalText:null, viewExpandedText:null, tableType:MANAGED_TABLE)	
\ No newline at end of file

http://git-wip-us.apache.org/repos/asf/spark/blob/7e17fe69/sql/hive/src/test/resources/golden/alter2-29-63f13c364546ddce5d2176c6604a948f
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/golden/alter2-29-63f13c364546ddce5d2176c6604a948f b/sql/hive/src/test/resources/golden/alter2-29-63f13c364546ddce5d2176c6604a948f
new file mode 100644
index 0000000..15e6bc8
--- /dev/null
+++ b/sql/hive/src/test/resources/golden/alter2-29-63f13c364546ddce5d2176c6604a948f
@@ -0,0 +1 @@
+insertdate=2008-01-01
\ No newline at end of file

http://git-wip-us.apache.org/repos/asf/spark/blob/7e17fe69/sql/hive/src/test/resources/golden/alter2-3-ca51e03a3de391983429b6ad877e573c
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/golden/alter2-3-ca51e03a3de391983429b6ad877e573c b/sql/hive/src/test/resources/golden/alter2-3-ca51e03a3de391983429b6ad877e573c
new file mode 100644
index 0000000..e69de29

http://git-wip-us.apache.org/repos/asf/spark/blob/7e17fe69/sql/hive/src/test/resources/golden/alter2-30-a336adf1d0ff00633c53600fc75ca3ae
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/golden/alter2-30-a336adf1d0ff00633c53600fc75ca3ae b/sql/hive/src/test/resources/golden/alter2-30-a336adf1d0ff00633c53600fc75ca3ae
new file mode 100644
index 0000000..e69de29