You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@hive.apache.org by "Jesus Camacho Rodriguez (Jira)" <ji...@apache.org> on 2020/07/25 00:43:00 UTC
[jira] [Resolved] (HIVE-23908) Rewrite plan to join back tables:
handle root input is an Aggregate
[ https://issues.apache.org/jira/browse/HIVE-23908?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Jesus Camacho Rodriguez resolved HIVE-23908.
--------------------------------------------
Fix Version/s: 4.0.0
Resolution: Fixed
Pushed to master, thanks [~kkasa]!
> 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
> Fix For: 4.0.0
>
> Time Spent: 0.5h
> 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)