SELECT sessionId, COUNT(DISTINCT uid) AS duid
FROM tracer_user_sessions
WHERE (
CASE
WHEN (joinTs <= 1727452799 AND leaveTs = 0) THEN 1
WHEN(joinTs <= 1727107200 AND leaveTs >= 1727107200 AND leaveTs != 0) THEN 1
WHEN (joinTs BETWEEN 1727107200 AND 1727452799 AND leaveTs != 0) THEN 1
ELSE 0
END
) = 1
and shard in (1,2,3,4,5,0,6,7,8,9)
AND (
uid IN (7849840, 2288658)
OR
account IN ('7849840', '2288658')
)
GROUP BY sessionId
LIMIT 10;
ERROR 1105 (HY000): errCode = 2, detailMessage = (10.10.8.68)[CANCELLED]failed to initialize storage reader. tablet=2225845, res=[E-1721][E-1721] Size of filter doesn't match size of column: size=0, filter.size=69
0# doris::Exception::Exception(int, std::basic_string_view<char, std::char_traits<char> > const&) at /var/local/ldb-toolchain/bin/../lib/gcc/x86_64-linux-gnu/11/../../../../include/c++/11/bits/unique_ptr.h:173
1# doris::Exception::Exception<unsigned long&, unsigned long&>(int, std::basic_string_view<char, std::