[
https://issues.apache.org/jira/browse/HIVE-25638?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
mahesh kumar behera updated HIVE-25638:
---------------------------------------
Description: Hive stores the stripe stats in the ORC files. During select,
these stats are used to create the SARG. The SARG is used to reduce the records
read from the delete-delta files. Currently, in case where the number of
stripes are more than 1, the SARG generated is not proper as it uses the first
stripe index for both min and max key interval. The max key interval should be
obtained from last stripe index. This cause some valid deleted records to be
skipped. And those records are return to the user. (was: Hive stores the
stripe stats in the ORC files. During select, these stats are used to create
the SARG. The SARG is used to reduce the records read from the delete-delta
files. Currently, in case where the number of stripes are more than 1, the SARG
generated is not proper as it uses the first stripe index for both min and max
key interval. The max key interval should be obtained from last stripe index.)
> Select returns deleted records in Hive ACID table
> -------------------------------------------------
>
> Key: HIVE-25638
> URL: https://issues.apache.org/jira/browse/HIVE-25638
> Project: Hive
> Issue Type: Bug
> Components: HiveServer2
> Reporter: mahesh kumar behera
> Assignee: mahesh kumar behera
> Priority: Major
>
> Hive stores the stripe stats in the ORC files. During select, these stats are
> used to create the SARG. The SARG is used to reduce the records read from the
> delete-delta files. Currently, in case where the number of stripes are more
> than 1, the SARG generated is not proper as it uses the first stripe index
> for both min and max key interval. The max key interval should be obtained
> from last stripe index. This cause some valid deleted records to be skipped.
> And those records are return to the user.
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
