开发者社区 > 大数据与机器学习 > 大数据开发治理DataWorks > 正文

DataWorks 赋值节点语句 在临时查询可以出结果。但是在赋值节点运行结果就是0 是什么原因?

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

展开
收起
wenti 2023-01-16 13:33:38 374 0
1 条回答
写回答
取消 提交回答
  • 调度参数没有赋值 1) 调度配置中 给参数做一下赋值 2)业务流程界面直接运行时需手动给参数赋日期值——该回答整理自钉群“DataWorks交流群(答疑@机器人)“

    2023-01-16 17:18:32
    赞同 展开评论 打赏

DataWorks基于MaxCompute/Hologres/EMR/CDP等大数据引擎,为数据仓库/数据湖/湖仓一体等解决方案提供统一的全链路大数据开发治理平台。

相关产品

  • 大数据开发治理平台 DataWorks
  • 热门讨论

    热门文章

    相关电子书

    更多
    DataWorks全链路数据质量解决方案-2020飞天大数据平台实战应用第一季 立即下载
    DataWorks数据集成实时同步最佳实践(含内测邀请)-2020飞天大数据平台实战应用第一季 立即下载
    基于DataWorks数据服务构建疫情大屏-2020飞天大数据平台实战应用第一季 立即下载

    相关实验场景

    更多