[jira] [Created] (IMPALA-6207) Avro - new column added from impala does not show up in describe on impala

["Mala Chikka Kempanna (JIRA)" <ji...@apache.org>]

Mala Chikka Kempanna created IMPALA-6207:
--------------------------------------------

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


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
(v6.4.14#64029)