| --! qt:dataset:src |
| drop table ctas_varchar_1; |
| drop table ctas_varchar_2; |
| drop view ctas_varchar_3; |
| |
| create table ctas_varchar_1 (key varchar(10), value string); |
| insert overwrite table ctas_varchar_1 |
| select key, value from src sort by key, value limit 5; |
| |
| -- create table as with varchar column |
| create table ctas_varchar_2 as select key, value from ctas_varchar_1; |
| |
| -- view with varchar column |
| create view ctas_varchar_3 as select key, value from ctas_varchar_2; |
| |
| select key, value from ctas_varchar_1; |
| select * from ctas_varchar_2; |
| select * from ctas_varchar_3; |
| |
| |
| drop table ctas_varchar_1; |
| drop table ctas_varchar_2; |
| drop view ctas_varchar_3; |