Maximum Number of Rows per Load: Quick Tip

Posted August 21, 2018 by Phil Molea, Sr. Information Developer, Vertica

Business Team Meeting Discussion Working Concept
Jim Knicely authored this tip. 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!