Skip to content

Latest commit

 

History

History
38 lines (37 loc) · 1.37 KB

README.md

File metadata and controls

38 lines (37 loc) · 1.37 KB
Raw

JDBCBulkInsert

See Pivotal Blog for more info
Building

mvn package

Create table

gpadmin=# create table jdbc_load (a text, b text, c text, d text, e text );
CREATE TABLE

Create a TAB delimited file in /tmp/test.txt

lksdfd	slkdfjds	klsdjfwo	sodifjds	fdlksjfew
lksdfd	slkdfjds	klsdjfwo	sodifjds	fdlksjfew
lksdfd	slkdfjds	klsdjfwo	sodifjds	fdlksjfew
lksdfd	slkdfjds	klsdjfwo	sodifjds	fdlksjfew
lksdfd	slkdfjds	klsdjfwo	sodifjds	fdlksjfew
lksdfd	slkdfjds	klsdjfwo	sodifjds	fdlksjfew
lksdfd	slkdfjds	klsdjfwo	sodifjds	fdlksjfew
lksdfd	slkdfjds	klsdjfwo	sodifjds	fdlksjfew
lksdfd	slkdfjds	klsdjfwo	sodifjds	fdlksjfew
lksdfd	slkdfjds	klsdjfwo	sodifjds	fdlksjfew
lksdfd	slkdfjds	klsdjfwo	sodifjds	fdlksjfew
lksdfd	slkdfjds	klsdjfwo	sodifjds	fdlksjfew
lksdfd	slkdfjds	klsdjfwo	sodifjds	fdlksjfew
lksdfd	slkdfjds	klsdjfwo	sodifjds	fdlksjfew
lksdfd	slkdfjds	klsdjfwo	sodifjds	fdlksjfew

Exectuing copy

[gpadmin@hdm1 ~]$ /usr/java/default/bin/java -classpath JDBCBulkInsert-1.0-jar-with-dependencies.jar io.pivotal.support.JDBCBulkInsert "jdbc:postgresql://localhost:5432/gpadmin" gpadmin gpadmin /tmp/test.txt jdbc_load;
~# Loading Driver org.postgresql.Driver
~# connecting to database with url jdbc:postgresql://localhost:5432/gpadmin
~# reading in file /tmp/test.txt
~# COPY operation completed successfully