Doris Error

来自牛奶河Wiki
阿奔讨论 | 贡献2023年12月5日 (二) 16:57的版本
跳到导航 跳到搜索

[1105] Right expr of binary predicate should be value

删除数据时,右侧不支持表达式。如:

DELETE FROM test WHERE part = abs( murmur_hash3_32 ('42cbd45b-f03b-4840-bdb0-965238c4c07c') % 10)
-->
DELETE FROM test WHERE part = 0

[5025] Insert has filtered data in strict mode

空值不支持 ,改为 NULL

INSERT INTO ti_f_identity_reg_log (part, mm) VALUES (abs(murmur_hash3_32('c07c') % 10), )
-->
INSERT INTO ti_f_identity_reg_log (part, mm) VALUES (abs(murmur_hash3_32('c07c') % 10), NULL)