[jira] [Updated] (HIVE-23908) Rewrite plan to join back tables: handle root input is an Aggregate

["ASF GitHub Bot (Jira)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/HIVE-23908?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

ASF GitHub Bot updated HIVE-23908:
----------------------------------
    Labels: pull-request-available  (was: )

> Rewrite plan to join back tables: handle root input is an Aggregate
> -------------------------------------------------------------------
>
>                 Key: HIVE-23908
>                 URL: https://issues.apache.org/jira/browse/HIVE-23908
>             Project: Hive
>          Issue Type: Improvement
>            Reporter: Krisztian Kasa
>            Assignee: Krisztian Kasa
>            Priority: Major
>              Labels: pull-request-available
>          Time Spent: 10m
>  Remaining Estimate: 0h
>
> {code}
> EXPLAIN	CBO
> SELECT
> 	C_CUSTOMER_ID
> FROM
> 	CUSTOMER
> ,	STORE_SALES
> WHERE
> 	C_CUSTOMER_SK	=	SS_CUSTOMER_SK
> GROUP BY
> 	C_CUSTOMER_SK
> ,	C_CUSTOMER_ID
> ,	C_FIRST_NAME
> ,	C_LAST_NAME
> ,	C_PREFERRED_CUST_FLAG
> ,	C_BIRTH_COUNTRY
> ,	C_LOGIN
> ,	C_EMAIL_ADDRESS
> {code}
> {code}
> HiveProject(c_customer_id=[$1])
>   HiveAggregate(group=[{0, 1}])
>     HiveProject($f0=[$0], $f1=[$1], $f2=[$2], $f3=[$3], $f4=[$4], $f5=[$5], $f6=[$6], $f7=[$7])
>       HiveJoin(condition=[=($0, $8)], joinType=[inner], algorithm=[none], cost=[not available])
>         HiveProject(c_customer_sk=[$0], c_customer_id=[$1], c_first_name=[$8], c_last_name=[$9], c_preferred_cust_flag=[$10], c_birth_country=[$14], c_login=[$15], c_email_address=[$16])
>           HiveTableScan(table=[[default, customer]], table:alias=[customer])
>         HiveProject(ss_customer_sk=[$3])
>           HiveFilter(condition=[IS NOT NULL($3)])
>             HiveTableScan(table=[[default, store_sales]], table:alias=[store_sales])
> {code}



--
This message was sent by Atlassian Jira
(v8.3.4#803005)