Please take this survey to help us learn more about how you use third party tools. Your input is greatly appreciated!

Need help on how vertica is handling LINEFEED in below FIXEDWIDTH file

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

Answers

Leave a Comment

BoldItalicStrikethroughOrdered listUnordered list
Emoji
Image
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file

Can't find what you're looking for? Search the Vertica Documentation, Knowledge Base, or Blog for more information.