DataWorks 赋值节点语句 在临时查询可以出结果。但是在赋值节点运行结果就是0 是什么原因? 2023-01-12 10:44:34.202 INFO - codeContent: SELECT count(group_id) from ods_up_oms_ups_user_group_data_sched_config_df where pt = '${bizdate}' and status = 1 and update_type = 1; odps output: 2023-01-12 10:44:34 config file is ok!!! odps output: 2023-01-12 10:44:34 sql: odps output: set SKYNET_ID=210001336492; odps output: set SKYNET_BIZDATE=20230111; odps output: set SKYNET_PACKAGEID=-; odps output: set SKYNET_CYCTIME=20230112002600; odps output: set SKYNET_NODENAME=up_system_fuzhi_fenzhi; odps output: set SKYNET_TASKID=1000283872634; odps output: set SKYNET_SYSTEMID=dev; odps output: set SKYNET_PRIORITY=1; odps output: set SKYNET_JOBID=1000047863725; odps output: set SKYNET_ONDUTY=239818365660725854; odps output: set SKYNET_TENANT_ID=526393659847298; odps output: set SKYNET_BUSINESS_ID=-; odps output: set SKYNET_BUSINESS_NAME=-; odps output: set LINK_FILE_ID=-; odps output: set SKYNET_DAGTYPE=3; odps output: set WRAPPER_SQLSEQ=1; odps output: set WRAPPER_RETRYNUM=1; odps output: set biz_id=210001336492_20230111_1000283872634_1000047863725_1_chengla_bigdata_2022_dev_239818365660725854_526393659847298; odps output: SELECT count(group_id) from ods_up_oms_ups_user_group_data_sched_config_df where pt = '${bizdate}' and status = 1 and update_type = 1; odps output: odpscmd process start... odps output: OK odps output: OK odps output: OK odps output: OK odps output: OK odps output: OK odps output: OK odps output: OK odps output: OK odps output: OK odps output: OK odps output: OK odps output: OK odps output: OK odps output: OK odps output: OK odps output: OK odps output: OK odps output: 2023-01-12 10:44:36 start to get jobId: odps output: 2023-01-12 10:44:36 get jobid:20230112024435822gkxd4d0hi32 odps output: ID = 20230112024435822gkxd4d0hi32 odps output: Log view: odps output: http://logview.odps.aliyun.com/logview/?h=http://service.cn.maxcompute.aliyun-inc.com/api&p=chengla_bigdata_2022_dev&i=20230112024435822gkxd4d0hi32&token=S3d0eTVIQU5rbDMyWGxWQzJtNlB2RDJ3bjVjPSxPRFBTX09CTzpwNF8yMzk4MTgzNjU2NjA3MjU4NTQsMTY3NjA4MzQ3Nix7IlN0YXRlbWVudCI6W3siQWN0aW9uIjpbIm9kcHM6UmVhZCJdLCJFZmZlY3QiOiJBbGxvdyIsIlJlc291cmNlIjpbImFjczpvZHBzOio6cHJvamVjdHMvY2hlbmdsYV9iaWdkYXRhXzIwMjJfZGV2L2luc3RhbmNlcy8yMDIzMDExMjAyNDQzNTgyMmdreGQ0ZDBoaTMyIl19XSwiVmVyc2lvbiI6IjEifQ== odps output: Job Queueing... odps output: Summary: odps output: WARNING:[0,0] table scan ods_up_oms_ups_user_group_data_sched_config_df with filter AND(EQ($8, S'${bizdate}'), EQ($5, 1L), EQ($4, 1L)) was pruned to empty values odps output: resource cost: cpu 0.00 Core * Min, memory 0.00 GB * Min odps output: inputs: odps output: outputs: odps output: Job run time: 1.000 odps output: Job run mode: service job 2.0 odps output: Job run engine: execution engine odps output: M1: odps output: bubble: 0 odps output: instance count: 1 odps output: run time: 1.000 odps output: instance time: odps output: min: 0.000, max: 0.000, avg: 0.000 odps output: input records: odps output: output records: odps output: AdhocSink1: 1 (min: 1, max: 1, avg: 1) odps output: metrics_output_count: odps output: AdhocSink1: 1 (min: 1, max: 1, avg: 1) odps output: Values1: 1 (min: 1, max: 1, avg: 1) odps output: metrics_inner_time_ms: odps output: AdhocSink1: 54 (min: 54, max: 54, avg: 54) MaxInstance: 0 odps output: GlobalInit: 0 (min: 0, max: 0, avg: 0) MaxInstance: 0 odps output: Values1: 0 (min: 0, max: 0, avg: 0) MaxInstance: 0 2023-01-12 10:44:38.390 INFO - ===>Output Result: [["0"]] 2023-01-12 10:44:38.833 INFO - cost Time: 4 2023-01-12 10:44:38 INFO ================================================================= 2023-01-12 10:44:38 INFO Exit code of the Shell command 0 2023-01-12 10:44:38 INFO --- Invocation of Shell command completed --- 2023-01-12 10:44:38 INFO Shell run successfully! 2023-01-12 10:44:38 INFO Current task status: FINISH 2023-01-12 10:44:38 INFO Cost time is: 7.807s /home/admin/alisatasknode/taskinfo//20230112/phoenix/10/44/28/aswr31pm9t9we28vf2avogxy/T3_1667960400.log-END-EOF
调度参数没有赋值 1) 调度配置中 给参数做一下赋值 2)业务流程界面直接运行时需手动给参数赋日期值——该回答整理自钉群“DataWorks交流群(答疑@机器人)“
版权声明:本文内容由阿里云实名注册用户自发贡献,版权归原作者所有,阿里云开发者社区不拥有其著作权,亦不承担相应法律责任。具体规则请查看《阿里云开发者社区用户服务协议》和《阿里云开发者社区知识产权保护指引》。如果您发现本社区中有涉嫌抄袭的内容,填写侵权投诉表单进行举报,一经查实,本社区将立刻删除涉嫌侵权内容。
DataWorks基于MaxCompute/Hologres/EMR/CDP等大数据引擎,为数据仓库/数据湖/湖仓一体等解决方案提供统一的全链路大数据开发治理平台。