You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
Coming from other tools, hyperdx feels quite rigid. It would go along way to support custom queries for searches (and maybe charts). The custom queries should also support alerting functionality. We use custom queries and alerts on those in axiom, for example. While I think it's good to strive for having high-level UI primitives for most things, I don't think that'll cover 100% of user needs, so it would be very powerful to allow folks to write custom queries and setup alerts over those queries.
This is maybe not the best example, but I was trying to calculate rate. The screenshot below demonstrates a few issues:
Sort of working, but verry clunky to put in custom SQL
bug: adds my default fields to select even though I removed them
bug: adds order by even though I removed it
Because it adds order by and other fields, query doesn't work
Happy to make this about removing the order by. The big picture here (apologies if I was confusing) is to allow arbitrary queries for more flexibility and ensure the alerts can be configured over those arbitrary queries. If you think the combination of #1363 and removing order by captures that, then 👍🏻
@benjreinhart I think this might a bit of difference between tools like Axiom/Splunk where the search panel also does aggregations vs HyperDX where we actually split out the two workflows.
The search page is optimimized for just showing results (logs, traces) that match a given filter criteria - but not really graph it.
For things like building a chart visualization, you should be able to accomplish what you're looking for in the chart explorer instead. Though agreed - we want to make it so that users can also just type in arbitrary SQL when they need it.
@MikeShi42 for sure, the point I was tying to make was about flexible search capabilities not necessarily where the visualization / tabular results are shown. I think the most important thing for my team is to ensure we can set up monitors for arbitrarily complex queries
The big picture here is to allow arbitrary queries for more flexibility and ensure the alerts can be configured over those arbitrary queries.
Hey there - Raw SQL dashboard tiles / chart explorer queries were added back in March, so arbitrary queries can be searched, visualized, and alerted on chart explorer or dashboard pages.
IMO if making the order by optional on the search page was intended to enable those use-cases, we should probably close this issue and open up followups if there are issues with the chart explorer or dashboards functionality for your use case.
Activity
brandon-pereira commentedon Nov 17, 2025
Hey @benjreinhart, This makes sense to me! Is your goal to have a query that shows you the error rate in a given time window?
I see you have two issues, this one and #1363.
What do you think about making this ticket about making order by optional, and the other ticket about not adding additional fields to the select?
I believe this one should be fairly easy to implement, #1363 might be a bit more challenging and require more testing.
benjreinhart commentedon Nov 17, 2025
Happy to make this about removing the
order by. The big picture here (apologies if I was confusing) is to allow arbitrary queries for more flexibility and ensure the alerts can be configured over those arbitrary queries. If you think the combination of #1363 and removingorder bycaptures that, then 👍🏻[-]Support custom SQL in searches + alerts[/-][+]Make `order by` optional in searches[/+]MikeShi42 commentedon Nov 18, 2025
@benjreinhart I think this might a bit of difference between tools like Axiom/Splunk where the search panel also does aggregations vs HyperDX where we actually split out the two workflows.
The search page is optimimized for just showing results (logs, traces) that match a given filter criteria - but not really graph it.
For things like building a chart visualization, you should be able to accomplish what you're looking for in the chart explorer instead. Though agreed - we want to make it so that users can also just type in arbitrary SQL when they need it.
benjreinhart commentedon Nov 18, 2025
@MikeShi42 for sure, the point I was tying to make was about flexible search capabilities not necessarily where the visualization / tabular results are shown. I think the most important thing for my team is to ensure we can set up monitors for arbitrarily complex queries
krishs01 commentedon Sep 19, 2026
Hii @benjreinhart , is this issue still open, I'm a first time contributor and would like to work on this.
pulpdrew commentedon Nov 17, 2026
Hey there - Raw SQL dashboard tiles / chart explorer queries were added back in March, so arbitrary queries can be searched, visualized, and alerted on chart explorer or dashboard pages.
IMO if making the order by optional on the search page was intended to enable those use-cases, we should probably close this issue and open up followups if there are issues with the chart explorer or dashboards functionality for your use case.