[sachi@sachi mdp]$ cat test.yml %YAML 1.1 --- VERSION: 1.0.0.1 DATABASE: sachi USER: sachi PASSWORD: sachi HOST: sachi PORT: 5432 GPLOAD: INPUT: - SOURCE: LOCAL_HOSTNAME: - sachi PORT: 8082 FILE: - /home/sachi/dia1data1/REGIONS.csv - COLUMNS: - region_id: numeric - region_name: text - FORMAT: csv - DELIMITER: "," - ESCAPE: '/' - NULL_AS: '/N' - QUOTE: '"' - ENCODING: 'utf8' - ERROR_LIMIT: 5 - ERROR_TABLE: sachi.ext_regions_error OUTPUT: - TABLE: sachi.regions - MODE: INSERT PRELOAD: [sachi@sachi mdp]$ gpload -f test.yml 2013-05-03 14:52:19|INFO|gpload session started 2013-05-03 14:52:19 2013-05-03 14:52:19|INFO|started gpfdist -p 8082 -P 8083 -f "/home/sachi/dia1data1/REGIONS.csv" -t 30 2013-05-03 14:52:19|INFO|running time: 0.25 seconds 2013-05-03 14:52:19|INFO|rows Inserted = 4 2013-05-03 14:52:19|INFO|rows Updated = 0 2013-05-03 14:52:19|INFO|data formatting errors = 0 2013-05-03 14:52:19|INFO|gpload succeeded [sachi@sachi mdp]$ |