Maximum Number of Rows per Load

Jim_KnicelyJim_Knicely Employee, Registered User, VerticaExpert

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!
----------------------------
  9,223,372,036,854,775,808
(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);
CREATE TABLE

dbadmin=> INSERT INTO int_test SELECT 9223372036854775807;
OUTPUT
--------
      1
(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.