You are viewing a plain text version of this content. The canonical link for it is here.
Posted to notifications@superset.apache.org by GitBox <gi...@apache.org> on 2021/08/04 17:40:00 UTC
[GitHub] [superset] graceguo-supercat opened a new issue #16067: [bar chart] "Unexpected Error"
graceguo-supercat opened a new issue #16067:
URL: https://github.com/apache/superset/issues/16067
Get an unexpected error when trying to generate a superset chart (as seen in the screenshot below) even though the query runs and returns results.
#### Screenshots
![image-2021-08-02-15-19-23-281 (1)](https://user-images.githubusercontent.com/27990562/128227882-1b81c669-d147-4279-b5f9-a83c4138148e.png)
You will see that `data` section has correct results but chart can't be rendered.
It seems like the SUM metrics are incorrectly being named "sum" in the generated query, which causes some weird sql problems.
![image-2021-08-02-15-21-43-760](https://user-images.githubusercontent.com/27990562/128227856-688892ff-851f-40df-b10d-5211bd52cc94.png)
Switching to "custom sql" is a workaround but not ideal.
### Environment
latest production
### Checklist
Make sure to follow these steps before submitting your issue - thank you!
- [x] I have checked the superset logs for python stacktraces and included it here as text if there are any.
- [x] I have reproduced the issue with at least the latest released version of superset.
- [x] I have checked the issue tracker for the same issue and I haven't found one similar.
### Additional context
CC @serenajiang @villebro
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org
[GitHub] [superset] villebro commented on issue #16067: [explore] "Unexpected Error"/chart not render on SUM metric
Posted by GitBox <gi...@apache.org>.
villebro commented on issue #16067:
URL: https://github.com/apache/superset/issues/16067#issuecomment-896558986
I was able to reproduce
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org
[GitHub] [superset] graceguo-supercat commented on issue #16067: [Area Chart] "Unexpected Error"
Posted by GitBox <gi...@apache.org>.
graceguo-supercat commented on issue #16067:
URL: https://github.com/apache/superset/issues/16067#issuecomment-892964809
```
{
"viz_type": "area",
"datasource": "158397__table",
"url_params": {},
"time_range_endpoints": [
"inclusive",
"exclusive"
],
"granularity_sqla": "ds_check_in",
"time_grain_sqla": "P1D",
"time_range": "No filter",
"metrics": [
{
"expressionType": "SIMPLE",
"column": {
"id": 1895078,
"column_name": "listings",
"verbose_name": null,
"description": null,
"expression": null,
"filterable": true,
"groupby": true,
"is_dttm": false,
"type": "BIGINT",
"type_generic": 0,
"python_date_format": null
},
"aggregate": "SUM",
"sqlExpression": null,
"isNew": false,
"hasCustomLabel": false,
"label": "",
"optionName": "metric_ja8im4tgzup_arys39zkcdj"
}
],
"adhoc_filters": [
{
"expressionType": "SIMPLE",
"subject": "dim_availability_type",
"operator": "==",
"operatorId": "EQUALS",
"comparator": "UNAVAILABLE",
"clause": "WHERE",
"sqlExpression": null,
"isExtra": false,
"isNew": false,
"filterOptionName": "filter_uedp7l1zhu_s587slv7edk"
}
],
"groupby": [
"dim_unavailability_reasons"
],
"limit": 100,
"order_desc": true,
"row_limit": 1000,
"show_brush": "auto",
"line_interpolation": "linear",
"stacked_style": "stack",
"color_scheme": "supersetColors",
"label_colors": {},
"rich_tooltip": true,
"bottom_margin": "auto",
"x_ticks_layout": "auto",
"x_axis_format": "smart_date",
"y_axis_format": "SMART_NUMBER",
"y_axis_bounds": [
null,
null
],
"rolling_type": "None",
"comparison_type": "values",
"annotation_layers": [],
"extra_form_data": {}
}
```
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org
[GitHub] [superset] graceguo-supercat commented on issue #16067: [explore] "Unexpected Error"/chart not render on SUM metric
Posted by GitBox <gi...@apache.org>.
graceguo-supercat commented on issue #16067:
URL: https://github.com/apache/superset/issues/16067#issuecomment-897392766
wow thanks so much for everyone @villebro @kgabryje @junlincc !!
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org
[GitHub] [superset] rusackas closed issue #16067: [explore] "Unexpected Error"/chart not render on SUM metric
Posted by GitBox <gi...@apache.org>.
rusackas closed issue #16067:
URL: https://github.com/apache/superset/issues/16067
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org
[GitHub] [superset] villebro commented on issue #16067: [Area Chart] "Unexpected Error"
Posted by GitBox <gi...@apache.org>.
villebro commented on issue #16067:
URL: https://github.com/apache/superset/issues/16067#issuecomment-892867389
Even better, can you post the redacted chart metadata, especially `params.metrics`?
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org
[GitHub] [superset] graceguo-supercat commented on issue #16067: [Area Chart] "Unexpected Error"
Posted by GitBox <gi...@apache.org>.
graceguo-supercat commented on issue #16067:
URL: https://github.com/apache/superset/issues/16067#issuecomment-892964809
```
{
"viz_type": "area",
"datasource": "158397__table",
"url_params": {},
"time_range_endpoints": [
"inclusive",
"exclusive"
],
"granularity_sqla": "ds_check_in",
"time_grain_sqla": "P1D",
"time_range": "No filter",
"metrics": [
{
"expressionType": "SIMPLE",
"column": {
"id": 1895078,
"column_name": "listings",
"verbose_name": null,
"description": null,
"expression": null,
"filterable": true,
"groupby": true,
"is_dttm": false,
"type": "BIGINT",
"type_generic": 0,
"python_date_format": null
},
"aggregate": "SUM",
"sqlExpression": null,
"isNew": false,
"hasCustomLabel": false,
"label": "",
"optionName": "metric_ja8im4tgzup_arys39zkcdj"
}
],
"adhoc_filters": [
{
"expressionType": "SIMPLE",
"subject": "dim_availability_type",
"operator": "==",
"operatorId": "EQUALS",
"comparator": "UNAVAILABLE",
"clause": "WHERE",
"sqlExpression": null,
"isExtra": false,
"isNew": false,
"filterOptionName": "filter_uedp7l1zhu_s587slv7edk"
}
],
"groupby": [
"dim_unavailability_reasons"
],
"limit": 100,
"order_desc": true,
"row_limit": 1000,
"show_brush": "auto",
"line_interpolation": "linear",
"stacked_style": "stack",
"color_scheme": "supersetColors",
"label_colors": {},
"rich_tooltip": true,
"bottom_margin": "auto",
"x_ticks_layout": "auto",
"x_axis_format": "smart_date",
"y_axis_format": "SMART_NUMBER",
"y_axis_bounds": [
null,
null
],
"rolling_type": "None",
"comparison_type": "values",
"annotation_layers": [],
"extra_form_data": {}
}
```
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org
[GitHub] [superset] graceguo-supercat commented on issue #16067: [Area Chart] "Unexpected Error"
Posted by GitBox <gi...@apache.org>.
graceguo-supercat commented on issue #16067:
URL: https://github.com/apache/superset/issues/16067#issuecomment-895459233
this issue also happens to Line Chart
```
{
"viz_type": "line",
"datasource": "158840__table",
"url_params": {},
"time_range_endpoints": [
"inclusive",
"exclusive"
],
"granularity_sqla": "ds",
"time_grain_sqla": "P1D",
"time_range": "No filter",
"metrics": [
{
"expressionType": "SIMPLE",
"column": {
"id": 1904718,
"column_name": "unique_visitors",
"verbose_name": null,
"description": null,
"expression": null,
"filterable": true,
"groupby": true,
"is_dttm": false,
"type": "BIGINT",
"type_generic": 0,
"python_date_format": null
},
"aggregate": "SUM",
"sqlExpression": null,
"isNew": false,
"hasCustomLabel": false,
"label": "",
"optionName": "metric_76gswmgyogo_kymat50bwcj"
}
],
"adhoc_filters": [
{
"expressionType": "SIMPLE",
"subject": "valid_visitor",
"operator": "==",
"operatorId": "EQUALS",
"comparator": "valid_visitor",
"clause": "WHERE",
"sqlExpression": null,
"isExtra": false,
"isNew": false,
"filterOptionName": "filter_sq1vozrzik_49hy4x6kuxy"
}
],
"groupby": [
"dim_platform_mode"
],
"limit": 100,
"order_desc": true,
"row_limit": 50000,
"color_scheme": "supersetColors",
"label_colors": {},
"show_brush": "auto",
"rich_tooltip": true,
"line_interpolation": "linear",
"bottom_margin": "auto",
"x_ticks_layout": "auto",
"x_axis_format": "smart_date",
"left_margin": "auto",
"y_axis_format": "SMART_NUMBER",
"y_axis_bounds": [
null,
null
],
"rolling_type": "None",
"comparison_type": "values",
"annotation_layers": [],
"extra_form_data": {}
}
```
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org
[GitHub] [superset] graceguo-supercat commented on issue #16067: [Area Chart] "Unexpected Error"
Posted by GitBox <gi...@apache.org>.
graceguo-supercat commented on issue #16067:
URL: https://github.com/apache/superset/issues/16067#issuecomment-895354801
Hi @villebro do you need more information for this issue? thanks!
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org
[GitHub] [superset] villebro commented on issue #16067: [Area Chart] "Unexpected Error"
Posted by GitBox <gi...@apache.org>.
villebro commented on issue #16067:
URL: https://github.com/apache/superset/issues/16067#issuecomment-892866225
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org
[GitHub] [superset] graceguo-supercat edited a comment on issue #16067: [explore] "Unexpected Error"/chart not render on SUM metric
Posted by GitBox <gi...@apache.org>.
graceguo-supercat edited a comment on issue #16067:
URL: https://github.com/apache/superset/issues/16067#issuecomment-897392766
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org
[GitHub] [superset] villebro commented on issue #16067: [Area Chart] "Unexpected Error"
Posted by GitBox <gi...@apache.org>.
villebro commented on issue #16067:
URL: https://github.com/apache/superset/issues/16067#issuecomment-892866225
@graceguo-supercat can you show a screenshot of the metric popover? It looks like it has a custom label, but I assume not? Also, is this Presto?
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org
[GitHub] [superset] junlincc commented on issue #16067: [explore] "Unexpected Error"/chart not render on SUM metric
Posted by GitBox <gi...@apache.org>.
junlincc commented on issue #16067:
URL: https://github.com/apache/superset/issues/16067#issuecomment-896396661
bump to p0, it is also happening in echarts. there are 2 workaround, another one is to create a chart with some other aggregate.. then switch to SUM
https://user-images.githubusercontent.com/67837651/128950710-145d55ab-97ae-4375-b1aa-5367503fe500.mov
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org