[
https://issues.apache.org/jira/browse/HIVE-8740?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14197718#comment-14197718
]
Prasanth J commented on HIVE-8740:
----------------------------------
[~alangates] Can you look at the test case that I added in this patch? Its
related to ACID DELETE operation. After deleting a newly added row, the select
count\(*\) query return 0 rows instead of actual 1000 rows. Is this a bug/known
issue or am I doing something wrong?
> Sorted dynamic partition does not work correctly with constant folding
> ----------------------------------------------------------------------
>
> Key: HIVE-8740
> URL: https://issues.apache.org/jira/browse/HIVE-8740
> Project: Hive
> Issue Type: Bug
> Affects Versions: 0.14.0
> Reporter: Prasanth J
> Assignee: Prasanth J
> Attachments: HIVE-8740.1.patch
>
>
> Sorted dynamic partition optimization looks for partition columns from the
> operator above FileSinkOperator. As per hive convention it expects partition
> columns at the last. But with HIVE-8585 equality filters on partition columns
> gets folded to constant. The column pruner then prunes the constant
> expression as they don't reference any columns. This in some cases will yield
> unexpected results (throw ArrayIndexOutOfBounds exception) with sorted
> dynamic partition insert optimization. In such we don't really need sorted
> dynamic partition optimization.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
