1、创建时间维表,dim_date
create table dongjj.dim_date(
year
VARCHAR(100),
month
VARCHAR(100),
date
VARCHAR(100),
yearweek VARCHAR(100),
week
VARCHAR(100),
weekend VARCHAR(100),
workday VARCHAR(100),
holiday VARCHAR(100),
holiday_or VARCHAR(100),
holiday_legal VARCHAR(100),
year_cn VARCHAR(100),
month_cn VARCHAR(100),
date_cn VARCHAR(100),
yearweek_cn VARCHAR(100),
week_cn VARCHAR(100),
weekend_cn VARCHAR(100),
workday_cn VARCHAR(100),
holiday_cn VARCHAR(100),
holiday_or_cn VARCHAR(100),
holiday_legal_cn VARCHAR(100)
);
2、使用kettle,调用josn input 组件,解析数据并入库