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

Usability first time users: "No index found" message.  N1QL requires an index to be created to run queries

    XMLWordPrintable

Details

    • Improvement
    • Resolution: Fixed
    • Major
    • 7.1.0
    • None
    • UI
    • None

    Description

      Frequently hit issue with first time users trying out Couchbase

      After importing/loading a dataset, running a N1QL query for the first time will result in "No index found" message.  N1QL requires an index to be created to run queries.

      [

      { "code": 4000, "msg": "No index available on keyspace `default`:`test`.`_default`.`_default` that matches your query. Use CREATE PRIMARY INDEX ON `default`:`test`.`_default`.`_default` to create a primary index, or check that your expected index is online.", "query": "select * from test._default._default;" }

      ]

       

      11/02 Met with Eben and Kamini, the plan would be to 

      Show up the "Create primary index" button similar to what we see in the "Advice" tab for creating secondary indexes. 

       

      Attachments

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

        Activity

          People

            eben Eben Haber
            rekha.nair Rekha Nair
            Votes:
            0 Vote for this issue
            Watchers:
            4 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Gerrit Reviews

                There are no open Gerrit changes

                PagerDuty