Dear all, I have two similar queries for which I get different (unexpected) result. I try to be clear as possible. The 2 queries have the same field “hit by” the where condition, that is an array called searckKeyA. query 1 - results OK, but slow select * from products where "photofast" in searchK…

@stefano.redaelli , In that case you can remove searchKeyA from the index as separate key. Checkout Implicit Covered Array Index https://developer.couchbase.com/documentation/server/current/n1ql/n1ql-language-reference/indexing-arrays.html

This may help you. I queried for searchKeyA of the 3 documents I need to fetch. When using “idx”, only the 3rd document is retrieved. [ { "searchKeyA": [ "nilox", "chiavette", "usb", "chiavetta", "photofast", "memoria", "esterna", "per", "smartphone", "128gb", "…

Check see if index caught up and no pending items. Check the indexer.log any skipped items due too size of index keys.

Dear @vsr1 , Thank you for your suggestion. If I try to access the indexer.log file I get a permission denied error, even using linux bash. Stefano

Check with user who had permission to that files. @deepkaran.salooja

Hi @deepkaran.salooja , I don’t have any permission to read file starting from path /opt/couchbase/var/ , even if folder has read+write+execute permission on it. [log folder] No problems at all on other folders inside /opt/couchbase/ : I can easily read, download, copy files, etc… Let me know i…

Look for any skipped documents in the indexer. It will log documents meta().id and with info

Hi @vsr1 , Unfortunately I have 2 replicas and in the first checks on log files I didn’t see anything because my index was on node :31 and indexer.log logs only node:35. Sorry about that, I made you lose your time. Now, I moved the index also on node:35 and I can finally see 7762 Error rows: [Err…

@deepkaran.salooja will help here how to increase keysize. One option will be make remove serachKeyA from index. This may make query uncovered. create index idx on products(distinct array v FOR v IN searchKeyA END) using gsi;

@stefano.redaelli , what version of Couchbase are you using?

Query on indexed array gives unexpected result

SQL++

vsr1 August 31, 2017, 1:44pm 9

Post the sample document, Index,Query

Topic		Replies	Views
Array indexing / Search Performance Question SQL++	2	604	March 11, 2021
Selecting from array using array index returns empty results. But correct results with USE KEYS SQL++ query , n1ql , index	6	1259	April 20, 2018
How to properly index array field? Couchbase Server n1ql , index	3	2317	June 21, 2017
Create GSI for indexing the string in array SQL++ query , n1ql	4	3285	June 3, 2016
Different result set when using the 'Use Index' hint SQL++	11	2825	March 31, 2017

Query on indexed array gives unexpected result

Related topics