Bug description
How to reproduce the bug
- CSV upload file test_null.csv
- CSV upload file test_null.csv. Configure the settings as shown in the screenshot
Screenshots/recordings
No response
Superset version
4.1.1
Python version
3.9
Node version
I don't know
Browser
Chrome
Additional context
No response
Checklist
- [x] I have searched Superset docs and Slack and didn't find a solution to my problem.
- [x] I have searched the GitHub issue tracker and didn't find a similar bug report.
- [ ] I have checked Superset's logs for errors and if I found a relevant Python stacktrace, I included it here as text in the "additional context" section.
Comment From: dosubot[bot]
@KlyapkoV Hello! I'm here to help you with any bugs, questions, or contributions you have in mind. I'm an expert bot named Dosu, and I'm ready to assist you while you wait for a human maintainer.
To resolve the error when loading data from a CSV file with empty values in Superset version 4.1.1, ensure that the null_values field is correctly configured to treat "null" and "N/A" as null values. You can specify these values in the null_values field as follows:
null_values = ["null", "N/A"]
Additionally, make sure to select the appropriate options for null values in the Superset UI. Superset provides a nullValuesOptions configuration where you can select "null" and "N/A" as null values. Ensure these options are selected when setting up the CSV import in Superset. This will ensure that the specified strings are treated as null values during the data loading process [1][2][3].
Note that the append operation is not supported in the current implementation, and attempting to use it will raise a SupersetException [4].
To continue talking to Dosu, mention @dosu.
Help Dosu learn! Give it feedback: Great Response | Irrelevant Answer | Incorrect Sources | Too Verbose | Hallucination | Bug Report | Other
Comment From: sadpandajoe
@KlyapkoV do you have logs for the errors?