-
I'm currently implementing a vector search using DuckDB and integrating it to work in the browser. However, I've recently discovered that the My questions are:
Any information or guidance on this matter would be greatly appreciated. (Partial answers are also really welcomed) |
Beta Was this translation helpful? Give feedback.
Replies: 2 comments
-
It should be a matter of:
What error message are you getting? Check: https://shell.duckdb.org/#queries=v0,LOAD-vss~,CREATE-TABLE-my_vector_table-(vec-FLOAT%5B3%5D)~%0AINSERT-INTO-my_vector_table-SELECT-array_value(a%2C-b%2C-c)-FROM-range(1%2C-10)-ra(a)%2C-range(1%2C-10)-rb(b)%2C-range(1%2C-10)-rc(c)~%0ACREATE-INDEX-my_hnsw_index-ON-my_vector_table-USING-HNSW-(vec)~%0A%0A,SELECT-*-FROM-my_vector_table-ORDER-BY-array_distance(vec%2C-%5B1%2C-2%2C-3%5D%3A%3AFLOAT%5B3%5D)-LIMIT-3~%0A%0A,EXPLAIN-SELECT-*-FROM-my_vector_table-ORDER-BY-array_distance(vec%2C-%5B1%2C-2%2C-3%5D%3A%3AFLOAT%5B3%5D)-LIMIT-3~%0A%0A |
Beta Was this translation helpful? Give feedback.
-
Thank you for your helpful response! I've resolved the issue by updating DuckDB to the latest version, and now the vector search functionality is working perfectly. |
Beta Was this translation helpful? Give feedback.
vss
does work in DuckDB-Wasm!It should be a matter of:
What error message are you getting?
Check: https://shell.duckdb.org/#queries=v0,LOAD-vss~,CREATE-TABLE-my_vector_table-(vec-FLOAT%5B3%5D)~%0AINSERT-INTO-my_vector_table-SELECT-array_value(a%2C-b%2C-c)-FROM-range(1%2C-10)-ra(a)%2C-range(1%2C-10)-rb(b)%2C-range(1%2C-10)-rc(c)~%0ACREATE-INDEX-my_hnsw_index-ON-my_vector_table-USING-HNSW-(vec)~%0A%0A,SELECT-*-FROM-my_vector_table-ORDER-BY-array_distance(vec%2C-%5B1%2C-2%2C-3%5D%3A%3AFLOAT%5B3%5D)-LIMIT-3~%0A%0A,EXPLAIN-SELECT-*-FROM-my_vector_table-ORDER-BY-array_distance(vec%2C-%5B1%2C-2%2C-3%5D%3A%3AFLOAT%5B3%5D)-LIMIT-3~%0A%0A
Where I execute a bunch of random statements fro…