Couchbase 6.5 release is one of the largest release content wise for Couchbase. For N1QL Query service, the focus for us is to bring Enterprise Database functionalities to the Couchbase Database. Expanding N1QL with additional functions to support Enterprise Application requirements with the goal to improve developers productivity.

So here is the summary of the N1QL features.

N1QL Search()

N1QL has added a full text search capability with the N1QL Search() function. It leverages Couchbase Full Text Search to deliver a variety of of text search capability, such as keyword and fuzzy search. Full Text Search is part of the Couchbase Data Platform that runs as a separate service with its Multi Dimensional Scaling capability. There is no need for a separate search engine, nor importing the data into a separate service. N1QL users can now leverage both Full Text Search and standard N1QL predicates in a single statement.

N1QL Window & Analytical Function

Window functions extends the basic query aggregation to allow complex business questions with an intuitive N1QL construct, which would otherwise require user to write complex queries and joins.

N1QL Common Table Expression

Common Table Expression introduces the WITH construct to N1QL to allow user to assign a name to query block, which can then be later referenced in the rest of the query.

N1QL User Defined Function

Allows developers to define custom N1QL function which is callable from N1QL queries. Allowing the isolation of N1QL application logic that can be reused by any application and micro services.

Subquery JOIN

Couchbase database enhances its support for ANSI Join to include joining with sub-queries, allowing the use of dynamic query result sets in the join.

The following features are also going to be available in version 6.5 as Developer Preview.

Index Advisor (DP)

User can now use the Index Advisor the create the most optimum indexes for their queries. The recommended indexes also include a section for covering indexes. Queries that leverages covering indexes can benefit from the need to perform additional data service fetching, and thus improve the overall query performance. Index Advisor works for specific query, or completed requests workload.

Other N1QL Enhancements in Couchbase v6.5


We are very excited about the new N1QL content for Couchbase v6.5, as these features will address many requests that our customers have asked for. As usual we’re all ears when it comes to feedback on our new features, and especially the Index Advisor(DP) .



We would love to hear from you on how you liked the 6.5 features and how it’ll benefit your business going forward. Please share your feedback via the comments or in the forum.


Posted by Binh Le

Binh Le is a Principal Product Manager for Couchbase Query service. Prior to Couchbase, he worked at Oracle and led the product management team for Sales Clould Analytics and CRM OnDemand. Binh holds a Bachelor's Degree in Computer Science from the University of Brighton, UK.

Leave a reply