This message was deleted.
# troubleshooting
s
This message was deleted.
๐Ÿ‘€ 1
i
itโ€™s translated to :
Copy code
{
    "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,
})
the fix to query is trivial:
Copy code
select __time, accountId 
from sp_campaigns_realtime_aggregation 
where 
__time = TIMESTAMP '2022-11-16 14:00:00'
m
Similar query with
>
sign works normally
Copy code
select __time, accountId 
from sp_campaigns_realtime_aggregation 
where 
__time > '2022-11-16 14:00:00'
Version: 24.0.0
Query engine:
sql-native
g
I looked into this for a bit, and don't have a solution yet, but made some progress on figuring out the cause
Raised a github issue with findings: https://github.com/apache/druid/issues/13400
๐Ÿ™Œ 1
i
thanks @Gian Merlino