Sascha-Gschwind opened a new issue #8542: Problem uploading CSV to PostgreSQL database URL: https://github.com/apache/incubator-superset/issues/8542 When you try to upload a CSV that has parentheses in the title column to a PostgreSQL database it fails with an error, showing the column title. If you upload the same file to a SQLite database it succeeds. ### Expected results The CSV can be successfully uploaded to a PostgreSQL database. ### Actual results The CSV can not be successfully uploaded to a PostgreSQL database. #### Screenshots CSV-Content:  Error displayed when uploading to a PostgreSQL database:  Database-Connection configuration:  Link to CSV: https://etherscan.io/chart/tx?output=csv #### How to reproduce the bug 1. As an Admin go to "Sources" > "Databases" and Create a new database connection. 2. Enter the connection string to a PostgreSQL database and ensure "Allow CSV Upload" is ticked 3. Go to "Sources" > "Upload a CSV" 4. Upload the CSV from https://etherscan.io/chart/tx?output=csv ### Environment - superset version: `0.999.0dev` (We are using the master-branch based on the commit `6d418308c734835b4b9257be32387d74f1a773a4`) - python version: `3.6.9` - node.js version: `v10.16.3` - npm version: `6.9.0` - PostgreSQL version: `PostgreSQL 11.2 (Debian 11.2-1.pgdg90+1)` ### 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.
---------------------------------------------------------------- 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: [email protected] With regards, Apache Git Services --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
