[
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)
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
