I'm Vertica Community Editions 6.0 (i downloaded it a couple days ago) with default settings.
I'm trying to import data from CSV file which was created from MySQL using "select field_list into outfile 'file/name' from table".
I'm using the following command to import data from file to Vertica
Code: Select all
COPY hl.data(array_of_fields) FROM '/home/dbadmin/dev/data.sql' DELIMITER E'\t';
I tried:
- read man (i thought there is some restrictions);
- i increased wosdata/sysdata.maxmemorysize up to 20G;
- If I'm trying to import the rest of file (head | tail) on each iteration Vertica takes the smaller amount of rows (3.1 -> 1.8 -> 1.2 -> 0.8 and I stopped);
- importing the same data to MySQL is fine.
Could someone please explain what I'm doing wrong?
thanks in advance.