阿里云首页

Dataphin事实逻辑表修改字段类型由string改为bigint,提交失败报错:"DPN.Onedata.FactTablePublishFail"

问题描述

Dataphin事实逻辑表修改字段类型由string改为bigint,提交失败报错:"DPN.Onedata.FactTablePublishFail"。

{"traceId":"87e68f3d1f6949c7","code":"0","message":"","data":
[{"id":167045,"modelId":5571812,"modelType":2,"submitType":2,"taskStatus":"FAIL","errorMsg":
{"warnInfo":null,"errorDTO":{"errorInfo":"事实逻辑表-发布失败:校验失败: [org.springframework.jdbc.UncategorizedSQLException: StatementCallback; uncategorized SQLException for SQL [set odps.sql.type.system.odps2=true;\nCREATE TABLE IF NOT EXISTS fct_order_df_OD000_V2 (\n\tchannel_id BIGINT COMMENT '渠道ID',\n\tdelete_type BIGINT COMMEN]","errorData":null,"errorCode":"DPN.Onedata.FactTablePublishFail"}}
,"warnMsg":null,"userId":"306246307","tenantId":300914617,"gmtCreate":"2021-11-24 17:52:53","gmtModified":"2021-11-24 17:52:53"}]
,"monitorLog":null}

问题原因

由于当前项目不支持decimal设置精度导致的。

解决方案

项目管理员添加下odps项目的配置:set odps.sql.decimal.odps2=true。

适用于

  • Dataphin
首页 Dataphin事实逻辑表修改字段类型由string改为bigint,提交失败报错:"DPN.Onedata.FactTablePublishFail"