Maximum Number of Rows per Load
Jim_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!
----------------------------
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!
0