Re: How to remove an Iceberg partition that only contains parquet files with 0 record

[Manu Zhang]

You may try following SQL which is supported by Spark


alter table identifier drop
partition(partition_col_name=partition_col_value)

Pucheng Yang <py...@pinterest.com.invalid>于2023年6月30日 周五11:13写道：

> Iceberg version: 1.3.0
> Spark version: 3.2.1
>
> Hi community,
>
> I have an interesting situation where I migrated a Hive table to Iceberg
> and this original Hive table has a partition containing parquet files
> without any record. The delete statement can not get rid of this partition,
> any suggestion on how to deal with this? Thanks!
>
> Best,
> Pucheng
>