I have a small csv file I would like to bulk load into a Vertica 6.1 database table, this file has 92 lines.
dbadmin=> COPY games FROM '/tmp/games.csv' DELIMITER ','; Rows Loaded ------------- 44
The file is 92 lines, but Vertica only loads 44 lines. As a test, I tried loading the same file in MySQL, and all 92 lines loaded fine.
I verified the file has 92 lines.
[root@localhost tmp]# cat /tmp/games.csv | wc -l 92
I opened the file and verified it has no unusual characters.