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

Reply via email to