Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

CREATE VECTOR INDEX statement not supported #215

Open
pdarulewski opened this issue Feb 25, 2025 · 0 comments
Open

CREATE VECTOR INDEX statement not supported #215

pdarulewski opened this issue Feb 25, 2025 · 0 comments

Comments

@pdarulewski
Copy link

pdarulewski commented Feb 25, 2025

It looks like it's not possible to create a vector index using the emulator.

To reproduce

> gcloud --project local spanner databases ddl update local-database --instance local-instance --ddl="CREATE VECTOR INDEX embeddings_idx ON a_table(embeddings) OPTIONS (distance_type = 'COSINE', tree_depth = 2, num_leaves = 100, num_branches = 10);"

Expected behaviour

The vector index is created

Actual behaviour

The following error is returned:

ERROR: (gcloud.spanner.databases.ddl.update) HTTPError 400: {"code":3,"message":"Error parsing Spanner DDL statement: CREATE VECTOR INDEX text_embeddings ON non_existent_table(text_embeddings) OPTIONS (distance_type = 'COSINE', tree_depth = 2, num_leaves = 100, num_branches = 10) : Syntax error on line 1, column 8: Encountered 'VECTOR' while parsing: create_statement"}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant