Couchbase Questions: N1QL

Have a Question? Get it answered by our community

SasaBHoda's picture
Asked 2 weeks 20 hours ago
Latest activity 1 week 11 hours ago

where can I write my questio for couchbase

I used to practice on Couchbase queries on N1Q1 which is already provided with sample data

I mean that usually, I open this folder
and then I run the start_tutorial.bat and start learning

now I have got a Couchbase server and I...

joaojeronimo's picture
Asked 3 weeks 3 days ago
Latest activity 3 weeks 1 day ago

Is there any way to manipulate the stale flag ?

I was running some tests, inserting a bunch of data and retrieving it right after with a N1QL query, and after I created an index for a field, querying by that field right after inserting the document was not working. I dug a bit and found some information about the stale flag, and thought that...

ANdrei Nechifor's picture
Asked 3 weeks 6 days ago
Latest activity 3 weeks 6 days ago

couchbase-net-client-2.0-dp3 -> SELECT don't work at all

I took the last couchbase-net-client-2.0-dp3
Inserting and updating of the documents works fine
The interesting part is that I can't select anything using N1QL

I also tried version 1 and version 2 and I have the same problem.
In version 1 -> results.Rows is NULL...

TomS's picture
Asked 1 month 4 days ago
Latest activity 1 month 3 days ago

N1QL and non-default buckets

Have downloaded and implemented N1QL per instructions. I can query the beer-sample and default buckets successfully with cbq. However, when I try to query a new bucket I have created and loaded, I get the "Bucket xxxx does not exist" error.

What have I done wrong?

cbq> select...

joaojeronimo's picture
Asked 1 month 5 days ago
Latest activity 1 month 4 days ago

How to query with curl ?

I'm running the latest versions of CouchBase and N1QL (as of now Community 2.2.0-837-rel and Developer Preview 3 respectively) and I'm able to do queries using the cbq command, but I'd like to do them with curl.

I tried curl...

mark.ward's picture
Asked 1 month 1 week ago
Latest activity 1 month 1 week ago

N1QL and Python SDK

Is there a plan and timeframe for integrating N1QL within the Python SDK? I'm new to Couchbase and evaluating it as the backend for Celery task results. While it's be extremely easy to setup and use for this purpose, I'm encountering some friction and drag now that we're needing to extract and...

ohassidi's picture
Asked 1 month 2 weeks ago
Latest activity 1 month 2 weeks ago

where fieldName in [value1, value2]


I saw that "where fieldName in [value1, value2]" is the same as "where fieldName=value1 or fieldName=value2 which is great the thing is that when using the in array I can't add an "and" after which where in "or" I can do an "and" after. For example:

where name in [value1,...

ohassidi's picture
Asked 2 months 6 days ago
Latest activity 2 months 4 days ago

Create multiple indexes

Today I have multiple views in order to use they ability to filter and sort, for example if I have employee object the I have several views for it:

  • emit(employeeId);
  • emit(employeeAddress)
  • emit(employeeName)
  • This view are used mainly for filtering and sorting...

    misterajc's picture
    Asked 2 months 1 week ago
    Latest activity 2 months 1 week ago

    Using an index for lookups of multiple records

    When I set up an index on source.sig, the query
    select * from default where source.sig = "ytHl-__aF1oA";
    uses the index and runs in milliseconds. However

    ohassidi's picture
    Asked 2 months 1 week ago
    Latest activity 2 months 5 days ago

    Customizing an index, Create index on dev design doc, and Customized sorting

    Few questions in one post I hope I will be clear :)

    • Customizing an index: after creating an index is it healthy to customize it by editing the created view? For example I have created an index using CREATE INDEX then went to the view created in the couchbase and edited it a bit and
    • ...