Zoltan Haindrich created HIVE-17617:
---------------------------------------
Summary: Rollup of an empty resultset should contain the grouping
of the empty grouping set
Key: HIVE-17617
URL: https://issues.apache.org/jira/browse/HIVE-17617
Project: Hive
Issue Type: Sub-task
Reporter: Zoltan Haindrich
running
{code}
drop table if exists tx1;
create table tx1 (a integer,b integer,c integer);
select sum(c),
grouping(b)
from tx1
group by rollup (b);
{code}
returns 0 rows; however
according to the standard:
The <empty grouping set> is regarded as the shortest such initial sublist. For
example, “ROLLUP ( (A, B), (C, D) )”
is equivalent to “GROUPING SETS ( (A, B, C, D), (A, B), () )”.
so I think the totals row (the grouping for {{()}} should be present) - psql
returns it.
--
This message was sent by Atlassian JIRA
(v6.4.14#64029)
