Slackbot
11/17/2022, 7:30 AMIgor Berman
11/17/2022, 7:30 AM{
"queryType": "scan",
"dataSource": {
"type": "table",
"name": "sp_campaigns_realtime_aggregation"
},
"intervals": {
"type": "intervals",
"intervals": [
"-146136543-09-08T08:23:32.096Z/146140482-04-24T15:36:27.903Z"
]
},
"resultFormat": "compactedList",
"columns": [
"__time",
"accountId"
],
"legacy": false,
"context": {
"sqlOuterLimit": 1001,
"sqlQueryId": "e4a54e89-fb46-42d7-ab05-ce14b0efb60d"
},
"granularity": {
"type": "all"
}
},signature={__time:LONG, accountType:LONG,
})Igor Berman
11/17/2022, 7:31 AMselect __time, accountId
from sp_campaigns_realtime_aggregation
where
__time = TIMESTAMP '2022-11-16 14:00:00'Michael Taranov
11/17/2022, 8:39 AM> sign works normally
select __time, accountId
from sp_campaigns_realtime_aggregation
where
__time > '2022-11-16 14:00:00'Michael Taranov
11/17/2022, 9:04 AMVersion: 24.0.0Michael Taranov
11/17/2022, 9:05 AMsql-nativeGian Merlino
11/21/2022, 10:00 AMGian Merlino
11/21/2022, 10:00 AMIgor Berman
11/21/2022, 11:46 AM