Testing gpload utility in greenplum SNE env

posted Apr 28, 2017, 4:14 PM by Sachchida Ojha
[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]$ 
Comments