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 2020/07/22 10:03:48 UTC

[GitHub] [incubator-superset] durchgedreht commented on issue #10203: 0NaN-NaN-NaN NaN:NaN:NaN in Tables when Include Time is enabled

durchgedreht commented on issue #10203:
URL: https://github.com/apache/incubator-superset/issues/10203#issuecomment-662364229

Hi,
we encounter the same issue, but with the pattern "NaN/NaN/0NaN".

- superset version: 0.36.0
- clickhouse
- native clickhouse alchemy driver

When looking in the query log, ordering per week applies a toMonday() function after a toDatetime(). Result will not be DateTime but Date (have a look in the. "__timestamp" field - no time infos available). I'm not sure where the issue resides, but the rending in HTML shows a zeroed out Datetime with format "yyyy-MM-dd 00:00:00" (first picture at the bottom shows the chrome dev inspect window with <td> data-sort="2020-02-24T00:00:00" ) .
<img width="639" alt="Superset_toMonday" src="https://user-images.githubusercontent.com/4490840/88162805-20345680-cc12-11ea-8e85-e98d76172447.png">

So I believe it's just the rendering that's impacted. Many NaN Date rendering is related to wrong Date input, so maybe columns are mixed up, wrong format pattern applied, index wrong (month values 0-11 vs 1-12).

I can provide more infos if needed. Please advise which data might be helpful.

----------------------------------------------------------------
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.

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