We've a scenario that is working fine in vertica but erroring our in other system. In a file1 : few rows have line feed(i.e same as record terminator) with in data, Vertica is able to handle it but in other system it's erroring out. Can someone explain how vertica is handling this scenario?
My assumption is: Since its a fixedwidth file and the special char is within the specified record length vertica is treating that as 'with in data' and processing. Is it correct?
Sample data:
1216G780615615202012072020120720210106+000000000.00+000000000.00+000000000.00+000000000.00+000000006.36-000000002.42+000000003.94+000000000.02+000000000.00+000000000.00+000000000.02+000000000.00+000000000.00+000000000.00+000000000.00+000000000.00+000000000.00+000000000.00+000000002.58+000000000.00+000000000.00+000000000.00+000000002.60+000000006.54+000000000.00 +000000000.00+000000000.00+000000000.00+000000000.00+000000000.00+000000000.00+000000000.00+000000000.00+000000000.00+000000000.00+000000000.00+000000000.00+000000000.00+000000000.00+000000002.58+00000000002.5820203420AYV +000000000.00+000000000.00+000000000.00+000000000.00+000000000.00+000000000.00+000000000.00+000000000.00+000000000.00+000000000.00+000000000.00+000000000.00+000000000.00+000000000.00+000000000.00+000000000.00+000000000.00+000000000.00+000000000.00+000000000.00+000000000.00+000000000.008173 +000000000.00+000000000.00+000000000.00AYV 20210107 OH
Æ0+000000000.00AL +000000000.00+000000000.00BCED
FIXEDWIDTH COLSIZES (1,13,8,8,8,13,13,13,13,13,13,13,13,13,13,13,13,13,13,13,13,13,13,13,13,13,13,13,13,13,6,6,6,6,6,6,6,6,6,6,6,6,6,6,6,6,6,6,6,5,8,13,13,13,13,13,13,13,13,13,13,13,13,13,13,13,15,7,1,5,13,13,13,13,13,13,13,13,13,13,13,13,13,13,13,13,13,13,13,13,13,13,4,1,1,1,1,1,13,13,13,4,1,8,1,2,6,1,13,1,1,2,13,13,1,1,1,1,67)
The Linefeed is here at: "20210107 OH
Æ0+000000000.00AL +000000000.00+000000000.00BCED
"
Please share your inputs
