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
}
}