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