Details
-
Bug
-
Resolution: Done
-
Blocker
-
4.0.0
-
Security Level: Public
-
400-2213
sabre dataload
4 gsi indexes, attached screenshot
-
Untriaged
-
Unknown
Description
1. load 13M data on sabre-default bucket
2. create indexes on default - all successful
3. Most of the expected queries were taking longer to run, so I ran the explain stmts to check - looks like each query was using the primary scan inplace of expected Index scan.
cbq> select * from system:indexes where keyspace_id="default";
{
"requestID": "85f1adb5-4b8d-489a-a4a3-4cbe4b61aa6b",
"signature":
,
"results": [
{
"indexes":
},
{
"indexes":
},
{
"indexes":
},
{
"indexes":
}
],
"status": "success",
"metrics":
}
cbq> explain select AirItineraryPricingInfo.PTC_FareBreakdowns.PTC_FareBreakdown.PassengerFare.TotalFare.Amount as a123 from default where a123}
{
"requestID": "e28feb99-47d0-4c57-a0bf-ea698d44cbec",
"signature": "json",
"results": [
{
"#operator": "Sequence",
"~children": [
{
"#operator": "Sequence",
"~children": [
,
{
"#operator": "Parallel",
"~child": {
"#operator": "Sequence",
"~children": [
,
,
{
"#operator": "InitialProject",
"result_terms": [
]
},
]
}
}
]
},
]
}
],
"status": "success",
"metrics":
}
4. The above uses indexscan when I use full field reference instead of the alias
cbq>
{
"requestID": "5483c80b-f471-4616-808b-c1a86cd46554",
"signature": "json",
"results": [
{
"#operator": "Sequence",
"~children": [
{
"#operator": "Sequence",
"~children": [
{
"#operator": "IndexScan",
"index": "amt",
"keyspace": "default",
"limit": 9.223372036854776e+18,
"namespace": "default",
"spans": [
{
"Range":
,
"Seek": null
}
],
"using": "gsi"
},
{
"#operator": "Parallel",
"~child": {
"#operator": "Sequence",
"~children": [
,
,
{
"#operator": "InitialProject",
"result_terms": [
]
},
]
}
}
]
},
]
}
],
"status": "success",
"metrics":
}