· 9 years ago · Dec 20, 2016, 08:36 PM
1set hivevar:start_date=0000-01-01;
2set hivevar:days=1000000;
3set hivevar:table_name=[INSERT YOUR TABLE NAME HERE];
4
5CREATE TABLE IF NOT EXISTS ${table_name} AS
6WITH dates AS (
7 SELECT date_add("${start_date}", a.pos) as date
8 FROM (SELECT posexplode(split(repeat(",", ${days}), ","))) a
9)
10SELECT
11 date
12FROM dates
13SORT BY date
14;