这个工具是要求分析图层的字段名称也是有固定格式的吗,您看一下报错信息
[2023-08-21 01:30:22] [ERROR] [Process] [土地利用变化检测] [appender] AnalysisException: cannot resolve '`DLBM_ed`' given input columns: [overlayres.tbppmj, overlayres.__fid__, overlayres.jsydlx, overlayres.tbmj_1, overlayres.dlmc_1, overlayres.qsdwmc, overlayres.gdlx_1, overlayres.pdjb4, overlayres.ykcdlbm, overlayres.bisland, overlayres.qsxz, overlayres.tkmj_1, overlayres.lxdwmj, overlayres.dlmc, overlayres.tkmj, overlayres.gdlx, overlayres.mqsdwmc, overlayres.qsdwmc_1, overlayres.tbmj, overlayres.Area, overlayres.fxmid, overlayres.sjbz10, overlayres.zldwmc_1, overlayres.bgrq, overlayres.sjbz4, overlayres.sjbz6, overlayres.sjbz, overlayres.ysdm_1, overlayres.tkxs_1, overlayres.ydlbm, overlayres.kcdlbm, overlayres.lxdwmj_1, overlayres.sjbz9, overlayres.tbdlmj_1, overlayres.ftbid, overlayres.bz, overlayres.gdpdj_1, overlayres.bgjlh, overlayres.qsxz_1, overlayres.bsm_1, overlayres.dlbz, overlayres.tbbh_1, overlayres.shape_leng, overlayres.zldwdm, overlayres.jbnt, overlayres.zldwmc, overlayres.sjbz7, overlayres.xwsj, overlayres.bgjlh_1, overlayres.bgrq_1, overlayres.xglx, overlayres.sjbz11, overlayres.tbdlmj, overlayres.zldwdm_1, overlayres.kclx_1, overlayres.scsj, overlayres.jsydxhfl, overlayres.pdjb, overlayres.pdjb1, overlayres.gdpdj, overlayres.tbybh, overlayres.sjbz2, overlayres.qsdwdm_1, overlayres.bgtbid, overlayres.bsm, overlayres.kcdlbm_1, overlayres.kclx, overlayres.xzgdjfly, overlayres.kzmj, overlayres.dlbm2, overlayres.yxbz, overlayres.xzgdjfly_1, overlayres.pdjb2, overlayres.hqrq, overlayres.dlbm, overlayres.tkxs, overlayres.zzxzgdmj, overlayres.dlppmj, overlayres.tbbh, overlayres.xzdwmj, overlayres.xzdwmj_1, overlayres.pzwh, overlayres.geom, overlayres.sjbz8, overlayres.sjbz5, overlayres.mqsdwdm, overlayres.pdjb3, overlayres.xmid, overlayres.xzgdly, overlayres.dlbz_1, overlayres.pzwh_1, overlayres.gzzk, overlayres.sjbz1, overlayres.sjbz3, overlayres.qsdwdm, overlayres.tbybh_1, overlayres.ysdm, overlayres.tbxh, overlayres.shape_area, overlayres.pdjb5]; line 1 pos 70; 'Aggregate ['DLBM_ed, 'DLBM_sd], [sum(Area#518) AS sumarea#900, 'DLBM_ed, 'DLBM_sd] +- SubqueryAlias overlayres +- LogicalRDD [__fid__#300, geom#303, bsm#304, ysdm#305, tbybh#306, tbbh#307, dlbm#308, dlmc#309, qsxz#310, qsdwdm#311, qsdwmc#312, zldwdm#313, zldwmc#314, gdlx#315, kclx#317, kcdlbm#319, tkxs#320, tbmj#322, xzdwmj#325, lxdwmj#328, tkmj#330, tbdlmj#332, pzwh#335, bgjlh#337, ... 76 more fields], false java.lang.reflect.InvocationTargetException at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:498) at com.supermap.sps.impl.annotated.AnnotatedProcess.execute(SourceFile:452) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:498) at com.supermap.bdt.processing.sps.AbstractBDTProcessFactory.lambda$proxyProcess$1(AbstractBDTProcessFactory.java:91) at com.sun.proxy.$Proxy90.execute(Unknown Source) at com.supermap.sps.core.workflow.impls.ProcessItemImpl.a(SourceFile:508) at com.supermap.sps.core.workflow.impls.ProcessItemImpl.execute(SourceFile:353) at com.supermap.sps.core.executor.ProcessTaskNode.a(SourceFile:23) at com.supermap.sps.core.executor.AbstractTaskNode.call(SourceFile:59) at com.supermap.sps.core.executor.DefaultWorkflowExecutor$a.a(SourceFile:390) at com.supermap.sps.core.executor.DefaultWorkflowExecutor$a.call(SourceFile:376) at java.util.concurrent.FutureTask.run(FutureTask.java:266) at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511) at java.util.concurrent.FutureTask.run(FutureTask.java:266) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) at java.lang.Thread.run(Thread.java:750) Caused by: org.apache.spark.sql.AnalysisException: cannot resolve '`DLBM_ed`' given input columns: [overlayres.tbppmj, overlayres.__fid__, overlayres.jsydlx, overlayres.tbmj_1, overlayres.dlmc_1, overlayres.qsdwmc, overlayres.gdlx_1, overlayres.pdjb4, overlayres.ykcdlbm, overlayres.bisland, overlayres.qsxz, overlayres.tkmj_1, overlayres.lxdwmj, overlayres.dlmc, overlayres.tkmj, overlayres.gdlx, overlayres.mqsdwmc, overlayres.qsdwmc_1, overlayres.tbmj, overlayres.Area, overlayres.fxmid, overlayres.sjbz10, overlayres.zldwmc_1, overlayres.bgrq, overlayres.sjbz4, overlayres.sjbz6, overlayres.sjbz, overlayres.ysdm_1, overlayres.tkxs_1, overlayres.ydlbm, overlayres.kcdlbm, overlayres.lxdwmj_1, overlayres.sjbz9, overlayres.tbdlmj_1, overlayres.ftbid, overlayres.bz, overlayres.gdpdj_1, overlayres.bgjlh, overlayres.qsxz_1, overlayres.bsm_1, overlayres.dlbz, overlayres.tbbh_1, overlayres.shape_leng, overlayres.zldwdm, overlayres.jbnt, overlayres.zldwmc, overlayres.sjbz7, overlayres.xwsj, overlayres.bgjlh_1, overlayres.bgrq_1, overlayres.xglx, overlayres.sjbz11, overlayres.tbdlmj, overlayres.zldwdm_1, overlayres.kclx_1, overlayres.scsj, overlayres.jsydxhfl, overlayres.pdjb, overlayres.pdjb1, overlayres.gdpdj, overlayres.tbybh, overlayres.sjbz2, overlayres.qsdwdm_1, overlayres.bgtbid, overlayres.bsm, overlayres.kcdlbm_1, overlayres.kclx, overlayres.xzgdjfly, overlayres.kzmj, overlayres.dlbm2, overlayres.yxbz, overlayres.xzgdjfly_1, overlayres.pdjb2, overlayres.hqrq, overlayres.dlbm, overlayres.tkxs, overlayres.zzxzgdmj, overlayres.dlppmj, overlayres.tbbh, overlayres.xzdwmj, overlayres.xzdwmj_1, overlayres.pzwh, overlayres.geom, overlayres.sjbz8, overlayres.sjbz5, overlayres.mqsdwdm, overlayres.pdjb3, overlayres.xmid, overlayres.xzgdly, overlayres.dlbz_1, overlayres.pzwh_1, overlayres.gzzk, overlayres.sjbz1, overlayres.sjbz3, overlayres.qsdwdm, overlayres.tbybh_1, overlayres.ysdm, overlayres.tbxh, overlayres.shape_area, overlayres.pdjb5]; line 1 pos 70; 'Aggregate ['DLBM_ed, 'DLBM_sd], [sum(Area#518) AS sumarea#900, 'DLBM_ed, 'DLBM_sd] +- SubqueryAlias overlayres +- LogicalRDD [__fid__#300, geom#303, bsm#304, ysdm#305, tbybh#306, tbbh#307, dlbm#308, dlmc#309, qsxz#310, qsdwdm#311, qsdwmc#312, zldwdm#313, zldwmc#314, gdlx#315, kclx#317, kcdlbm#319, tkxs#320, tbmj#322, xzdwmj#325, lxdwmj#328, tkmj#330, tbdlmj#332, pzwh#335, bgjlh#337, ... 76 more fields], false
默认检测是根据DLBM_sd和DLBM_ed字段来查询,如果需要切换成其他字段进行查询,您可以在模型中选中对应模型右键选择【编辑模型】,然后修改查询语句。
解决了,谢谢你
同样遇到这个问题,版本是11.1.0
所有的模型都没法编辑,能拖入到画布里