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/01/02 19:37:39 UTC
[GitHub] [incubator-superset] kinghuang opened a new issue #8915: Unhashable
type error when adding a table
kinghuang opened a new issue #8915: Unhashable type error when adding a table
URL: https://github.com/apache/incubator-superset/issues/8915
I've added a Redshift database, and I'm trying to add a table. After I select the database and fill in the schema and table name, I get a `TypeError: unhashable type: 'list'` from Superset.
### Expected results
The table should be added.
### Actual results
A TypeError is raised.
#### Screenshots
```
2020-01-02 19:31:30,418:INFO:root:Database.get_sqla_engine(). Masked URL: redshift+psycopg2://XXXXXXXXXX:XXXXXXXXXX@XXXXXXXXXX:5439/XXXXXXXXXX
Got an error in pre_add for sa.invoice_detail
Traceback (most recent call last):
File "/usr/local/lib/python3.6/site-packages/superset/connectors/sqla/views.py", line 351, in pre_add
table.get_sqla_table_object()
File "/usr/local/lib/python3.6/site-packages/superset/connectors/sqla/models.py", line 964, in get_sqla_table_object
return self.database.get_table(self.table_name, schema=self.schema)
File "/usr/local/lib/python3.6/site-packages/superset/models/core.py", line 1161, in get_table
autoload_with=self.get_sqla_engine(),
File "<string>", line 2, in __new__
File "/usr/local/lib/python3.6/site-packages/sqlalchemy/util/deprecations.py", line 128, in warned
return fn(*args, **kwargs)
File "/usr/local/lib/python3.6/site-packages/sqlalchemy/sql/schema.py", line 506, in __new__
metadata._remove_table(name, schema)
File "/usr/local/lib/python3.6/site-packages/sqlalchemy/util/langhelpers.py", line 68, in __exit__
compat.reraise(exc_type, exc_value, exc_tb)
File "/usr/local/lib/python3.6/site-packages/sqlalchemy/util/compat.py", line 153, in reraise
raise value
File "/usr/local/lib/python3.6/site-packages/sqlalchemy/sql/schema.py", line 501, in __new__
table._init(name, metadata, *args, **kw)
File "/usr/local/lib/python3.6/site-packages/sqlalchemy/sql/schema.py", line 595, in _init
resolve_fks=resolve_fks,
File "/usr/local/lib/python3.6/site-packages/sqlalchemy/sql/schema.py", line 619, in _autoload
_extend_on=_extend_on,
File "/usr/local/lib/python3.6/site-packages/sqlalchemy/engine/base.py", line 2163, in run_callable
return conn.run_callable(callable_, *args, **kwargs)
File "/usr/local/lib/python3.6/site-packages/sqlalchemy/engine/base.py", line 1615, in run_callable
return callable_(self, *args, **kwargs)
File "/usr/local/lib/python3.6/site-packages/sqlalchemy/engine/default.py", line 460, in reflecttable
table, include_columns, exclude_columns, resolve_fks, **opts
File "/usr/local/lib/python3.6/site-packages/sqlalchemy/engine/reflection.py", line 642, in reflecttable
table_name, schema, **table.dialect_kwargs
File "/usr/local/lib/python3.6/site-packages/sqlalchemy/engine/reflection.py", line 369, in get_columns
self.bind, table_name, schema, info_cache=self.info_cache, **kw
File "<string>", line 2, in get_columns
File "/usr/local/lib/python3.6/site-packages/sqlalchemy/engine/reflection.py", line 50, in cache
ret = info_cache.get(key)
TypeError: unhashable type: 'list'
```
#### How to reproduce the bug
1. Go to Sources → Tables.
2. Click on + (Add a new record).
3. Fill in the database, schema, and table name. Press Save.
4. See error.
### Environment
(please complete the following information):
- superset version: Superset 0.35.1
- python version: Python 3.6.10
- node.js version: none
- npm version: none
### 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
None.
----------------------------------------------------------------
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
With regards,
Apache Git Services
---------------------------------------------------------------------
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 #8915:
Unhashable type error when adding a table
Posted by GitBox <gi...@apache.org>.
issue-label-bot[bot] commented on issue #8915: Unhashable type error when adding a table
URL: https://github.com/apache/incubator-superset/issues/8915#issuecomment-570318299
Issue-Label Bot is automatically applying the label `#bug` to this issue, with a confidence of 0.94. 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
With regards,
Apache Git Services
---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org
[GitHub] [incubator-superset] kinghuang closed issue #8915: Unhashable type
error when adding a table
Posted by GitBox <gi...@apache.org>.
kinghuang closed issue #8915: Unhashable type error when adding a table
URL: https://github.com/apache/incubator-superset/issues/8915
----------------------------------------------------------------
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
With regards,
Apache Git Services
---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org
[GitHub] [incubator-superset] kinghuang commented on issue #8915: Unhashable
type error when adding a table
Posted by GitBox <gi...@apache.org>.
kinghuang commented on issue #8915: Unhashable type error when adding a table
URL: https://github.com/apache/incubator-superset/issues/8915#issuecomment-570330940
It appears this issue was introduced by a change in sqlalchemy 1.3.11 that impacts sqlalchemy-redshift. I'm able to work around it by temporarily downgrading to sqlalchemy 1.3.10.
https://github.com/sqlalchemy/sqlalchemy/issues/4984
----------------------------------------------------------------
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
With regards,
Apache Git Services
---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org