Quick BI数据集新建计算字段后，预览报错“There is no supertype for types String, Float64 because some of them are String/FixedString and some of them are not”

问题描述

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 公共云