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

[russell . spitzer]

You probably will need to manually delete the file entry using the table api from Java Sent from my iPhone On Jun 30, 2023, at 6:58 AM, Pucheng Yang <py...@pinterest.com.invalid> wrote:  Hi Manu, the table has already been migrated to Iceberg and I think your command only available to Hive table. It seems won’t help my case. Appreciate your response! On Thu, Jun 29, 2023 at 11:38 PM Manu Zhang <owenzhang1...@gmail.com> wrote: 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