GitHub user Dhruvin4530 added a comment to the discussion: Superset is not able
to load the result from hydrolix
@dosu
This query is running in hydrolix and giving the result but this same query is
not running in superset & not giving the result.
```
SELECT
toDateTime(intDiv(toUInt32(toDateTime("timestamp")), 300) * 300) AS
"timestamp",
countIf(location = 'session_setup' AND message = 'Session Created') AS
"Session Created",
countIf(solved = 1 AND verified = 1 AND location = 'game_verify') AS "Session
Verified"
FROM "events_development"."events"
WHERE
"timestamp" >= toDateTime('2026-06-23 14:02:34')
AND "timestamp" < toDateTime('2026-06-23 15:02:34')
GROUP BY
"timestamp"
ORDER BY
"Session Created" DESC
LIMIT 10
```
Why so?
GitHub link:
https://github.com/apache/superset/discussions/41395#discussioncomment-17424782
----
This is an automatically sent email for [email protected].
To unsubscribe, please send an email to:
[email protected]
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
