GitHub user Dhruvin4530 created a discussion: Superset is not able to load the
result from hydrolix
Superset is unable to load the dashboard even though there is a timestamp
mentioned in the query. Here is an example of that.
```
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-24 14:02:34')
GROUP BY
"timestamp"
ORDER BY
"Session Created" DESC
LIMIT 10000
```
Error
```
Error: Received ClickHouse exception, code: 1001, server response: { "error":
"std::exception. Code: 1001, type: h::db::HdxStorageError, e.what() =
<HdxStorageError hdx_query_timerange_required is set to true. Your query needs
a time range filter in a WHERE clause> (version 24.8.6.1)", "query": "SELECT\n
toDateTime(intDiv(toUInt32(toDateTime(\"timestamp\")), 300) * 300) AS
\"timestamp\",\n countIf(location = 'session_setup' AND message = 'Session
Created') AS \"Session Created\",\n countIf(solved = 1 AND verified = 1 AND
location = 'game_verify') AS \"Session Verified\"\nFROM
\"events_development\".\"events\"\nWHERE\n \"timestamp\" >=
toDateTime('2026-06-23 18:04:38')\n AND \"timestamp\" < toDateTime('2026-06-24
18:04:38')\nGROUP BY\n \"timestamp\"\nORDER BY\n \"Session Created\"
DESC\nLIMIT 10000\nSETTINGS hdx_query_pool_name = 'query-peer',
hdx_query_max_memory_usage = 40802189312, hdx_query_timerange_required = TRUE,
hdx_query_max_timerange_sec = 5356800, hdx_query_max_execution_t
ime = 120, hdx_query_admin_comment = 'User: Dhruvin Soni'\n FORMAT Native" }
(for url https://hydrolix-eks.darkoselabs.com:8088)
```
@dosu Please take a look and help here.
GitHub link: https://github.com/apache/superset/discussions/41395
----
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]
