You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@impala.apache.org by "Quanlong Huang (Jira)" <ji...@apache.org> on 2024/03/11 12:02:00 UTC

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

Quanlong Huang created IMPALA-12888:
---------------------------------------

             Summary: Unsetting the 'avro.schema.url' table property is not supported for non-Avro tables
                 Key: IMPALA-12888
                 URL: https://issues.apache.org/jira/browse/IMPALA-12888
             Project: IMPALA
          Issue Type: Bug
          Components: Catalog
            Reporter: Quanlong Huang


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:
{code:sql}
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.
{code}
Hive is able to do this without any errors.



--
This message was sent by Atlassian Jira
(v8.20.10#820010)