[
https://issues.apache.org/jira/browse/HIVE-23908?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Krisztian Kasa reassigned HIVE-23908:
-------------------------------------
> 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
>
> {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)
