1CREATE TABLE hnswpq_documents (
2    `id` BIGINT NOT NULL,
3    `content` STRING,
4    `embedding` ARRAY<FLOAT> NOT NULL,
5    INDEX idx_hnswpq(embedding) USING ANN PROPERTIES(
6        'algorithm' = 'hnswpq',
7        'dimension' = '4',
8        'distance' = 'cosine',
9        'hnswpq_m' = '16',
10        'hnswpq_efConstruction' = '200',
11        'hnswpq_sampleRate' = '0.25'
12    )
13)
14DUPLICATE KEY(`id`)
15DISTRIBUTED BY HASH(`id`) BUCKETS 4;

1CREATE INDEX idx_hnswpq
2ON hnswpq_documents (embedding)
3USING ANN
4PROPERTIES(
5    'algorithm' = 'hnswpq',
6    'dimension' = '4',
7    'distance' = 'cosine',
8    'hnswpq_m' = '16',
9    'hnswpq_efConstruction' = '200',
10    'hnswpq_sampleRate' = '0.25'
11);

1SET hnswpq_ef_search = 100;

1SELECT /*+ SET_VAR(hnswpq_ef_search=100) */
2       id, content, __DISTANCE
3FROM hnswpq_documents
4ORDER BY ann_distance(embedding, [0.10, 0.20, 0.30, 0.40])
5LIMIT 10;

1SELECT id, content, __DISTANCE
2FROM hnswpq_documents
3ORDER BY ann_distance(embedding, '[0.10, 0.20, 0.30, 0.40]')
4LIMIT 10;

1SELECT id, content, __DISTANCE
2FROM hnswpq_documents
3WHERE ann_distance(embedding, '[0.10, 0.20, 0.30, 0.40]')
4      BETWEEN 0.0 AND 0.5
5ORDER BY __DISTANCE
6LIMIT 100;