| --! qt:dataset:src | |
| drop table date_3; | |
| create table date_3 ( | |
| c1 int | |
| ); | |
| alter table date_3 add columns (c2 date); | |
| insert overwrite table date_3 | |
| select 1, cast(cast('2011-01-01 00:00:00' as timestamp) as date) from src tablesample (1 rows); | |
| select * from date_3; | |
| drop table date_3; |