AWS S3 + Spice AI Tutorial
An implementation of Architecting high-performance AI-driven data applications with Spice AI and AWS running on Spice Cloud, instead of an EC2 instance.
SQL Queries
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
