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

N1QL's `CREATE INDEX` command to setup FTS indexes

    XMLWordPrintable

Details

    • Improvement
    • Resolution: Unresolved
    • Major
    • Morpheus
    • 7.1.0
    • fts, query
    • None
    • 1

    Description

      N1fty to interpret `CREATE INDEX` commands to generate an FTS index definition.

      • The generated index definition will be pushed to a node hosting the search service as a curl command or using the SDK.

      Example commands ..

      • CREATE FLEX INDEX  
        • To set up an FTS index definition over chosen fields with the keyword analyzer only.CREATE SEARCH INDEX
      • CREATE SEARCH INDEX
        • To set up an FTS index definition over default dynamic mapping (as v0.1 and then support more after)

      Additionally ..

      • N1fty will also support UPDATE INDEX if an existing index can be easily modified to accommodate a query
        • This will push an UPDATE INDEX button for the user to click on N1QL workbench
      • Also support a DROP INDEX command.

      Attachments

        Issue Links

          relates to

          Improvement - An improvement or enhancement to an existing feature or task. MB-58441 Extend N1QL expression syntax for vector search

          • Major - Major loss of function.
          • Open
          No reviews matched the request. Check your Options in the drop-down menu of this sections header.

          Activity

            People

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

              Dates

                Created:
                Updated:

                Gerrit Reviews

                  There are no open Gerrit changes

                  PagerDuty