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:25 UTC
[23/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/groupby9-13-a6b1560ec2eb0bd64c9dd2c8daae99c5
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/golden/groupby9-13-a6b1560ec2eb0bd64c9dd2c8daae99c5 b/sql/hive/src/test/resources/golden/groupby9-13-a6b1560ec2eb0bd64c9dd2c8daae99c5
new file mode 100644
index 0000000..326493a
--- /dev/null
+++ b/sql/hive/src/test/resources/golden/groupby9-13-a6b1560ec2eb0bd64c9dd2c8daae99c5
@@ -0,0 +1,309 @@
+0 1
+2 1
+4 1
+5 1
+8 1
+9 1
+10 1
+11 1
+12 1
+15 1
+17 1
+18 1
+19 1
+20 1
+24 1
+26 1
+27 1
+28 1
+30 1
+33 1
+34 1
+35 1
+37 1
+41 1
+42 1
+43 1
+44 1
+47 1
+51 1
+53 1
+54 1
+57 1
+58 1
+64 1
+65 1
+66 1
+67 1
+69 1
+70 1
+72 1
+74 1
+76 1
+77 1
+78 1
+80 1
+82 1
+83 1
+84 1
+85 1
+86 1
+87 1
+90 1
+92 1
+95 1
+96 1
+97 1
+98 1
+100 1
+103 1
+104 1
+105 1
+111 1
+113 1
+114 1
+116 1
+118 1
+119 1
+120 1
+125 1
+126 1
+128 1
+129 1
+131 1
+133 1
+134 1
+136 1
+137 1
+138 1
+143 1
+145 1
+146 1
+149 1
+150 1
+152 1
+153 1
+155 1
+156 1
+157 1
+158 1
+160 1
+162 1
+163 1
+164 1
+165 1
+166 1
+167 1
+168 1
+169 1
+170 1
+172 1
+174 1
+175 1
+176 1
+177 1
+178 1
+179 1
+180 1
+181 1
+183 1
+186 1
+187 1
+189 1
+190 1
+191 1
+192 1
+193 1
+194 1
+195 1
+196 1
+197 1
+199 1
+200 1
+201 1
+202 1
+203 1
+205 1
+207 1
+208 1
+209 1
+213 1
+214 1
+216 1
+217 1
+218 1
+219 1
+221 1
+222 1
+223 1
+224 1
+226 1
+228 1
+229 1
+230 1
+233 1
+235 1
+237 1
+238 1
+239 1
+241 1
+242 1
+244 1
+247 1
+248 1
+249 1
+252 1
+255 1
+256 1
+257 1
+258 1
+260 1
+262 1
+263 1
+265 1
+266 1
+272 1
+273 1
+274 1
+275 1
+277 1
+278 1
+280 1
+281 1
+282 1
+283 1
+284 1
+285 1
+286 1
+287 1
+288 1
+289 1
+291 1
+292 1
+296 1
+298 1
+302 1
+305 1
+306 1
+307 1
+308 1
+309 1
+310 1
+311 1
+315 1
+316 1
+317 1
+318 1
+321 1
+322 1
+323 1
+325 1
+327 1
+331 1
+332 1
+333 1
+335 1
+336 1
+338 1
+339 1
+341 1
+342 1
+344 1
+345 1
+348 1
+351 1
+353 1
+356 1
+360 1
+362 1
+364 1
+365 1
+366 1
+367 1
+368 1
+369 1
+373 1
+374 1
+375 1
+377 1
+378 1
+379 1
+382 1
+384 1
+386 1
+389 1
+392 1
+393 1
+394 1
+395 1
+396 1
+397 1
+399 1
+400 1
+401 1
+402 1
+403 1
+404 1
+406 1
+407 1
+409 1
+411 1
+413 1
+414 1
+417 1
+418 1
+419 1
+421 1
+424 1
+427 1
+429 1
+430 1
+431 1
+432 1
+435 1
+436 1
+437 1
+438 1
+439 1
+443 1
+444 1
+446 1
+448 1
+449 1
+452 1
+453 1
+454 1
+455 1
+457 1
+458 1
+459 1
+460 1
+462 1
+463 1
+466 1
+467 1
+468 1
+469 1
+470 1
+472 1
+475 1
+477 1
+478 1
+479 1
+480 1
+481 1
+482 1
+483 1
+484 1
+485 1
+487 1
+489 1
+490 1
+491 1
+492 1
+493 1
+494 1
+495 1
+496 1
+497 1
+498 1
\ No newline at end of file
http://git-wip-us.apache.org/repos/asf/spark/blob/7e17fe69/sql/hive/src/test/resources/golden/groupby9-14-404392d6faff5db5f36b4aa87ac8e8c9
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/golden/groupby9-14-404392d6faff5db5f36b4aa87ac8e8c9 b/sql/hive/src/test/resources/golden/groupby9-14-404392d6faff5db5f36b4aa87ac8e8c9
new file mode 100644
index 0000000..0e40f3f
--- /dev/null
+++ b/sql/hive/src/test/resources/golden/groupby9-14-404392d6faff5db5f36b4aa87ac8e8c9
@@ -0,0 +1,309 @@
+0 val_0 1
+2 val_2 1
+4 val_4 1
+5 val_5 1
+8 val_8 1
+9 val_9 1
+10 val_10 1
+11 val_11 1
+12 val_12 1
+15 val_15 1
+17 val_17 1
+18 val_18 1
+19 val_19 1
+20 val_20 1
+24 val_24 1
+26 val_26 1
+27 val_27 1
+28 val_28 1
+30 val_30 1
+33 val_33 1
+34 val_34 1
+35 val_35 1
+37 val_37 1
+41 val_41 1
+42 val_42 1
+43 val_43 1
+44 val_44 1
+47 val_47 1
+51 val_51 1
+53 val_53 1
+54 val_54 1
+57 val_57 1
+58 val_58 1
+64 val_64 1
+65 val_65 1
+66 val_66 1
+67 val_67 1
+69 val_69 1
+70 val_70 1
+72 val_72 1
+74 val_74 1
+76 val_76 1
+77 val_77 1
+78 val_78 1
+80 val_80 1
+82 val_82 1
+83 val_83 1
+84 val_84 1
+85 val_85 1
+86 val_86 1
+87 val_87 1
+90 val_90 1
+92 val_92 1
+95 val_95 1
+96 val_96 1
+97 val_97 1
+98 val_98 1
+100 val_100 1
+103 val_103 1
+104 val_104 1
+105 val_105 1
+111 val_111 1
+113 val_113 1
+114 val_114 1
+116 val_116 1
+118 val_118 1
+119 val_119 1
+120 val_120 1
+125 val_125 1
+126 val_126 1
+128 val_128 1
+129 val_129 1
+131 val_131 1
+133 val_133 1
+134 val_134 1
+136 val_136 1
+137 val_137 1
+138 val_138 1
+143 val_143 1
+145 val_145 1
+146 val_146 1
+149 val_149 1
+150 val_150 1
+152 val_152 1
+153 val_153 1
+155 val_155 1
+156 val_156 1
+157 val_157 1
+158 val_158 1
+160 val_160 1
+162 val_162 1
+163 val_163 1
+164 val_164 1
+165 val_165 1
+166 val_166 1
+167 val_167 1
+168 val_168 1
+169 val_169 1
+170 val_170 1
+172 val_172 1
+174 val_174 1
+175 val_175 1
+176 val_176 1
+177 val_177 1
+178 val_178 1
+179 val_179 1
+180 val_180 1
+181 val_181 1
+183 val_183 1
+186 val_186 1
+187 val_187 1
+189 val_189 1
+190 val_190 1
+191 val_191 1
+192 val_192 1
+193 val_193 1
+194 val_194 1
+195 val_195 1
+196 val_196 1
+197 val_197 1
+199 val_199 1
+200 val_200 1
+201 val_201 1
+202 val_202 1
+203 val_203 1
+205 val_205 1
+207 val_207 1
+208 val_208 1
+209 val_209 1
+213 val_213 1
+214 val_214 1
+216 val_216 1
+217 val_217 1
+218 val_218 1
+219 val_219 1
+221 val_221 1
+222 val_222 1
+223 val_223 1
+224 val_224 1
+226 val_226 1
+228 val_228 1
+229 val_229 1
+230 val_230 1
+233 val_233 1
+235 val_235 1
+237 val_237 1
+238 val_238 1
+239 val_239 1
+241 val_241 1
+242 val_242 1
+244 val_244 1
+247 val_247 1
+248 val_248 1
+249 val_249 1
+252 val_252 1
+255 val_255 1
+256 val_256 1
+257 val_257 1
+258 val_258 1
+260 val_260 1
+262 val_262 1
+263 val_263 1
+265 val_265 1
+266 val_266 1
+272 val_272 1
+273 val_273 1
+274 val_274 1
+275 val_275 1
+277 val_277 1
+278 val_278 1
+280 val_280 1
+281 val_281 1
+282 val_282 1
+283 val_283 1
+284 val_284 1
+285 val_285 1
+286 val_286 1
+287 val_287 1
+288 val_288 1
+289 val_289 1
+291 val_291 1
+292 val_292 1
+296 val_296 1
+298 val_298 1
+302 val_302 1
+305 val_305 1
+306 val_306 1
+307 val_307 1
+308 val_308 1
+309 val_309 1
+310 val_310 1
+311 val_311 1
+315 val_315 1
+316 val_316 1
+317 val_317 1
+318 val_318 1
+321 val_321 1
+322 val_322 1
+323 val_323 1
+325 val_325 1
+327 val_327 1
+331 val_331 1
+332 val_332 1
+333 val_333 1
+335 val_335 1
+336 val_336 1
+338 val_338 1
+339 val_339 1
+341 val_341 1
+342 val_342 1
+344 val_344 1
+345 val_345 1
+348 val_348 1
+351 val_351 1
+353 val_353 1
+356 val_356 1
+360 val_360 1
+362 val_362 1
+364 val_364 1
+365 val_365 1
+366 val_366 1
+367 val_367 1
+368 val_368 1
+369 val_369 1
+373 val_373 1
+374 val_374 1
+375 val_375 1
+377 val_377 1
+378 val_378 1
+379 val_379 1
+382 val_382 1
+384 val_384 1
+386 val_386 1
+389 val_389 1
+392 val_392 1
+393 val_393 1
+394 val_394 1
+395 val_395 1
+396 val_396 1
+397 val_397 1
+399 val_399 1
+400 val_400 1
+401 val_401 1
+402 val_402 1
+403 val_403 1
+404 val_404 1
+406 val_406 1
+407 val_407 1
+409 val_409 1
+411 val_411 1
+413 val_413 1
+414 val_414 1
+417 val_417 1
+418 val_418 1
+419 val_419 1
+421 val_421 1
+424 val_424 1
+427 val_427 1
+429 val_429 1
+430 val_430 1
+431 val_431 1
+432 val_432 1
+435 val_435 1
+436 val_436 1
+437 val_437 1
+438 val_438 1
+439 val_439 1
+443 val_443 1
+444 val_444 1
+446 val_446 1
+448 val_448 1
+449 val_449 1
+452 val_452 1
+453 val_453 1
+454 val_454 1
+455 val_455 1
+457 val_457 1
+458 val_458 1
+459 val_459 1
+460 val_460 1
+462 val_462 1
+463 val_463 1
+466 val_466 1
+467 val_467 1
+468 val_468 1
+469 val_469 1
+470 val_470 1
+472 val_472 1
+475 val_475 1
+477 val_477 1
+478 val_478 1
+479 val_479 1
+480 val_480 1
+481 val_481 1
+482 val_482 1
+483 val_483 1
+484 val_484 1
+485 val_485 1
+487 val_487 1
+489 val_489 1
+490 val_490 1
+491 val_491 1
+492 val_492 1
+493 val_493 1
+494 val_494 1
+495 val_495 1
+496 val_496 1
+497 val_497 1
+498 val_498 1
\ No newline at end of file
http://git-wip-us.apache.org/repos/asf/spark/blob/7e17fe69/sql/hive/src/test/resources/golden/groupby9-15-c3d5e2da9bbf7d66aa106eb13183dbed
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/golden/groupby9-15-c3d5e2da9bbf7d66aa106eb13183dbed b/sql/hive/src/test/resources/golden/groupby9-15-c3d5e2da9bbf7d66aa106eb13183dbed
new file mode 100644
index 0000000..e69de29
http://git-wip-us.apache.org/repos/asf/spark/blob/7e17fe69/sql/hive/src/test/resources/golden/groupby9-16-c05b1bc66a607e43633dc457ecf48f3b
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/golden/groupby9-16-c05b1bc66a607e43633dc457ecf48f3b b/sql/hive/src/test/resources/golden/groupby9-16-c05b1bc66a607e43633dc457ecf48f3b
new file mode 100644
index 0000000..e69de29
http://git-wip-us.apache.org/repos/asf/spark/blob/7e17fe69/sql/hive/src/test/resources/golden/groupby9-17-a6b1560ec2eb0bd64c9dd2c8daae99c5
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/golden/groupby9-17-a6b1560ec2eb0bd64c9dd2c8daae99c5 b/sql/hive/src/test/resources/golden/groupby9-17-a6b1560ec2eb0bd64c9dd2c8daae99c5
new file mode 100644
index 0000000..df07a9d
--- /dev/null
+++ b/sql/hive/src/test/resources/golden/groupby9-17-a6b1560ec2eb0bd64c9dd2c8daae99c5
@@ -0,0 +1,309 @@
+0 3
+2 1
+4 1
+5 3
+8 1
+9 1
+10 1
+11 1
+12 2
+15 2
+17 1
+18 2
+19 1
+20 1
+24 2
+26 2
+27 1
+28 1
+30 1
+33 1
+34 1
+35 3
+37 2
+41 1
+42 2
+43 1
+44 1
+47 1
+51 2
+53 1
+54 1
+57 1
+58 2
+64 1
+65 1
+66 1
+67 2
+69 1
+70 3
+72 2
+74 1
+76 2
+77 1
+78 1
+80 1
+82 1
+83 2
+84 2
+85 1
+86 1
+87 1
+90 3
+92 1
+95 2
+96 1
+97 2
+98 2
+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
\ No newline at end of file
http://git-wip-us.apache.org/repos/asf/spark/blob/7e17fe69/sql/hive/src/test/resources/golden/groupby9-18-404392d6faff5db5f36b4aa87ac8e8c9
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/golden/groupby9-18-404392d6faff5db5f36b4aa87ac8e8c9 b/sql/hive/src/test/resources/golden/groupby9-18-404392d6faff5db5f36b4aa87ac8e8c9
new file mode 100644
index 0000000..cf0c065
--- /dev/null
+++ b/sql/hive/src/test/resources/golden/groupby9-18-404392d6faff5db5f36b4aa87ac8e8c9
@@ -0,0 +1,309 @@
+0 val_0 3
+2 val_2 1
+4 val_4 1
+5 val_5 3
+8 val_8 1
+9 val_9 1
+10 val_10 1
+11 val_11 1
+12 val_12 2
+15 val_15 2
+17 val_17 1
+18 val_18 2
+19 val_19 1
+20 val_20 1
+24 val_24 2
+26 val_26 2
+27 val_27 1
+28 val_28 1
+30 val_30 1
+33 val_33 1
+34 val_34 1
+35 val_35 3
+37 val_37 2
+41 val_41 1
+42 val_42 2
+43 val_43 1
+44 val_44 1
+47 val_47 1
+51 val_51 2
+53 val_53 1
+54 val_54 1
+57 val_57 1
+58 val_58 2
+64 val_64 1
+65 val_65 1
+66 val_66 1
+67 val_67 2
+69 val_69 1
+70 val_70 3
+72 val_72 2
+74 val_74 1
+76 val_76 2
+77 val_77 1
+78 val_78 1
+80 val_80 1
+82 val_82 1
+83 val_83 2
+84 val_84 2
+85 val_85 1
+86 val_86 1
+87 val_87 1
+90 val_90 3
+92 val_92 1
+95 val_95 2
+96 val_96 1
+97 val_97 2
+98 val_98 2
+100 val_100 2
+103 val_103 2
+104 val_104 2
+105 val_105 1
+111 val_111 1
+113 val_113 2
+114 val_114 1
+116 val_116 1
+118 val_118 2
+119 val_119 3
+120 val_120 2
+125 val_125 2
+126 val_126 1
+128 val_128 3
+129 val_129 2
+131 val_131 1
+133 val_133 1
+134 val_134 2
+136 val_136 1
+137 val_137 2
+138 val_138 4
+143 val_143 1
+145 val_145 1
+146 val_146 2
+149 val_149 2
+150 val_150 1
+152 val_152 2
+153 val_153 1
+155 val_155 1
+156 val_156 1
+157 val_157 1
+158 val_158 1
+160 val_160 1
+162 val_162 1
+163 val_163 1
+164 val_164 2
+165 val_165 2
+166 val_166 1
+167 val_167 3
+168 val_168 1
+169 val_169 4
+170 val_170 1
+172 val_172 2
+174 val_174 2
+175 val_175 2
+176 val_176 2
+177 val_177 1
+178 val_178 1
+179 val_179 2
+180 val_180 1
+181 val_181 1
+183 val_183 1
+186 val_186 1
+187 val_187 3
+189 val_189 1
+190 val_190 1
+191 val_191 2
+192 val_192 1
+193 val_193 3
+194 val_194 1
+195 val_195 2
+196 val_196 1
+197 val_197 2
+199 val_199 3
+200 val_200 2
+201 val_201 1
+202 val_202 1
+203 val_203 2
+205 val_205 2
+207 val_207 2
+208 val_208 3
+209 val_209 2
+213 val_213 2
+214 val_214 1
+216 val_216 2
+217 val_217 2
+218 val_218 1
+219 val_219 2
+221 val_221 2
+222 val_222 1
+223 val_223 2
+224 val_224 2
+226 val_226 1
+228 val_228 1
+229 val_229 2
+230 val_230 5
+233 val_233 2
+235 val_235 1
+237 val_237 2
+238 val_238 2
+239 val_239 2
+241 val_241 1
+242 val_242 2
+244 val_244 1
+247 val_247 1
+248 val_248 1
+249 val_249 1
+252 val_252 1
+255 val_255 2
+256 val_256 2
+257 val_257 1
+258 val_258 1
+260 val_260 1
+262 val_262 1
+263 val_263 1
+265 val_265 2
+266 val_266 1
+272 val_272 2
+273 val_273 3
+274 val_274 1
+275 val_275 1
+277 val_277 4
+278 val_278 2
+280 val_280 2
+281 val_281 2
+282 val_282 2
+283 val_283 1
+284 val_284 1
+285 val_285 1
+286 val_286 1
+287 val_287 1
+288 val_288 2
+289 val_289 1
+291 val_291 1
+292 val_292 1
+296 val_296 1
+298 val_298 3
+302 val_302 1
+305 val_305 1
+306 val_306 1
+307 val_307 2
+308 val_308 1
+309 val_309 2
+310 val_310 1
+311 val_311 3
+315 val_315 1
+316 val_316 3
+317 val_317 2
+318 val_318 3
+321 val_321 2
+322 val_322 2
+323 val_323 1
+325 val_325 2
+327 val_327 3
+331 val_331 2
+332 val_332 1
+333 val_333 2
+335 val_335 1
+336 val_336 1
+338 val_338 1
+339 val_339 1
+341 val_341 1
+342 val_342 2
+344 val_344 2
+345 val_345 1
+348 val_348 5
+351 val_351 1
+353 val_353 2
+356 val_356 1
+360 val_360 1
+362 val_362 1
+364 val_364 1
+365 val_365 1
+366 val_366 1
+367 val_367 2
+368 val_368 1
+369 val_369 3
+373 val_373 1
+374 val_374 1
+375 val_375 1
+377 val_377 1
+378 val_378 1
+379 val_379 1
+382 val_382 2
+384 val_384 3
+386 val_386 1
+389 val_389 1
+392 val_392 1
+393 val_393 1
+394 val_394 1
+395 val_395 2
+396 val_396 3
+397 val_397 2
+399 val_399 2
+400 val_400 1
+401 val_401 5
+402 val_402 1
+403 val_403 3
+404 val_404 2
+406 val_406 4
+407 val_407 1
+409 val_409 3
+411 val_411 1
+413 val_413 2
+414 val_414 2
+417 val_417 3
+418 val_418 1
+419 val_419 1
+421 val_421 1
+424 val_424 2
+427 val_427 1
+429 val_429 2
+430 val_430 3
+431 val_431 3
+432 val_432 1
+435 val_435 1
+436 val_436 1
+437 val_437 1
+438 val_438 3
+439 val_439 2
+443 val_443 1
+444 val_444 1
+446 val_446 1
+448 val_448 1
+449 val_449 1
+452 val_452 1
+453 val_453 1
+454 val_454 3
+455 val_455 1
+457 val_457 1
+458 val_458 2
+459 val_459 2
+460 val_460 1
+462 val_462 2
+463 val_463 2
+466 val_466 3
+467 val_467 1
+468 val_468 4
+469 val_469 5
+470 val_470 1
+472 val_472 1
+475 val_475 1
+477 val_477 1
+478 val_478 2
+479 val_479 1
+480 val_480 3
+481 val_481 1
+482 val_482 1
+483 val_483 1
+484 val_484 1
+485 val_485 1
+487 val_487 1
+489 val_489 4
+490 val_490 1
+491 val_491 1
+492 val_492 2
+493 val_493 1
+494 val_494 1
+495 val_495 1
+496 val_496 1
+497 val_497 1
+498 val_498 3
\ No newline at end of file
http://git-wip-us.apache.org/repos/asf/spark/blob/7e17fe69/sql/hive/src/test/resources/golden/groupby9-19-55781df7ed3ff9e37001fbd7739b9c2e
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/golden/groupby9-19-55781df7ed3ff9e37001fbd7739b9c2e b/sql/hive/src/test/resources/golden/groupby9-19-55781df7ed3ff9e37001fbd7739b9c2e
new file mode 100644
index 0000000..e69de29
http://git-wip-us.apache.org/repos/asf/spark/blob/7e17fe69/sql/hive/src/test/resources/golden/groupby9-2-a4e1a4b250c160f9b90b12a2e7c5e82f
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/golden/groupby9-2-a4e1a4b250c160f9b90b12a2e7c5e82f b/sql/hive/src/test/resources/golden/groupby9-2-a4e1a4b250c160f9b90b12a2e7c5e82f
new file mode 100644
index 0000000..e69de29
http://git-wip-us.apache.org/repos/asf/spark/blob/7e17fe69/sql/hive/src/test/resources/golden/groupby9-20-ccc5914317422f569e8b7171a3b2b243
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/golden/groupby9-20-ccc5914317422f569e8b7171a3b2b243 b/sql/hive/src/test/resources/golden/groupby9-20-ccc5914317422f569e8b7171a3b2b243
new file mode 100644
index 0000000..e69de29
http://git-wip-us.apache.org/repos/asf/spark/blob/7e17fe69/sql/hive/src/test/resources/golden/groupby9-21-a6b1560ec2eb0bd64c9dd2c8daae99c5
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/golden/groupby9-21-a6b1560ec2eb0bd64c9dd2c8daae99c5 b/sql/hive/src/test/resources/golden/groupby9-21-a6b1560ec2eb0bd64c9dd2c8daae99c5
new file mode 100644
index 0000000..326493a
--- /dev/null
+++ b/sql/hive/src/test/resources/golden/groupby9-21-a6b1560ec2eb0bd64c9dd2c8daae99c5
@@ -0,0 +1,309 @@
+0 1
+2 1
+4 1
+5 1
+8 1
+9 1
+10 1
+11 1
+12 1
+15 1
+17 1
+18 1
+19 1
+20 1
+24 1
+26 1
+27 1
+28 1
+30 1
+33 1
+34 1
+35 1
+37 1
+41 1
+42 1
+43 1
+44 1
+47 1
+51 1
+53 1
+54 1
+57 1
+58 1
+64 1
+65 1
+66 1
+67 1
+69 1
+70 1
+72 1
+74 1
+76 1
+77 1
+78 1
+80 1
+82 1
+83 1
+84 1
+85 1
+86 1
+87 1
+90 1
+92 1
+95 1
+96 1
+97 1
+98 1
+100 1
+103 1
+104 1
+105 1
+111 1
+113 1
+114 1
+116 1
+118 1
+119 1
+120 1
+125 1
+126 1
+128 1
+129 1
+131 1
+133 1
+134 1
+136 1
+137 1
+138 1
+143 1
+145 1
+146 1
+149 1
+150 1
+152 1
+153 1
+155 1
+156 1
+157 1
+158 1
+160 1
+162 1
+163 1
+164 1
+165 1
+166 1
+167 1
+168 1
+169 1
+170 1
+172 1
+174 1
+175 1
+176 1
+177 1
+178 1
+179 1
+180 1
+181 1
+183 1
+186 1
+187 1
+189 1
+190 1
+191 1
+192 1
+193 1
+194 1
+195 1
+196 1
+197 1
+199 1
+200 1
+201 1
+202 1
+203 1
+205 1
+207 1
+208 1
+209 1
+213 1
+214 1
+216 1
+217 1
+218 1
+219 1
+221 1
+222 1
+223 1
+224 1
+226 1
+228 1
+229 1
+230 1
+233 1
+235 1
+237 1
+238 1
+239 1
+241 1
+242 1
+244 1
+247 1
+248 1
+249 1
+252 1
+255 1
+256 1
+257 1
+258 1
+260 1
+262 1
+263 1
+265 1
+266 1
+272 1
+273 1
+274 1
+275 1
+277 1
+278 1
+280 1
+281 1
+282 1
+283 1
+284 1
+285 1
+286 1
+287 1
+288 1
+289 1
+291 1
+292 1
+296 1
+298 1
+302 1
+305 1
+306 1
+307 1
+308 1
+309 1
+310 1
+311 1
+315 1
+316 1
+317 1
+318 1
+321 1
+322 1
+323 1
+325 1
+327 1
+331 1
+332 1
+333 1
+335 1
+336 1
+338 1
+339 1
+341 1
+342 1
+344 1
+345 1
+348 1
+351 1
+353 1
+356 1
+360 1
+362 1
+364 1
+365 1
+366 1
+367 1
+368 1
+369 1
+373 1
+374 1
+375 1
+377 1
+378 1
+379 1
+382 1
+384 1
+386 1
+389 1
+392 1
+393 1
+394 1
+395 1
+396 1
+397 1
+399 1
+400 1
+401 1
+402 1
+403 1
+404 1
+406 1
+407 1
+409 1
+411 1
+413 1
+414 1
+417 1
+418 1
+419 1
+421 1
+424 1
+427 1
+429 1
+430 1
+431 1
+432 1
+435 1
+436 1
+437 1
+438 1
+439 1
+443 1
+444 1
+446 1
+448 1
+449 1
+452 1
+453 1
+454 1
+455 1
+457 1
+458 1
+459 1
+460 1
+462 1
+463 1
+466 1
+467 1
+468 1
+469 1
+470 1
+472 1
+475 1
+477 1
+478 1
+479 1
+480 1
+481 1
+482 1
+483 1
+484 1
+485 1
+487 1
+489 1
+490 1
+491 1
+492 1
+493 1
+494 1
+495 1
+496 1
+497 1
+498 1
\ No newline at end of file
http://git-wip-us.apache.org/repos/asf/spark/blob/7e17fe69/sql/hive/src/test/resources/golden/groupby9-22-404392d6faff5db5f36b4aa87ac8e8c9
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/golden/groupby9-22-404392d6faff5db5f36b4aa87ac8e8c9 b/sql/hive/src/test/resources/golden/groupby9-22-404392d6faff5db5f36b4aa87ac8e8c9
new file mode 100644
index 0000000..4ef88d5
--- /dev/null
+++ b/sql/hive/src/test/resources/golden/groupby9-22-404392d6faff5db5f36b4aa87ac8e8c9
@@ -0,0 +1,309 @@
+0 val_0 1
+10 val_10 1
+100 val_100 1
+103 val_103 1
+104 val_104 1
+105 val_105 1
+11 val_11 1
+111 val_111 1
+113 val_113 1
+114 val_114 1
+116 val_116 1
+118 val_118 1
+119 val_119 1
+12 val_12 1
+120 val_120 1
+125 val_125 1
+126 val_126 1
+128 val_128 1
+129 val_129 1
+131 val_131 1
+133 val_133 1
+134 val_134 1
+136 val_136 1
+137 val_137 1
+138 val_138 1
+143 val_143 1
+145 val_145 1
+146 val_146 1
+149 val_149 1
+15 val_15 1
+150 val_150 1
+152 val_152 1
+153 val_153 1
+155 val_155 1
+156 val_156 1
+157 val_157 1
+158 val_158 1
+160 val_160 1
+162 val_162 1
+163 val_163 1
+164 val_164 1
+165 val_165 1
+166 val_166 1
+167 val_167 1
+168 val_168 1
+169 val_169 1
+17 val_17 1
+170 val_170 1
+172 val_172 1
+174 val_174 1
+175 val_175 1
+176 val_176 1
+177 val_177 1
+178 val_178 1
+179 val_179 1
+18 val_18 1
+180 val_180 1
+181 val_181 1
+183 val_183 1
+186 val_186 1
+187 val_187 1
+189 val_189 1
+19 val_19 1
+190 val_190 1
+191 val_191 1
+192 val_192 1
+193 val_193 1
+194 val_194 1
+195 val_195 1
+196 val_196 1
+197 val_197 1
+199 val_199 1
+2 val_2 1
+20 val_20 1
+200 val_200 1
+201 val_201 1
+202 val_202 1
+203 val_203 1
+205 val_205 1
+207 val_207 1
+208 val_208 1
+209 val_209 1
+213 val_213 1
+214 val_214 1
+216 val_216 1
+217 val_217 1
+218 val_218 1
+219 val_219 1
+221 val_221 1
+222 val_222 1
+223 val_223 1
+224 val_224 1
+226 val_226 1
+228 val_228 1
+229 val_229 1
+230 val_230 1
+233 val_233 1
+235 val_235 1
+237 val_237 1
+238 val_238 1
+239 val_239 1
+24 val_24 1
+241 val_241 1
+242 val_242 1
+244 val_244 1
+247 val_247 1
+248 val_248 1
+249 val_249 1
+252 val_252 1
+255 val_255 1
+256 val_256 1
+257 val_257 1
+258 val_258 1
+26 val_26 1
+260 val_260 1
+262 val_262 1
+263 val_263 1
+265 val_265 1
+266 val_266 1
+27 val_27 1
+272 val_272 1
+273 val_273 1
+274 val_274 1
+275 val_275 1
+277 val_277 1
+278 val_278 1
+28 val_28 1
+280 val_280 1
+281 val_281 1
+282 val_282 1
+283 val_283 1
+284 val_284 1
+285 val_285 1
+286 val_286 1
+287 val_287 1
+288 val_288 1
+289 val_289 1
+291 val_291 1
+292 val_292 1
+296 val_296 1
+298 val_298 1
+30 val_30 1
+302 val_302 1
+305 val_305 1
+306 val_306 1
+307 val_307 1
+308 val_308 1
+309 val_309 1
+310 val_310 1
+311 val_311 1
+315 val_315 1
+316 val_316 1
+317 val_317 1
+318 val_318 1
+321 val_321 1
+322 val_322 1
+323 val_323 1
+325 val_325 1
+327 val_327 1
+33 val_33 1
+331 val_331 1
+332 val_332 1
+333 val_333 1
+335 val_335 1
+336 val_336 1
+338 val_338 1
+339 val_339 1
+34 val_34 1
+341 val_341 1
+342 val_342 1
+344 val_344 1
+345 val_345 1
+348 val_348 1
+35 val_35 1
+351 val_351 1
+353 val_353 1
+356 val_356 1
+360 val_360 1
+362 val_362 1
+364 val_364 1
+365 val_365 1
+366 val_366 1
+367 val_367 1
+368 val_368 1
+369 val_369 1
+37 val_37 1
+373 val_373 1
+374 val_374 1
+375 val_375 1
+377 val_377 1
+378 val_378 1
+379 val_379 1
+382 val_382 1
+384 val_384 1
+386 val_386 1
+389 val_389 1
+392 val_392 1
+393 val_393 1
+394 val_394 1
+395 val_395 1
+396 val_396 1
+397 val_397 1
+399 val_399 1
+4 val_4 1
+400 val_400 1
+401 val_401 1
+402 val_402 1
+403 val_403 1
+404 val_404 1
+406 val_406 1
+407 val_407 1
+409 val_409 1
+41 val_41 1
+411 val_411 1
+413 val_413 1
+414 val_414 1
+417 val_417 1
+418 val_418 1
+419 val_419 1
+42 val_42 1
+421 val_421 1
+424 val_424 1
+427 val_427 1
+429 val_429 1
+43 val_43 1
+430 val_430 1
+431 val_431 1
+432 val_432 1
+435 val_435 1
+436 val_436 1
+437 val_437 1
+438 val_438 1
+439 val_439 1
+44 val_44 1
+443 val_443 1
+444 val_444 1
+446 val_446 1
+448 val_448 1
+449 val_449 1
+452 val_452 1
+453 val_453 1
+454 val_454 1
+455 val_455 1
+457 val_457 1
+458 val_458 1
+459 val_459 1
+460 val_460 1
+462 val_462 1
+463 val_463 1
+466 val_466 1
+467 val_467 1
+468 val_468 1
+469 val_469 1
+47 val_47 1
+470 val_470 1
+472 val_472 1
+475 val_475 1
+477 val_477 1
+478 val_478 1
+479 val_479 1
+480 val_480 1
+481 val_481 1
+482 val_482 1
+483 val_483 1
+484 val_484 1
+485 val_485 1
+487 val_487 1
+489 val_489 1
+490 val_490 1
+491 val_491 1
+492 val_492 1
+493 val_493 1
+494 val_494 1
+495 val_495 1
+496 val_496 1
+497 val_497 1
+498 val_498 1
+5 val_5 1
+51 val_51 1
+53 val_53 1
+54 val_54 1
+57 val_57 1
+58 val_58 1
+64 val_64 1
+65 val_65 1
+66 val_66 1
+67 val_67 1
+69 val_69 1
+70 val_70 1
+72 val_72 1
+74 val_74 1
+76 val_76 1
+77 val_77 1
+78 val_78 1
+8 val_8 1
+80 val_80 1
+82 val_82 1
+83 val_83 1
+84 val_84 1
+85 val_85 1
+86 val_86 1
+87 val_87 1
+9 val_9 1
+90 val_90 1
+92 val_92 1
+95 val_95 1
+96 val_96 1
+97 val_97 1
+98 val_98 1
\ No newline at end of file
http://git-wip-us.apache.org/repos/asf/spark/blob/7e17fe69/sql/hive/src/test/resources/golden/groupby9-3-9f4c2e7d95494bcdc7c4ed19e0434de6
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/golden/groupby9-3-9f4c2e7d95494bcdc7c4ed19e0434de6 b/sql/hive/src/test/resources/golden/groupby9-3-9f4c2e7d95494bcdc7c4ed19e0434de6
new file mode 100644
index 0000000..e69de29
http://git-wip-us.apache.org/repos/asf/spark/blob/7e17fe69/sql/hive/src/test/resources/golden/groupby9-4-a6b1560ec2eb0bd64c9dd2c8daae99c5
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/golden/groupby9-4-a6b1560ec2eb0bd64c9dd2c8daae99c5 b/sql/hive/src/test/resources/golden/groupby9-4-a6b1560ec2eb0bd64c9dd2c8daae99c5
new file mode 100644
index 0000000..326493a
--- /dev/null
+++ b/sql/hive/src/test/resources/golden/groupby9-4-a6b1560ec2eb0bd64c9dd2c8daae99c5
@@ -0,0 +1,309 @@
+0 1
+2 1
+4 1
+5 1
+8 1
+9 1
+10 1
+11 1
+12 1
+15 1
+17 1
+18 1
+19 1
+20 1
+24 1
+26 1
+27 1
+28 1
+30 1
+33 1
+34 1
+35 1
+37 1
+41 1
+42 1
+43 1
+44 1
+47 1
+51 1
+53 1
+54 1
+57 1
+58 1
+64 1
+65 1
+66 1
+67 1
+69 1
+70 1
+72 1
+74 1
+76 1
+77 1
+78 1
+80 1
+82 1
+83 1
+84 1
+85 1
+86 1
+87 1
+90 1
+92 1
+95 1
+96 1
+97 1
+98 1
+100 1
+103 1
+104 1
+105 1
+111 1
+113 1
+114 1
+116 1
+118 1
+119 1
+120 1
+125 1
+126 1
+128 1
+129 1
+131 1
+133 1
+134 1
+136 1
+137 1
+138 1
+143 1
+145 1
+146 1
+149 1
+150 1
+152 1
+153 1
+155 1
+156 1
+157 1
+158 1
+160 1
+162 1
+163 1
+164 1
+165 1
+166 1
+167 1
+168 1
+169 1
+170 1
+172 1
+174 1
+175 1
+176 1
+177 1
+178 1
+179 1
+180 1
+181 1
+183 1
+186 1
+187 1
+189 1
+190 1
+191 1
+192 1
+193 1
+194 1
+195 1
+196 1
+197 1
+199 1
+200 1
+201 1
+202 1
+203 1
+205 1
+207 1
+208 1
+209 1
+213 1
+214 1
+216 1
+217 1
+218 1
+219 1
+221 1
+222 1
+223 1
+224 1
+226 1
+228 1
+229 1
+230 1
+233 1
+235 1
+237 1
+238 1
+239 1
+241 1
+242 1
+244 1
+247 1
+248 1
+249 1
+252 1
+255 1
+256 1
+257 1
+258 1
+260 1
+262 1
+263 1
+265 1
+266 1
+272 1
+273 1
+274 1
+275 1
+277 1
+278 1
+280 1
+281 1
+282 1
+283 1
+284 1
+285 1
+286 1
+287 1
+288 1
+289 1
+291 1
+292 1
+296 1
+298 1
+302 1
+305 1
+306 1
+307 1
+308 1
+309 1
+310 1
+311 1
+315 1
+316 1
+317 1
+318 1
+321 1
+322 1
+323 1
+325 1
+327 1
+331 1
+332 1
+333 1
+335 1
+336 1
+338 1
+339 1
+341 1
+342 1
+344 1
+345 1
+348 1
+351 1
+353 1
+356 1
+360 1
+362 1
+364 1
+365 1
+366 1
+367 1
+368 1
+369 1
+373 1
+374 1
+375 1
+377 1
+378 1
+379 1
+382 1
+384 1
+386 1
+389 1
+392 1
+393 1
+394 1
+395 1
+396 1
+397 1
+399 1
+400 1
+401 1
+402 1
+403 1
+404 1
+406 1
+407 1
+409 1
+411 1
+413 1
+414 1
+417 1
+418 1
+419 1
+421 1
+424 1
+427 1
+429 1
+430 1
+431 1
+432 1
+435 1
+436 1
+437 1
+438 1
+439 1
+443 1
+444 1
+446 1
+448 1
+449 1
+452 1
+453 1
+454 1
+455 1
+457 1
+458 1
+459 1
+460 1
+462 1
+463 1
+466 1
+467 1
+468 1
+469 1
+470 1
+472 1
+475 1
+477 1
+478 1
+479 1
+480 1
+481 1
+482 1
+483 1
+484 1
+485 1
+487 1
+489 1
+490 1
+491 1
+492 1
+493 1
+494 1
+495 1
+496 1
+497 1
+498 1
\ No newline at end of file
http://git-wip-us.apache.org/repos/asf/spark/blob/7e17fe69/sql/hive/src/test/resources/golden/groupby9-5-404392d6faff5db5f36b4aa87ac8e8c9
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/golden/groupby9-5-404392d6faff5db5f36b4aa87ac8e8c9 b/sql/hive/src/test/resources/golden/groupby9-5-404392d6faff5db5f36b4aa87ac8e8c9
new file mode 100644
index 0000000..0e40f3f
--- /dev/null
+++ b/sql/hive/src/test/resources/golden/groupby9-5-404392d6faff5db5f36b4aa87ac8e8c9
@@ -0,0 +1,309 @@
+0 val_0 1
+2 val_2 1
+4 val_4 1
+5 val_5 1
+8 val_8 1
+9 val_9 1
+10 val_10 1
+11 val_11 1
+12 val_12 1
+15 val_15 1
+17 val_17 1
+18 val_18 1
+19 val_19 1
+20 val_20 1
+24 val_24 1
+26 val_26 1
+27 val_27 1
+28 val_28 1
+30 val_30 1
+33 val_33 1
+34 val_34 1
+35 val_35 1
+37 val_37 1
+41 val_41 1
+42 val_42 1
+43 val_43 1
+44 val_44 1
+47 val_47 1
+51 val_51 1
+53 val_53 1
+54 val_54 1
+57 val_57 1
+58 val_58 1
+64 val_64 1
+65 val_65 1
+66 val_66 1
+67 val_67 1
+69 val_69 1
+70 val_70 1
+72 val_72 1
+74 val_74 1
+76 val_76 1
+77 val_77 1
+78 val_78 1
+80 val_80 1
+82 val_82 1
+83 val_83 1
+84 val_84 1
+85 val_85 1
+86 val_86 1
+87 val_87 1
+90 val_90 1
+92 val_92 1
+95 val_95 1
+96 val_96 1
+97 val_97 1
+98 val_98 1
+100 val_100 1
+103 val_103 1
+104 val_104 1
+105 val_105 1
+111 val_111 1
+113 val_113 1
+114 val_114 1
+116 val_116 1
+118 val_118 1
+119 val_119 1
+120 val_120 1
+125 val_125 1
+126 val_126 1
+128 val_128 1
+129 val_129 1
+131 val_131 1
+133 val_133 1
+134 val_134 1
+136 val_136 1
+137 val_137 1
+138 val_138 1
+143 val_143 1
+145 val_145 1
+146 val_146 1
+149 val_149 1
+150 val_150 1
+152 val_152 1
+153 val_153 1
+155 val_155 1
+156 val_156 1
+157 val_157 1
+158 val_158 1
+160 val_160 1
+162 val_162 1
+163 val_163 1
+164 val_164 1
+165 val_165 1
+166 val_166 1
+167 val_167 1
+168 val_168 1
+169 val_169 1
+170 val_170 1
+172 val_172 1
+174 val_174 1
+175 val_175 1
+176 val_176 1
+177 val_177 1
+178 val_178 1
+179 val_179 1
+180 val_180 1
+181 val_181 1
+183 val_183 1
+186 val_186 1
+187 val_187 1
+189 val_189 1
+190 val_190 1
+191 val_191 1
+192 val_192 1
+193 val_193 1
+194 val_194 1
+195 val_195 1
+196 val_196 1
+197 val_197 1
+199 val_199 1
+200 val_200 1
+201 val_201 1
+202 val_202 1
+203 val_203 1
+205 val_205 1
+207 val_207 1
+208 val_208 1
+209 val_209 1
+213 val_213 1
+214 val_214 1
+216 val_216 1
+217 val_217 1
+218 val_218 1
+219 val_219 1
+221 val_221 1
+222 val_222 1
+223 val_223 1
+224 val_224 1
+226 val_226 1
+228 val_228 1
+229 val_229 1
+230 val_230 1
+233 val_233 1
+235 val_235 1
+237 val_237 1
+238 val_238 1
+239 val_239 1
+241 val_241 1
+242 val_242 1
+244 val_244 1
+247 val_247 1
+248 val_248 1
+249 val_249 1
+252 val_252 1
+255 val_255 1
+256 val_256 1
+257 val_257 1
+258 val_258 1
+260 val_260 1
+262 val_262 1
+263 val_263 1
+265 val_265 1
+266 val_266 1
+272 val_272 1
+273 val_273 1
+274 val_274 1
+275 val_275 1
+277 val_277 1
+278 val_278 1
+280 val_280 1
+281 val_281 1
+282 val_282 1
+283 val_283 1
+284 val_284 1
+285 val_285 1
+286 val_286 1
+287 val_287 1
+288 val_288 1
+289 val_289 1
+291 val_291 1
+292 val_292 1
+296 val_296 1
+298 val_298 1
+302 val_302 1
+305 val_305 1
+306 val_306 1
+307 val_307 1
+308 val_308 1
+309 val_309 1
+310 val_310 1
+311 val_311 1
+315 val_315 1
+316 val_316 1
+317 val_317 1
+318 val_318 1
+321 val_321 1
+322 val_322 1
+323 val_323 1
+325 val_325 1
+327 val_327 1
+331 val_331 1
+332 val_332 1
+333 val_333 1
+335 val_335 1
+336 val_336 1
+338 val_338 1
+339 val_339 1
+341 val_341 1
+342 val_342 1
+344 val_344 1
+345 val_345 1
+348 val_348 1
+351 val_351 1
+353 val_353 1
+356 val_356 1
+360 val_360 1
+362 val_362 1
+364 val_364 1
+365 val_365 1
+366 val_366 1
+367 val_367 1
+368 val_368 1
+369 val_369 1
+373 val_373 1
+374 val_374 1
+375 val_375 1
+377 val_377 1
+378 val_378 1
+379 val_379 1
+382 val_382 1
+384 val_384 1
+386 val_386 1
+389 val_389 1
+392 val_392 1
+393 val_393 1
+394 val_394 1
+395 val_395 1
+396 val_396 1
+397 val_397 1
+399 val_399 1
+400 val_400 1
+401 val_401 1
+402 val_402 1
+403 val_403 1
+404 val_404 1
+406 val_406 1
+407 val_407 1
+409 val_409 1
+411 val_411 1
+413 val_413 1
+414 val_414 1
+417 val_417 1
+418 val_418 1
+419 val_419 1
+421 val_421 1
+424 val_424 1
+427 val_427 1
+429 val_429 1
+430 val_430 1
+431 val_431 1
+432 val_432 1
+435 val_435 1
+436 val_436 1
+437 val_437 1
+438 val_438 1
+439 val_439 1
+443 val_443 1
+444 val_444 1
+446 val_446 1
+448 val_448 1
+449 val_449 1
+452 val_452 1
+453 val_453 1
+454 val_454 1
+455 val_455 1
+457 val_457 1
+458 val_458 1
+459 val_459 1
+460 val_460 1
+462 val_462 1
+463 val_463 1
+466 val_466 1
+467 val_467 1
+468 val_468 1
+469 val_469 1
+470 val_470 1
+472 val_472 1
+475 val_475 1
+477 val_477 1
+478 val_478 1
+479 val_479 1
+480 val_480 1
+481 val_481 1
+482 val_482 1
+483 val_483 1
+484 val_484 1
+485 val_485 1
+487 val_487 1
+489 val_489 1
+490 val_490 1
+491 val_491 1
+492 val_492 1
+493 val_493 1
+494 val_494 1
+495 val_495 1
+496 val_496 1
+497 val_497 1
+498 val_498 1
\ No newline at end of file
http://git-wip-us.apache.org/repos/asf/spark/blob/7e17fe69/sql/hive/src/test/resources/golden/groupby9-6-55781df7ed3ff9e37001fbd7739b9c2e
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/golden/groupby9-6-55781df7ed3ff9e37001fbd7739b9c2e b/sql/hive/src/test/resources/golden/groupby9-6-55781df7ed3ff9e37001fbd7739b9c2e
new file mode 100644
index 0000000..e69de29
http://git-wip-us.apache.org/repos/asf/spark/blob/7e17fe69/sql/hive/src/test/resources/golden/groupby9-7-ccc5914317422f569e8b7171a3b2b243
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/golden/groupby9-7-ccc5914317422f569e8b7171a3b2b243 b/sql/hive/src/test/resources/golden/groupby9-7-ccc5914317422f569e8b7171a3b2b243
new file mode 100644
index 0000000..e69de29
http://git-wip-us.apache.org/repos/asf/spark/blob/7e17fe69/sql/hive/src/test/resources/golden/groupby9-8-a6b1560ec2eb0bd64c9dd2c8daae99c5
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/golden/groupby9-8-a6b1560ec2eb0bd64c9dd2c8daae99c5 b/sql/hive/src/test/resources/golden/groupby9-8-a6b1560ec2eb0bd64c9dd2c8daae99c5
new file mode 100644
index 0000000..326493a
--- /dev/null
+++ b/sql/hive/src/test/resources/golden/groupby9-8-a6b1560ec2eb0bd64c9dd2c8daae99c5
@@ -0,0 +1,309 @@
+0 1
+2 1
+4 1
+5 1
+8 1
+9 1
+10 1
+11 1
+12 1
+15 1
+17 1
+18 1
+19 1
+20 1
+24 1
+26 1
+27 1
+28 1
+30 1
+33 1
+34 1
+35 1
+37 1
+41 1
+42 1
+43 1
+44 1
+47 1
+51 1
+53 1
+54 1
+57 1
+58 1
+64 1
+65 1
+66 1
+67 1
+69 1
+70 1
+72 1
+74 1
+76 1
+77 1
+78 1
+80 1
+82 1
+83 1
+84 1
+85 1
+86 1
+87 1
+90 1
+92 1
+95 1
+96 1
+97 1
+98 1
+100 1
+103 1
+104 1
+105 1
+111 1
+113 1
+114 1
+116 1
+118 1
+119 1
+120 1
+125 1
+126 1
+128 1
+129 1
+131 1
+133 1
+134 1
+136 1
+137 1
+138 1
+143 1
+145 1
+146 1
+149 1
+150 1
+152 1
+153 1
+155 1
+156 1
+157 1
+158 1
+160 1
+162 1
+163 1
+164 1
+165 1
+166 1
+167 1
+168 1
+169 1
+170 1
+172 1
+174 1
+175 1
+176 1
+177 1
+178 1
+179 1
+180 1
+181 1
+183 1
+186 1
+187 1
+189 1
+190 1
+191 1
+192 1
+193 1
+194 1
+195 1
+196 1
+197 1
+199 1
+200 1
+201 1
+202 1
+203 1
+205 1
+207 1
+208 1
+209 1
+213 1
+214 1
+216 1
+217 1
+218 1
+219 1
+221 1
+222 1
+223 1
+224 1
+226 1
+228 1
+229 1
+230 1
+233 1
+235 1
+237 1
+238 1
+239 1
+241 1
+242 1
+244 1
+247 1
+248 1
+249 1
+252 1
+255 1
+256 1
+257 1
+258 1
+260 1
+262 1
+263 1
+265 1
+266 1
+272 1
+273 1
+274 1
+275 1
+277 1
+278 1
+280 1
+281 1
+282 1
+283 1
+284 1
+285 1
+286 1
+287 1
+288 1
+289 1
+291 1
+292 1
+296 1
+298 1
+302 1
+305 1
+306 1
+307 1
+308 1
+309 1
+310 1
+311 1
+315 1
+316 1
+317 1
+318 1
+321 1
+322 1
+323 1
+325 1
+327 1
+331 1
+332 1
+333 1
+335 1
+336 1
+338 1
+339 1
+341 1
+342 1
+344 1
+345 1
+348 1
+351 1
+353 1
+356 1
+360 1
+362 1
+364 1
+365 1
+366 1
+367 1
+368 1
+369 1
+373 1
+374 1
+375 1
+377 1
+378 1
+379 1
+382 1
+384 1
+386 1
+389 1
+392 1
+393 1
+394 1
+395 1
+396 1
+397 1
+399 1
+400 1
+401 1
+402 1
+403 1
+404 1
+406 1
+407 1
+409 1
+411 1
+413 1
+414 1
+417 1
+418 1
+419 1
+421 1
+424 1
+427 1
+429 1
+430 1
+431 1
+432 1
+435 1
+436 1
+437 1
+438 1
+439 1
+443 1
+444 1
+446 1
+448 1
+449 1
+452 1
+453 1
+454 1
+455 1
+457 1
+458 1
+459 1
+460 1
+462 1
+463 1
+466 1
+467 1
+468 1
+469 1
+470 1
+472 1
+475 1
+477 1
+478 1
+479 1
+480 1
+481 1
+482 1
+483 1
+484 1
+485 1
+487 1
+489 1
+490 1
+491 1
+492 1
+493 1
+494 1
+495 1
+496 1
+497 1
+498 1
\ No newline at end of file
http://git-wip-us.apache.org/repos/asf/spark/blob/7e17fe69/sql/hive/src/test/resources/golden/groupby9-9-404392d6faff5db5f36b4aa87ac8e8c9
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/golden/groupby9-9-404392d6faff5db5f36b4aa87ac8e8c9 b/sql/hive/src/test/resources/golden/groupby9-9-404392d6faff5db5f36b4aa87ac8e8c9
new file mode 100644
index 0000000..4ef88d5
--- /dev/null
+++ b/sql/hive/src/test/resources/golden/groupby9-9-404392d6faff5db5f36b4aa87ac8e8c9
@@ -0,0 +1,309 @@
+0 val_0 1
+10 val_10 1
+100 val_100 1
+103 val_103 1
+104 val_104 1
+105 val_105 1
+11 val_11 1
+111 val_111 1
+113 val_113 1
+114 val_114 1
+116 val_116 1
+118 val_118 1
+119 val_119 1
+12 val_12 1
+120 val_120 1
+125 val_125 1
+126 val_126 1
+128 val_128 1
+129 val_129 1
+131 val_131 1
+133 val_133 1
+134 val_134 1
+136 val_136 1
+137 val_137 1
+138 val_138 1
+143 val_143 1
+145 val_145 1
+146 val_146 1
+149 val_149 1
+15 val_15 1
+150 val_150 1
+152 val_152 1
+153 val_153 1
+155 val_155 1
+156 val_156 1
+157 val_157 1
+158 val_158 1
+160 val_160 1
+162 val_162 1
+163 val_163 1
+164 val_164 1
+165 val_165 1
+166 val_166 1
+167 val_167 1
+168 val_168 1
+169 val_169 1
+17 val_17 1
+170 val_170 1
+172 val_172 1
+174 val_174 1
+175 val_175 1
+176 val_176 1
+177 val_177 1
+178 val_178 1
+179 val_179 1
+18 val_18 1
+180 val_180 1
+181 val_181 1
+183 val_183 1
+186 val_186 1
+187 val_187 1
+189 val_189 1
+19 val_19 1
+190 val_190 1
+191 val_191 1
+192 val_192 1
+193 val_193 1
+194 val_194 1
+195 val_195 1
+196 val_196 1
+197 val_197 1
+199 val_199 1
+2 val_2 1
+20 val_20 1
+200 val_200 1
+201 val_201 1
+202 val_202 1
+203 val_203 1
+205 val_205 1
+207 val_207 1
+208 val_208 1
+209 val_209 1
+213 val_213 1
+214 val_214 1
+216 val_216 1
+217 val_217 1
+218 val_218 1
+219 val_219 1
+221 val_221 1
+222 val_222 1
+223 val_223 1
+224 val_224 1
+226 val_226 1
+228 val_228 1
+229 val_229 1
+230 val_230 1
+233 val_233 1
+235 val_235 1
+237 val_237 1
+238 val_238 1
+239 val_239 1
+24 val_24 1
+241 val_241 1
+242 val_242 1
+244 val_244 1
+247 val_247 1
+248 val_248 1
+249 val_249 1
+252 val_252 1
+255 val_255 1
+256 val_256 1
+257 val_257 1
+258 val_258 1
+26 val_26 1
+260 val_260 1
+262 val_262 1
+263 val_263 1
+265 val_265 1
+266 val_266 1
+27 val_27 1
+272 val_272 1
+273 val_273 1
+274 val_274 1
+275 val_275 1
+277 val_277 1
+278 val_278 1
+28 val_28 1
+280 val_280 1
+281 val_281 1
+282 val_282 1
+283 val_283 1
+284 val_284 1
+285 val_285 1
+286 val_286 1
+287 val_287 1
+288 val_288 1
+289 val_289 1
+291 val_291 1
+292 val_292 1
+296 val_296 1
+298 val_298 1
+30 val_30 1
+302 val_302 1
+305 val_305 1
+306 val_306 1
+307 val_307 1
+308 val_308 1
+309 val_309 1
+310 val_310 1
+311 val_311 1
+315 val_315 1
+316 val_316 1
+317 val_317 1
+318 val_318 1
+321 val_321 1
+322 val_322 1
+323 val_323 1
+325 val_325 1
+327 val_327 1
+33 val_33 1
+331 val_331 1
+332 val_332 1
+333 val_333 1
+335 val_335 1
+336 val_336 1
+338 val_338 1
+339 val_339 1
+34 val_34 1
+341 val_341 1
+342 val_342 1
+344 val_344 1
+345 val_345 1
+348 val_348 1
+35 val_35 1
+351 val_351 1
+353 val_353 1
+356 val_356 1
+360 val_360 1
+362 val_362 1
+364 val_364 1
+365 val_365 1
+366 val_366 1
+367 val_367 1
+368 val_368 1
+369 val_369 1
+37 val_37 1
+373 val_373 1
+374 val_374 1
+375 val_375 1
+377 val_377 1
+378 val_378 1
+379 val_379 1
+382 val_382 1
+384 val_384 1
+386 val_386 1
+389 val_389 1
+392 val_392 1
+393 val_393 1
+394 val_394 1
+395 val_395 1
+396 val_396 1
+397 val_397 1
+399 val_399 1
+4 val_4 1
+400 val_400 1
+401 val_401 1
+402 val_402 1
+403 val_403 1
+404 val_404 1
+406 val_406 1
+407 val_407 1
+409 val_409 1
+41 val_41 1
+411 val_411 1
+413 val_413 1
+414 val_414 1
+417 val_417 1
+418 val_418 1
+419 val_419 1
+42 val_42 1
+421 val_421 1
+424 val_424 1
+427 val_427 1
+429 val_429 1
+43 val_43 1
+430 val_430 1
+431 val_431 1
+432 val_432 1
+435 val_435 1
+436 val_436 1
+437 val_437 1
+438 val_438 1
+439 val_439 1
+44 val_44 1
+443 val_443 1
+444 val_444 1
+446 val_446 1
+448 val_448 1
+449 val_449 1
+452 val_452 1
+453 val_453 1
+454 val_454 1
+455 val_455 1
+457 val_457 1
+458 val_458 1
+459 val_459 1
+460 val_460 1
+462 val_462 1
+463 val_463 1
+466 val_466 1
+467 val_467 1
+468 val_468 1
+469 val_469 1
+47 val_47 1
+470 val_470 1
+472 val_472 1
+475 val_475 1
+477 val_477 1
+478 val_478 1
+479 val_479 1
+480 val_480 1
+481 val_481 1
+482 val_482 1
+483 val_483 1
+484 val_484 1
+485 val_485 1
+487 val_487 1
+489 val_489 1
+490 val_490 1
+491 val_491 1
+492 val_492 1
+493 val_493 1
+494 val_494 1
+495 val_495 1
+496 val_496 1
+497 val_497 1
+498 val_498 1
+5 val_5 1
+51 val_51 1
+53 val_53 1
+54 val_54 1
+57 val_57 1
+58 val_58 1
+64 val_64 1
+65 val_65 1
+66 val_66 1
+67 val_67 1
+69 val_69 1
+70 val_70 1
+72 val_72 1
+74 val_74 1
+76 val_76 1
+77 val_77 1
+78 val_78 1
+8 val_8 1
+80 val_80 1
+82 val_82 1
+83 val_83 1
+84 val_84 1
+85 val_85 1
+86 val_86 1
+87 val_87 1
+9 val_9 1
+90 val_90 1
+92 val_92 1
+95 val_95 1
+96 val_96 1
+97 val_97 1
+98 val_98 1
\ No newline at end of file
http://git-wip-us.apache.org/repos/asf/spark/blob/7e17fe69/sql/hive/src/test/resources/golden/groupby_bigdata-0-e011be1172043c0c6d0fd2c0e89f361e
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/golden/groupby_bigdata-0-e011be1172043c0c6d0fd2c0e89f361e b/sql/hive/src/test/resources/golden/groupby_bigdata-0-e011be1172043c0c6d0fd2c0e89f361e
new file mode 100644
index 0000000..573541a
--- /dev/null
+++ b/sql/hive/src/test/resources/golden/groupby_bigdata-0-e011be1172043c0c6d0fd2c0e89f361e
@@ -0,0 +1 @@
+0
http://git-wip-us.apache.org/repos/asf/spark/blob/7e17fe69/sql/hive/src/test/resources/golden/groupby_bigdata-1-1100bb0c115c024998d35888ae5bbd71
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/golden/groupby_bigdata-1-1100bb0c115c024998d35888ae5bbd71 b/sql/hive/src/test/resources/golden/groupby_bigdata-1-1100bb0c115c024998d35888ae5bbd71
new file mode 100644
index 0000000..573541a
--- /dev/null
+++ b/sql/hive/src/test/resources/golden/groupby_bigdata-1-1100bb0c115c024998d35888ae5bbd71
@@ -0,0 +1 @@
+0
http://git-wip-us.apache.org/repos/asf/spark/blob/7e17fe69/sql/hive/src/test/resources/golden/groupby_bigdata-2-3688b45adbdb190d58799c0b6d601055
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/golden/groupby_bigdata-2-3688b45adbdb190d58799c0b6d601055 b/sql/hive/src/test/resources/golden/groupby_bigdata-2-3688b45adbdb190d58799c0b6d601055
new file mode 100644
index 0000000..d00491f
--- /dev/null
+++ b/sql/hive/src/test/resources/golden/groupby_bigdata-2-3688b45adbdb190d58799c0b6d601055
@@ -0,0 +1 @@
+1
http://git-wip-us.apache.org/repos/asf/spark/blob/7e17fe69/sql/hive/src/test/resources/golden/groupby_complex_types-0-de39f8b5f4305136d945da94d5222283
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/golden/groupby_complex_types-0-de39f8b5f4305136d945da94d5222283 b/sql/hive/src/test/resources/golden/groupby_complex_types-0-de39f8b5f4305136d945da94d5222283
new file mode 100644
index 0000000..e69de29
http://git-wip-us.apache.org/repos/asf/spark/blob/7e17fe69/sql/hive/src/test/resources/golden/groupby_complex_types-1-10fe6134247226ab2b309bb62460d080
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/golden/groupby_complex_types-1-10fe6134247226ab2b309bb62460d080 b/sql/hive/src/test/resources/golden/groupby_complex_types-1-10fe6134247226ab2b309bb62460d080
new file mode 100644
index 0000000..e69de29
http://git-wip-us.apache.org/repos/asf/spark/blob/7e17fe69/sql/hive/src/test/resources/golden/groupby_complex_types-2-2500cd8e85b71222253a05a979442a4a
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/golden/groupby_complex_types-2-2500cd8e85b71222253a05a979442a4a b/sql/hive/src/test/resources/golden/groupby_complex_types-2-2500cd8e85b71222253a05a979442a4a
new file mode 100644
index 0000000..e69de29
http://git-wip-us.apache.org/repos/asf/spark/blob/7e17fe69/sql/hive/src/test/resources/golden/groupby_complex_types-3-85850072f0f9604d4e55a08fb9c45ba6
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/golden/groupby_complex_types-3-85850072f0f9604d4e55a08fb9c45ba6 b/sql/hive/src/test/resources/golden/groupby_complex_types-3-85850072f0f9604d4e55a08fb9c45ba6
new file mode 100644
index 0000000..e69de29
http://git-wip-us.apache.org/repos/asf/spark/blob/7e17fe69/sql/hive/src/test/resources/golden/groupby_complex_types_multi_single_reducer-0-b31bf66c43bb9f7ddc09b138b7bf36e0
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/golden/groupby_complex_types_multi_single_reducer-0-b31bf66c43bb9f7ddc09b138b7bf36e0 b/sql/hive/src/test/resources/golden/groupby_complex_types_multi_single_reducer-0-b31bf66c43bb9f7ddc09b138b7bf36e0
new file mode 100644
index 0000000..573541a
--- /dev/null
+++ b/sql/hive/src/test/resources/golden/groupby_complex_types_multi_single_reducer-0-b31bf66c43bb9f7ddc09b138b7bf36e0
@@ -0,0 +1 @@
+0
http://git-wip-us.apache.org/repos/asf/spark/blob/7e17fe69/sql/hive/src/test/resources/golden/groupby_complex_types_multi_single_reducer-1-de39f8b5f4305136d945da94d5222283
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/golden/groupby_complex_types_multi_single_reducer-1-de39f8b5f4305136d945da94d5222283 b/sql/hive/src/test/resources/golden/groupby_complex_types_multi_single_reducer-1-de39f8b5f4305136d945da94d5222283
new file mode 100644
index 0000000..e69de29
http://git-wip-us.apache.org/repos/asf/spark/blob/7e17fe69/sql/hive/src/test/resources/golden/groupby_complex_types_multi_single_reducer-2-10fe6134247226ab2b309bb62460d080
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/golden/groupby_complex_types_multi_single_reducer-2-10fe6134247226ab2b309bb62460d080 b/sql/hive/src/test/resources/golden/groupby_complex_types_multi_single_reducer-2-10fe6134247226ab2b309bb62460d080
new file mode 100644
index 0000000..e69de29
http://git-wip-us.apache.org/repos/asf/spark/blob/7e17fe69/sql/hive/src/test/resources/golden/groupby_complex_types_multi_single_reducer-3-28264b197e3997f7c5fe88c1c2f7d5c5
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/golden/groupby_complex_types_multi_single_reducer-3-28264b197e3997f7c5fe88c1c2f7d5c5 b/sql/hive/src/test/resources/golden/groupby_complex_types_multi_single_reducer-3-28264b197e3997f7c5fe88c1c2f7d5c5
new file mode 100644
index 0000000..e69de29
http://git-wip-us.apache.org/repos/asf/spark/blob/7e17fe69/sql/hive/src/test/resources/golden/groupby_distinct_samekey-0-63603572a0f759ea81f4649ae2210ef8
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/golden/groupby_distinct_samekey-0-63603572a0f759ea81f4649ae2210ef8 b/sql/hive/src/test/resources/golden/groupby_distinct_samekey-0-63603572a0f759ea81f4649ae2210ef8
new file mode 100644
index 0000000..e69de29
http://git-wip-us.apache.org/repos/asf/spark/blob/7e17fe69/sql/hive/src/test/resources/golden/groupby_distinct_samekey-1-a3f3e279ab0be5093f4a926e265c0211
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/golden/groupby_distinct_samekey-1-a3f3e279ab0be5093f4a926e265c0211 b/sql/hive/src/test/resources/golden/groupby_distinct_samekey-1-a3f3e279ab0be5093f4a926e265c0211
new file mode 100644
index 0000000..573541a
--- /dev/null
+++ b/sql/hive/src/test/resources/golden/groupby_distinct_samekey-1-a3f3e279ab0be5093f4a926e265c0211
@@ -0,0 +1 @@
+0
http://git-wip-us.apache.org/repos/asf/spark/blob/7e17fe69/sql/hive/src/test/resources/golden/groupby_distinct_samekey-2-59ee4550803e419b3adb1e9dd4220113
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/golden/groupby_distinct_samekey-2-59ee4550803e419b3adb1e9dd4220113 b/sql/hive/src/test/resources/golden/groupby_distinct_samekey-2-59ee4550803e419b3adb1e9dd4220113
new file mode 100644
index 0000000..e69de29
http://git-wip-us.apache.org/repos/asf/spark/blob/7e17fe69/sql/hive/src/test/resources/golden/groupby_distinct_samekey-3-12b0749f4fb915f3b2e317ed4fbc9cb4
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/golden/groupby_distinct_samekey-3-12b0749f4fb915f3b2e317ed4fbc9cb4 b/sql/hive/src/test/resources/golden/groupby_distinct_samekey-3-12b0749f4fb915f3b2e317ed4fbc9cb4
new file mode 100644
index 0000000..e69de29
http://git-wip-us.apache.org/repos/asf/spark/blob/7e17fe69/sql/hive/src/test/resources/golden/groupby_distinct_samekey-4-d88c962262d3524bfc881b7309688e38
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/golden/groupby_distinct_samekey-4-d88c962262d3524bfc881b7309688e38 b/sql/hive/src/test/resources/golden/groupby_distinct_samekey-4-d88c962262d3524bfc881b7309688e38
new file mode 100644
index 0000000..e69de29
http://git-wip-us.apache.org/repos/asf/spark/blob/7e17fe69/sql/hive/src/test/resources/golden/groupby_distinct_samekey-5-78c0b7be08118a14e0337ff552fcb9ad
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/golden/groupby_distinct_samekey-5-78c0b7be08118a14e0337ff552fcb9ad b/sql/hive/src/test/resources/golden/groupby_distinct_samekey-5-78c0b7be08118a14e0337ff552fcb9ad
new file mode 100644
index 0000000..917d19a
--- /dev/null
+++ b/sql/hive/src/test/resources/golden/groupby_distinct_samekey-5-78c0b7be08118a14e0337ff552fcb9ad
@@ -0,0 +1,4 @@
+0 0
+2 2
+4 4
+5 5
http://git-wip-us.apache.org/repos/asf/spark/blob/7e17fe69/sql/hive/src/test/resources/golden/groupby_distinct_samekey-6-edcbea736edb6104a73f0dc670418ee5
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/golden/groupby_distinct_samekey-6-edcbea736edb6104a73f0dc670418ee5 b/sql/hive/src/test/resources/golden/groupby_distinct_samekey-6-edcbea736edb6104a73f0dc670418ee5
new file mode 100644
index 0000000..917d19a
--- /dev/null
+++ b/sql/hive/src/test/resources/golden/groupby_distinct_samekey-6-edcbea736edb6104a73f0dc670418ee5
@@ -0,0 +1,4 @@
+0 0
+2 2
+4 4
+5 5
http://git-wip-us.apache.org/repos/asf/spark/blob/7e17fe69/sql/hive/src/test/resources/golden/groupby_distinct_samekey-7-ca16024e6f5399b1d035f5b9fd665163
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/golden/groupby_distinct_samekey-7-ca16024e6f5399b1d035f5b9fd665163 b/sql/hive/src/test/resources/golden/groupby_distinct_samekey-7-ca16024e6f5399b1d035f5b9fd665163
new file mode 100644
index 0000000..e69de29
http://git-wip-us.apache.org/repos/asf/spark/blob/7e17fe69/sql/hive/src/test/resources/golden/groupby_map_ppr-0-dbcec232623048c7748b708123e18bf0
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/golden/groupby_map_ppr-0-dbcec232623048c7748b708123e18bf0 b/sql/hive/src/test/resources/golden/groupby_map_ppr-0-dbcec232623048c7748b708123e18bf0
new file mode 100644
index 0000000..c227083
--- /dev/null
+++ b/sql/hive/src/test/resources/golden/groupby_map_ppr-0-dbcec232623048c7748b708123e18bf0
@@ -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/groupby_map_ppr-1-85c4f90b754cd88147d6b74e17d22063
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/golden/groupby_map_ppr-1-85c4f90b754cd88147d6b74e17d22063 b/sql/hive/src/test/resources/golden/groupby_map_ppr-1-85c4f90b754cd88147d6b74e17d22063
new file mode 100644
index 0000000..c227083
--- /dev/null
+++ b/sql/hive/src/test/resources/golden/groupby_map_ppr-1-85c4f90b754cd88147d6b74e17d22063
@@ -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/groupby_map_ppr-2-83c59d378571a6e487aa20217bd87817
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/golden/groupby_map_ppr-2-83c59d378571a6e487aa20217bd87817 b/sql/hive/src/test/resources/golden/groupby_map_ppr-2-83c59d378571a6e487aa20217bd87817
new file mode 100644
index 0000000..c227083
--- /dev/null
+++ b/sql/hive/src/test/resources/golden/groupby_map_ppr-2-83c59d378571a6e487aa20217bd87817
@@ -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/groupby_map_ppr-3-1c0aa77190a5b3e1895e58cfbe7467a9
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/golden/groupby_map_ppr-3-1c0aa77190a5b3e1895e58cfbe7467a9 b/sql/hive/src/test/resources/golden/groupby_map_ppr-3-1c0aa77190a5b3e1895e58cfbe7467a9
new file mode 100644
index 0000000..e69de29
http://git-wip-us.apache.org/repos/asf/spark/blob/7e17fe69/sql/hive/src/test/resources/golden/groupby_map_ppr-4-e5121a2b8210b2e4f8b1bfbf0a044486
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/golden/groupby_map_ppr-4-e5121a2b8210b2e4f8b1bfbf0a044486 b/sql/hive/src/test/resources/golden/groupby_map_ppr-4-e5121a2b8210b2e4f8b1bfbf0a044486
new file mode 100644
index 0000000..e69de29
http://git-wip-us.apache.org/repos/asf/spark/blob/7e17fe69/sql/hive/src/test/resources/golden/groupby_map_ppr-5-d4faa22fc1ec8cfc8ab21474841d415a
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/golden/groupby_map_ppr-5-d4faa22fc1ec8cfc8ab21474841d415a b/sql/hive/src/test/resources/golden/groupby_map_ppr-5-d4faa22fc1ec8cfc8ab21474841d415a
new file mode 100644
index 0000000..e69de29
http://git-wip-us.apache.org/repos/asf/spark/blob/7e17fe69/sql/hive/src/test/resources/golden/groupby_map_ppr-6-adc1ec67836b26b60d8547c4996bfd8f
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/golden/groupby_map_ppr-6-adc1ec67836b26b60d8547c4996bfd8f b/sql/hive/src/test/resources/golden/groupby_map_ppr-6-adc1ec67836b26b60d8547c4996bfd8f
new file mode 100644
index 0000000..ae9bbc3
--- /dev/null
+++ b/sql/hive/src/test/resources/golden/groupby_map_ppr-6-adc1ec67836b26b60d8547c4996bfd8f
@@ -0,0 +1,10 @@
+0 1 00.0
+1 71 132828.0
+2 69 251142.0
+3 62 364008.0
+4 74 4105526.0
+5 6 5794.0
+6 5 6796.0
+7 6 71470.0
+8 8 81524.0
+9 7 92094.0
\ No newline at end of file
http://git-wip-us.apache.org/repos/asf/spark/blob/7e17fe69/sql/hive/src/test/resources/golden/groupby_map_ppr_multi_distinct-0-dbcec232623048c7748b708123e18bf0
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/golden/groupby_map_ppr_multi_distinct-0-dbcec232623048c7748b708123e18bf0 b/sql/hive/src/test/resources/golden/groupby_map_ppr_multi_distinct-0-dbcec232623048c7748b708123e18bf0
new file mode 100644
index 0000000..573541a
--- /dev/null
+++ b/sql/hive/src/test/resources/golden/groupby_map_ppr_multi_distinct-0-dbcec232623048c7748b708123e18bf0
@@ -0,0 +1 @@
+0
http://git-wip-us.apache.org/repos/asf/spark/blob/7e17fe69/sql/hive/src/test/resources/golden/groupby_map_ppr_multi_distinct-1-85c4f90b754cd88147d6b74e17d22063
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/golden/groupby_map_ppr_multi_distinct-1-85c4f90b754cd88147d6b74e17d22063 b/sql/hive/src/test/resources/golden/groupby_map_ppr_multi_distinct-1-85c4f90b754cd88147d6b74e17d22063
new file mode 100644
index 0000000..573541a
--- /dev/null
+++ b/sql/hive/src/test/resources/golden/groupby_map_ppr_multi_distinct-1-85c4f90b754cd88147d6b74e17d22063
@@ -0,0 +1 @@
+0
http://git-wip-us.apache.org/repos/asf/spark/blob/7e17fe69/sql/hive/src/test/resources/golden/groupby_map_ppr_multi_distinct-2-83c59d378571a6e487aa20217bd87817
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/golden/groupby_map_ppr_multi_distinct-2-83c59d378571a6e487aa20217bd87817 b/sql/hive/src/test/resources/golden/groupby_map_ppr_multi_distinct-2-83c59d378571a6e487aa20217bd87817
new file mode 100644
index 0000000..573541a
--- /dev/null
+++ b/sql/hive/src/test/resources/golden/groupby_map_ppr_multi_distinct-2-83c59d378571a6e487aa20217bd87817
@@ -0,0 +1 @@
+0
http://git-wip-us.apache.org/repos/asf/spark/blob/7e17fe69/sql/hive/src/test/resources/golden/groupby_map_ppr_multi_distinct-3-a04c523002e79c588e350486c815e785
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/golden/groupby_map_ppr_multi_distinct-3-a04c523002e79c588e350486c815e785 b/sql/hive/src/test/resources/golden/groupby_map_ppr_multi_distinct-3-a04c523002e79c588e350486c815e785
new file mode 100644
index 0000000..e69de29
http://git-wip-us.apache.org/repos/asf/spark/blob/7e17fe69/sql/hive/src/test/resources/golden/groupby_map_ppr_multi_distinct-4-d6c134387c0c9343ec6ea88b5086dbe2
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/golden/groupby_map_ppr_multi_distinct-4-d6c134387c0c9343ec6ea88b5086dbe2 b/sql/hive/src/test/resources/golden/groupby_map_ppr_multi_distinct-4-d6c134387c0c9343ec6ea88b5086dbe2
new file mode 100644
index 0000000..e69de29
http://git-wip-us.apache.org/repos/asf/spark/blob/7e17fe69/sql/hive/src/test/resources/golden/groupby_map_ppr_multi_distinct-5-2efbb90d3df011282b70623e0905c390
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/golden/groupby_map_ppr_multi_distinct-5-2efbb90d3df011282b70623e0905c390 b/sql/hive/src/test/resources/golden/groupby_map_ppr_multi_distinct-5-2efbb90d3df011282b70623e0905c390
new file mode 100644
index 0000000..e69de29
http://git-wip-us.apache.org/repos/asf/spark/blob/7e17fe69/sql/hive/src/test/resources/golden/groupby_map_ppr_multi_distinct-6-adc1ec67836b26b60d8547c4996bfd8f
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/golden/groupby_map_ppr_multi_distinct-6-adc1ec67836b26b60d8547c4996bfd8f b/sql/hive/src/test/resources/golden/groupby_map_ppr_multi_distinct-6-adc1ec67836b26b60d8547c4996bfd8f
new file mode 100644
index 0000000..64bb7c6
--- /dev/null
+++ b/sql/hive/src/test/resources/golden/groupby_map_ppr_multi_distinct-6-adc1ec67836b26b60d8547c4996bfd8f
@@ -0,0 +1,10 @@
+0 1 00.0 0 1
+1 71 132828.0 10044 71
+2 69 251142.0 15780 69
+3 62 364008.0 20119 62
+4 74 4105526.0 30965 74
+5 6 5794.0 278 6
+6 5 6796.0 331 5
+7 6 71470.0 447 6
+8 8 81524.0 595 8
+9 7 92094.0 577 7
http://git-wip-us.apache.org/repos/asf/spark/blob/7e17fe69/sql/hive/src/test/resources/golden/groupby_multi_insert_common_distinct-0-dbcec232623048c7748b708123e18bf0
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/golden/groupby_multi_insert_common_distinct-0-dbcec232623048c7748b708123e18bf0 b/sql/hive/src/test/resources/golden/groupby_multi_insert_common_distinct-0-dbcec232623048c7748b708123e18bf0
new file mode 100644
index 0000000..c227083
--- /dev/null
+++ b/sql/hive/src/test/resources/golden/groupby_multi_insert_common_distinct-0-dbcec232623048c7748b708123e18bf0
@@ -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/groupby_multi_insert_common_distinct-1-388618d4d475de38d5c280fd7038730b
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/golden/groupby_multi_insert_common_distinct-1-388618d4d475de38d5c280fd7038730b b/sql/hive/src/test/resources/golden/groupby_multi_insert_common_distinct-1-388618d4d475de38d5c280fd7038730b
new file mode 100644
index 0000000..e69de29
http://git-wip-us.apache.org/repos/asf/spark/blob/7e17fe69/sql/hive/src/test/resources/golden/groupby_multi_insert_common_distinct-10-6aa66df624cd32601218eee200977ce6
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/golden/groupby_multi_insert_common_distinct-10-6aa66df624cd32601218eee200977ce6 b/sql/hive/src/test/resources/golden/groupby_multi_insert_common_distinct-10-6aa66df624cd32601218eee200977ce6
new file mode 100644
index 0000000..6b6a788
--- /dev/null
+++ b/sql/hive/src/test/resources/golden/groupby_multi_insert_common_distinct-10-6aa66df624cd32601218eee200977ce6
@@ -0,0 +1,6 @@
+0 1
+2 1
+4 1
+5 1
+8 1
+9 1
\ No newline at end of file
http://git-wip-us.apache.org/repos/asf/spark/blob/7e17fe69/sql/hive/src/test/resources/golden/groupby_multi_insert_common_distinct-11-59a77127c166fef57504c011ccb427a6
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/golden/groupby_multi_insert_common_distinct-11-59a77127c166fef57504c011ccb427a6 b/sql/hive/src/test/resources/golden/groupby_multi_insert_common_distinct-11-59a77127c166fef57504c011ccb427a6
new file mode 100644
index 0000000..c33eed6
--- /dev/null
+++ b/sql/hive/src/test/resources/golden/groupby_multi_insert_common_distinct-11-59a77127c166fef57504c011ccb427a6
@@ -0,0 +1,6 @@
+0 1
+4 1
+8 1
+10 1
+16 1
+18 1
\ No newline at end of file
http://git-wip-us.apache.org/repos/asf/spark/blob/7e17fe69/sql/hive/src/test/resources/golden/groupby_multi_insert_common_distinct-2-2e1779fc58da364612a1c84d563ea7d5
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/golden/groupby_multi_insert_common_distinct-2-2e1779fc58da364612a1c84d563ea7d5 b/sql/hive/src/test/resources/golden/groupby_multi_insert_common_distinct-2-2e1779fc58da364612a1c84d563ea7d5
new file mode 100644
index 0000000..e69de29
http://git-wip-us.apache.org/repos/asf/spark/blob/7e17fe69/sql/hive/src/test/resources/golden/groupby_multi_insert_common_distinct-3-febd68f62dd71550dd3db8335d1f93f7
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/golden/groupby_multi_insert_common_distinct-3-febd68f62dd71550dd3db8335d1f93f7 b/sql/hive/src/test/resources/golden/groupby_multi_insert_common_distinct-3-febd68f62dd71550dd3db8335d1f93f7
new file mode 100644
index 0000000..e69de29
http://git-wip-us.apache.org/repos/asf/spark/blob/7e17fe69/sql/hive/src/test/resources/golden/groupby_multi_insert_common_distinct-4-c2781ed9ce9a29f484f7648ce6e06a9e
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/golden/groupby_multi_insert_common_distinct-4-c2781ed9ce9a29f484f7648ce6e06a9e b/sql/hive/src/test/resources/golden/groupby_multi_insert_common_distinct-4-c2781ed9ce9a29f484f7648ce6e06a9e
new file mode 100644
index 0000000..e69de29
http://git-wip-us.apache.org/repos/asf/spark/blob/7e17fe69/sql/hive/src/test/resources/golden/groupby_multi_insert_common_distinct-5-6aa66df624cd32601218eee200977ce6
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/golden/groupby_multi_insert_common_distinct-5-6aa66df624cd32601218eee200977ce6 b/sql/hive/src/test/resources/golden/groupby_multi_insert_common_distinct-5-6aa66df624cd32601218eee200977ce6
new file mode 100644
index 0000000..6b6a788
--- /dev/null
+++ b/sql/hive/src/test/resources/golden/groupby_multi_insert_common_distinct-5-6aa66df624cd32601218eee200977ce6
@@ -0,0 +1,6 @@
+0 1
+2 1
+4 1
+5 1
+8 1
+9 1
\ No newline at end of file
http://git-wip-us.apache.org/repos/asf/spark/blob/7e17fe69/sql/hive/src/test/resources/golden/groupby_multi_insert_common_distinct-6-59a77127c166fef57504c011ccb427a6
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/golden/groupby_multi_insert_common_distinct-6-59a77127c166fef57504c011ccb427a6 b/sql/hive/src/test/resources/golden/groupby_multi_insert_common_distinct-6-59a77127c166fef57504c011ccb427a6
new file mode 100644
index 0000000..c33eed6
--- /dev/null
+++ b/sql/hive/src/test/resources/golden/groupby_multi_insert_common_distinct-6-59a77127c166fef57504c011ccb427a6
@@ -0,0 +1,6 @@
+0 1
+4 1
+8 1
+10 1
+16 1
+18 1
\ No newline at end of file
http://git-wip-us.apache.org/repos/asf/spark/blob/7e17fe69/sql/hive/src/test/resources/golden/groupby_multi_insert_common_distinct-7-293182ac89effb268855f5ac53e1ec11
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/golden/groupby_multi_insert_common_distinct-7-293182ac89effb268855f5ac53e1ec11 b/sql/hive/src/test/resources/golden/groupby_multi_insert_common_distinct-7-293182ac89effb268855f5ac53e1ec11
new file mode 100644
index 0000000..c227083
--- /dev/null
+++ b/sql/hive/src/test/resources/golden/groupby_multi_insert_common_distinct-7-293182ac89effb268855f5ac53e1ec11
@@ -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/groupby_multi_insert_common_distinct-8-51d6bc83dcb6610b5b4f350cbaf25d29
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/golden/groupby_multi_insert_common_distinct-8-51d6bc83dcb6610b5b4f350cbaf25d29 b/sql/hive/src/test/resources/golden/groupby_multi_insert_common_distinct-8-51d6bc83dcb6610b5b4f350cbaf25d29
new file mode 100644
index 0000000..e69de29
http://git-wip-us.apache.org/repos/asf/spark/blob/7e17fe69/sql/hive/src/test/resources/golden/groupby_multi_insert_common_distinct-9-c2781ed9ce9a29f484f7648ce6e06a9e
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/golden/groupby_multi_insert_common_distinct-9-c2781ed9ce9a29f484f7648ce6e06a9e b/sql/hive/src/test/resources/golden/groupby_multi_insert_common_distinct-9-c2781ed9ce9a29f484f7648ce6e06a9e
new file mode 100644
index 0000000..e69de29
http://git-wip-us.apache.org/repos/asf/spark/blob/7e17fe69/sql/hive/src/test/resources/golden/groupby_multi_single_reducer-0-b31bf66c43bb9f7ddc09b138b7bf36e0
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/golden/groupby_multi_single_reducer-0-b31bf66c43bb9f7ddc09b138b7bf36e0 b/sql/hive/src/test/resources/golden/groupby_multi_single_reducer-0-b31bf66c43bb9f7ddc09b138b7bf36e0
new file mode 100644
index 0000000..573541a
--- /dev/null
+++ b/sql/hive/src/test/resources/golden/groupby_multi_single_reducer-0-b31bf66c43bb9f7ddc09b138b7bf36e0
@@ -0,0 +1 @@
+0
http://git-wip-us.apache.org/repos/asf/spark/blob/7e17fe69/sql/hive/src/test/resources/golden/groupby_multi_single_reducer-1-f64b982c4bf34931f03447e635ae33d2
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/golden/groupby_multi_single_reducer-1-f64b982c4bf34931f03447e635ae33d2 b/sql/hive/src/test/resources/golden/groupby_multi_single_reducer-1-f64b982c4bf34931f03447e635ae33d2
new file mode 100644
index 0000000..e69de29
http://git-wip-us.apache.org/repos/asf/spark/blob/7e17fe69/sql/hive/src/test/resources/golden/groupby_multi_single_reducer-10-3b3ef4d975716744c85af560aa240abd
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/golden/groupby_multi_single_reducer-10-3b3ef4d975716744c85af560aa240abd b/sql/hive/src/test/resources/golden/groupby_multi_single_reducer-10-3b3ef4d975716744c85af560aa240abd
new file mode 100644
index 0000000..922f4bf
--- /dev/null
+++ b/sql/hive/src/test/resources/golden/groupby_multi_single_reducer-10-3b3ef4d975716744c85af560aa240abd
@@ -0,0 +1,10 @@
+0 1 00.0 0 3
+1 71 116414.0 10044 115
+2 69 225571.0 15780 111
+3 62 332004.0 20119 99
+4 74 452763.0 30965 124
+5 6 5397.0 278 10
+6 5 6398.0 331 6
+7 6 7735.0 447 10
+8 8 8762.0 595 10
+9 7 91047.0 577 12
http://git-wip-us.apache.org/repos/asf/spark/blob/7e17fe69/sql/hive/src/test/resources/golden/groupby_multi_single_reducer-11-4e95946ec07f04479da42ba5cbfa531b
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/golden/groupby_multi_single_reducer-11-4e95946ec07f04479da42ba5cbfa531b b/sql/hive/src/test/resources/golden/groupby_multi_single_reducer-11-4e95946ec07f04479da42ba5cbfa531b
new file mode 100644
index 0000000..e69de29
http://git-wip-us.apache.org/repos/asf/spark/blob/7e17fe69/sql/hive/src/test/resources/golden/groupby_multi_single_reducer-12-51fe5b5a17ddc56fb8712340b38773b2
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/golden/groupby_multi_single_reducer-12-51fe5b5a17ddc56fb8712340b38773b2 b/sql/hive/src/test/resources/golden/groupby_multi_single_reducer-12-51fe5b5a17ddc56fb8712340b38773b2
new file mode 100644
index 0000000..e69de29
http://git-wip-us.apache.org/repos/asf/spark/blob/7e17fe69/sql/hive/src/test/resources/golden/groupby_multi_single_reducer-13-38f492067df78144c272bb212633cc5e
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/golden/groupby_multi_single_reducer-13-38f492067df78144c272bb212633cc5e b/sql/hive/src/test/resources/golden/groupby_multi_single_reducer-13-38f492067df78144c272bb212633cc5e
new file mode 100644
index 0000000..106132f
--- /dev/null
+++ b/sql/hive/src/test/resources/golden/groupby_multi_single_reducer-13-38f492067df78144c272bb212633cc5e
@@ -0,0 +1,5 @@
+5 6 5397.0 278 10
+6 5 6398.0 331 6
+7 6 7735.0 447 10
+8 8 8762.0 595 10
+9 7 91047.0 577 12
http://git-wip-us.apache.org/repos/asf/spark/blob/7e17fe69/sql/hive/src/test/resources/golden/groupby_multi_single_reducer-14-d7b3676444a9e95811184637dd0b3231
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/golden/groupby_multi_single_reducer-14-d7b3676444a9e95811184637dd0b3231 b/sql/hive/src/test/resources/golden/groupby_multi_single_reducer-14-d7b3676444a9e95811184637dd0b3231
new file mode 100644
index 0000000..6523535
--- /dev/null
+++ b/sql/hive/src/test/resources/golden/groupby_multi_single_reducer-14-d7b3676444a9e95811184637dd0b3231
@@ -0,0 +1,5 @@
+0 1 00.0 0 3
+1 71 116414.0 10044 115
+2 69 225571.0 15780 111
+3 62 332004.0 20119 99
+4 74 452763.0 30965 124
http://git-wip-us.apache.org/repos/asf/spark/blob/7e17fe69/sql/hive/src/test/resources/golden/groupby_multi_single_reducer-15-3b3ef4d975716744c85af560aa240abd
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/golden/groupby_multi_single_reducer-15-3b3ef4d975716744c85af560aa240abd b/sql/hive/src/test/resources/golden/groupby_multi_single_reducer-15-3b3ef4d975716744c85af560aa240abd
new file mode 100644
index 0000000..922f4bf
--- /dev/null
+++ b/sql/hive/src/test/resources/golden/groupby_multi_single_reducer-15-3b3ef4d975716744c85af560aa240abd
@@ -0,0 +1,10 @@
+0 1 00.0 0 3
+1 71 116414.0 10044 115
+2 69 225571.0 15780 111
+3 62 332004.0 20119 99
+4 74 452763.0 30965 124
+5 6 5397.0 278 10
+6 5 6398.0 331 6
+7 6 7735.0 447 10
+8 8 8762.0 595 10
+9 7 91047.0 577 12
http://git-wip-us.apache.org/repos/asf/spark/blob/7e17fe69/sql/hive/src/test/resources/golden/groupby_multi_single_reducer-16-b21ae88a5fc7f9b5c25ca954889ee421
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/golden/groupby_multi_single_reducer-16-b21ae88a5fc7f9b5c25ca954889ee421 b/sql/hive/src/test/resources/golden/groupby_multi_single_reducer-16-b21ae88a5fc7f9b5c25ca954889ee421
new file mode 100644
index 0000000..017878b
--- /dev/null
+++ b/sql/hive/src/test/resources/golden/groupby_multi_single_reducer-16-b21ae88a5fc7f9b5c25ca954889ee421
@@ -0,0 +1,10 @@
+0 1 00.0 0 3
+1 4 1878.0 878 6
+1 5 1729.0 729 8
+1 6 11282.0 1282 12
+1 6 11494.0 1494 11
+1 7 11171.0 1171 11
+1 7 11516.0 1516 10
+1 8 11263.0 1263 10
+1 9 12294.0 2294 14
+1 9 12654.0 2654 16
http://git-wip-us.apache.org/repos/asf/spark/blob/7e17fe69/sql/hive/src/test/resources/golden/groupby_multi_single_reducer-17-7f344c2f066d74ecd135c43d39658bae
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/golden/groupby_multi_single_reducer-17-7f344c2f066d74ecd135c43d39658bae b/sql/hive/src/test/resources/golden/groupby_multi_single_reducer-17-7f344c2f066d74ecd135c43d39658bae
new file mode 100644
index 0000000..f21a658
--- /dev/null
+++ b/sql/hive/src/test/resources/golden/groupby_multi_single_reducer-17-7f344c2f066d74ecd135c43d39658bae
@@ -0,0 +1,32 @@
+5 1 5102.0 102 2
+5 1 5116.0 116 2
+5 1 515.0 15 3
+5 1 553.0 53 1
+5 1 554.0 54 1
+5 1 557.0 57 1
+6 1 6134.0 134 2
+6 1 664.0 64 1
+6 1 665.0 65 1
+6 1 666.0 66 1
+6 1 669.0 69 1
+7 1 7144.0 144 2
+7 1 7152.0 152 2
+7 1 7210.0 210 3
+7 1 774.0 74 1
+7 1 777.0 77 1
+7 1 778.0 78 1
+8 1 8166.0 166 2
+8 1 8168.0 168 2
+8 1 88.0 8 1
+8 1 880.0 80 1
+8 1 882.0 82 1
+8 1 885.0 85 1
+8 1 886.0 86 1
+8 1 887.0 87 1
+9 1 9190.0 190 2
+9 1 9194.0 194 2
+9 1 9196.0 196 2
+9 1 9270.0 270 3
+9 1 99.0 9 1
+9 1 992.0 92 1
+9 1 996.0 96 1
http://git-wip-us.apache.org/repos/asf/spark/blob/7e17fe69/sql/hive/src/test/resources/golden/groupby_multi_single_reducer-18-4938ddc6b516cf67779be0d7dc29e7ab
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/golden/groupby_multi_single_reducer-18-4938ddc6b516cf67779be0d7dc29e7ab b/sql/hive/src/test/resources/golden/groupby_multi_single_reducer-18-4938ddc6b516cf67779be0d7dc29e7ab
new file mode 100644
index 0000000..e69de29
http://git-wip-us.apache.org/repos/asf/spark/blob/7e17fe69/sql/hive/src/test/resources/golden/groupby_multi_single_reducer-19-180b611e08d4080fa098ed69169c2478
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/golden/groupby_multi_single_reducer-19-180b611e08d4080fa098ed69169c2478 b/sql/hive/src/test/resources/golden/groupby_multi_single_reducer-19-180b611e08d4080fa098ed69169c2478
new file mode 100644
index 0000000..e69de29
http://git-wip-us.apache.org/repos/asf/spark/blob/7e17fe69/sql/hive/src/test/resources/golden/groupby_multi_single_reducer-2-392062177be62090adedf1ab6c0a0b78
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/golden/groupby_multi_single_reducer-2-392062177be62090adedf1ab6c0a0b78 b/sql/hive/src/test/resources/golden/groupby_multi_single_reducer-2-392062177be62090adedf1ab6c0a0b78
new file mode 100644
index 0000000..e69de29
http://git-wip-us.apache.org/repos/asf/spark/blob/7e17fe69/sql/hive/src/test/resources/golden/groupby_multi_single_reducer-20-db2149b42cdbf998187034233fc846cc
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/golden/groupby_multi_single_reducer-20-db2149b42cdbf998187034233fc846cc b/sql/hive/src/test/resources/golden/groupby_multi_single_reducer-20-db2149b42cdbf998187034233fc846cc
new file mode 100644
index 0000000..e69de29
http://git-wip-us.apache.org/repos/asf/spark/blob/7e17fe69/sql/hive/src/test/resources/golden/groupby_multi_single_reducer-21-322f23866cf3ca62d4ba93cf904c520
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/golden/groupby_multi_single_reducer-21-322f23866cf3ca62d4ba93cf904c520 b/sql/hive/src/test/resources/golden/groupby_multi_single_reducer-21-322f23866cf3ca62d4ba93cf904c520
new file mode 100644
index 0000000..e69de29
http://git-wip-us.apache.org/repos/asf/spark/blob/7e17fe69/sql/hive/src/test/resources/golden/groupby_multi_single_reducer-22-21fcbcafc3b5b22572ddd5c87df1c06f
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/golden/groupby_multi_single_reducer-22-21fcbcafc3b5b22572ddd5c87df1c06f b/sql/hive/src/test/resources/golden/groupby_multi_single_reducer-22-21fcbcafc3b5b22572ddd5c87df1c06f
new file mode 100644
index 0000000..e69de29
http://git-wip-us.apache.org/repos/asf/spark/blob/7e17fe69/sql/hive/src/test/resources/golden/groupby_multi_single_reducer-3-82b65775ae9c6dcb85ca87804dbb0288
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/golden/groupby_multi_single_reducer-3-82b65775ae9c6dcb85ca87804dbb0288 b/sql/hive/src/test/resources/golden/groupby_multi_single_reducer-3-82b65775ae9c6dcb85ca87804dbb0288
new file mode 100644
index 0000000..e69de29
http://git-wip-us.apache.org/repos/asf/spark/blob/7e17fe69/sql/hive/src/test/resources/golden/groupby_multi_single_reducer-4-7df7c16e4063683d0ca40360da460799
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/golden/groupby_multi_single_reducer-4-7df7c16e4063683d0ca40360da460799 b/sql/hive/src/test/resources/golden/groupby_multi_single_reducer-4-7df7c16e4063683d0ca40360da460799
new file mode 100644
index 0000000..e69de29
http://git-wip-us.apache.org/repos/asf/spark/blob/7e17fe69/sql/hive/src/test/resources/golden/groupby_multi_single_reducer-5-c19e7bf0732e7a103966ebc43eb0bcea
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/golden/groupby_multi_single_reducer-5-c19e7bf0732e7a103966ebc43eb0bcea b/sql/hive/src/test/resources/golden/groupby_multi_single_reducer-5-c19e7bf0732e7a103966ebc43eb0bcea
new file mode 100644
index 0000000..e69de29
http://git-wip-us.apache.org/repos/asf/spark/blob/7e17fe69/sql/hive/src/test/resources/golden/groupby_multi_single_reducer-6-3be7ae6a87b9091bc61d221de8bdd55b
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/golden/groupby_multi_single_reducer-6-3be7ae6a87b9091bc61d221de8bdd55b b/sql/hive/src/test/resources/golden/groupby_multi_single_reducer-6-3be7ae6a87b9091bc61d221de8bdd55b
new file mode 100644
index 0000000..e69de29
http://git-wip-us.apache.org/repos/asf/spark/blob/7e17fe69/sql/hive/src/test/resources/golden/groupby_multi_single_reducer-7-ad39c0f14b6e0752489479138516bd57
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/golden/groupby_multi_single_reducer-7-ad39c0f14b6e0752489479138516bd57 b/sql/hive/src/test/resources/golden/groupby_multi_single_reducer-7-ad39c0f14b6e0752489479138516bd57
new file mode 100644
index 0000000..e69de29
http://git-wip-us.apache.org/repos/asf/spark/blob/7e17fe69/sql/hive/src/test/resources/golden/groupby_multi_single_reducer-8-38f492067df78144c272bb212633cc5e
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/golden/groupby_multi_single_reducer-8-38f492067df78144c272bb212633cc5e b/sql/hive/src/test/resources/golden/groupby_multi_single_reducer-8-38f492067df78144c272bb212633cc5e
new file mode 100644
index 0000000..106132f
--- /dev/null
+++ b/sql/hive/src/test/resources/golden/groupby_multi_single_reducer-8-38f492067df78144c272bb212633cc5e
@@ -0,0 +1,5 @@
+5 6 5397.0 278 10
+6 5 6398.0 331 6
+7 6 7735.0 447 10
+8 8 8762.0 595 10
+9 7 91047.0 577 12
http://git-wip-us.apache.org/repos/asf/spark/blob/7e17fe69/sql/hive/src/test/resources/golden/groupby_multi_single_reducer-9-d7b3676444a9e95811184637dd0b3231
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/golden/groupby_multi_single_reducer-9-d7b3676444a9e95811184637dd0b3231 b/sql/hive/src/test/resources/golden/groupby_multi_single_reducer-9-d7b3676444a9e95811184637dd0b3231
new file mode 100644
index 0000000..6523535
--- /dev/null
+++ b/sql/hive/src/test/resources/golden/groupby_multi_single_reducer-9-d7b3676444a9e95811184637dd0b3231
@@ -0,0 +1,5 @@
+0 1 00.0 0 3
+1 71 116414.0 10044 115
+2 69 225571.0 15780 111
+3 62 332004.0 20119 99
+4 74 452763.0 30965 124
http://git-wip-us.apache.org/repos/asf/spark/blob/7e17fe69/sql/hive/src/test/resources/golden/groupby_multi_single_reducer2-0-b31bf66c43bb9f7ddc09b138b7bf36e0
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/golden/groupby_multi_single_reducer2-0-b31bf66c43bb9f7ddc09b138b7bf36e0 b/sql/hive/src/test/resources/golden/groupby_multi_single_reducer2-0-b31bf66c43bb9f7ddc09b138b7bf36e0
new file mode 100644
index 0000000..c227083
--- /dev/null
+++ b/sql/hive/src/test/resources/golden/groupby_multi_single_reducer2-0-b31bf66c43bb9f7ddc09b138b7bf36e0
@@ -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/groupby_multi_single_reducer2-1-660d3ff0ca588c2da097b5f3ca753ada
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/golden/groupby_multi_single_reducer2-1-660d3ff0ca588c2da097b5f3ca753ada b/sql/hive/src/test/resources/golden/groupby_multi_single_reducer2-1-660d3ff0ca588c2da097b5f3ca753ada
new file mode 100644
index 0000000..e69de29
http://git-wip-us.apache.org/repos/asf/spark/blob/7e17fe69/sql/hive/src/test/resources/golden/groupby_multi_single_reducer2-2-7372ea92a15e7beed3be5e2dd2cbac47
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/golden/groupby_multi_single_reducer2-2-7372ea92a15e7beed3be5e2dd2cbac47 b/sql/hive/src/test/resources/golden/groupby_multi_single_reducer2-2-7372ea92a15e7beed3be5e2dd2cbac47
new file mode 100644
index 0000000..e69de29
http://git-wip-us.apache.org/repos/asf/spark/blob/7e17fe69/sql/hive/src/test/resources/golden/groupby_multi_single_reducer2-3-eeaa92b3f8e6667d3395f8dc7ea6d89e
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/golden/groupby_multi_single_reducer2-3-eeaa92b3f8e6667d3395f8dc7ea6d89e b/sql/hive/src/test/resources/golden/groupby_multi_single_reducer2-3-eeaa92b3f8e6667d3395f8dc7ea6d89e
new file mode 100644
index 0000000..e69de29
http://git-wip-us.apache.org/repos/asf/spark/blob/7e17fe69/sql/hive/src/test/resources/golden/groupby_multi_single_reducer2-4-427627f4cf6d91e5314c85e0c5aa2f84
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/golden/groupby_multi_single_reducer2-4-427627f4cf6d91e5314c85e0c5aa2f84 b/sql/hive/src/test/resources/golden/groupby_multi_single_reducer2-4-427627f4cf6d91e5314c85e0c5aa2f84
new file mode 100644
index 0000000..e69de29
http://git-wip-us.apache.org/repos/asf/spark/blob/7e17fe69/sql/hive/src/test/resources/golden/groupby_multi_single_reducer2-5-376542befbcab97d864e874251720c40
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/golden/groupby_multi_single_reducer2-5-376542befbcab97d864e874251720c40 b/sql/hive/src/test/resources/golden/groupby_multi_single_reducer2-5-376542befbcab97d864e874251720c40
new file mode 100644
index 0000000..dbc7aeb
--- /dev/null
+++ b/sql/hive/src/test/resources/golden/groupby_multi_single_reducer2-5-376542befbcab97d864e874251720c40
@@ -0,0 +1,5 @@
+5 6
+6 5
+7 6
+8 8
+9 7
\ No newline at end of file
http://git-wip-us.apache.org/repos/asf/spark/blob/7e17fe69/sql/hive/src/test/resources/golden/groupby_multi_single_reducer2-6-8566e4c94d34b0fc4a71d34e89529c74
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/golden/groupby_multi_single_reducer2-6-8566e4c94d34b0fc4a71d34e89529c74 b/sql/hive/src/test/resources/golden/groupby_multi_single_reducer2-6-8566e4c94d34b0fc4a71d34e89529c74
new file mode 100644
index 0000000..ebf9d69
--- /dev/null
+++ b/sql/hive/src/test/resources/golden/groupby_multi_single_reducer2-6-8566e4c94d34b0fc4a71d34e89529c74
@@ -0,0 +1,5 @@
+0 1 3
+1 71 115
+2 69 111
+3 62 99
+4 74 124
\ No newline at end of file
http://git-wip-us.apache.org/repos/asf/spark/blob/7e17fe69/sql/hive/src/test/resources/golden/groupby_multi_single_reducer2-7-4938ddc6b516cf67779be0d7dc29e7ab
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/golden/groupby_multi_single_reducer2-7-4938ddc6b516cf67779be0d7dc29e7ab b/sql/hive/src/test/resources/golden/groupby_multi_single_reducer2-7-4938ddc6b516cf67779be0d7dc29e7ab
new file mode 100644
index 0000000..e69de29
http://git-wip-us.apache.org/repos/asf/spark/blob/7e17fe69/sql/hive/src/test/resources/golden/groupby_multi_single_reducer2-8-180b611e08d4080fa098ed69169c2478
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/golden/groupby_multi_single_reducer2-8-180b611e08d4080fa098ed69169c2478 b/sql/hive/src/test/resources/golden/groupby_multi_single_reducer2-8-180b611e08d4080fa098ed69169c2478
new file mode 100644
index 0000000..e69de29
http://git-wip-us.apache.org/repos/asf/spark/blob/7e17fe69/sql/hive/src/test/resources/golden/groupby_multi_single_reducer3-0-36cc74ebca5adb026757c5cd8df5a0dd
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/golden/groupby_multi_single_reducer3-0-36cc74ebca5adb026757c5cd8df5a0dd b/sql/hive/src/test/resources/golden/groupby_multi_single_reducer3-0-36cc74ebca5adb026757c5cd8df5a0dd
new file mode 100644
index 0000000..e69de29
http://git-wip-us.apache.org/repos/asf/spark/blob/7e17fe69/sql/hive/src/test/resources/golden/groupby_multi_single_reducer3-1-9e61989d717403353689cbbb2816210d
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/golden/groupby_multi_single_reducer3-1-9e61989d717403353689cbbb2816210d b/sql/hive/src/test/resources/golden/groupby_multi_single_reducer3-1-9e61989d717403353689cbbb2816210d
new file mode 100644
index 0000000..e69de29
http://git-wip-us.apache.org/repos/asf/spark/blob/7e17fe69/sql/hive/src/test/resources/golden/groupby_multi_single_reducer3-10-73819ea1a7c0653a61652b3766afb003
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/golden/groupby_multi_single_reducer3-10-73819ea1a7c0653a61652b3766afb003 b/sql/hive/src/test/resources/golden/groupby_multi_single_reducer3-10-73819ea1a7c0653a61652b3766afb003
new file mode 100644
index 0000000..c227083
--- /dev/null
+++ b/sql/hive/src/test/resources/golden/groupby_multi_single_reducer3-10-73819ea1a7c0653a61652b3766afb003
@@ -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/groupby_multi_single_reducer3-11-8603afa3bf3deeda532fc69b7df49e09
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/golden/groupby_multi_single_reducer3-11-8603afa3bf3deeda532fc69b7df49e09 b/sql/hive/src/test/resources/golden/groupby_multi_single_reducer3-11-8603afa3bf3deeda532fc69b7df49e09
new file mode 100644
index 0000000..e69de29
http://git-wip-us.apache.org/repos/asf/spark/blob/7e17fe69/sql/hive/src/test/resources/golden/groupby_multi_single_reducer3-12-2ab5cc10c0b37e7cf3c0d33fdc39b628
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/golden/groupby_multi_single_reducer3-12-2ab5cc10c0b37e7cf3c0d33fdc39b628 b/sql/hive/src/test/resources/golden/groupby_multi_single_reducer3-12-2ab5cc10c0b37e7cf3c0d33fdc39b628
new file mode 100644
index 0000000..e69de29
http://git-wip-us.apache.org/repos/asf/spark/blob/7e17fe69/sql/hive/src/test/resources/golden/groupby_multi_single_reducer3-13-521e0c1054cfa35116c02245874a4e69
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/golden/groupby_multi_single_reducer3-13-521e0c1054cfa35116c02245874a4e69 b/sql/hive/src/test/resources/golden/groupby_multi_single_reducer3-13-521e0c1054cfa35116c02245874a4e69
new file mode 100644
index 0000000..a5ae9e2
--- /dev/null
+++ b/sql/hive/src/test/resources/golden/groupby_multi_single_reducer3-13-521e0c1054cfa35116c02245874a4e69
@@ -0,0 +1,2 @@
+100 2
+200 2
\ No newline at end of file