set CURRENT_YEAR=2018;
set CURRENT_MONTH=11;
set CURRENT_DAY=9;
select * from talename
where year >= '${hiveconf:CURRENT_YEAR}'
and month>='${hiveconf:CURRENT_MONTH}'
and day>='${hiveconf:CURRENT_DAY}'
LIMIT 100
如此只需每天更换常量数据就可获得预期时间的数据!
set CURRENT_YEAR=2018;
set CURRENT_MONTH=11;
set CURRENT_DAY=9;
select * from talename
where year >= '${hiveconf:CURRENT_YEAR}'
and month>='${hiveconf:CURRENT_MONTH}'
and day>='${hiveconf:CURRENT_DAY}'
LIMIT 100
如此只需每天更换常量数据就可获得预期时间的数据!