麦粉社区
>
帖子详情

插入更新关系表

数据准备 发表于 2025-7-10 09:48
发表于 2025-7-10 09:48:33

sql报错:


2025-07-10 09:54:47.134  [29064611] INFO launcher.DefaultLauncher.run:68 [tid=edb7ffffef7cfa10] - Task start. (id:129fad66e6b70b5dd501478bbcd58c1c,name:JDBC_DATATARGER_UPSET)
2025-07-10 09:54:47.135  [29064611] INFO launcher.DefaultLauncher.run:72 [tid=edb7ffffef7cfa10] - Agent:default
2025-07-10 09:54:47.162  [29064611] INFO repository.NodeStatusRepository.executeUpdate:158 [tid=edb7ffffef7cfa10] - Report status successful.(state:RUNNING)
2025-07-10 09:54:47.162  [29064611] INFO node.GenericNode.start:108 [tid=edb7ffffef7cfa10] - Node start. (id:129fad66e6b70b5dd501478bbcd58c1c,name:JDBC_DATATARGER_UPSET)
2025-07-10 09:54:47.163  [29064611] INFO datatarget.JdbcDataTargetNode.checkConfig:330 [tid=edb7ffffef7cfa10] - loaded advanced properties: {}
2025-07-10 09:54:47.191  [29064611] INFO datasources.InMemoryFileIndex.logInfo:60 [tid=edb7ffffef7cfa10] - It took 1 ms to list leaf files for 1 paths.
2025-07-10 09:54:47.251  [29064611] INFO spark.SparkContext.logInfo:60 [tid=edb7ffffef7cfa10] - Starting job: parquet at DatasetEvent.java:247
2025-07-10 09:54:47.292  [29064611] INFO scheduler.DAGScheduler.logInfo:60 [tid=edb7ffffef7cfa10] - Job 7335335 finished: parquet at DatasetEvent.java:247, took 0.040461 s
2025-07-10 09:54:47.295  [29064611] INFO util.EventSerializeUtil.deserialize:106 [tid=edb7ffffef7cfa10] - Deserialization event finished,took 0.131 s
2025-07-10 09:54:47.297  [29064611] INFO datatarget.JdbcDataTargetNode.datasetColumnChange:283 [tid=edb7ffffef7cfa10] - Finish rename the Dataset-Column!
2025-07-10 09:54:47.315  [29064611] ERROR node.GenericNode.handleExecuteError:150 [tid=edb7ffffef7cfa10] - Node execution failed.(id:129fad66e6b70b5dd501478bbcd58c1c,name:JDBC_DATATARGER_UPSET)
smartbix.datamining.engine.execute.exception.CheckedException: 数据集中未检测到与目标表null.ceshi1匹配的列:user!请检查字段映射并点击确认
    at smartbix.datamining.engine.execute.node.datatarget.JdbcDataTargetNode.execute(JdbcDataTargetNode.java:152) ~[EngineCommonNode-1.0.jar:?]
    at smartbix.datamining.engine.execute.node.GenericNode.start(GenericNode.java:118) [EngineCore-1.0.jar:?]
    at smartbix.datamining.engine.agent.execute.executor.DefaultNodeExecutor.execute(DefaultNodeExecutor.java:60) [EngineAgent-1.0.jar:?]
    at smartbix.datamining.engine.agent.execute.launcher.DefaultLauncher.run(DefaultLauncher.java:79) [EngineAgent-1.0.jar:?]
    at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511) [?:1.8.0_181]
    at java.util.concurrent.FutureTask.run(FutureTask.java:266) [?:1.8.0_181]
    at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) [?:1.8.0_181]
    at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) [?:1.8.0_181]
    at java.lang.Thread.run(Thread.java:748) [?:1.8.0_181]
2025-07-10 09:54:47.315  [29064611] INFO flow.DistributionFlowContext.notifyNodeFail:540 [tid=edb7ffffef7cfa10] - Number of records outputed:0
2025-07-10 09:54:47.341  [29064611] INFO repository.NodeStatusRepository.executeUpdate:158 [tid=edb7ffffef7cfa10] - Report status successful.(state:FAIL)

发表于 2025-7-10 17:06:01
数据集中未检测到与目标表null.ceshi1匹配的列:user! 请检查字段映射并点击确认
回复

使用道具 举报

高级模式
B Color Image Link Quote Code Smilies
您需要登录后才可以回帖 登录 | 立即注册

1回帖数 0关注人数 963浏览人数
最后回复于:2025-7-10 17:06

社区

指南

AI

搜索

快速回复 返回顶部 返回列表