Neha Tomar created HIVE-5211: -------------------------------- Summary: ALTER TABLE does not change the type of column for a table with AVRO data Key: HIVE-5211 URL: https://issues.apache.org/jira/browse/HIVE-5211 Project: Hive Issue Type: Bug Components: Metastore Affects Versions: 0.11.0 Reporter: Neha Tomar
1 >> Created a table in Hive with AVRO data. hive> CREATE EXTERNAL TABLE sample 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 '/home/neha/test_data/avrodata' > TBLPROPERTIES ('avro.schema.literal'='{"type": "record","name": "TUPLE_3","fields": [ { "name": "sample_id","type": [ "null", "int" ],"doc": "autogenerated from Pig Field Schema"} ]}' > ); OK Time taken: 0.16 seconds hive> describe sample; OK sample_id int from deserializer Time taken: 0.516 seconds, Fetched: 1 row(s) >> Alter the type of column from int to bigint. It displays "OK" as the result >> of DDL execution. However, describing the table still shows previous data >> type. hive> alter table sample change sample_id int bigint; OK Time taken: 0.614 seconds hive> describe sample; OK sample_id int from deserializer Time taken: 0.4 seconds, Fetched: 1 row(s) -- This message is automatically generated by JIRA. If you think it was sent incorrectly, please contact your JIRA administrators For more information on JIRA, see: http://www.atlassian.com/software/jira