Trino Invalid partition spec:

I've created a external partition table in trino, I'm using hive connector.

I'm changing the partition location with unregister partition using command system.unregister_partition(schema_name, table_name, partition_columns, partition_values) and then register new partition location using system.register_partition(schema_name, table_name, partition_columns, partition_values, location).

Now If I开发者_如何学编程 run sync_partition_metadata system.sync_partition_metadata(schema_name, table_name, mode, case_sensitive) it is getting failed with below error

trino:default> call system.sync_partition_metadata('default','register_tbl1','full');
Query 20221207_050340_00129_cs2qk failed: Invalid partition spec: /path/default/compact_register_tbl1/partition_col=2022-12-07

Is there any other way to handle this call if we are changing the partition locations ??

Thanks in advance!