I have a unique issue. Grouping__id function doesnt seem to be worked as expected or as shown in the hive manual.
I am executing the same example as shown in the hive guide.
I could find any open bugs but I have tested it out in 3 different version of hdp
The statement executed are here below and the results are as expected and everything works fine
-- create table
create table grp_tst( col1 int,col2 int);
-- insert query
insert into table grp_tst values (1, NULL);
insert into table grp_tst values (1, 1);
insert into table grp_tst values (2, 2);
insert into table grp_tst values (3, 3);
insert into table grp_tst values (3, NULL);
insert into table grp_tst values (4, 5);
-- select query
col2, GROUPING__ID, count(*) from grp_tst GROUP BY col1, col2 WITH ROLLUP
HDP2.5 and HDP2.6.0 -
Both the resutls seems to be wrong but consistently wrong. So i am wondering if there was a bug introduced in Hive from 2.4 to 2.5 upgrade.
Hive setting: I am happy to share any property files if required. It would be great if you could help me out here.