--! qt:dataset:src
set hive.strict.checks.bucketing=false;

set hive.mapred.mode=nonstrict;
drop table varchar1;
drop table varchar1_1;

create table varchar1 (key varchar(10), value varchar(20));
create table varchar1_1 (key string, value string);

-- load from file
load data local inpath '../../data/files/srcbucket0.txt' overwrite into table varchar1;
select * from varchar1 order by key, value limit 2;

-- insert overwrite, from same/different length varchar
insert overwrite table varchar1
  select cast(key as varchar(10)), cast(value as varchar(15)) from src order by key, value limit 2;
select key, value from varchar1 order by key, value;

-- insert overwrite, from string
insert overwrite table varchar1
  select key, value from src order by key, value limit 2;
select key, value from varchar1 order by key, value;

-- insert string from varchar
insert overwrite table varchar1_1
  select key, value from varchar1 order by key, value limit 2;
select key, value from varchar1_1 order by key, value;

-- respect string length
insert overwrite table varchar1 
  select key, cast(value as varchar(3)) from src order by key, value limit 2;
select key, value from varchar1 order by key, value;

drop table varchar1;
drop table varchar1_1;