blob: d36906c4f4749388872e2134280f909a557526cb [file] [log] [blame]
-- verify that we can modify avro tables created by externalschemas
CREATE TABLE avro_extschema
STORED AS AVRO
TBLPROPERTIES ('avro.schema.literal'='{
"namespace": "org.apache.hive",
"name": "ext_schema",
"type": "record",
"fields": [
{ "name":"number", "type":"int" },
{ "name":"first_name", "type":"string" },
{ "name":"last_name", "type":"string" }
] }');
DESCRIBE avro_extschema;
ALTER TABLE avro_extschema
CHANGE COLUMN number number bigint;