How to index two keys of array element

[vsr1]

Creating a covered index with array, how to access array elements in select?

Hi, I’m trying to create a covered index using some data from an object, but with unknown key names. I’m not able to figure out how to get the query planner match and get the data back. This is example data (insert multiple times with different key names if you want): INSERT INTO `test-bucket` ( KEY, VALUE ) VALUES ( "k001", { "id": "1da0c06c-b9af-404c-ab51-86f1b00f7c0e", "stuff": { "25443790-6ab9-4374-90f2-aa927b066ae8": { "thing": "one", "nested": { "foo": "ba…

Composite index from an array of objects

Hello, I have a bucket with documents like this: { "fd": [{ "ac": "AF", "d": 30, "fn": 1096, "ym": 1911 }, { "ac": "AF", "d": 9, "fn": 1053, "ym": 2009 }, { "ac": "BA", "d": 29, "fn": 1002, "ym": 2006 }, { "ac": "QR", "d": 6, "fn": 1764, "ym": 2011 } ], "ts": 1572258925.187879, "yld": [ "PEKAMS", "CDGORY" ] } I am trying to index, as a composite index the following fields: fd.ac, fd.ym, fd.d, i.e. I need to be able to perform qu…

Search forums SUCCESSOR you will get relevant posts