GitHub user dosubot[bot] added a comment to the discussion: Superset is not
able to load the result from hydrolix
<!-- Answer -->
If you set `hdx_query_timerange_required = False`, Hydrolix will **no longer
reject queries that lack a time range filter**. This means:
- Queries without a `WHERE timestamp >= ... AND timestamp < ...` clause will be
allowed to execute
- Those queries could potentially scan your **entire table** across all time
partitions, leading to very expensive/slow queries, high memory usage, and
potentially hitting `hdx_query_max_execution_time` or
`hdx_query_max_memory_usage` limits instead
The `hdx_query_timerange_required` setting exists as a safety guardrail to
prevent unbounded full-table scans on Hydrolix's columnar storage.
**A better middle-ground approach** would be to keep the guardrail but make it
conditional in your mutator. For example, you could check whether the query
already contains a time filter before deciding:
```python
def get_settings(user_name, security_manager, query_settings=None, query=None):
...
# Only enforce time range requirement if query doesn't already have a time
filter
has_time_filter = query and re.search(
r"""["']?timestamp["']?\s*>=\s*""", query, re.IGNORECASE
)
settings = {
...
"hdx_query_timerange_required": not has_time_filter,
...
}
```
Or alternatively, since the real issue is that Hydrolix's validator doesn't
recognize `toDateTime('...')` as a valid time range — you could raise this with
Hydrolix support as a bug in their validator. The setting *should* work with
your queries since they clearly contain time boundaries; the validator just
isn't parsing them correctly in the newer server version (24.8.6.1).
You also still have `hdx_query_max_timerange_sec: 62 days` as a secondary
guardrail, so even without the `timerange_required` check, queries are still
bounded by the max time range setting if Hydrolix enforces that separately.
<!-- 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=b0d89c76-4a7a-48d8-acfe-62020b3c12f5)
[](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-17424977
----
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]
