[ https://issues.apache.org/jira/browse/HIVE-14726?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15478698#comment-15478698 ]
Ashutosh Chauhan edited comment on HIVE-14726 at 9/9/16 11:52 PM: ------------------------------------------------------------------ Thanks [~alangates] for looking into it. So, we begin with {{ROW__ID}} in sort and shuffle key and partition column as value of RS. In this optimization if we change RS sort and shuffle key to ROW__ID and partition column, we need not to keep orc buffer open and thus avoid OOM case. But is that ok with ACID writer in FileSink or it assumes sort and shuffle keys as {{ROW__ID}} and nothing else? was (Author: ashutoshc): Thanks [~alangates] for looking into it. So, we begin with ROW__ID in sort and shuffle key and partition column as value of RS. In this optimization if we change RS sort and shuffle key to ROW__ID and partition column, we need not to keep orc buffer open and thus avoid OOM case. But is that ok with ACID writer in FileSink or it assumes sort and shuffle keys as ROW__ID and nothing else? > 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)