[
https://issues.apache.org/jira/browse/HIVE-25918?focusedWorklogId=726176&page=com.atlassian.jira.plugin.system.issuetabpanels:worklog-tabpanel#worklog-726176
]
ASF GitHub Bot logged work on HIVE-25918:
-----------------------------------------
Author: ASF GitHub Bot
Created on: 14/Feb/22 08:58
Start Date: 14/Feb/22 08:58
Worklog Time Spent: 10m
Work Description: kasakrisz opened a new pull request #3020:
URL: https://github.com/apache/hive/pull/3020
### What changes were proposed in this pull request?
HIVE-23949 introduces a caching layer between HS2 and HMS. This patch extend
alter partition HMS API call with invalidating cached `Partition` entries after
successful alter partition calls.
Alter partition calls has several versions but only the one which depends on
the `writeIdList` is affected.
### Why are the changes needed?
Subsequent `getPartitionsByNames` calls return the cached `Partition`
objects however alter partition may changed the underlying Partitions and the
changes are not reflected in the cache objects. This can lead to data
correctness issues for example when computing stats.
### Does this PR introduce _any_ user-facing change?
Yes. Incorrect results are fixed.
### How was this patch tested?
```
mvn test -Dtest.output.overwrite -DskipSparkTests
-Dtest=TestMiniLlapLocalCliDriver -Dqfile=stats_part_multi_insert_acid.q -pl
itests/qtest -Pitests
```
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: [email protected]
For queries about this service, please contact Infrastructure at:
[email protected]
Issue Time Tracking
-------------------
Worklog Id: (was: 726176)
Time Spent: 1h 40m (was: 1.5h)
> Invalid stats after multi inserting into the same partition
> -----------------------------------------------------------
>
> Key: HIVE-25918
> URL: https://issues.apache.org/jira/browse/HIVE-25918
> Project: Hive
> Issue Type: Sub-task
> Components: Statistics
> Reporter: Krisztian Kasa
> Assignee: Krisztian Kasa
> Priority: Major
> Labels: pull-request-available
> Time Spent: 1h 40m
> Remaining Estimate: 0h
>
> {code}
> create table source(p int, key int,value string);
> insert into source(p, key, value) values (101,42,'string42');
> create table stats_part(key int,value string) partitioned by (p int);
> from source
> insert into stats_part select key, value, p
> insert into stats_part select key, value, p;
> select count(*) from stats_part;
> {code}
> In this case {{StatsOptimizer}} helps serving this query because the result
> should be {{rowNum}} of the partition {{p=101}}. The result is
> {code}
> 1
> {code}
> however it shloud be
> {code}
> 2
> {code}
> because both insert branches inserts 1-1 records.
--
This message was sent by Atlassian Jira
(v8.20.1#820001)
