Strangely I am actually receiving document where the metadata.delete = true.
SELECT MAX([metadata.published, metadata.deleted, meta().id]) FROM zeusresource WHERE (
(tag.internal = ‘fordemo’ AND tag.external = ‘fordemo’)
(tag.internal = ‘donkey’ AND tag.external = ‘donkey’)
) AND
metadata.published <= 1496636763719
GROUP BY tag.external, tag.internal HAVING metadata.deleted = false
Here is the explain
{
“requestID”: “e09a4dea-797e-4f95-b427-9b5f1a5c43f2”,
“clientContextID”: “8c160753-34cc-4983-8f29-44879791b333”,
“signature”: “json”,
“results”: [
{
“plan”: {
"#operator": “Sequence”,
"~children": [
{
"#operator": “DistinctScan”,
“scan”: {
"#operator": “IndexScan”,
“covers”: [
“cover (((zeusresource.tag).internal))”,
“cover (((zeusresource.tag).external))”,
“cover (((zeusresource.metadata).published))”,
“cover (((zeusresource.metadata).deleted))”,
“cover ((zeusresource.outline))”,
“cover ((meta(zeusresource).id))”
],
“index”: “zeusresourcetoken”,
“index_id”: “c2a521613d8fc0e0”,
“keyspace”: “zeusresource”,
“namespace”: “default”,
“spans”: [
{
“Range”: {
“High”: [
"“fordemo”",
"“fordemo”",
“successor(1496636763719)”
],
“Inclusion”: 0,
“Low”: [
"“fordemo”",
"“fordemo”",
“null”
]
}
},
{
“Range”: {
“High”: [
"“fordemo”",
"“donkey”",
“successor(1496636763719)”
],
“Inclusion”: 0,
“Low”: [
"“fordemo”",
"“donkey”",
“null”
]
}
},
{
“Range”: {
“High”: [
"“donkey”",
"“fordemo”",
“successor(1496636763719)”
],
“Inclusion”: 0,
“Low”: [
"“donkey”",
"“fordemo”",
“null”
]
}
},
{
“Range”: {
“High”: [
"“donkey”",
"“donkey”",
“successor(1496636763719)”
],
“Inclusion”: 0,
“Low”: [
"“donkey”",
"“donkey”",
“null”
]
}
}
],
“using”: “gsi”
}
},
{
"#operator": “Parallel”,
"~child": {
"#operator": “Sequence”,
"~children": [
{
"#operator": “Filter”,
“condition”: “((((cover (((zeusresource.tag).internal)) = “fordemo”) and (cover (((zeusresource.tag).external)) = “fordemo”)) or ((cover (((zeusresource.tag).internal)) = “donkey”) and (cover (((zeusresource.tag).external)) = “donkey”))) and (cover (((zeusresource.metadata).published)) <= 1496636763719))”
},
{
"#operator": “InitialGroup”,
“aggregates”: [
“max([cover (((zeusresource.metadata).published)), cover (((zeusresource.metadata).deleted)), cover ((meta(zeusresource).id))])”
],
“group_keys”: [
“cover (((zeusresource.tag).external))”,
“cover (((zeusresource.tag).internal))”
]
}
]
}
},
{
"#operator": “IntermediateGroup”,
“aggregates”: [
“max([cover (((zeusresource.metadata).published)), cover (((zeusresource.metadata).deleted)), cover ((meta(zeusresource).id))])”
],
“group_keys”: [
“cover (((zeusresource.tag).external))”,
“cover (((zeusresource.tag).internal))”
]
},
{
"#operator": “FinalGroup”,
“aggregates”: [
“max([cover (((zeusresource.metadata).published)), cover (((zeusresource.metadata).deleted)), cover ((meta(zeusresource).id))])”
],
“group_keys”: [
“cover (((zeusresource.tag).external))”,
“cover (((zeusresource.tag).internal))”
]
},
{
"#operator": “Parallel”,
"~child": {
"#operator": “Sequence”,
"~children": [
{
"#operator": “Filter”,
“condition”: “(cover (((zeusresource.metadata).deleted)) = false)”
},
{
"#operator": “InitialProject”,
“result_terms”: [
{
“expr”: “max([cover (((zeusresource.metadata).published)), cover (((zeusresource.metadata).deleted)), cover ((meta(zeusresource).id))])”
}
]
},
{
"#operator": “FinalProject”
}
]
}
}
]
},
“text”: “SELECT MAX([metadata.published, metadata.deleted, meta().id]) FROM zeusresource WHERE (\n(tag.internal = ‘fordemo’ AND tag.external = ‘fordemo’) OR \n(tag.internal = ‘donkey’ AND tag.external = ‘donkey’)\n) AND \nmetadata.published <= 1496636763719\nGROUP BY tag.external, tag.internal HAVING metadata.deleted = false”
}
],
“status”: “success”,
“metrics”: {
“elapsedTime”: “7.62846ms”,
“executionTime”: “7.577916ms”,
“resultCount”: 1,
“resultSize”: 8296
}
}
Here are the 2 documents in the repository
{
“metadata”: {
“publishedby”: “6acbb871-e944-4864-983b-47adf59495d2”,
“tagsize”: 2,
“serverpid”: 14028,
“deleted”: false,
“published”: 1496636639501,
“serverhostname”: “APSGONTW7W1076”
},
“outline”: null,
“tag”: {
“internal”: “donkey”,
“external”: “donkey”
},
“payload”: {
“resources”: [
{
“readoutline”: true,
“readpayload”: true,
“tagsize”: 4,
“tag”: {
“environment”: “",
“source”: "”,
“type”: “",
“ccypair”: "”
},
“write”: true,
“readmetadata”: true
}
],
“deleteresource”: true,
“createresource”: true,
“queryresources”: true,
“keyvaluediscovery”: true
}
}
{
“metadata”: {
“publishedby”: “1b770b3c-edb5-4fb7-bf8f-fa518179d5c2”,
“tagsize”: 2,
“serverpid”: 14028,
“deleted”: true,
“published”: 1496636663354,
“serverhostname”: “APSGONTW7W1076”
},
“outline”: null,
“tag”: {
“internal”: “donkey”,
“external”: “donkey”
},
“payload”: null
}