N1QL Error

  • concept
    +

    A N1QL error happens when there is an error processing the N1QL statement in a request.

    Request
    curl -v http://localhost:8093/query/service \
         -d 'statement=SLECT name FROM `travel-sample`.inventory.hotel LIMIT 1' \
         -u Administrator:password
    Response
    {
      "requestID": "27087759-07af-431d-a3d7-29080f870e56",
      "errors": [
        {
          "code": 3000,
          "msg": "syntax error - line 1, column 7, near 'SLECT', at: name"
        }
      ],
      "status": "fatal",
      "metrics": {
        "elapsedTime": "1.478631ms",
        "executionTime": "1.393274ms",
        "resultCount": 0,
        "resultSize": 0,
        "serviceLoad": 12,
        "errorCount": 1
      }
    }
    Request
    curl -v http://localhost:8093/query/service \
         -d 'statement=SELECT name FROM `travel-sample`.inventory.motel LIMIT 1' \
         -u Administrator:password
    Response
    {
      "requestID": "d30b805f-6c1e-44ec-9aec-35ff711a6e88",
      "errors": [
        {
          "code": 12003,
          "msg": "Keyspace not found in CB datastore: default:travel-sample.inventory.motel"
        }
      ],
      "status": "fatal",
      "metrics": {
        "elapsedTime": "3.096786ms",
        "executionTime": "2.468282ms",
        "resultCount": 0,
        "resultSize": 0,
        "serviceLoad": 12,
        "errorCount": 1
      }
    }