Uploaded image for project: 'Couchbase Server'
  1. Couchbase Server
  2. MB-58441

Extend N1QL expression syntax for vector search

    XMLWordPrintable

Details

    • Improvement
    • Resolution: Unresolved
    • Major
    • Morpheus
    • 7.6.0
    • fts, query
    • Security Level: Public
    • None

    Description

      Vector search requests can be used directly by embedding the search request into N1QL's SEARCH() function.

      The ask here is to go a little beyond that for on boarding users easily with the a CREATE VECTOR INDEX and a KNN() search function so then can skip coming up to speed on the search index definition syntaxes. 

      • Introduce CREATE INDEX capability to build vector indexes in the search space -

        CREATE [VECTOR] INDEX `idx` ON `key-space`({"field": expression, "dimension": constant, "similarity": string}, {"field": expression, "dimension": constant, "similarity": string}) USING FTS;  

      • Add a KNN function as an added convenience that would spare users the SEARCH() function syntax -

        SELECT * FROM `key-space` WHERE KNN(`key-space`, {object}, {object [optional]})  

      Attachments

        Issue Links

          For Gerrit Dashboard: MB-58441
          # Subject Branch Project Status CR V

          Activity

            People

              abhinav Abhi Dangeti
              abhinav Abhi Dangeti
              Votes:
              0 Vote for this issue
              Watchers:
              4 Start watching this issue

              Dates

                Created:
                Updated:

                Gerrit Reviews

                  There are no open Gerrit changes

                  PagerDuty