执行命令,用户绑定了拦截规则partition_num_block_rule
explain select * from xxx
报错
errCode = 2, detailMessage = sql hits sql block rule: partition_num_block_rule, reach partition_num : 30
执行命令,用户绑定了拦截规则partition_num_block_rule
explain select * from xxx
报错
errCode = 2, detailMessage = sql hits sql block rule: partition_num_block_rule, reach partition_num : 30
【问题状态】处理中
【问题处理】可以通过SHOW SQL_BLOCK_RULE命令查看是什么规则限制了查询最大扫描的分区数量,可以暂时drop这个拦截规则或者通过ALTER SQL BLOCK RULE修改规则
👉 参考文档:ALTER SQL BLOCK RULE
DROP-SQL-BLOCK-RULE