The Vertica Forum recently got a makeover! Let us know what you think by filling out this short, anonymous survey.
Please take this survey to help us learn more about how you use third party tools. Your input is greatly appreciated!

Maximum Number of Rows per Load

Jim_KnicelyJim_Knicely - Select Field - Administrator

I’m often asked if there is a maximum number of rows that Vertica can load using the bulk loader COPY command. The answer to that question is “yes”, but the number is really, really big (i.e. 2^63)!

How big is that?

dbadmin=> SELECT TO_CHAR(2^63, '9,999,999,999,999,999,999') "Extremely BIG!";
       Extremely BIG!
(1 row)

Note that the number is actually 9,223,372,036,854,775,807 because that is the largest unsigned integer that Vertica can store in an INTEGER data type.

dbadmin=> CREATE TABLE int_test(c INT);

dbadmin=> INSERT INTO int_test SELECT 9223372036854775807;
(1 row)

dbadmin=> INSERT INTO int_test SELECT 9223372036854775808;
ERROR 5411:  Value exceeds range of type numeric(18,0)

Have fun!

Sign In or Register to comment.