pv
# import to vertica zcat data.sql | pv -s 16986105538 -p -t -r | vsql ALTER TABLE 0:13:56 [4.22MB/s] [==============> ] 14%
More http://linux.die.net/man/1/pv
I used it for import PostgreSQL dump file to Vertica
cat data2.sql | sed "s/FROM stdin/FROM LOCAL stdin DIRECT DELIMITER E'\\\t'/g" | pv -t -p -a -b -s 125494564903 | vsql
No comments:
Post a Comment