I have enabled data replication from an Oracle database to a Hive database.
I have a data replication problem for tables that in the source DB have BLOB columns that contain XML files.
The data is reported incorrectly in the target db because the carriage returns (\r\n) defined in the XML file are dirty.
In practice, if you capture 1 row of the source table in the Hive target database I have 23 lines:
source data:
I did some tests:
MAP XDM.SYSINT_REMIT_TABLE4, target DL_XDMGAS.SYSINT_REMIT_TABLE4, COLMAP (usedefaults, day = @DATE ('YYYY-MM-DD', 'YYYY-MM-DD', @GETENV ('GGHEADER', 'COMMITTIMESTAMP')), XML_FILE = @STRSUB (XML_FILE, '\x10 + \x13', '')) KEYCOLS (ID_REMIT_TABLE4);
without success.
Can you give me a hint to solve the problem?