SQL++ Error

concept

A SQL++ error happens when there is an error processing the SQL++ 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
  }
}