this is orginal table, but
Originally, organization_id, device_id, dst_ip IDs were symbols, but in the case of varchar vs symbol, they were changed to test ilp performance.
this is testing table
This is how I worked:
CREATE TABLE 'traffic_dst_min_test' (
organization_id VARCHAR,
device_id VARCHAR,
dst_ip VARCHAR,
domain SYMBOL,
lan_tcp_up_bytes LONG,
lan_tcp_down_bytes LONG,
lan_udp_up_bytes LONG,
lan_udp_down_bytes LONG,
wan_tcp_up_bytes LONG,
wan_tcp_down_bytes LONG,
wan_udp_up_bytes LONG,
wan_udp_down_bytes LONG,
ts TIMESTAMP
) timestamp (ts) PARTITION BY HOUR WAL;
insert into traffic_dst_min_test
select
organization_id,
device_id,
dst_ip,
case
when cast(dst_ip as ipv4) is null then dst_ip
else null
end domain,
lan_tcp_up_bytes,
lan_tcp_down_bytes,
lan_udp_up_bytes,
lan_udp_down_bytes,
wan_tcp_up_bytes,
wan_tcp_down_bytes,
wan_udp_up_bytes,
wan_udp_down_bytes,
ts
from
traffic_dst_min
where
ts IN '2024-11-11';
alter table traffic_dst_min_test alter column organization_id type symbol;
alter table traffic_dst_min_test alter column organization_id add index;
alter table traffic_dst_min_test alter column device_id type symbol;
alter table traffic_dst_min_test alter column device_id add index;
After restarting, the symbol’s capacity was resolved.
