[
https://issues.apache.org/jira/browse/HIVE-30274?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Krisztian Kasa updated HIVE-30274:
----------------------------------
Description:
h4. CASE / IF split
An aggregate function argument can be
{code:java}
CASE WHEN cond THEN value [ELSE [NULL|0|0.0]] END
{code}
or
{code:java}
IF(cond, value)
IF(cond, value, [NULL|0|0.0])
{code}
where cond references one join input and value the other. For example, from
TPC-DS query 43:
{code:java}
sum(case when d_day_name = 'Sunday' then ss_sales_price else null end)
{code}
* The value is aggregated below the join: sum(ss_sales_price).
* The merge above the join applies the condition: sum(if(d_day_name =
'Sunday', partial, null)). COUNT merges with sum(if(cond, partial, 0)).
Every row in a group created by the pushed-down GROUP BY has the same join key,
so it joins with the same rows from the other input. For each of those rows,
the condition evaluates to either true or false for the entire group.
Restrictions:
* The value expression can only contain columns, constants, +, -, *, negation,
and casts. Without partial aggregate push-down, the value expression is
evaluated only for rows where the condition is true. Since the pushed-down
aggregate does not include the condition, all values are aggregated—even for
rows where the condition is false—so evaluating them must not fail in order to
preserve the original behavior.
* ELSE must be NULL or omitted. 0 is also allowed for SUM and $SUM0.
* A CASE expression can have only one WHEN clause.
> Partial GROUP BY join transpose: split IF/CASE aggregation arguments across
> the join
> ------------------------------------------------------------------------------------
>
> Key: HIVE-30274
> URL: https://issues.apache.org/jira/browse/HIVE-30274
> Project: Hive
> Issue Type: Sub-task
> Components: Physical Optimizer
> Reporter: Krisztian Kasa
> Priority: Major
>
> h4. CASE / IF split
> An aggregate function argument can be
> {code:java}
> CASE WHEN cond THEN value [ELSE [NULL|0|0.0]] END
> {code}
> or
> {code:java}
> IF(cond, value)
> IF(cond, value, [NULL|0|0.0])
> {code}
> where cond references one join input and value the other. For example, from
> TPC-DS query 43:
> {code:java}
> sum(case when d_day_name = 'Sunday' then ss_sales_price else null end)
> {code}
> * The value is aggregated below the join: sum(ss_sales_price).
> * The merge above the join applies the condition: sum(if(d_day_name =
> 'Sunday', partial, null)). COUNT merges with sum(if(cond, partial, 0)).
> Every row in a group created by the pushed-down GROUP BY has the same join
> key, so it joins with the same rows from the other input. For each of those
> rows, the condition evaluates to either true or false for the entire group.
> Restrictions:
> * The value expression can only contain columns, constants, +, -, *,
> negation, and casts. Without partial aggregate push-down, the value
> expression is evaluated only for rows where the condition is true. Since the
> pushed-down aggregate does not include the condition, all values are
> aggregated—even for rows where the condition is false—so evaluating them must
> not fail in order to preserve the original behavior.
> * ELSE must be NULL or omitted. 0 is also allowed for SUM and $SUM0.
> * A CASE expression can have only one WHEN clause.
--
This message was sent by Atlassian Jira
(v10.3.26#10030026)