You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@dolphinscheduler.apache.org by lidong dai <da...@gmail.com> on 2020/08/04 11:44:42 UTC

Re: exeute external hive sql BUG

you don't use right way
8.1 系统参数
变量含义
${system.biz.date} 日常调度实例定时的定时时间前一天,格式为 yyyyMMdd,补数据时,该日期 +1
${system.biz.curdate} 日常调度实例定时的定时时间,格式为 yyyyMMdd,补数据时,该日期 +1
${system.datetime} 日常调度实例定时的定时时间,格式为 yyyyMMddHHmmss,补数据时,该日期 +1
https://dolphinscheduler.apache.org/zh-cn/docs/1.3.1/user_doc/system-manual.html



Best Regards
---------------
DolphinScheduler(Incubator) PPMC
Lidong Dai 代立冬
dailidong66@gmail.com
---------------


chonglou <ch...@byai.com> 于2020年7月9日周四 下午3:30写道:

> i created a hive external table, when i exeute this hive sql----alter
> table log_nlp_industory_log add partition (dt='${biz_date}') location
> '/log/nlp/${biz_date}',  the replace sql is print----alter table
> log_nlp_industory_log add partition (dt=?) location '/log/nlp/?
> obvious, this replace sql is not conform to hive's grammar