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验证