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 >>> >>