We're Moving!

The Vertica Forum is moving to a new OpenText Analytics Database (Vertica) Community.

Join us there to post discussion topics, learn about

product releases, share tips, access the blog, and much more.

Create My New Community Account Now


Can I use Vertica as a Vector Database, including semantic search? — Vertica Forum

Can I use Vertica as a Vector Database, including semantic search?

joergschaberjoergschaber Vertica Customer

Hi,
I am looking for a way to store my embeddings calculated by a LLM and do similarity/semantic searches on those embeddings. So, basically, I am looking for a vector database.
In principle I could use the array datatype to store vectors in Vertica, but is there also functionality in Vertica to calculate distance metrics on arrays, like inner product, cosine distance, and L1 distance? I could not find any. Is anybody using Vertica as a vector database?

Leave a Comment

BoldItalicStrikethroughOrdered listUnordered list
Emoji
Image
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file