GV

GeezerVison

The World Wide Web, restored to 800 pixels of glory.

Home|About|Gaming cabinet|Archives|How it works|Starter sites

On this site

  • Sign in
  • ActionsCI/CD and automation
  • CodespacesCloud development environments
  • All Features
  • Documentation
  • Training
  • Certifications
  • Build with Copilot
  • Customize Copilot
  • Integrations
  • Trending repos
  • GitHub Sponsors
  • Developer articles
  • Enterprises

This view

  • Original page
  • New address

GeezerVison is showing github.com — Add SQLite Hybrid Search and BM25 for local vector search · Issue #5073 · feast-dev/feast

Add SQLite Hybrid Search and BM25 for local vector search #5073

New issue
Copy link
New issue
Copy link
Closed
Closed
Add SQLite Hybrid Search and BM25 for local vector search#5073
Copy link
Labels
kind/featureNew feature or requestNew feature or requestwontfixThis will not be worked onThis will not be worked on

Description

@franciscojavierarceo
franciscojavierarceo
opened on Feb 19, 2025
Issue body actions

Is your feature request related to a problem? Please describe.
See this example: https://github.com/liamca/sqlite-hybrid-search/tree/main and the sqlite docs: https://www.sqlite.org/fts5.html

This should be complemented with the SQLite-vec implementation.

Describe the solution you'd like

document_embeddings = FeatureView(
    name="embedded_documents",
    entities=[item, author],
    schema=[
        Field(
            name="vector",
            dtype=Array(Float32),
            # Look how easy it is to enable RAG!
            vector_index=True,
            vector_search_metric="COSINE",
        ),
        Field(name="item_id", dtype=Int64),
        Field(name="author_id", dtype=String),
        Field(name="created_timestamp", dtype=UnixTimestamp),
        Field(name="sentence_chunks", dtype=String),
        Field(name="event_timestamp", dtype=UnixTimestamp),
    ],
    source=rag_documents_source,
    ttl=timedelta(hours=24),
)

Somewhere in the FeatureView we should allow the search to be declared explicitly.

Also, need to drop the query_embedding as a required input in:

results = store.retrieve_online_documents_v2(
    features=[
        "document_embeddings:Embeddings",
        "document_embeddings:content",
        "document_embeddings:title",
    ],
    query=query_embedding,
    query_string="(content: 5) OR (title: 1) OR (title: 3)",
    top_k=3,
).to_dict()
print(results)

Describe alternatives you've considered
TBD

Additional context
Add any other context or screenshots about the feature request here.

Activity

  1. franciscojavierarceo
    added
    kind/featureNew feature or requestNew feature or request
    on Feb 19, 2025
  2. franciscojavierarceo
    changed the title [-]Add SQLite Hybrid Search for local vector search[/-] [+]Add SQLite Hybrid Search and BM25 for local vector search[/+] on Feb 19, 2025
  3. franciscojavierarceo
    added a parent issue on Mar 4, 2025
    • Introduce Feast NLP/LLM Add-On #4964
  4. stale commented on Jun 27, 2025

    @stale
    staleBot
    on Jun 27, 2025 – with Stale
    More actions

    This issue has been automatically marked as stale because it has not had recent activity. It will be closed if no further activity occurs. Thank you for your contributions.

  5. stale
    added
    wontfixThis will not be worked onThis will not be worked on
    on Jun 27, 2025
  6. stale
    closed this as completedon Jul 19, 2025
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

Metadata

Metadata

Assignees

No one assigned

    Labels

    kind/featureNew feature or requestNew feature or requestwontfixThis will not be worked onThis will not be worked on

    Type

    No type

    Projects

    No projects

      Milestone

      No milestone

      Relationships

      None yet

      Development

      No branches or pull requests

      Issue actions

      You are visitor 01402520 — GeezerVison does not store the pages you look up.
      Best viewed with Netscape Navigator 4.7 or Internet Explorer 6 at 800×600. No cookies required.