blob: ae2b8d5c93a130fa9fc80a70403d8bf3e15c1b9b [file] [log] [blame]
-- Setup
create table t1_n14 (c1 int);
-- Check value of parameter
set hive.metastore.disallow.incompatible.col.type.changes;
set metaconf:hive.metastore.disallow.incompatible.col.type.changes;
-- Change parameter to allow column type changes in metastore
set metaconf:hive.metastore.disallow.incompatible.col.type.changes=false;
-- check value of parameter
set hive.metastore.disallow.incompatible.col.type.changes;
set metaconf:hive.metastore.disallow.incompatible.col.type.changes;
-- Change int to small int now allowed.
explain alter table t1_n14 change column c1 c1 smallint;
alter table t1_n14 change column c1 c1 smallint;