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/07 21:17:29 UTC
[GitHub] [incubator-superset] kalkrishnan opened a new issue #10008: Error while querying jsob column from postgres
kalkrishnan opened a new issue #10008:
URL: https://github.com/apache/incubator-superset/issues/10008
While querying jsonb columns from a postgres database, I get an exception.
### Expected results
The json value stored in the column
### Actual results
I get the below exception:
postgresql error: name 'isinstance' is not defined
#### Screenshots
If applicable, add screenshots to help explain your problem.
#### How to reproduce the bug
1. Connect to a postgres database
2. select a jsonb column from a table
3. Scroll down to results
4. See error postgresql error: name 'isinstance' is not defined
### Environment
(please complete the following information):
Superset 0.35.2
Python 3.6.9
No node or npm
### Checklist
Make sure these boxes are checked 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
Logs:
ERROR:root:Query 199: name 'isinstance' is not defined
Traceback (most recent call last):
File "/home/superset/.virtualenvs/superset/lib/python3.6/site-packages/superset/sql_lab.py", line 236, in execute_sql_statement
data = db_engine_spec.fetch_data(cursor, query.limit)
File "/home/superset/.virtualenvs/superset/lib/python3.6/site-packages/superset/db_engine_specs/postgres.py", line 52, in fetch_data
return cursor.fetchall()
File "/home/superset/.virtualenvs/superset/lib/python3.6/site-packages/psycopg2/_json.py", line 167, in typecast_json
return loads(s)
File "/usr/lib/python3.6/json/__init__.py", line 341, in loads
if isinstance(s, str):
NameError: name 'isinstance' is not defined
----------------------------------------------------------------
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] kalkrishnan commented on issue #10008: Error while querying jsob column from postgres
Posted by GitBox <gi...@apache.org>.
kalkrishnan commented on issue #10008:
URL: https://github.com/apache/incubator-superset/issues/10008#issuecomment-646687035
Any updates on this?
----------------------------------------------------------------
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 #10008: Error while querying jsob column from postgres
Posted by GitBox <gi...@apache.org>.
stale[bot] commented on issue #10008:
URL: https://github.com/apache/incubator-superset/issues/10008#issuecomment-678677925
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
[GitHub] [incubator-superset] issue-label-bot[bot] commented on issue #10008: Error while querying jsob column from postgres
Posted by GitBox <gi...@apache.org>.
issue-label-bot[bot] commented on issue #10008:
URL: https://github.com/apache/incubator-superset/issues/10008#issuecomment-640281318
Issue-Label Bot is automatically applying the label `#bug` to this issue, with a confidence of 0.84. 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] closed issue #10008: Error while querying jsob column from postgres
Posted by GitBox <gi...@apache.org>.
stale[bot] closed issue #10008:
URL: https://github.com/apache/incubator-superset/issues/10008
----------------------------------------------------------------
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