The Vertica Forum recently got a makeover! Let us know what you think by filling out this short, anonymous survey.

Maximum Number of Rows per Load

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.

Can't find what you're looking for? Search the Vertica Documentation, Knowledge Base, or Blog for more information.