You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
We are migrating over from Postgres/Greenplum where, when importing from CSV file, we are able to specify that a blank entry represent null, but a blank quoted string is an empty string. I cannot replicate this behaviour with Databend, but would very much like to. I have tried many combinations of the EMPTY_FIELD_AS and NULL_DISPLAY but I cannot get the same as the Postgres import.
The ability to differentiate between blank entry and empty string would be very useful to us.
We receive CSVs from upstream customer systems that we have no control over. For the most part NULL is the correct default. However, there are real world situations where a blank string has a different meaning than null.
We are migrating over from Postgres/Greenplum where, when importing from CSV file, we are able to specify that a blank entry represent null, but a blank quoted string is an empty string. I cannot replicate this behaviour with Databend, but would very much like to. I have tried many combinations of the
EMPTY_FIELD_AS
andNULL_DISPLAY
but I cannot get the same as the Postgres import.The ability to differentiate between blank entry and empty string would be very useful to us.
CSV Data:
Postgres Import
Result
Databend Import
Result
The text was updated successfully, but these errors were encountered: