You are viewing a plain text version of this content. The canonical link for it is here.
Posted to notifications@superset.apache.org by "kartikdhar (via GitHub)" <gi...@apache.org> on 2023/04/11 11:43:05 UTC

[GitHub] [superset] kartikdhar opened a new issue, #23645: Bar Chart and area chart not handling epoch_ms dates properly (Out of bounds nanosecond timestamp error)

kartikdhar opened a new issue, #23645:
URL: https://github.com/apache/superset/issues/23645

   In Superset v2.1.0 - When trying to create a bar chart or area chart (new one), with a dataset that uses epoch_ms as datetime object, the calculations under the hood are incorrect. Superset is not handling the conversion correctly. This is a new issue that was not the case in previous version we were using (2.0.1)
   
   #### How to reproduce the bug
   
   1. With a dataset with epoch_ms as datetime value
   2. Create a bar chart (new one)
   3. Select any time grain or filters
   
   ### Expected results
   
   Bar chart should be rendered as per the correct dates
   
   ### Actual results
   
   Error:
   ```Out of bounds nanosecond timestamp: 167-01-01 00:00:00```
   
   
   #### Screenshots
   
   ![CleanShot 2023-04-11 at 17 10 20](https://user-images.githubusercontent.com/5626803/231151940-c6a1f682-ee5a-43c1-a818-38e45c619bfd.jpg)
   
   
   ### Environment
   
   (please complete the following information):
   
   - Arc version 112
   - superset version: `2.1.0`
   
   - any feature flags active: ENABLE_TEMPLATE_PROCESSING, HTML_SANITIZATION = False
   
   ### 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
   
   No addition context
   


-- 
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.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] eschutho commented on issue #23645: Bar Chart and area chart not handling epoch_ms dates properly (Out of bounds nanosecond timestamp error)

Posted by "eschutho (via GitHub)" <gi...@apache.org>.
eschutho commented on issue #23645:
URL: https://github.com/apache/superset/issues/23645#issuecomment-1540696656

   Hi @kartikdhar Thanks for reporting this issue. Are there any specific dbs that are running into this 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.

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] HeathLee commented on issue #23645: Bar Chart and area chart not handling epoch_ms dates properly (Out of bounds nanosecond timestamp error)

Posted by "HeathLee (via GitHub)" <gi...@apache.org>.
HeathLee commented on issue #23645:
URL: https://github.com/apache/superset/issues/23645#issuecomment-1667301167

   Hi @eschutho   is this issue still being addressed?


-- 
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] HeathLee commented on issue #23645: Bar Chart and area chart not handling epoch_ms dates properly (Out of bounds nanosecond timestamp error)

Posted by "HeathLee (via GitHub)" <gi...@apache.org>.
HeathLee commented on issue #23645:
URL: https://github.com/apache/superset/issues/23645#issuecomment-1664072703

   Similar issue. With version 2.1.0
   We have a column  `start_time` in millisecond timestamp format, and set epoch_ms in dataset


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


Re: [I] Bar Chart and area chart not handling epoch_ms dates properly (Out of bounds nanosecond timestamp error) [superset]

Posted by "rusackas (via GitHub)" <gi...@apache.org>.
rusackas closed issue #23645: Bar Chart and area chart not handling epoch_ms dates properly (Out of bounds nanosecond timestamp error)
URL: https://github.com/apache/superset/issues/23645


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


Re: [I] Bar Chart and area chart not handling epoch_ms dates properly (Out of bounds nanosecond timestamp error) [superset]

Posted by "rusackas (via GitHub)" <gi...@apache.org>.
rusackas commented on issue #23645:
URL: https://github.com/apache/superset/issues/23645#issuecomment-1981869277

   Hi there, and sorry this has gone quiet for so long. We're no longer supporting Superset 2.x or prior, and it's been a while since this thread saw any activity, so I'm closing this as stale. If it is still an issue in Superset 3.x, we can happily re-open this, or feel free to open a new issue with updated context if that makes more sense. 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