Hi I have document structure like below and want to pull documents whose keys are in snapShotId as in the given document. I am unable to unnest the value of snapShotsMappings with USE KEYS by writing the query something like below. Can anyone help me out in getting the query correct. SELECT p.* …

USE KEYS must be allowed only after bucket. Check syntax. SELECT p.* FROM promotions AS p USE KEYS ARRAY_FLATTEN((SELECT RAW snapShotsMappings[*].snapShotId FROM promotions USE KEYS "1234567890"),1) OR SELECT p.* FROM promotions AS p USE KEYS ARRAY_FLATTEN((SELECT RAW snaps.snapShotId FROM promot…

Unable to UNNEST when combining with USE KEYS

SQL++

sri_ram May 22, 2020, 3:48pm 7

Sure. Many thanks @vsr1

Topic		Replies	Views
Need suggestion on how to write query when subquery returns an array SQL++ query , n1ql	5	641	May 22, 2020
Processing document which contains array of objects SQL++ n1ql , arrays	12	1304	August 18, 2021
USE KEYS and Key value Operation Java SDK query , java , n1ql	4	1317	March 27, 2022
N1QL Union performance with UNNEST SQL++ java , n1ql	8	2006	August 8, 2017
Why USE KEYS error shown when using DB name SQL++ query , n1ql	7	674	June 2, 2023

Unable to UNNEST when combining with USE KEYS

Related topics