Hybrid (keyword + semantic) search
infino_hybrid_searchRanks results by combining exact-term matching (BM25) with semantic similarity in a single pass. Embeds queries locally with no API key needed, capturing both literal and conceptual relevance.
Instructions
Use when a query carries both specific terms and an intent — you want exact-term precision without giving up paraphrase recall. Fuses BM25 over a text column with vector similarity over the embedding column in a single ranking pass, so rows matching the literal terms AND the meaning rank highest. Embeds the query with a local model (no API key). Sits between infino_keyword_search (literal only) and infino_semantic_search (meaning only).
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| k | No | Maximum results. | |
| query | Yes | Query text; matched as keyword terms AND embedded for vector similarity. | |
| table | Yes | Table to search. | |
| column | No | Text column for the keyword half; inferred if omitted. | |
| columns | No | Columns to return with each hit (e.g. an id, path, or line range to cite). Defaults to the text column; '_id' and 'score' are always included. | |
| vectorColumn | No | Vector column for the semantic half; inferred if omitted. |