Description
The indexes present are:
default(VMs)
standard_bucket0(VMs)
This query:
select * from standard_bucket0 s INNER JOIN default d ON (d.VMs == s.VMs) LIMIT 10
Also hangs with the same datasets I gave you earlier in MB-27763, this may even be the same issue. Basically VMs is an array in the dataset that looks like so:
"VMs": [
{
"RAM": 10,
"os": "ubuntu",
"name": "vm_10",
"memory": 10
}]
Explain is attached here:
{
"plan": {
"#operator": "Sequence",
"~children": [
{
"#operator": "Sequence",
"~children": [
{
"#operator": "IndexScan3",
"as": "s",
"index": "arrays1",
"index_id": "596ca10a51a354e",
"index_projection": {
"primary_key": true
},
"keyspace": "standard_bucket0",
"namespace": "default",
"spans": [
{
"exact": true,
"range": [
{
"inclusion": 0,
"low": "null"
}
]
}
],
"using": "gsi"
},
{
"#operator": "Fetch",
"as": "s",
"keyspace": "standard_bucket0",
"namespace": "default"
},
{
"#operator": "Parallel",
"~child": {
"#operator": "Sequence",
"~children": [
{
"#operator": "AnsiJoin",
"alias": "d",
"on_clause": "((`d`.`VMs`) = (`s`.`VMs`))",
"~child": {
"#operator": "Sequence",
"~children": [
{
"#operator": "IndexScan3",
"ansi_join": true,
"as": "d",
"index": "arrays",
"index_id": "5fec13f1bab1b8f0",
"index_projection": {
"primary_key": true
},
"keyspace": "default",
"namespace": "default",
"spans": [
{
"exact": true,
"range": [
{
"high": "(`s`.`VMs`)",
"inclusion": 3,
"low": "(`s`.`VMs`)"
}
]
}
],
"using": "gsi"
},
{
"#operator": "Fetch",
"ansi_join": true,
"as": "d",
"keyspace": "default",
"namespace": "default"
}
]
}
},
{
"#operator": "InitialProject",
"result_terms": [
{
"expr": "self",
"star": true
}
]
},
{
"#operator": "FinalProject"
}
]
}
}
]
},
{
"#operator": "Limit",
"expr": "10"
}
]
},
"text": "select * from standard_bucket0 s INNER JOIN default d ON (d.VMs == s.VMs) LIMIT 10"
}
Attachments
Issue Links
- duplicates
-
MB-27763 [ANSI JOIN] ROJ query hangs
- Closed