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

["Krisztian Kasa (Jira)" <ji...@apache.org>]

Krisztian Kasa created HIVE-23908:
-------------------------------------

             Summary: 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


{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)