Quick BI图表展示报错："Semantic analysis exception - invalid operand type(s) BOOLEAN,STRING for operator '='"

问题描述

Quick BI图表展示报错："Semantic analysis exception - invalid operand type(s) BOOLEAN,STRING for operator '='"。

errMsg:数据源执行SQL失败:INTERNAL: instance:[20221229064154410gg3f14fou8d1] failed: ODPS-0130071:[29,18] Semantic analysis exception - invalid operand type(s) BOOLEAN,STRING for operator '='  io.grpc.stub.ServerCalls$UnaryServerCallHandler$UnaryServerCallListener.onHalfClose(ServerCalls.java:182) io.grpc.internal.ServerCallImpl$ServerStreamListenerImpl.halfClosed(ServerCallImpl.java:331) io.grpc.internal.ServerImpl$JumpToApplicationThreadServerStreamListener$1HalfClosed.runInContext(ServerImpl.java:814) io.grpc.internal.ContextRunnable.run(ContextRunnable.java:37) io.grpc.internal.SerializingExecutor.run(SerializingExecutor.java:123) 

问题原因

字段中存在BOOLEAN类型，不能与STRING用'='计算。

解决方案

Quick BI数据集不支持BOOLEAN类型，需要新建计算字段将BOOLEAN类型强转为STRING类型。

适用于

• Quick BI 公共云