Quick BI数据集新建计算字段后,预览报错“There is no supertype for types String, Float64 because some of them are String/FixedString and some of them are not”
更新时间:2025-03-26 12:40:30
问题描述
Quick BI数据集新建计算字段后,预览报错“There is no supertype for types String, Float64 because some of them are String/FixedString and some of them are not”。
数据源执行SQL失败:INTERNAL: java.lang.RuntimeException: SQL execute error by datasource... ru.yandex.clickhouse.except.ClickHouseException: ClickHouse exception, code: 386, host: *.*.*.*, port: 39384; Code: 386, e.displayText() = DB::Exception: There is no supertype for types String, Float64 because some of them are String/FixedString and some of them are not (version *.*.*.*) ru.yandex.clickhouse.except.ClickHouseExceptionSpecifier.specify(ClickHouseExceptionSpecifier.java:58) ru.yandex.clickhouse.except.ClickHouseExceptionSpecifier.specify(ClickHouseExceptionSpecifier.java:28) ru.yandex.clickhouse.ClickHouseStatementImpl.checkForErrorAndThrow(ClickHouseStatementImpl.java:875) ru.yandex.clickhouse.ClickHouseStatementImpl.getInputStream(ClickHouseStatementImpl.java:616)
ru.yandex.clickhouse.ClickHouseStatementImpl.executeQuery(ClickHouseStatementImpl.java:117)
问题原因
新建的计算字段中,使用string类型字段进行计算,导致报错。
解决方案
将Excel中的string字段类型切换为数值类型即可。
适用于
- Quick BI 公共云
该文章对您有帮助吗?
- 本页导读
- 问题描述
- 问题原因
- 解决方案
- 适用于