Category: N1QL / Query
Testing N1QL workloads with Apache JMeter
One of the key features that Couchbase provides for querying JSON data is a N1QL language. N1QL allows users to access and modify the contents of their JSON documents with familiar SQL statements. Quite often, during development phase of a...
Introducing FTS with N1QL
Topics this article will cover What’s good with N1QL? What about FTS? But why FTS within N1QL? Basic N1QL+FTS queries Deploying N1QL+FTS Syntax(es) Abilities & limitations N1QL+FTS Internals Covered-index vs Non-covered-index queries More N1QL+FTS query examples What’s next? 1. Couchbase’s...
Deep Dive: Window functions in Couchbase Analytics
Couchbase Server 6.5 Beta brings a host of new features [1] to the leading NoSQL database. One of the key additions to the N1QL query language is support for window functions. These functions were originally introduced in the SQL:2003 standard and...
Running FTS Queries in N1QL
We already discussed how the Like % clause is potentially harmful for your application at scale, and why you should consider using Couchbase Full-Text Search instead. One thing we haven’t mentioned yet is why you might prefer Couchbase FTS over any...
Infosys Completes “OpenHack” Solution Development Program with Couchbase
Couchbase is expanding its partnerships with industry-leading global systems integrators and regional solution providers. Through these partnerships, Couchbase’s unique capabilities can be delivered to our global footprint of enterprise customers. We collaborate closely with our Strategic Alliance partner Infosys to...
Less is More: Why Cost Based Optimizer?
Less is more. — Ludwig Mies van der Rohe This is no truer statement on the goals of a query optimizer. Do less: Less memory, less CPU, less disk, less IO, less instructions, less partitions, less overflow. Less everything for...
Analytics Explain Plan – Part 1
Co-author: Till Westmann, Senior Director, Engineering Introduction Couchbase Analytics is the “newest kid on the block” amongst all the services available in Couchbase Server. The new service is providing rapid time to insight in many use cases like ship to...
It’s SQL. Again.
[crayon-5da7a3013a0bc107917887/] [crayon-5da7a3013a0c2471260753/] — In the spirit of Alexander Pope and Sir John Squire.
Index Advisor For Query Workload
Overview As the second feature of Index Advisor released in Couchbase server 6.5 (Developer Preview), Advisor function extends the scope from advising on single query to providing index recommendations for query workload and support on session handling. In this article,...
Window functions in Couchbase Analytics
Co-author: Till Westmann, Senior Director, Engineering The beta bits for Couchbase 6.5, the upcoming release of Couchbase Server, are now available. The Analytics service, which supports efficient parallel query processing, has added support for support for window functions defined in...