And, run the same SQL in hive and post any difference. On 15 Nov 2016 07:48, "ayan guha" <guha.a...@gmail.com> wrote:
> It should be A,yes. Can you please reproduce this with small data and > exact SQL? > On 15 Nov 2016 02:21, "Andrés Ivaldi" <iaiva...@gmail.com> wrote: > >> Hello, I'm tryin to use Grouping Set, but I dont know if it is a bug or >> the correct behavior. >> >> Givven the above example >> Select a,b,sum(c) from table group by a,b grouping set ( (a), (a,b) ) >> >> What shound be the expected result >> A: >> >> A | B | sum(c) >> xx | null | #### >> xx | yy | #### >> xx | zz | #### >> >> >> B >> A | B | sum(c) >> xx | null | #### >> xx | yy | #### >> xx | zz | #### >> null| yy | #### >> null| zz | #### >> null| null | #### >> >> >> I believe is A, but i'm getting B >> thanks >> >> -- >> Ing. Ivaldi Andres >> >