You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@impala.apache.org by "Tim Armstrong (Jira)" <ji...@apache.org> on 2020/12/21 17:30:01 UTC
[jira] [Resolved] (IMPALA-6207) Avro - new column added from impala
does not show up in describe on impala
[ https://issues.apache.org/jira/browse/IMPALA-6207?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Tim Armstrong resolved IMPALA-6207.
-----------------------------------
Resolution: Not A Problem
I believe this is the intended behaviour when you specify the avro schema
> Avro - new column added from impala does not show up in describe on impala
> --------------------------------------------------------------------------
>
> Key: IMPALA-6207
> URL: https://issues.apache.org/jira/browse/IMPALA-6207
> Project: IMPALA
> Issue Type: Bug
> Affects Versions: Impala 2.8.0
> Reporter: Mala Chikka Kempanna
> Priority: Major
>
> When a new column is added to avro table, it does not show up on immediate alter command.
> {code}
> [host-10-17-101-175.coe.cloudera.com:21000] > create table avro_1 stored as avro tblproperties('avro.schema.url'='/user/admin/test_schema.avsc');
> Query: create table avro_1 stored as avro tblproperties('avro.schema.url'='/user/admin/test_schema.avsc')
> WARNINGS: Ignoring column definitions in favor of Avro schema.
> The Avro schema has 2 column(s) but 0 column definition(s) were given.
> Fetched 0 row(s) in 0.05s
> [host-10-17-101-175.coe.cloudera.com:21000] > describe avro_1;
> Query: describe avro_1
> +------+--------+-------------------+
> | name | type | comment |
> +------+--------+-------------------+
> | a | int | from deserializer |
> | b | string | from deserializer |
> +------+--------+-------------------+
> Fetched 2 row(s) in 3.74s
> {code}
> New column added
> {code}
> [host-10-17-101-175.coe.cloudera.com:21000] > alter table avro_1 add columns (c int) ;
> Query: alter table avro_1 add columns (c int)
> Fetched 0 row(s) in 0.10s
> [host-10-17-101-175.coe.cloudera.com:21000] > describe avro_1;
> Query: describe avro_1
> +------+--------+-------------------+
> | name | type | comment |
> +------+--------+-------------------+
> | a | int | from deserializer |
> | b | string | from deserializer |
> +------+--------+-------------------+
> Fetched 2 row(s) in 0.00s
> {code}
--
This message was sent by Atlassian Jira
(v8.3.4#803005)