How to create a table with dates in sequence between range in Hive?
You do not need VALUES keyword when using INSERT ... SELECT.
Working example:
set hivevar:start_date=2009-01-01;set hivevar:end_date=2016-06-31;CREATE TABLE DateRangeTable(mydate DATE, qty INT);with date_range as (--this query generates date rangeselect date_add ('${hivevar:start_date}',s.i) as dt from ( select posexplode(split(space(datediff('${hivevar:end_date}','${hivevar:start_date}')),' ')) as (i,x) ) s) INSERT INTO TABLE DateRangeTableselect d.dt, 0 qty from date_range d where d.dt between '2019-01-01' and '2016-06-30');