We are trying coachbase for future use and we do some tests.
We use coachbase Version: 4.0.0-4051 Community Edition (build-4051) and we have some difficulties in using the syntax for creating indexes array :
cbq> CREATE INDEX A ON ATABLE ( DISTINCT ARRAY v FOR v IN xmldata END ) USING GSI;
{
“requestID”: “689654af-9425-4991-aa77-d1d51d14e36b”,
“errors”: [
{
“code”: 3000,
“msg”: “syntax error - at DISTINCT”
}
],
“status”: “fatal”,
“metrics”: {
“elapsedTime”: “478.469µs”,
“executionTime”: “437.855µs”,
“resultCount”: 0,
“resultSize”: 0,
“errorCount”: 1
}
}
This is working without DISTINCT but at querying it there is no use of the index.
Do I miss something ?
You can use 4.5 EE for your evaluation, and then use CE or EE for production, depending on your situation. The CE release lags the EE release by a time gap.
Thank you all, we installed 4.5 EE successfully and effectively that works.
1 Like