Does DataGrip support SQL Server 2025 preview tables that have vector columns?
Completed
I am running this query for a table that has a vector data type column and the results pane is showing no results even though the output pane says it retrieved 10 rows? SSMS 21 shows the results.
Is this related to the fact that it's SQL Server 2025 preview?
---
DECLARE @querytext NVARCHAR (3000) ='i want blue products'
DECLARE @search_vector vector(768) = AI_GENERATE_EMBEDDINGS(@querytext USE MODEL MyOllamaModel);
--COSINE Measures angle between vectors 0 = similar, 1 = opposite
SELECT TOP(10) *, vector_distance('cosine', @search_vector, p.embedding) AS distance
FROM embeddings p
ORDER BY distance;
Please sign in to leave a comment.
This issue might be related to DBE-23860. Do the following steps help you retrieve the query results?
It's working now after upgrading to 2025.2.1.