doris2.1.7 执行报错

Viewed 46

Caused by: java.sql.SQLException: errCode = 2, detailMessage = (10.1.106.156)[CANCELLED]sync filter size meet error, filter: RuntimeFilter: (id = 11, type = bloomfilter, need_local_merge: true, is_broadcast: false, build_bf_cardinality: true

at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:129)

at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:97)

at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:122)

at com.mysql.cj.jdbc.ClientPreparedStatement.executeInternal(ClientPreparedStatement.java:955)

at com.mysql.cj.jdbc.ClientPreparedStatement.executeUpdateInternal(ClientPreparedStatement.java:1094)

at com.mysql.cj.jdbc.ClientPreparedStatement.executeUpdateInternal(ClientPreparedStatement.java:1042)

at com.mysql.cj.jdbc.ClientPreparedStatement.executeLargeUpdate(ClientPreparedStatement.java:1345)

at com.mysql.cj.jdbc.ClientPreparedStatement.executeUpdate(ClientPreparedStatement.java:1027)

at org.apache.dolphinscheduler.plugin.task.sql.SqlTask.executeUpdate(SqlTask.java:319)

at org.apache.dolphinscheduler.plugin.task.sql.SqlTask.executeFuncAndSql(SqlTask.java:215)

at org.apache.dolphinscheduler.plugin.task.sql.SqlTask.handle(SqlTask.java:166)

... 9 common frames omitted
1 Answers

2.1.7已知问题,建议升级至 2.1.9

目前可以做以下操作进行规避:
set global enable_sync_runtime_filter_size=false
set runtime_filter_type = 'in_or_bloom_filter'

禁用了收集全局rf大小的优化,可能会导致rf size没有那么精确,有很小的概率会让性能略差一点,影响不大。