Please use the form below to provide your feedback. Because your feedback is valuable to us, the information you submit in this form is recorded in our issue tracking system (JIRA), which is publicly available. You can track the status of your feedback using the ticket number displayed in the dialog once you submit the form.

A newer version of this documentation is available.

View Latest

SQL++ Error

  • concept
March 23, 2025
+ 12

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

Request
sh
Copy
curl -v http://localhost:8093/query/service \
     -d 'statement=SLECT name FROM `travel-sample`.inventory.hotel LIMIT 1' \
     -u Administrator:password
Response
json
Copy
{
  "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
sh
Copy
curl -v http://localhost:8093/query/service \
     -d 'statement=SELECT name FROM `travel-sample`.inventory.motel LIMIT 1' \
     -u Administrator:password
Response
json
Copy
{
  "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
  }
}