Details
-
Bug
-
Resolution: Unresolved
-
Major
-
7.6.0
-
Couchbase server Enterprise Edition 7.6.0 build 1944
-
Untriaged
-
0
-
Unknown
Description
1. Created a 3 node cluster (1 - kv, 1 - kv+fts+query, 1-kv,fts)
2. Created a bucket and loaded siftsmall dataset to the bucket which has about 10k items.
3. Created an index 'i1' on the 'vector_data' field with 'l2_norm' similarity.
4. Ran 5 queries using both N1QL and FTS query on the index 'i1'. Both gave same number of hits.
5. Updated the index to now use 'dot_product' and ran the same 5 query as before using N1QL as well as FTS query. Both gave same number of hits as before.
6. Created a second index 'i2' on the same vector data with 'dot_product' similarity.
7. Ran 5 queries using both N1QL and FTS query on the index 'i2'. Both gave same number of hits.
8. Updated the index 'i2' to now use 'l2_norm' similarity.
9. Ran the following N1QL query which gave 3 hits
SELECT COUNT(*) FROM `b1`.s1.c1 AS t1 WHERE SEARCH(t1, {'query': {'match_none': {}}, 'explain': True, 'knn': [{'field': 'vector_data', 'k': 3, 'vector': [1.0, 3.0, 11.0, 110.0, 62.0, 22.0, 4.0, 0.0, 43.0, 21.0, 22.0, 18.0, 6.0, 28.0, 64.0, 9.0, 11.0, 1.0, 0.0, 0.0, 1.0, 40.0, 101.0, 21.0, 20.0, 2.0, 4.0, 2.0, 2.0, 9.0, 18.0, 35.0, 1.0, 1.0, 7.0, 25.0, 108.0, 116.0, 63.0, 2.0, 0.0, 0.0, 11.0, 74.0, 40.0, 101.0, 116.0, 3.0, 33.0, 1.0, 1.0, 11.0, 14.0, 18.0, 116.0, 116.0, 68.0, 12.0, 5.0, 4.0, 2.0, 2.0, 9.0, 102.0, 17.0, 3.0, 10.0, 18.0, 8.0, 15.0, 67.0, 63.0, 15.0, 0.0, 14.0, 116.0, 80.0, 0.0, 2.0, 22.0, 96.0, 37.0, 28.0, 88.0, 43.0, 1.0, 4.0, 18.0, 116.0, 51.0, 5.0, 11.0, 32.0, 14.0, 8.0, 23.0, 44.0, 17.0, 12.0, 9.0, 0.0, 0.0, 19.0, 37.0, 85.0, 18.0, 16.0, 104.0, 22.0, 6.0, 2.0, 26.0, 12.0, 58.0, 67.0, 82.0, 25.0, 12.0, 2.0, 2.0, 25.0, 18.0, 8.0, 2.0, 19.0, 42.0, 48.0, 11.0]}]}); |
10. Ran an FTS query with the following params
{"indexName": "i2", "size": 10000000, "from": 0, "explain": true, "query": {"match_none": {}}, "fields": [], "ctl": {"consistency": {"level": "", "vectors": {}}, "timeout": 60000}, "knn": [{"field": "vector_data", "k": 3, "vector": [1.0, 3.0, 11.0, 110.0, 62.0, 22.0, 4.0, 0.0, 43.0, 21.0, 22.0, 18.0, 6.0, 28.0, 64.0, 9.0, 11.0, 1.0, 0.0, 0.0, 1.0, 40.0, 101.0, 21.0, 20.0, 2.0, 4.0, 2.0, 2.0, 9.0, 18.0, 35.0, 1.0, 1.0, 7.0, 25.0, 108.0, 116.0, 63.0, 2.0, 0.0, 0.0, 11.0, 74.0, 40.0, 101.0, 116.0, 3.0, 33.0, 1.0, 1.0, 11.0, 14.0, 18.0, 116.0, 116.0, 68.0, 12.0, 5.0, 4.0, 2.0, 2.0, 9.0, 102.0, 17.0, 3.0, 10.0, 18.0, 8.0, 15.0, 67.0, 63.0, 15.0, 0.0, 14.0, 116.0, 80.0, 0.0, 2.0, 22.0, 96.0, 37.0, 28.0, 88.0, 43.0, 1.0, 4.0, 18.0, 116.0, 51.0, 5.0, 11.0, 32.0, 14.0, 8.0, 23.0, 44.0, 17.0, 12.0, 9.0, 0.0, 0.0, 19.0, 37.0, 85.0, 18.0, 16.0, 104.0, 22.0, 6.0, 2.0, 26.0, 12.0, 58.0, 67.0, 82.0, 25.0, 12.0, 2.0, 2.0, 25.0, 18.0, 8.0, 2.0, 19.0, 42.0, 48.0, 11.0]}]} |
11. The above query returned the following error
{"error":"rest_index: Query, indexName: i2, err: pindex not available","request":{"ctl":{"consistency":{"level":"","vectors":{}},"timeout":60000},"explain":true,"fields":[],"from":0,"indexName":"i2","knn":[{"field":"vector_data","k":3,"vector":[1,3,11,110,62,22,4,0,43,21,22,18,6,28,64,9,11,1,0,0,1,40,101,21,20,2,4,2,2,9,18,35,1,1,7,25,108,116,63,2,0,0,11,74,40,101,116,3,33,1,1,11,14,18,116,116,68,12,5,4,2,2,9,102,17,3,10,18,8,15,67,63,15,0,14,116,80,0,2,22,96,37,28,88,43,1,4,18,116,51,5,11,32,14,8,23,44,17,12,9,0,0,19,37,85,18,16,104,22,6,2,26,12,58,67,82,25,12,2,2,25,18,8,2,19,42,48,11]}],"query":{"match_none":{}},"size":10000000},"status":"fail"} |