Hybrid Semantic + Exact Keyword RAG with Page Citations
Operational failure without it
Pure embeddings overlook UN ADR codes, form labels like EX-1 / EUR.1, and pallet numbers; pure keyword search fails when new staff phrase operational questions casually.
How SCA implements it
SCA combines cosine vector search (pgvector HNSW) with PostgreSQL full-text search via configurable Reciprocal Rank Fusion (RRF), citing exact document titles, sections, and page numbers—and separating retrieval_use from view_content.



