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 2019/11/12 09:18:28 UTC
[GitHub] [incubator-superset] Sascha-Gschwind opened a new issue #8542:
Problem uploading CSV to PostgreSQL database
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:
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