【详述】with a as (
select
‘0’ as fielda
),
b as (
select
cast(issetpaypwdtip as string) as fielda
from
kudu_yqz.integral.integralclientnewinfo_new
)
select
*
from
a
inner join b on a.fielda = b.fielda
limit
10;
issetpaypwdtip 为 bigint类型
ERROR 1064 (HY000): issetpaypwdtip’s type isn’t [Type: string, Type: varchar], it’s int64
b表换成 sr 内表,查询没有问题
【业务影响】
【是否存算分离】存算一体
【StarRocks版本】例如:3.3.6