[jira] [Commented] (HIVE-26882) Allow transactional check of Table parameter before altering the Table

["Ayush Saxena (Jira)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/HIVE-26882?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17676233#comment-17676233 ] 

Ayush Saxena commented on HIVE-26882:
-------------------------------------

Hi [~pvary] 

Got some offline pointers from Attila around this, Do you want to get the Hive PR backported to branch-3? There is some work going around for 3.2 release so if you can backport this change to branch-3 we can get that in or if you want some help around that let me know.

The next 4.x release may be atleast 6 months away from my guess.

 

> Allow transactional check of Table parameter before altering the Table
> ----------------------------------------------------------------------
>
>                 Key: HIVE-26882
>                 URL: https://issues.apache.org/jira/browse/HIVE-26882
>             Project: Hive
>          Issue Type: Improvement
>          Components: Standalone Metastore
>            Reporter: Peter Vary
>            Assignee: Peter Vary
>            Priority: Major
>              Labels: pull-request-available
>             Fix For: 4.0.0
>
>          Time Spent: 3h 20m
>  Remaining Estimate: 0h
>
> We should add the possibility to transactionally check if a Table parameter is changed before altering the table in the HMS.
> This would provide an alternative, less error-prone and faster way to commit an Iceberg table, as the Iceberg table currently needs to:
> - Create an exclusive lock
> - Get the table metadata to check if the current snapshot is not changed
> - Update the table metadata
> - Release the lock
> After the change these 4 HMS calls could be substituted with a single alter table call.
> Also we could avoid cases where the locks are left hanging by failed processes



--
This message was sent by Atlassian Jira
(v8.20.10#820010)