--! qt:dataset:src
drop table ctas_char_1;
drop table ctas_char_2;
drop view ctas_char_3;

create table ctas_char_1 (key char(10), value string);
insert overwrite table ctas_char_1 
  select key, value from src sort by key, value limit 5;

-- create table as with char column
create table ctas_char_2 as select key, value from ctas_char_1;

-- view with char column
create view ctas_char_3 as select key, value from ctas_char_2;

select key, value from ctas_char_1;
select * from ctas_char_2;
select * from ctas_char_3;


drop table ctas_char_1;
drop table ctas_char_2;
drop view ctas_char_3;