You are viewing a plain text version of this content. The canonical link for it is here.
Posted to notifications@superset.apache.org by "unicornis-pl (via GitHub)" <gi...@apache.org> on 2023/01/24 10:04:19 UTC
[GitHub] [superset] unicornis-pl opened a new issue, #22841: Timestamp formats diplayed as NaN:NaN:NaN
unicornis-pl opened a new issue, #22841:
URL: https://github.com/apache/superset/issues/22841
In charts time fields are displayed as NaN:NaN
#### How to reproduce the bug
1. Run SQL query: `SELECT CURTIME()`
2. Result: `0 days 09:26:27`
3. Create chart to explore query results, add field to chart, chose any of available timestamp formats
### Expected results
Data displayed in chart as 09:26:27
### Actual results
Data displayed in chart as NaN:NaN:NaN
#### Screenshots

### Environment
(please complete the following information):
- browser type and version on client: Chrome on Windows, 108.0.5359.126
- superset version: `Version: 2.0.1`
- python version: `Python 3.8.13`
- node.js version: `v12.22.12` on server, none on client
- any feature flags active: `superset run --host=0.0.0.0 -p 8008 --with-threads --reload --debugger`
- database: `mysql Ver 15.1 Distrib 5.5.68-MariaDB, for Linux (x86_64) using readline 5.1`
```
pip list --local
Package Version
aiohttp 3.8.3
aiosignal 1.3.1
alembic 1.9.1
amqp 5.1.1
apache-superset 2.0.1
apispec 5.2.2
async-generator 1.10
async-timeout 4.0.2
attrs 22.2.0
Babel 2.11.0
backoff 2.2.1
billiard 3.6.4.0
bleach 3.3.1
Brotli 1.0.9
cachelib 0.4.1
celery 5.2.7
certifi 2022.12.7
cffi 1.15.1
charset-normalizer 2.1.1
click 8.1.3
click-didyoumean 0.3.0
click-plugins 1.1.1
click-repl 0.2.0
colorama 0.4.6
convertdate 2.4.0
cron-descriptor 1.2.32
croniter 1.3.8
cryptography 3.4.7
deprecation 2.1.0
dnspython 2.2.1
email-validator 1.3.0
exceptiongroup 1.1.0
Flask 2.2.2
Flask-AppBuilder 4.2.0
Flask-Babel 2.0.0
Flask-Caching 1.11.1
Flask-Compress 1.13
Flask-JWT-Extended 4.4.4
Flask-Login 0.6.2
Flask-Migrate 4.0.1
Flask-SQLAlchemy 2.5.1
flask-talisman 1.0.0
Flask-WTF 1.0.1
frozenlist 1.3.3
func-timeout 4.3.5
geographiclib 2.0
geopy 2.3.0
graphlib-backport 1.0.3
gunicorn 20.1.0
h11 0.14.0
hashids 1.3.1
hijri-converter 2.2.4
holidays 0.14.2
humanize 4.4.0
idna 3.4
importlib-metadata 6.0.0
importlib-resources 5.10.2
isodate 0.6.1
itsdangerous 2.1.2
Jinja2 3.1.2
jsonschema 4.17.3
kombu 5.2.4
korean-lunar-calendar 0.3.1
Mako 1.2.4
Markdown 3.4.1
MarkupSafe 2.1.1
marshmallow 3.19.0
marshmallow-enum 1.5.1
marshmallow-sqlalchemy 0.26.1
msgpack 1.0.4
multidict 6.0.4
mysql-connector-python 8.0.31
mysqlclient 2.1.1
numpy 1.22.1
outcome 1.2.0
packaging 23.0
pandas 1.3.5
parsedatetime 2.6
pgsanity 0.2.9
Pillow 9.4.0
pip 22.3.1
pkgutil_resolve_name 1.3.10
polyline 1.4.0
prison 0.2.1
prompt-toolkit 3.0.36
protobuf 3.20.1
pyarrow 5.0.0
pycparser 2.21
PyJWT 2.6.0
PyMeeus 0.5.12
PyMySQL 1.0.2
pyparsing 3.0.9
pyrsistent 0.19.3
PySocks 1.7.1
python-dateutil 2.8.2
python-dotenv 0.21.0
python-geohash 0.8.5
pytz 2022.7
PyYAML 6.0
redis 4.4.1
selenium 4.7.2
setuptools 56.0.0
simplejson 3.18.1
six 1.16.0
slackclient 2.5.0
sniffio 1.3.0
sortedcontainers 2.4.0
SQLAlchemy 1.3.24
SQLAlchemy-Utils 0.37.9
sqlparse 0.3.0
tabulate 0.8.9
trio 0.22.0
trio-websocket 0.9.2
typing-extensions 3.10.0.2
urllib3 1.26.13
vine 5.0.0
wcwidth 0.2.5
webencodings 0.5.1
Werkzeug 2.2.2
wsproto 1.2.0
WTForms 2.3.0
WTForms-JSON 0.3.5
yarl 1.8.2
zipp 3.11.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.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] sfirke commented on issue #22841: Timestamp formats diplayed as NaN:NaN:NaN
Posted by "sfirke (via GitHub)" <gi...@apache.org>.
sfirke commented on issue #22841:
URL: https://github.com/apache/superset/issues/22841#issuecomment-1674799666
@unicornis-pl are you able to test this issue in 3.0.0rc2 release candidate? I'm unable to reproduce it there, but I'm using a different data warehouse (MS SQL Server instead of your MySQL) so it would be nice to get confirmation that this has been fixed.
--
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 #22841: Timestamp formats diplayed as NaN:NaN:NaN
Posted by "villebro (via GitHub)" <gi...@apache.org>.
villebro commented on issue #22841:
URL: https://github.com/apache/superset/issues/22841#issuecomment-1465682886
What database engine is this happening on @unicornis-pl?
--
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] unicornis-pl commented on issue #22841: Timestamp formats diplayed as NaN:NaN:NaN
Posted by "unicornis-pl (via GitHub)" <gi...@apache.org>.
unicornis-pl commented on issue #22841:
URL: https://github.com/apache/superset/issues/22841#issuecomment-1674951019
I'll do it after my holiday
--
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] Shazad-khan commented on issue #22841: Timestamp formats diplayed as NaN:NaN:NaN
Posted by "Shazad-khan (via GitHub)" <gi...@apache.org>.
Shazad-khan commented on issue #22841:
URL: https://github.com/apache/superset/issues/22841#issuecomment-1472112717

It is working as expected please recheck it and close 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] unicornis-pl commented on issue #22841: Timestamp formats diplayed as NaN:NaN:NaN
Posted by "unicornis-pl (via GitHub)" <gi...@apache.org>.
unicornis-pl commented on issue #22841:
URL: https://github.com/apache/superset/issues/22841#issuecomment-1473519610
I will and I'll let you know. Thank you
--
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] Timestamp formats diplayed as NaN:NaN:NaN [superset]
Posted by "rusackas (via GitHub)" <gi...@apache.org>.
rusackas commented on issue #22841:
URL: https://github.com/apache/superset/issues/22841#issuecomment-1942490763
Closing this as stale since it's been silent for so long, and we're trying to steer toward a more actionable Issues backlog. If people are still encountering this in current versions (currently 3.x) please re-open this issue, open a new Issue with updated context, or raise a PR to address the problem. 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
Re: [I] Timestamp formats diplayed as NaN:NaN:NaN [superset]
Posted by "rusackas (via GitHub)" <gi...@apache.org>.
rusackas closed issue #22841: Timestamp formats diplayed as NaN:NaN:NaN
URL: https://github.com/apache/superset/issues/22841
--
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 #22841: Timestamp formats diplayed as NaN:NaN:NaN
Posted by "villebro (via GitHub)" <gi...@apache.org>.
villebro commented on issue #22841:
URL: https://github.com/apache/superset/issues/22841#issuecomment-1465687021
It appears the database is returning the timestamp in non standard string format. To make the table chart able to parse the date you should first convert it to ISO-8601 format (I assume there should be functions for this in MySQL).
--
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