Limitations

Limitations

The following list covers some of the limitations with Couchbase Analytics. Please read this carefully before reporting any new issues.

Issue Description
MB-21201 Unpredictable behavior may result if you change Couchbase Server topology or modify connected buckets, for example, by deleting or flushing a bucket in Couchbase Server. These operations are not supported.

If you must change your Couchbase Server cluster or buckets, first DROP your Analytics Datasets and then recreate them after your changes have been completed.

MB-21155 The SELECT DISTINCT operation is not supported.
MB-21163 The MINUS, INTERSECT, UNION without ALL operations are not supported.
MB-21182 The OFFSET without a LIMIT statement is not supported.
MB-21184 If you use add a GROUP BY expression in the SQL format, the expression for the GROUP BY key in the SELECT clause must be identical to the GROUP BY key expression.
MB-21270 The PREPARE statement is not supported.
MB-21294 Data Manipulation Language (DML) operations such as INSERT, DELETE, UPSERT, UPDATE do not apply to shadow datasets (which mirror data in Couchbase Server) and are therefore not supported.