هل يمكن استخدام ClickHouse للبحث المتجهي؟

CREATE TABLE images
(
	`_file` LowCardinality(String),
	`caption` String,
	`image_embedding` Array(Float32)
)
ENGINE = MergeTree;

SELECT
    _file,
	caption,
	cosineDistance(
        -- تضمين لصورة الكلب "المدخلة"
        [0.5736801028251648, 0.2516217529773712, ...,  -0.6825592517852783],
        image_embedding
    ) AS score
FROM images
ORDER BY score ASC
LIMIT 10