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/06/15 13:23:30 UTC
[GitHub] [incubator-superset] ayushbilala opened a new issue #10053: Superset isn't displaying the date value correctly
ayushbilala opened a new issue #10053:
URL: https://github.com/apache/incubator-superset/issues/10053
My SQL query is supposed to return a date column with value '2500-01-01' but is returning '1915-06-14T00:25:26.290448384' via Superset.
I get the correct result from other BI tools, be it Tableau or DBeaver.
On further research, I figured out the root cause. The reason Superset is displaying 1915-06-14 is because the date 2500-01-01 is going out of the range of date type of Superset. Superset’s supported date range is from 1677-09-21 – 2262-04-11, due to this any date after the max date starts again from 1677.
This is the same issue I have seen while working with Pandas (pandas.Timestamp.max)
----------------------------------------------------------------
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
[GitHub] [incubator-superset] willbarrett commented on issue #10053: Superset isn't displaying the date value correctly
Posted by GitBox <gi...@apache.org>.
willbarrett commented on issue #10053:
URL: https://github.com/apache/incubator-superset/issues/10053#issuecomment-649111211
Superset relies on Pandas for many of its transformations. I believe you are correct that this is a limitation of Pandas. Out of curiosity, what is your use-case for far-future dates? Climate projection?
----------------------------------------------------------------
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
[GitHub] [incubator-superset] ayushbilala commented on issue #10053: Superset isn't displaying the date value correctly
Posted by GitBox <gi...@apache.org>.
ayushbilala commented on issue #10053:
URL: https://github.com/apache/incubator-superset/issues/10053#issuecomment-677889146
No not really. Our users do store some far-future dates instead of some NULL value which is why I am having a hard time :)
----------------------------------------------------------------
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
[GitHub] [incubator-superset] issue-label-bot[bot] commented on issue #10053: Superset isn't displaying the date value correctly
Posted by GitBox <gi...@apache.org>.
issue-label-bot[bot] commented on issue #10053:
URL: https://github.com/apache/incubator-superset/issues/10053#issuecomment-644132311
Issue-Label Bot is automatically applying the label `#bug` to this issue, with a confidence of 0.65. Please mark this comment with :thumbsup: or :thumbsdown: to give our bot feedback!
Links: [app homepage](https://github.com/marketplace/issue-label-bot), [dashboard](https://mlbot.net/data/apache/incubator-superset) and [code](https://github.com/hamelsmu/MLapp) for this bot.
----------------------------------------------------------------
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
[GitHub] [incubator-superset] stale[bot] commented on issue #10053: Superset isn't displaying the date value correctly
Posted by GitBox <gi...@apache.org>.
stale[bot] commented on issue #10053:
URL: https://github.com/apache/incubator-superset/issues/10053#issuecomment-714210371
This issue has been automatically marked as stale because it has not had recent activity. It will be closed if no further activity occurs. Thank you for your contributions. For admin, please label this issue `.pinned` to prevent stale bot from closing the issue.
----------------------------------------------------------------
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