You are viewing a plain text version of this content. The canonical link for it is here.
Posted to gitbox@hive.apache.org by "wecharyu (via GitHub)" <gi...@apache.org> on 2023/09/06 17:55:33 UTC
[GitHub] [hive] wecharyu commented on pull request #4517: HIVE-27530: Implement direct SQL for alter partitions to improve performance
wecharyu commented on PR #4517:
URL: https://github.com/apache/hive/pull/4517#issuecomment-1708843511
@saihemanth-cloudera Here is another benchmark test for before and after this path:
- before
```bash
Operation Mean Med Min Max Err%
addPartition 25.61 22.90 20.19 59.38 26.34
alterPartitions.10 59.55 58.81 55.35 69.30 5.140
alterPartitions.100 295.5 291.8 283.9 382.4 4.622
alterPartitions.1000 3532 3558 2721 5680 18.14
```
- after
```bash
Operation Mean Med Min Max Err%
addPartition 25.29 22.77 20.06 42.67 21.88
alterPartitions.10 41.49 40.56 37.99 55.41 7.436
alterPartitions.100 95.19 84.00 80.56 169.2 26.87
alterPartitions.1000 1343 1332 1190 1546 5.928
```
--
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: gitbox-unsubscribe@hive.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: gitbox-unsubscribe@hive.apache.org
For additional commands, e-mail: gitbox-help@hive.apache.org