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

Eugene Koifman updated HIVE-14946:
----------------------------------
    Description: 
For example, if there is only WHEN NOT MATCHED clause, the base generating 
expression can be an INNER JOIN

Generally, we should make sure the optimizer is able to work with the plan for 
Merge statement

Various WHEN clauses can have "extra" predicates.  In some cases they may be 
pushable.

The "source" can be an arbitrary expression - in particular it may include 
joins which together with the join introduced by Merge itself may need to be 
reordered.

  was:
For example, if there is only WHEN NOT MATCHED clause, the base generating 
expression can be an INNER JOIN

Generally, we should make sure the optimizer is able to work with the plan for 
Merge statement


> Optimizations
> -------------
>
>                 Key: HIVE-14946
>                 URL: https://issues.apache.org/jira/browse/HIVE-14946
>             Project: Hive
>          Issue Type: Sub-task
>          Components: Query Planning, Transactions
>            Reporter: Eugene Koifman
>
> For example, if there is only WHEN NOT MATCHED clause, the base generating 
> expression can be an INNER JOIN
> Generally, we should make sure the optimizer is able to work with the plan 
> for Merge statement
> Various WHEN clauses can have "extra" predicates.  In some cases they may be 
> pushable.
> The "source" can be an arbitrary expression - in particular it may include 
> joins which together with the join introduced by Merge itself may need to be 
> reordered.



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

Reply via email to