Contents

The Couchbase Analytics Service uses the SQL++ query language. SQL++ is an modern query language designed to work with semi-structured data and the JSON data model. SQL++ is backwards-compatible with SQL.

The Coucbase Analytics Service is currently in developer preview. As such, there are occasional breaking changes between releases. This post serves to document those changes.

6.0

Data Definition Language

  • Bucket association is now automatic

    Previous versions required explicit association between Analytics buckets and Couchbase Server buckets. For example, CREATE BUCKET ha WITH {"name":"health"}. Analytics buckets now automatically mirror Server buckets, e.g. in the previous example other Analytics DDL commands can refer to a bucket health without any extra configuration.

  • Dataset definitions no longer require the SHADOW keyword

    Preview releases before version 5.5 required the SHADOW keyword. It is optional in v5.5. It is an error to include it in v6.0. The syntax for creating datasets is therefore CREATE DATASET ((dataverse_name.)? dataset_name)? ON bucket_name (WHERE where_exp)?.

  • CONNECT/DISCONNECT BUCKET have been replaced by CONNECT/DISCONNECT LINK

    The connect and disconnect commands activate/deactivate dataset processing of data from Server buckets. The new full syntax is CONNECT LINK (dataverse_name.)? Local (, (dataverse_name.)? Local)*. This will connect all datasets in a dataverse.

Postscript

Couchbase is open source and free to try out.
Get started with sample code, example queries, tutorials, and more.
Find more resources on our developer portal.
Follow us on Twitter @CouchbaseDev.
You can post questions on our forums.
We actively participate on Stack Overflow.

Posted by Hod Greeley, Developer Advocate, Couchbase

Hod Greeley is a Developer Advocate for Couchbase, living in Silicon Valley. He has over two decades of experience as a software engineer and engineering manager. He has worked in a variety of software fields, including computational physics and chemistry, computer and network security, finance, and mobile. Prior to joining Couchbase in 2016, Hod led developer relations for mobile at Samsung. Hod holds a Ph.D. in chemical physics from Columbia University.

Leave a reply