Skip to content

error when adding pk in the vector index prefix #18196

@dennnniska

Description

@dennnniska

При создание векторного индекса в котором префикс является pk выводится ошибка

CREATE TABLE prefix_index(pk Int64, prefix String, vec String, PRIMARY KEY(pk, prefix));

UPSERT INTO prefix_index(pk, prefix, vec) VALUES(1, "1", Untag(Knn::ToBinaryStringUint8([1, 1, 2]), "Uint8Vector"));
UPSERT INTO prefix_index(pk, prefix, vec) VALUES(2, "1", Untag(Knn::ToBinaryStringUint8([1, 1, 3]), "Uint8Vector"));
UPSERT INTO prefix_index(pk, prefix, vec) VALUES(3, "1", Untag(Knn::ToBinaryStringUint8([1, 1, 4]), "Uint8Vector"));
UPSERT INTO prefix_index(pk, prefix, vec) VALUES(4, "1", Untag(Knn::ToBinaryStringUint8([1, 1, 5]), "Uint8Vector"));

ALTER TABLE prefix_index
        ADD INDEX idx
        GLOBAL  USING vector_kmeans_tree
        ON (prefix, vec)
        WITH (distance=manhattan, vector_type="uint8", vector_dimension=3, levels=1, clusters=100);


 $Target = Knn::ToBinaryStringUint8(Cast([2,2,2] AS List<Uint8>));
SELECT Knn::ManhattanDistance(vec, $Target) from prefix_index VIEW idx
WHERE prefix = "1"
ORDER BY Knn::ManhattanDistance(vec, $Target)
LIMIT 10;

Column not found: prefix

Metadata

Metadata

Assignees

Labels

No labels
No labels

Type

No type

Projects

No projects

Milestone

No milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions