在kafka例程加载到StarRocks时将列转换为位图/HLL

Question

我打算在SR中进行不同的计数，并且注意到的列可以在加载期间转换为位图或HLL。但是我只在流加载和代理加载中找到转换，在kafka例程加载过程中有没有隐藏位图或HLL的方法？

Answer 1

CREATE ROUTINE LOAD example_tbl1_ordertest1 ON example_tbl1
COLUMNS (c1, c2, temp, c3=to_bitmap(c3))

FROM KAFKA
(
    "kafka_broker_list" ="<kafka_broker1_ip>:<kafka_broker1_port>",
    "kafka_topic" = "ordertest1",
    "kafka_partitions" ="0,1,2,3,4",
    "property.kafka_default_offsets" = "OFFSET_BEGINNING"
);