Julian Keppel created HIVE-11093:
------------------------------------
Summary: ALTER TABLE for avro backed tables
Key: HIVE-11093
URL: https://issues.apache.org/jira/browse/HIVE-11093
Project: Hive
Issue Type: Bug
Components: Hive
Affects Versions: 1.1.0
Environment: Cloudera CDH 5.4.0
Reporter: Julian Keppel
I use Hive Version 1.1.0 in Cloudera CDH 5.4.0.
I have created an external table:
CREATE EXTERNAL TABLE *tableA*
ROW FORMAT SERDE 'org.apache.hadoop.hive.serde2.avro.AvroSerDe'
STORED AS
INPUTFORMAT
'org.apache.hadoop.hive.ql.io.avro.AvroContainerInputFormat'
OUTPUTFORMAT
'org.apache.hadoop.hive.ql.io.avro.AvroContainerOutputFormat'
LOCATION 'location'
TBLPROPERTIES ('avro.schema.url'=schema_location');
Now I wanted to create a managed table with exactly the same columns except
of one additional column (a generated hash key). The only idea I had was to
create the table with: CREATE TABLE *tableB* LIKE *tableA*;
And then add the additional column with: ALTER TABLE *tableB* ADD COLUMNS
(new_column INT);
The statements run without any errors or exceptions (even in the log files
under /var/log/hive) but the new column doesn't appear.
With a CSV table it worked properly. So I think this has to do with the fact
that its a avro backed table. But according to this ticket
(https://issues.apache.org/jira/browse/HIVE-7446) the feature was added in
version 0.14.0.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
