GitHub user dosubot[bot] added a comment to the discussion: Superset is not
able to load the result from hydrolix
<!-- Answer -->
This is a **Hydrolix-side issue**, not a Superset bug. The error
`hdx_query_timerange_required is set to true. Your query needs a time range
filter in a WHERE clause` is coming from Hydrolix's query validator, which is
failing to recognize Superset's time filter as a valid time range — even though
the `WHERE` clause clearly contains timestamp boundaries.
Looking at the query in the error, the filter is:
```sql
WHERE "timestamp" >= toDateTime('2026-06-23 18:04:38')
AND "timestamp" < toDateTime('2026-06-24 18:04:38')
```
The likely cause is that **Hydrolix requires the time range filter to reference
the raw primary timestamp column directly**, without the `toDateTime()`
wrapping or with a specific format it can parse. Superset's ClickHouse engine
always wraps datetime literals with `toDateTime()`
[[1]](https://github.com/apache/superset/blob/829e4d92d91ceae4b43b1ed3b063ffe45377799c/superset/db_engine_specs/clickhouse.py#L126-L135),
which Hydrolix's filter validator may not recognize.
**Suggested workarounds:**
1. **Check Hydrolix's time filter requirements** — Hydrolix may require the
filter to use specific comparison syntax (e.g., bare string literals like
`'2026-06-23 14:02:34'` instead of `toDateTime('...')`). Consult Hydrolix
documentation on what constitutes a recognized time range filter when
`hdx_query_timerange_required = TRUE`.
2. **Disable `hdx_query_timerange_required`** — If you control the Hydrolix
settings (the `SETTINGS` appended to the query), setting
`hdx_query_timerange_required = FALSE` would bypass the validator. This appears
to be injected by Hydrolix's query pool configuration rather than by Superset.
3. **Use a custom DB engine spec** — You could create a custom Superset
database engine spec that extends ClickHouse but overrides `convert_dttm()` to
output datetime literals in whatever format Hydrolix's validator expects. The
current implementation is in `superset/db_engine_specs/clickhouse.py`
[[2]](https://github.com/apache/superset/blob/829e4d92d91ceae4b43b1ed3b063ffe45377799c/superset/db_engine_specs/clickhouse.py).
4. **Add a Jinja template or SQL override** — If your dataset supports custom
SQL, you might be able to use a virtual dataset with a raw SQL query that
formats the time filter in a way Hydrolix accepts.
This is fundamentally a compatibility gap between Superset's ClickHouse
connector and Hydrolix's extended validation layer. You may want to raise this
with the Hydrolix team to understand exactly what filter format their validator
parses.
<!-- Dosu Comment Footer -->
*To reply, just mention
[@dosu](https://go.dosu.dev/dosubot?utm_source=github&utm_medium=bot-comment&utm_campaign=github-comment-footer-20260415&utm_content=reply-with-mention&utm_term=apache%2Fsuperset).*
---
Docs are dead. Just use
[Dosu](https://dosu.dev?utm_source=github&utm_medium=bot-comment&utm_campaign=github-comment-footer-20260415&utm_content=static-docs-tagline&utm_term=apache%2Fsuperset).
[](https://app.dosu.dev/response-feedback?utm_source=github&utm_medium=bot-comment&utm_campaign=github-comment-footer-20260415&utm_content=static-docs-feedback&utm_term=apache%2Fsuperset&message_id=f85c09c1-6136-43a1-ac65-8b16826e7d69)
[](https://github.dosu.com/apache/superset?utm_source=github&utm_medium=bot-comment&utm_campaign=github-comment-footer-20260415&utm_content=static-docs-ask-repo&utm_term=apache%2Fsuperset)
[](https://app.dosu.dev/signup?referrer=openSource&source=github-footer&utm_source=github&utm_medium=bot-comment&utm_campaign=github-comment-footer-20260415&utm_content=static-docs-share-team&utm_term=apache%2Fsuperset)
GitHub link:
https://github.com/apache/superset/discussions/41395#discussioncomment-17424605
----
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]
