CREATE TABLE exemplar_source_ids (
    __table_id INT UNSIGNED NOT NULL,
    __tsid BIGINT UNSIGNED NOT NULL,
    greptime_metric STRING,
    greptime_timestamp TIMESTAMP(9) TIME INDEX,
    greptime_value DOUBLE,
    PRIMARY KEY (__table_id, __tsid, greptime_metric)
) WITH ('append_mode'='true', 'primary_key_encoding'='sparse');
INSERT INTO exemplar_source_ids VALUES
    (42, 18446744073709551615, 'cpu', 20, 1.0),
    (42, 18446744073709551615, 'cpu', 20, 1.0),
    (43, 18446744073709551615, 'memory', 10, 2.0);
ADMIN FLUSH_TABLE('exemplar_source_ids');
ALTER TABLE exemplar_source_ids ADD COLUMN job STRING PRIMARY KEY;
INSERT INTO exemplar_source_ids VALUES (42, 7, 'cpu', 30, 3.0, 'api');