Please take this survey to help us learn more about how you use third party tools. Your input is greatly appreciated!
Error with executing a copy command on a ascii 29 delimited file
Hi All,
I am getting this error executing the copy command in VSQL commandline below. Please let me know your thoughts.Thanks
copy sample.temp_full from local 'test.txt' delimiter E'\029'.
ERROR 2730. COPY delimiter must be a single character
I am getting this error executing the copy command in VSQL commandline below. Please let me know your thoughts.Thanks
copy sample.temp_full from local 'test.txt' delimiter E'\029'.
ERROR 2730. COPY delimiter must be a single character
0
Leave a Comment
Can't find what you're looking for? Search the Vertica Documentation, Knowledge Base, or Blog for more information.
Comments
I am using the following command now and it works fine: copy sample.temp_full from local 'test.txt' delimiter E'\035'
I am glad it worked out well.
Regards,
Bhawana