Timester opened a new issue #3755: Table metadata autoload does not work on 
UTF-8 MySQL databses
URL: https://github.com/apache/incubator-superset/issues/3755
 
 
   ### Superset version
   0.20.4
   
   ### Expected results
   When I add a new table from a database that uses UTF-8 encoding, columns and 
metrics should be auto loaded.
   
   ### Actual results
   Adding a table is somewhat successful. It shows up on the tables list screen 
(but the 2 colored info banners are missing from the top (new row added, and I 
should edit the table now)). When I go to edit the table the columns and 
metrics lists are empty.
   
   After the table shows up on the tables list screen there are 3 rows in the 
logs:
   
   ```
   2017-11-01 08:51:28,586:ERROR:root:Expecting value: line 3 column 68 (char 
94)
   2017-11-01 08:51:28,617:ERROR:root:Expecting value: line 3 column 68 (char 
94)
   2017-11-01 08:51:28,617:ERROR:root:Expecting value: line 3 column 68 (char 
94)
    ```
   Adding tables from non utf8 schemas are working fine.
   
   ### Steps to reproduce
   Install Superset
   Add a new MySQL database that has a schema created like this:
   
   `CREATE DATABASE mydatabase CHARACTER SET utf8mb4 COLLATE 
utf8mb4_unicode_ci;`
   
   Connection string:
   
   `mysql://root:XXXXXXXXXX@mysql:3306/mydatabase?charset=utf8mb4`
   
   I have also tried to use just utf8 (for connection string), same results.
   
   

----------------------------------------------------------------
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

Reply via email to