Quick BI新建的日期计算字段报错:“ODPS-0130071:[1,429] Semantic analysis exception - function TO_CHAR cannot match any overloaded functions with (STRING, STRING)”
更新时间:
问题描述
Quick BI新建的日期计算字段报错:
errMsg:数据源执行SQL失败:INTERNAL: instance:[20220930023439271gjbmxh8a2] failed: ODPS-0130071:[1,429] Semantic analysis exception - function TO_CHAR cannot match any overloaded functions with (STRING, STRING), candidates are STRING TO_CHAR(BIGINT arg0); STRING TO_CHAR(BOOLEAN arg0); STRING TO_CHAR(DATE arg0, STRING arg1); STRING TO_CHAR(DATETIME arg0, STRING arg1); STRING TO_CHAR(DECIMAL(?,?) arg0); STRING TO_CHAR(DOUBLE arg0); STRING TO_CHAR(TIMESTAMP arg0, STRING arg1); STRING TO_CHAR(VOID arg0) ODPS-0130071:[1,512] Semantic analysis exception - function TO_CHAR cannot match any overloaded functions with (STRING, STRING), candidates are STRING TO_CHAR(BIGINT arg0); STRING TO_CHAR(BOOLEAN arg0); STRING TO_CHAR(DATE arg0, STRING arg1); STRING TO_CHAR(DATETIME arg0, STRING arg1); STRING TO_CHAR(DECIMAL(?,?) arg0); STRING TO_CHAR(DOUBLE arg0); STRING TO_CHAR(TIMESTAMP arg0, STRING arg1); STRING TO_CHAR(VOID arg0) ODPS-0130071:[1,585] Semantic analysis exception - function TO_CHAR cannot match any overloaded functions with...
解决方案
使用to_date函数对字段类型转换处理。
适用于
- Quick BI
- 基于公共云4.4.3验证
文档内容是否对您有帮助?