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.