How to set an ASCII or non printable character as DELIMITER
Posted: Thu Sep 12, 2013 11:52 am
I need to COPY data from SQL Server to Vertica. I need to delimit the records with an unique non printable, non-keyboard character to ensure the same doesn't exists in the data.
As per Vertica docs - "A single ASCII character that separates columns within each record of a file. The default in HP Vertica is a vertical bar (|). You can use any ASCII value in the range E'\000' to E'\177' inclusive. You cannot use the same character for both the DELIMITER and NULL options."
Kindly provide me with an example on how to set an ASCII charcater as delimiter.
As per Vertica docs - "A single ASCII character that separates columns within each record of a file. The default in HP Vertica is a vertical bar (|). You can use any ASCII value in the range E'\000' to E'\177' inclusive. You cannot use the same character for both the DELIMITER and NULL options."
Kindly provide me with an example on how to set an ASCII charcater as delimiter.