Couchbase Questions: N1QL

Have a Question? Get it answered by our community

ohassidi's picture
Asked 1 week 5 days ago
Latest activity 1 week 3 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 weeks 11 min ago
    Latest activity 1 week 6 days 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 weeks 20 hours ago
    Latest activity 1 week 4 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
    • ...
    fredericb's picture
    Asked 2 weeks 2 days ago
    Latest activity 2 weeks 1 day ago

    How to write Where condition on arrays using INDEX

    While trying the N1QL language, I found a difficulty to request the following:

    Let say the document contains, among other attributes, an array of values as in
    varArray : [ val1, val2, val3 ]

    How can I...

    fredericb's picture
    Asked 2 weeks 2 days ago
    Latest activity 2 weeks 1 day ago

    How to partially update a document

    Many times, it is very convenient to only update one attribute instead of loading everything into memory and then pushing everything onto the wire, specially when a few changed (let say only 1% had changed).

    I did not find any element, except an issue opened from 2012/06 (...

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

    Can N1QL query to stored index or create indexes?


    We are working on an web analytics application and we were doing some medium level load test. At the time we are having 3-4 records, N1QL returns the answers very quickly.

    However, as soon as we increased the number of documents from 4000 to 4,00,000, it is taking 25-30...

    rubynadler's picture
    Asked 1 month 1 week ago
    Latest activity 1 month 1 week ago


    i tried running the example Couchbase.NetDP1 in C#.
    I changed the code so i connect to my server and bucket:

    private void button1_Click(object sender, EventArgs e)
    Cluster cluster = InitializeCluster2();
    var bucket = GetBucket(...

    fredericb's picture
    Asked 2 months 4 days ago
    Latest activity 2 months 2 days ago

    Is there any Java API to use N1QL?


    I'm interesting in N1QL with Couchbase. I understand that one can use:
    - web interface (as in http://localhost:8093/tutorial)
    - through CLI ( as in ./cbq -engine=http://HOST:8093/)


    yaco's picture
    Asked 2 months 4 days ago
    Latest activity 2 months 4 days ago

    Error while trying to query my own repository in the Query Tutorial #3


    I'm trying to execute any query at the query tutorial #3 whit my own bucket and i'm not able to.

    1) When i choose a wrong bucket name, i got the "non existing bucket repsonse", so there is no conectivity issues.
    2) When the bucket it's empty, i got no errors, just a...

    robertgtaylor1's picture
    Asked 2 months 1 week ago
    Latest activity 1 month 3 weeks ago

    When do you expect N1QL to be ready for release?

    I realize you will not want to commit to a date but when do you plan to make N1QL available; month, quarter, year?