An implementation of Architecting high-performance AI-driven data applications with Spice AI and AWS running on Spice Cloud, instead of an EC2 instance.
SELECT title, tags, type FROM questions WHERE body ILIKE '%Java%' LIMIT 5;SELECT title, creation_date, score FROM vector_search (questions,'Java issues',5) ORDER BY score DESC;SELECT title, creation_date, score FROM vector_search (questions,'JVM issues',5) ORDER BY score DESC;-- Expected zero results.
SELECT title, tags, type FROM questions WHERE body ILIKE '%JVM Issues%' LIMIT 5;select question_id, fused_score, title, tags
from rrf(
text_search(questions, 'Java'),
vector_search(questions, 'Java issues')) order by fused_score desc
limit 5