hive -f tableCreate.hql

set hive.exec.compress.output=false;
set hive.mapred.mode=nonstrict;

set hivevar:MIN_DT=20170401;
set hivevar:MAX_DT=20170301;

DROP TABLE IF EXISTS table1;
CREATE TABLE table1 AS
SELECT *
      FROM table t
      WHERE dt<=${MAX_DT} AND dt>=(${MIN_DT})

set hive.exec.compress.output=false;
set hive.mapred.mode=nonstrict;

set hivevar:MIN_DT=20170401;
set hivevar:MAX_DT=20170301;

DROP TABLE IF EXISTS table1;
CREATE TABLE table1 AS
SELECT *
      FROM table t
      WHERE dt<=${MAX_DT} AND dt>=('${MIN_DT}')