[IMPALA-12888] Unsetting the 'avro.schema.url' table property is not supported for non-Avro tables

• Type: Bug
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Component/s: Catalog
• Labels: ramp-up
• Epic Link: avro-metadata-issues
• Epic Color: ghx-label-7
• Assignee: Unassigned
• Reporter: Quanlong Huang
• Created: 11/Mar/24 12:01
• Updated: 11/Mar/24 23:31

Description

Impala can set the 'avro.schema.url' table property on any tables but can't unset it even if the table is not in AVRO format:

create table mytbl(i int) stored as textfile;
alter table mytbl set tblproperties('avro.schema.url'='hdfs:////test-warehouse/avro_schemas/functional/alltypes.json');

alter table mytbl unset tblproperties('avro.schema.url');

ERROR: AnalysisException: Unsetting the 'avro.schema.url' table property is not supported for Avro table.

Hive is able to do this without any errors.