We have migrated to new Google sites!
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]$