We're Moving!

The Vertica Forum is moving to a new OpenText Analytics Database (Vertica) Community.

Join us there to post discussion topics, learn about

product releases, share tips, access the blog, and much more.

Create My New Community Account Now


Error In Loading File of 2GB — Vertica Forum

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