doris 2.1.8 读取paimon catalog报错,大多数时候成功,偶尔报错

Viewed 30

报错信息为:1105: errCode = 2, detailMessage = Operand '?' of timestamp arithmetic expression 'now() - INTERVAL ? DAY' returns type 'unsupported_type' which is incompatible with expected type 'INT'.
rows:-] SELECT count(1) FROM paimon.prod.表名 WHERE updated_at >= NOW() - INTERVAL 7 DAY

1 Answers

有可能是jdbc driver报的。需要让明确下错误到底发生在哪。如果明确是doris 侧,那需要提供下异常日志,建表语句。