tomwojcik edited a comment on issue #5202: Get an error unhashable type: 'dict' in a TableView with a NUMERIC type using PostgreSQL URL: https://github.com/apache/incubator-superset/issues/5202#issuecomment-399397623 I and a few others have the exact same problem. The same issue happens when I use a heatmap. Possibly related #4984 Pivot table ``` Traceback (most recent call last): File "/home/ubuntu/venv/lib/python3.5/site-packages/superset/views/core.py", line 1107, in generate_json payload = viz_obj.get_payload() File "/home/ubuntu/venv/lib/python3.5/site-packages/superset/viz.py", line 329, in get_payload payload['data'] = self.get_data(df) File "/home/ubuntu/venv/lib/python3.5/site-packages/superset/viz.py", line 628, in get_data margins=self.form_data.get('pivot_margins'), File "/home/ubuntu/venv/lib/python3.5/site-packages/pandas/core/frame.py", line 5303, in pivot_table margins_name=margins_name) File "/home/ubuntu/venv/lib/python3.5/site-packages/pandas/core/reshape/pivot.py", line 60, in pivot_table if i not in data: File "/home/ubuntu/venv/lib/python3.5/site-packages/pandas/core/generic.py", line 1519, in __contains__ return key in self._info_axis File "/home/ubuntu/venv/lib/python3.5/site-packages/pandas/core/indexes/base.py", line 2021, in __contains__ hash(key) TypeError: unhashable type: 'dict' 2018-06-22 10:33:24,148:INFO:werkzeug:195.82.165.141 - - [22/Jun/2018 10:33:24] "POST /superset/explore_json/ HTTP/1.1" 500 - ``` Heatmap traceback ``` Traceback (most recent call last): File "/home/ubuntu/venv/lib/python3.5/site-packages/superset/views/core.py", line 1107, in generate_json payload = viz_obj.get_payload() File "/home/ubuntu/venv/lib/python3.5/site-packages/superset/viz.py", line 329, in get_payload payload['data'] = self.get_data(df) File "/home/ubuntu/venv/lib/python3.5/site-packages/superset/viz.py", line 1801, in get_data df = df[[x, y, v]] File "/home/ubuntu/venv/lib/python3.5/site-packages/pandas/core/frame.py", line 2682, in __getitem__ return self._getitem_array(key) File "/home/ubuntu/venv/lib/python3.5/site-packages/pandas/core/frame.py", line 2726, in _getitem_array indexer = self.loc._convert_to_indexer(key, axis=1) File "/home/ubuntu/venv/lib/python3.5/site-packages/pandas/core/indexing.py", line 1314, in _convert_to_indexer indexer = check = labels.get_indexer(objarr) File "/home/ubuntu/venv/lib/python3.5/site-packages/pandas/core/indexes/base.py", line 3245, in get_indexer indexer = self._engine.get_indexer(target._ndarray_values) File "pandas/_libs/index.pyx", line 301, in pandas._libs.index.IndexEngine.get_indexer File "pandas/_libs/hashtable_class_helper.pxi", line 1544, in pandas._libs.hashtable.PyObjectHashTable.lookup TypeError: unhashable type: 'dict' 2018-06-22 10:27:07,098:INFO:werkzeug:195.82.165.141 - - [22/Jun/2018 10:27:07] "POST /superset/explore_json/ HTTP/1.1" 500 - ```
---------------------------------------------------------------- This is an automated message from the Apache Git Service. To respond to the message, please log on GitHub and use the URL above to go to the specific comment. For queries about this service, please contact Infrastructure at: [email protected] With regards, Apache Git Services --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
