-
Notifications
You must be signed in to change notification settings - Fork 89
Open
Labels
questionFurther information is requestedFurther information is requested
Description
#Background
Currently we are using Cobrix with Databricks to read EBCDI files from Mainframe and convert them to Parquet. All is working fine. Some of the fields have Low values along with data in the Character/String fields. When we read the binary files they look like empty boxes. All is good till here.But when we load them to Postgres DB the load is failing as it is not able to recognize these characters.
Question
We can definitely write a spark code to replace these as Spaces or something else. But will like to know if Cobrix has any function which we can apply so that it can convert these unrecogniized characters to a Default Value?
Reactions are currently unavailable
Metadata
Metadata
Assignees
Labels
questionFurther information is requestedFurther information is requested