Index for nested data couchbase

SQL++
1

Hi
Below is my Data

{
“VehicleTrip”: {
“departureTime”: 1483176300000
},
“Orders”: {
“Order”: [{
“numberOfShops”: 3,
“customerTitle”: “Mrs”,
“notes”: “”
“orderId”: “3060_1”
}, {
“numberOfShops”: 3,
“customerTitle”: “Mrs”,
“notes”: “”
“orderId”: “3060_2”
}
}]
}
I want to create index for orderId. My bucket name is Delivery

I tried with

CREATE INDEX isched1
ON Delivery (DISTINCT ARRAY v.orderId FOR v IN Orders.Order END);
But no use. Can anyone help me in getting index for above data.

Thanks,
Vinay

2

What is the issue . Your query should look some thing like below. Or you can post the query

SELECT META(d).id FROM Delivery d WHERE ANY v IN Orders.Order SATISFIES v.orderId = "3060_1" END;

3

Hi,

My query is as below

select D.VehicleTrip, D.Orders,
from Delivery as D UNNEST Orders.Order O WHERE O.orderId = ‘3060_2’

I want to create Index for orderId for better performance of query.
I am unaware of creating Index for nested data

Thanks,
Vinay J

4

Unnest Alias needs to be matched with the variable used in the CREATE INDEX.
Do EXPLAIN on the following query. It should have used isched1 index and Spans should have “3060_2”.

   CREATE INDEX isched1 ON Delivery (DISTINCT ARRAY v.orderId FOR v IN Orders.Order END);
    SELECT D.VehicleTrip, D.Orders,
    FROM Delivery AS D UNNEST D.Orders.Order AS v WHERE v.orderId = "3060_2";
5

It worked after changing alias name
Thanks,
Vinay J