| --! qt:dataset:src |
| -- SORT_QUERY_RESULTS |
| |
| create database avc; |
| |
| create table avc.alter_varchar_1 (key string, value string); |
| insert overwrite table avc.alter_varchar_1 |
| select key, value from src order by key limit 5; |
| |
| select * from avc.alter_varchar_1; |
| |
| -- change column to varchar |
| alter table avc.alter_varchar_1 change column value value varchar(20); |
| -- contents should still look the same |
| select * from avc.alter_varchar_1; |
| |
| -- change column to smaller varchar |
| alter table avc.alter_varchar_1 change column value value varchar(3); |
| -- value column should be truncated now |
| select * from avc.alter_varchar_1; |
| |
| -- change back to bigger varchar |
| alter table avc.alter_varchar_1 change column value value varchar(20); |
| -- column values should be full size again |
| select * from avc.alter_varchar_1; |
| |
| -- add varchar column |
| alter table avc.alter_varchar_1 add columns (key2 int, value2 varchar(10)); |
| select * from avc.alter_varchar_1; |
| |
| insert overwrite table avc.alter_varchar_1 |
| select key, value, key, value from src order by key limit 5; |
| select * from avc.alter_varchar_1; |
| |
| drop table avc.alter_varchar_1; |
| drop database avc; |