dosubot[bot] commented on issue #32819: URL: https://github.com/apache/superset/issues/32819#issuecomment-2747846962
<!-- Greeting --> @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](https://dosu.dev), and I'm ready to assist you while you wait for a human maintainer. <!-- Answer --> 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: ```python 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 <sup>[[1]](https://github.com/apache/superset/blob/master/superset/databases/schemas.py)</sup><sup>[[2]](https://github.com/apache/superset/blob/master/superset-frontend/src/features/databases/UploadDataModel/index.tsx)</sup><sup>[[3]](https://github.com/apache/superset/blob/master/tests/unit_tests/commands/databases/csv_reader_test.py)</sup>. Note that the append operation is not supported in the current implementation, and attempting to use it will raise a `SupersetException` <sup>[[4]](https://github.com/apache/superset/blob/master/superset/db_engine_specs/hive.py)</sup>. <!-- Dosu Comment Footer --> *To continue talking to [Dosu](https://dosu.dev), mention @dosu.* --- <sup>Help Dosu learn! Give it feedback: [Great Response](https://app.dosu.dev/response-feedback/dcf967da-8b0f-4687-afeb-ac040af9a582?feedback_type=great_response) | [Irrelevant Answer](https://app.dosu.dev/response-feedback/dcf967da-8b0f-4687-afeb-ac040af9a582?feedback_type=irrelevant_answer) | [Incorrect Sources](https://app.dosu.dev/response-feedback/dcf967da-8b0f-4687-afeb-ac040af9a582?feedback_type=incorrect_sources) | [Too Verbose](https://app.dosu.dev/response-feedback/dcf967da-8b0f-4687-afeb-ac040af9a582?feedback_type=too_verbose) | [Hallucination](https://app.dosu.dev/response-feedback/dcf967da-8b0f-4687-afeb-ac040af9a582?feedback_type=hallucination) | [Bug Report](https://app.dosu.dev/response-feedback/dcf967da-8b0f-4687-afeb-ac040af9a582?feedback_type=bug_report) | [Other](https://app.dosu.dev/response-feedback/dcf967da-8b0f-4687-afeb-ac040af9a582?feedback_type=other)</sup> -- 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. To unsubscribe, e-mail: [email protected] For queries about this service, please contact Infrastructure at: [email protected] --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
