Creating A Vector Table in 23ai….

In this post, we shall see very quickly how to create a table with vector embeddings and select the same.

Remember, vectors are an array of numbers and they can be null. However, individual vector array elements can’t be null.

Above, we have entered some trivial vector values. Do note that you have to separate each number with a comma. And also, you need to enclose the array with single quotes.

Let’s check the inserted values.

Notice that the formatting is in a particular format.

Let’s try some data selection.

So we (deliberately) missed the single quotes. Let’s try using them now.

So what we learned? It’s not possible to perform comparison operations between vectors.

Hope this helps.