[ https://issues.apache.org/jira/browse/HIVE-5211?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Sean Busbey updated HIVE-5211: ------------------------------ Labels: avro (was: ) > 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 > Labels: avro > > 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