izetex opened a new issue #3337: Error in SQL Query results on Spatial columns URL: https://github.com/apache/incubator-superset/issues/3337 ### Superset version ### Expected results Results are rendered with spatial data. ### Actual results Error: 'utf8' codec can't decode byte 0xe6 in position 0: invalid continuation byte ### Steps to reproduce 1) create table in MySQL with spatial data https://dev.mysql.com/doc/refman/5.7/en/spatial-extensions.html 2) go to SQL query 3) select all columns from a table which has spatial data Trace: 2017-08-18 10:57:30,673:INFO:root:Fetching cursor description 2017-08-18 10:57:30,746:ERROR:root:'utf8' codec can't decode byte 0xe6 in position 0: invalid continuation byte Traceback (most recent call last): File "/usr/local/lib/python2.7/site-packages/superset/views/core.py", line 2071, in sql_json payload = json.dumps(data, default=utils.json_iso_dttm_ser) File "/usr/local/Cellar/python/2.7.13_1/Frameworks/Python.framework/Versions/2.7/lib/python2.7/json/__init__.py", line 251, in dumps sort_keys=sort_keys, **kw).encode(obj) File "/usr/local/Cellar/python/2.7.13_1/Frameworks/Python.framework/Versions/2.7/lib/python2.7/json/encoder.py", line 207, in encode chunks = self.iterencode(o, _one_shot=True) File "/usr/local/Cellar/python/2.7.13_1/Frameworks/Python.framework/Versions/2.7/lib/python2.7/json/encoder.py", line 270, in iterencode return _iterencode(o, 0) UnicodeDecodeError: 'utf8' codec can't decode byte 0xe6 in position 0: invalid continuation byte ---------------------------------------------------------------- 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: us...@infra.apache.org
With regards, Apache Git Services
