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

Eugene Koifman commented on HIVE-14726:
---------------------------------------

every update/delete statement in dynpart_sort_optimization_acid.q has "key" 
which is the bucketing column in the WHERE clause.  Perhaps that's why this 
works.

For ACID data only needs to be sorted in each bucket by ROW__ID.
Thus if we sort globally by partition/bucket/ROW__ID, acid would still work.

> 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