Testing gpload utility in greenplum SNE env

Post date: May 03, 2013 9:37:46 PM

[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]$