| --! qt:dataset:src |
| drop table ctas_date_1; |
| drop table ctas_date_2; |
| drop view ctas_date_3; |
| drop view ctas_date_4; |
| |
| create table ctas_date_1 (key int, value string, dd date); |
| insert overwrite table ctas_date_1 |
| select key, value, date '2012-01-01' from src sort by key, value limit 5; |
| |
| -- create table as with date column |
| create table ctas_date_2 as select key, value, dd, date '1980-12-12' from ctas_date_1; |
| |
| -- view with date column |
| create view ctas_date_3 as select * from ctas_date_2 where dd > date '2000-01-01'; |
| create view ctas_date_4 as select * from ctas_date_2 where dd < date '2000-01-01'; |
| |
| select key, value, dd, date '1980-12-12' from ctas_date_1; |
| select * from ctas_date_2; |
| select * from ctas_date_3; |
| select count(*) from ctas_date_4; |
| |
| |
| drop table ctas_date_1; |
| drop table ctas_date_2; |
| drop view ctas_date_3; |
| drop view ctas_date_4; |