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

Error In Loading File of 2GB

Hi All

I have created following Table and faced an error 

Create Table Reference(col1 varchar(20) , col2 integer ,col3 varchar(20) );

 copy Reference  from '/home/dbadmin/Reference.txt' delimiter '|';

Then I have faced the Following error 

ERROR 2344:  Cannot allocate sufficient memory for COPY statement (536870912 requested, 268435456 permitted)
HINT:  This can happen if you have very wide rows, or if you have specified an incorrect record terminator.  (Check your escaping -- for example, "'    '" is not a tab; you must use "E'       '".)

Note :My reference.txt file is 2gb large and it is delimited with '|' 

Can anyone Help 

Comments

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.