Okay, maybe I took this sentence in the alter table doc <https://iceberg.apache.org/docs/latest/spark-ddl/#alter-table> too serious 😂
> Iceberg has full ALTER TABLE support in Spark 3 > On Fri, Jun 30, 2023 at 10:11 PM Pucheng Yang <py...@pinterest.com.invalid> wrote: > Thanks Russell, will take a look today. > > On Fri, Jun 30, 2023 at 7:08 AM <russell.spit...@gmail.com> wrote: > >> 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 >>>> >>>