create table tmp.date_dim as
select date_add('2016-01-01',a.rk) from(select row_number()over() as rk from db_user.user limit 10000)a
- db_user.user里必须有数据
- 从2016-01-01开始创建一个只含有日期的10000条数据的表
create table tmp.date_dim as
select date_add('2016-01-01',a.rk) from(select row_number()over() as rk from db_user.user limit 10000)a