Slackbot
01/12/2023, 9:23 AMPawel Rzepinski
01/17/2023, 9:28 AMBen Krug
01/17/2023, 6:11 PMPawel Rzepinski
01/18/2023, 8:56 AMscan - timeouts for value 5, runs fine for 500):
{
"queryType": "timeseries",
"dataSource": {
"type": "query",
"query": {
"queryType": "scan",
"dataSource": {
"type": "table",
"name": "wikipedia"
},
"intervals": {
"type": "intervals",
"intervals": [
"-146136543-09-08T08:23:32.096Z/146140482-04-24T15:36:27.903Z"
]
},
"virtualColumns": [],
"resultFormat": "compactedList",
"batchSize": 20480,
"limit": 10,
"order": "none",
"filter": {
"type": "bound",
"dimension": "added",
"lower": "0",
"upper": null,
"lowerStrict": true,
"upperStrict": false,
"extractionFn": null,
"ordering": {
"type": "numeric"
}
},
"columns": [
"__time",
"added",
],
"legacy": false,
"context": {
"sqlOuterLimit": 100,
"sqlQueryId": "521b2d60-2164-43ac-afe4-9aec03480f99",
"timeout": 5
},
"descending": false,
"granularity": {
"type": "all"
}
}
},
"intervals": {
"type": "intervals",
"intervals": [
"-146136543-09-08T08:23:32.096Z/146140482-04-24T15:36:27.903Z"
]
},
"descending": false,
"virtualColumns": [],
"filter": null,
"granularity": {
"type": "all"
},
"aggregations": [
{
"type": "longMax",
"name": "a0",
"fieldName": "added",
"expression": null
}
],
"postAggregations": [],
"limit": 2147483647,
"context": {
"skipEmptyBuckets": true,
"sqlOuterLimit": 100,
"sqlQueryId": "84271bba-4a62-489f-b3e3-cd0351eb61d4",
"timeout": 10000
}
}Ben Krug
01/18/2023, 4:31 PM