Is alter table supported or not in iceberg-hive?

[allendang001]

i find that create (external) table and drop table statements are supported in iceberg hive doc, however,
I did not find any introduction about the alter table statement
https://iceberg.apache.org/hive/#ddl-commands
If anyone knows the content, please let me know

[pvary]

There are some missing feature in the Hive API. Especially in 2.x, but even in 3.x which prevented us to provide alter table support for Hive tables in Iceberg code.

That said there is an implementation in the Hive master which allows some of the ALTER functionality.
https://github.com/apache/hive/blob/master/iceberg/iceberg-handler/src/main/java/org/apache/iceberg/mr/hive/HiveIcebergMetaHook.java#L96-L99

  static final EnumSet<AlterTableType> SUPPORTED_ALTER_OPS = EnumSet.of(
      AlterTableType.ADDCOLS, AlterTableType.REPLACE_COLUMNS, AlterTableType.RENAME_COLUMN,
      AlterTableType.ADDPROPS, AlterTableType.DROPPROPS, AlterTableType.SETPARTITIONSPEC,
      AlterTableType.UPDATE_COLUMNS);

[allendang001]

There are some missing feature in the Hive API. Especially in 2.x, but even in 3.x which prevented us to provide alter table support for Hive tables in Iceberg code.

That said there is an implementation in the Hive master which allows some of the ALTER functionality. https://github.com/apache/hive/blob/master/iceberg/iceberg-handler/src/main/java/org/apache/iceberg/mr/hive/HiveIcebergMetaHook.java#L96-L99

  static final EnumSet<AlterTableType> SUPPORTED_ALTER_OPS = EnumSet.of(
      AlterTableType.ADDCOLS, AlterTableType.REPLACE_COLUMNS, AlterTableType.RENAME_COLUMN,
      AlterTableType.ADDPROPS, AlterTableType.DROPPROPS, AlterTableType.SETPARTITIONSPEC,
      AlterTableType.UPDATE_COLUMNS);

Thanks a lot. It seems that the community has already achieved some realization, but it is still not enough and cannot support our current business.
Do you know that the community will be improved in this regard in the future?

[pvary]

@allendang001: What do you need? What alter table functions would you like to use?

Thanks, Peter

[github-actions]

This issue has been automatically marked as stale because it has been open for 180 days with no activity. It will be closed in next 14 days if no further activity occurs. To permanently prevent this issue from being considered stale, add the label 'not-stale', but commenting on the issue is preferred when possible.

[github-actions]

This issue has been closed because it has not received any activity in the last 14 days since being marked as 'stale'