Couchbase Questions: N1QL

Have a Question? Get it answered by our community

Kristas's picture
Asked 9 hours 13 min ago
Latest activity 1 hour 26 min ago

N1QL + where in collection

Hi there.

I'm very new in N1QL, please assist.

Let's suppose I have documents like this:

key1=321

{
  "propertyName1": {
    "value": "value1",
    "last_update": "2014-07-29T14:
...
markanichols's picture
Asked 5 days 1 hour ago
Latest activity 4 days 22 hours ago

N1QL: Index on all elements in an array?

Hi, is there a way to create an index on all a property for all elements in an array in documents?

For example, I can create an index on property 'tpnc' for the first element in my 'variants' array like this:

create index tpnc_index on PriceServiceCopy(variants[0].tpnc)

or...

bdmcleod's picture
Asked 1 week 22 hours ago
Latest activity 6 days 2 hours ago

querying key with wildcard seems slow

I'd like to do somthing like:
select META().id from mybucket where META().id like "blah%";

This seems to be slow. I created a primary index, which helped, but
it's still pretty slow. They couchbase logs make it seem like the n1ql
client is querying through every doc...

SasaBHoda's picture
Asked 3 weeks 6 days ago
Latest activity 1 day 20 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
couchbase-query_dev_preview3_x86_64_win
and then I run the start_tutorial.bat and start learning

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

joaojeronimo's picture
Asked 1 month 6 days ago
Latest activity 1 month 5 days 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 1 month 1 week ago
Latest activity 1 month 1 week 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 2 weeks ago
Latest activity 1 month 2 weeks 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 2 weeks ago
Latest activity 1 month 2 weeks 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 3 weeks ago
Latest activity 1 month 3 weeks 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 2 months 2 days ago
Latest activity 2 months 1 day ago

where fieldName in [value1, value2]

Hey

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,...

Pages