Slackbot
08/16/2023, 9:22 PMSergio Ferragut
08/16/2023, 10:41 PMBen Krug
08/16/2023, 11:12 PMJianshu Chi
08/16/2023, 11:49 PM{
"queryType": "timeseries",
"dataSource": {
"type": "join",
"left": {
"type": "query",
"query": {
"queryType": "timeseries",
"dataSource": "abc",
"granularity": "day",
"aggregations": [
{
"type": "longSum",
"fieldName": "row1Count",
"name": "countSum"
}
],
"intervals": [
"2023-01-01T00:00:00Z/2023-01-10T00:00:00Z"
],
"context": {}
}
},
"right": {
"type": "query",
"query": {
"queryType": "timeseries",
"dataSource": "abc",
"granularity": "day",
"aggregations": [
{
"type": "longSum",
"fieldName": "row2Count",
"name": "countSum"
}
],
"intervals": [
"2023-01-01T00:00:00Z/2023-01-10T00:00:00Z"
],
"context": {}
}
},
"rightPrefix": "r.",
"condition": "__time == \"r.__time\"",
"joinType": "LEFT"
},
"dimensions": [
{
"dimension": "__time",
"outputName": "timestamp"
}
],
"limitSpec": null,
"virtualColumns": null,
"granularity": "all",
"aggregations": [
{
"type": "doubleSum",
"name": "result",
"expression": "countSum/r.countSum"
}
],
"intervals": [
"0000/3000"
],
"context": {
"keys": "values"
}
}
The "keys": "values" within the outer timeseries queries context is not propagated to the inner timeseries.Ben Krug
08/17/2023, 12:04 AM"context": {} entries helps; maybe that's overriding the outer context, I'm not sure. (I could test if you don't agree or it doesn't work.)Jianshu Chi
08/17/2023, 4:10 AMKaran Kumar
08/19/2023, 2:08 AMJianshu Chi
08/28/2023, 6:59 PM"context": {} . However, it’s still not propagated to inner queries.
Curious to know what do these custom context keys do ?try to do some experiment to exam the query pattern
Ben Krug
08/28/2023, 7:58 PMJianshu Chi
08/28/2023, 9:18 PMBen Krug
08/28/2023, 9:33 PM