[ 
https://issues.apache.org/jira/browse/HIVE-14726?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15478442#comment-15478442
 ] 

Eugene Koifman edited comment on HIVE-14726 at 9/9/16 10:23 PM:
----------------------------------------------------------------

Update/Delete can certainly write many partitions at the same time, e.g.  
Update T set c1=c1+1 where c2 > 100.
This may match 1 row in each partition and thus the Insert statement that is 
actually executed will write to each partition.  Same for Delete.

Since what is actually executed is an Insert statement, why is Update/Delete 
different from any other Insert?


was (Author: ekoifman):
Update/Delete can certainly write many partitions at the same time, e.g.  
Update T set c1=c1+1 where c2 > 100.
This may match 1 row in each partition and thus the Insert statement that is 
actually executed will write to each partition.  Same for Delete.

> delete statement fails when spdo is on
> --------------------------------------
>
>                 Key: HIVE-14726
>                 URL: https://issues.apache.org/jira/browse/HIVE-14726
>             Project: Hive
>          Issue Type: Bug
>          Components: Logical Optimizer
>    Affects Versions: 2.1.0
>            Reporter: Deepesh Khandelwal
>            Assignee: Ashutosh Chauhan
>         Attachments: HIVE-14726.patch
>
>




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

Reply via email to