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
When using an INTERVAL type in postgres as a metric, both bar charts and pie charts fail to render with no obvious errors.
For a pie chart, the legend is rendered but nothing else. For a bar chart, the axes and X-axis labels are rendered, but the bars are not drawn.
No errors are reported, either via toast, in the browser console, or in the application logs.
How to reproduce the bug
Write a query against postgres with an INTERVAL column in the response
Create a bar chart or pie chart from that query
Use the INTERVAL as a metric, e.g. with MAX aggregation
Press the button to render the chart
Screenshots/recordings
Superset version
4.0.2
Python version
3.9
Node version
16
Browser
Firefox
Additional context
Rendering the exact same chart but modifying the query to convert the INTERVAL into an integer number of milliseconds worked fine.
Note I also couldn't work around it in this way from the chart itself, as I'd need my metric to be EXTRACT('epoch' FROM total_playtime) which the chart disallowed as it contains a subquery; I had to modify the virtual dataset to work around this.
Checklist
I have searched Superset docs and Slack and didn't find a solution to my problem.
I have searched the GitHub issue tracker and didn't find a similar bug report.
I have checked Superset's logs for errors and if I found a relevant Python stacktrace, I included it here as text in the "additional context" section.
The text was updated successfully, but these errors were encountered:
Note that I've also noticed the INTERVAL type doesn't get sorted correctly in query results in SQL Lab; results just end up sorted alphabetically according to the rendered text. It seems there's just no support for INTERVAL in the engine spec.
Bug description
When using an
INTERVAL
type in postgres as a metric, both bar charts and pie charts fail to render with no obvious errors.For a pie chart, the legend is rendered but nothing else. For a bar chart, the axes and X-axis labels are rendered, but the bars are not drawn.
No errors are reported, either via toast, in the browser console, or in the application logs.
How to reproduce the bug
INTERVAL
column in the responseINTERVAL
as a metric, e.g. withMAX
aggregationScreenshots/recordings
Superset version
4.0.2
Python version
3.9
Node version
16
Browser
Firefox
Additional context
Rendering the exact same chart but modifying the query to convert the
INTERVAL
into an integer number of milliseconds worked fine.Note I also couldn't work around it in this way from the chart itself, as I'd need my metric to be
EXTRACT('epoch' FROM total_playtime)
which the chart disallowed as it contains a subquery; I had to modify the virtual dataset to work around this.Checklist
The text was updated successfully, but these errors were encountered: