维度逻辑表中d_months字段的类型是DATETIME类型,但是补数据时发现物化表sdiccy_cdm.dws_fund_months_od000_v1中该字段类型却是DATE类型。导致补数据操作报错:com.aliyun.odps.OdpsException: ODPS-0130071:Semantic analysis exception - column D_MONTHS in source has incompatible type DATETIME with destination column d_months。
补数据运行报字段类型不匹配错误,完整的报错信息如下:
2022-08-05 15:34:11.497 com.aliyun.odps.OdpsException: ODPS-0130071:[2,8] Semantic analysis exception - column D_MONTHS in source has incompatible type DATETIME with destination column d_months, which has type DATE
at com.aliyun.odps.Instance.waitForSuccess(Instance.java:809)
at com.aliyun.odps.Instance.waitForSuccess(Instance.java:786)
at com.alibaba.dt.oneservice.sdk.OdpsSqlExecutor.run(OdpsSqlExecutor.java:86)
at com.alibaba.dt.oneservice.sdk.OdpsTask.runTask(OdpsTask.java:94)
at com.alibaba.dt.oneservice.sdk.task.BaseOsTask.run(BaseOsTask.java:116)
at com.alibaba.dt.oneservice.sdk.job.OsJob.run(OsJob.java:219)
at com.alibaba.dt.oneservice.sdk.executor.BaseOsExecutor.lambda$run$0(BaseOsExecutor.java:48)
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:1152)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:627)
at java.lang.Thread.run(Thread.java:882)