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

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

    XMLWordPrintable

    Details

    • Type: Improvement
    • Status: Open
    • Priority: Major
    • Resolution: Unresolved
    • Affects Version/s: Neo
    • Fix Version/s: Morpheus
    • Component/s: fts, query
    • Labels:
      None
    • Story Points:
      1

      Description

      • N1fty to interpret `CREATE INDEX` commands to generate an 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 command ..

      CREATE INDEX idx on `keyspace` USING FTS WITH ... 

        Attachments

          Issue Links

          No reviews matched the request. Check your Options in the drop-down menu of this sections header.

            Activity

            Hide
            Sitaram.Vemulapalli Sitaram Vemulapalli added a comment -

            Another option to consider : CREATE INDEX idx ON `keyspace` (key1, key2, key3) USING FTS WITH ...
            If keys present WITH should not present index definition JSON
            if keys not present WITH should consider index definition JSON
            Validity (supported expressions) of keys will be done by FTS

            Show
            Sitaram.Vemulapalli Sitaram Vemulapalli added a comment - Another option to consider : CREATE INDEX idx ON `keyspace` (key1, key2, key3) USING FTS WITH ... If keys present WITH should not present index definition JSON if keys not present WITH should consider index definition JSON Validity (supported expressions) of keys will be done by FTS

              People

              Assignee:
              abhinav Abhinav Dangeti
              Reporter:
              abhinav Abhinav Dangeti
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

                Dates

                Created:
                Updated:

                  Gerrit Reviews

                  There are no open Gerrit changes

                    PagerDuty