| create table `widestrings` as |
| select cast(id as int) id, cast(str_fixed as varchar(5000)) str_fixed, cast(str_var as varchar(5000)) str_var, cast(str_empty as varchar(5000)) str_empty, cast(str_null as varchar(5000)) str_null, cast(str_empty_null as varchar(5000)) str_empty_null, cast(str_var_null_empty as varchar(5000)) str_var_null_empty, cast(str_fixed_null_empty as varchar(5000)) str_fixed_null_empty, cast(tinyint_var as int) tinyint_var, cast(dec_var_prec5_sc2 as decimal(5,2)) dec_var_prec5_sc2 from `/drill/testdata/data-shapes/wide-columns/5000/100rows/json/widestrings`; |
