export PGDATABASE=gptest
export PGHOST=127.0.0.1
export PGPORT=5432
export PGUSER=gpadmin
export PGPASSWORD=gpadmin
[gpadmin@zhaogh gpload]$ vim gpload
1 VERSION: 1.0.0.1
2 DATABASE: tmp_test1
3 USER: gpadmin
4 HOST: 127.0.0.1
5 PORT: 5432
6 GPLOAD:
7 INPUT:
8 - SOURCE:
9 LOCAL_HOSTNAME:
10 - mdw
11 PORT: 8082
12 FILE:
13 - /home/gpadmin/gpload/test.csv
14 - COLUMNS:
15 - id: int
16 - name: text
17 - FORMAT: text
18 - DELIMITER: ';'
19 - ERROR_LIMIT: 25
20 OUTPUT:
21 - TABLE: tmp_zgh_table
22 - MODE: INSERT
[gpadmin@zhaogh gpload]$ gpload -f gpload.yml
2013-09-20 15:27:14|INFO|gpload session started 2013-09-20 15:27:14
2013-09-20 15:27:14|INFO|started gpfdist -p 8082 -P 8083 -f "/home/gpadmin/gpload/test.csv" -t 30
2013-09-20 15:27:14|INFO|running time: 0.51 seconds
2013-09-20 15:27:14|INFO|rows Inserted = 4
2013-09-20 15:27:14|INFO|rows Updated = 0
2013-09-20 15:27:14|INFO|data formatting errors = 1
2013-09-20 15:27:14|INFO|gpload succeeded