Doris版本:2.1.5
SQL查询导致BE服务重启,报错如下
column_string.cpp:254] Check failed: filter.size() == offsets.size() (4064 vs. 8128)
2.1.6版本会修复吗?
SQL如下
SELECT rn_max ,count(distinct a.device_id) cnt from (SELECT device_id ,max(rn) rn_max from (SELECT device_id ,row_number() over(partition by device_id,carrier_type order by month asc) rn ,row_number() over(partition by device_id order by month asc) rn1 from hive.base.dim_ip_p_c_result where city in ('重庆市')) a where rn1 - rn > 0 group by device_id) a join (SELECT device_id from (SELECT device_id ,row_number() over(partition by device_id order by month asc) rn1 from hive.base.dim_ip_p_c_result where city in ('重庆市')) a where rn1 > 24 group by device_id) b on a.device_id = b.device_id group by rn_max
完整报错信息如下
图一
图二