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 2022/01/24 20:11:33 UTC
[GitHub] [superset] igor-lukyanov opened a new issue #18155: Area chart - number of rows returned from the database and listed in Chart Explore > Data section (and drawn on chart) differs by 2
igor-lukyanov opened a new issue #18155:
URL: https://github.com/apache/superset/issues/18155
After migration to 1.4.0 from a previous version (1.0.1) some charts (mainly with low number of dots) got a different (wrong) look (for instance, some area chart became falling instead of growing before). Short investigation indicated that all area charts started to lose first 2 rows in the result set somewhere between fetching them from a database (which returns 16 rows, for example) and drawing data drawn on the chart (when dataset, according to the Data section, contains only 14 rows). Clickhouse database is used.
Notably, exactly 2 first rows are missed - when 'Sort descending' option is enabled in chart settings, 2 greatest values are lost, and when it's disabled - 2 least values. Sorry for a bit framed screenshots (production data).
The same problem is appliable affects pie charts (also with Clickhouse).
#### How to reproduce the bug
1. Open area or pie chart in Chart Explorer.
2. Wait until the data is loaded and chart is rendered
3. Scroll down to 'Data' section.
4. Check the row counter
5. Copy the query and execute manually without using Superset, in some IDE, for instance.
6. Check the row counter there and compare with that one from Superset, they differ by 2.
(please complete the following information):
- browser type and version: Safari
- superset version: 1.4.0
--
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] mayurnewase commented on issue #18155: Number of rows returned from the database and listed in Chart Explore > Data section (and drawn on charts) differs by 2
Posted by GitBox <gi...@apache.org>.
mayurnewase commented on issue #18155:
URL: https://github.com/apache/superset/issues/18155#issuecomment-1027628171
cant reproduce on master
--
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] mayurnewase edited a comment on issue #18155: Number of rows returned from the database and listed in Chart Explore > Data section (and drawn on charts) differs by 2
Posted by GitBox <gi...@apache.org>.
mayurnewase edited a comment on issue #18155:
URL: https://github.com/apache/superset/issues/18155#issuecomment-1027628171
cant reproduce on master for clickhouse db.
--
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] igor-lukyanov commented on issue #18155: Number of rows returned from the database and listed in Chart Explore > Data section (and drawn on charts) differs by 2
Posted by GitBox <gi...@apache.org>.
igor-lukyanov commented on issue #18155:
URL: https://github.com/apache/superset/issues/18155#issuecomment-1022218162
UPD: does not affect Postgresql databases, Clickhouse only.
--
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] igor-lukyanov commented on issue #18155: Number of rows returned from the database and listed in Chart Explore > Data section (and drawn on charts) differs by 2
Posted by GitBox <gi...@apache.org>.
igor-lukyanov commented on issue #18155:
URL: https://github.com/apache/superset/issues/18155#issuecomment-1022239031
Created MRE as a virtual query
```select all 1 as test
union all select 2 as test
union all select 3 as test
union all select 4 as test
```
AND table chart, please check the screenshot.
<img width="1054" alt="Screenshot 2022-01-26 at 17 16 13" src="https://user-images.githubusercontent.com/4200212/151179320-4fafa82c-da4f-4491-ac4f-a9ec1e5f9006.png">
--
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