CREATE TABLE test (
big_key int NULL COMMENT "唯一列",
int_1 int NULL COMMENT "最小值-2147483648"
) ENGINE=OLAP
DUPLICATE KEY(big_key)
COMMENT 'olap'
DISTRIBUTED BY HASH(big_key) BUCKETS AUTO
PROPERTIES (
"replication_allocation" = "tag.location.default: 1"
);
insert into test(big_key, int_1) values(1, 2);
explain optimized plan
select
case exists(select int_1 from test)
when 1 then 2
when 3 then 4
else 5 end a3
from test;
