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
