Skip to content

Low Values in Binary Data #835

@pinakigit

Description

@pinakigit

#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?

Metadata

Metadata

Assignees

No one assigned

    Labels

    questionFurther information is requested

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions