| CREATE TABLE IF NOT EXISTS `date` ( |
| `d_datekey` int(11) NOT NULL COMMENT "", |
| `d_date` varchar(20) NOT NULL COMMENT "", |
| `d_dayofweek` varchar(10) NOT NULL COMMENT "", |
| `d_month` varchar(11) NOT NULL COMMENT "", |
| `d_year` int(11) NOT NULL COMMENT "", |
| `d_yearmonthnum` int(11) NOT NULL COMMENT "", |
| `d_yearmonth` varchar(9) NOT NULL COMMENT "", |
| `d_daynuminweek` int(11) NOT NULL COMMENT "", |
| `d_daynuminmonth` int(11) NOT NULL COMMENT "", |
| `d_daynuminyear` int(11) NOT NULL COMMENT "", |
| `d_monthnuminyear` int(11) NOT NULL COMMENT "", |
| `d_weeknuminyear` int(11) NOT NULL COMMENT "", |
| `d_sellingseason` varchar(14) NOT NULL COMMENT "", |
| `d_lastdayinweekfl` int(11) NOT NULL COMMENT "", |
| `d_lastdayinmonthfl` int(11) NOT NULL COMMENT "", |
| `d_holidayfl` int(11) NOT NULL COMMENT "", |
| `d_weekdayfl` int(11) NOT NULL COMMENT "" |
| ) |
| DISTRIBUTED BY HASH(`d_datekey`) BUCKETS 1 |
| PROPERTIES ( |
| "replication_num" = "1" |
| ); |