The following list covers some of the limitations with Couchbase Analytics. Please read this carefully before reporting any new issues.
|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.|