Suppose we have one row that represents the total for department 10, and
another that represents the grand total of all departments. Which row would we
say that department is “grouped” (in Calcite’s parlance) or “aggregated” in
(Hive’s parlance)?
I find the terms confusing. It’s possible that C
I expect that the user behavior for the GROUPING in both hive and calcite is
same. It’s just the documentation which is a bit confusing.
e.g. comment line on grouping : if both deptno and gender are being grouped
should really mean that the row which represents the grand total i.e without
grou
Hi Vineet ~
+1 on your analysis.
Checking below case in agg.iq. We can see that the behavior of GROUPING
function in Calcite is the same as Hive.
# GROUPING in SELECT clause of CUBE query
select deptno, job, count(*) as c, grouping(deptno) as d,
grouping(job) j, grouping(deptno, job) as x
from "
Filed a JIRA: https://issues.apache.org/jira/browse/CALCITE-3950
XING JIN 于2020年4月22日周三 下午2:51写道:
> Hi Vineet ~
> +1 on your analysis.
> Checking below case in agg.iq. We can see that the behavior of GROUPING
> function in Calcite is the same as Hive.
>
> # GROUPING in SELECT clause of CUBE quer
Doesn’t help much. It’s not obvious to me what “being grouped” means.
Julian
> On Apr 21, 2020, at 23:52, XING JIN wrote:
>
> Hi Vineet ~
> +1 on your analysis.
> Checking below case in agg.iq. We can see that the behavior of GROUPING
> function in Calcite is the same as Hive.
>
> # GROUPING