Menu

#56 pg_bulkload not working with Postgres-XL

9.2rc
open
nobody
None
4
None
nobody
2015-03-21
2015-03-21
mason_s
No

Reported by Varun SS:

We are trying to load data into a cluster 4nodes lectures (1CN,3DN) . Its a huge data in the tunes of terabytes and hence decided to use pg_bulkload.
We were able to build and install the extension. But when we try to load data..

execute <unnamed>: SELECT * FROM pg_bulkload($1)
DETAIL: parameters: $1 = '{"infile=/home/qwewqe/qweqwe/wewqe/scripts/Test Cases/qweqwe/test10.csv",output=rdw.test

4:37:44 write(2, "NOTICE: BULK LOAD END\n\t0 Rows sk"..., 191NOTICE: BULK LOAD END
0 Rows skipped.
87600096 Rows successfully loaded.
0 Rows not loaded due to parse errors.
0 Rows not loaded due to duplicate errors.
0 Rows replaced with new rows.

But when we check the table rdw.test , it shows no data . tried all combination of Direct load, BUFFERED LOAD and Parallel load still it doest insert data.
However the utility always logs back success status and says data has been entered. When i check the data folder of coordinator i could find some I/O happening.

Discussion


Log in to post a comment.