AWS S3 + Spice AI Tutorial

SELECT title, tags, type FROM questions WHERE body ILIKE '%Java%' LIMIT 5;

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,'Java issues',5) ORDER BY score DESC;

SELECT title, creation_date, score FROM vector_search (questions,'JVM 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;

-- 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

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