Create index if not exists

SQL++
1

I have been tried to create index only if one does not exists by issue
CREATE INDEX NOT EXISTS typeId_index ON fmm-schema(typeId)

But I keep getting the following error:
[
{
“code”: 3000,
“msg”: “syntax error - at NOT”,
“query_from_user”: “CREATE INDEX NOT EXISTS typeId_index ON fmm-schema(typeId)”
}
]

But according to https://docs.couchbase.com/server/6.5/analytics/5_ddl.ht, it seems I should be able to do that. Please let me know if there is anything that I am missing.

2

You seem to be missing “IF”. See the docs on this.

3

Sorry. There was a typo in my original message. I actually tried CREATE INDEX IF NOT EXISTS typeId_index ON fmm-schema(typeId), but still got the error.

[
{
“code”: 3000,
“msg”: “syntax error - at IF”,
“query_from_user”: “CREATE INDEX IF NOT EXISTS typeId_index ON fmm-schema(typeId)”
}
]

4

The syntax is not supported in Query service . Track MB-38737

The link points to Analytical service.