Hi,
Do you have a CSV or similar we can import? I’ve been trying to reproduce, but no luck. This is my reproducer
CREATE TABLE 'sample' (
tdate TIMESTAMP,
reg SYMBOL capacity 8 CACHE,
id INT,
symbol1 SYMBOL capacity 65536 CACHE,
symbol2 SYMBOL capacity 131072 CACHE,
pk SYMBOL capacity 65536 CACHE,
cur SYMBOL capacity 128 CACHE,
px FLOAT,
qty LONG
) timestamp (tdate) PARTITION BY DAY WAL DEDUP UPSERT KEYS(tdate, id, symbol1);
truncate table 'sample';
INSERT INTO 'sample'
SELECT
timestamp_sequence(
to_timestamp('2023-01-01', 'yyyy-MM-dd'),
100000000L
) AS tdate,
rnd_symbol('AAA', 'BBB', 'CCC', 'DDD', 'EEE') AS reg,
x AS id,
rnd_symbol('BBB', 'CCC', 'DDD', 'EEE', 'AAA') AS symbol1,
rnd_symbol('CCC', 'DDD', 'EEE', 'AAA', 'BBB') AS symbol2,
rnd_symbol('DDD', 'EEE', 'AAA', 'BBB', 'CCC') AS pk,
rnd_symbol('EEE', 'AAA', 'BBB', 'CCC', 'DDD') AS cur,
rnd_float(0) * 100 AS px,
rnd_long(1, 10000, 0) AS qty
FROM
long_sequence(5000);
select * from 'sample';
select * from 'sample' where symbol1 != symbol2 order by symbol1, symbol2;