Implementing Analytics with Greenplum UAP - Getting Started with Greenplum for Big Data Analytics - page 107

//Greenplum database connection configurations
VERSION: 1.0.0.1
DATABASE: master
USER: master
PASSWORD: master
HOST: master
PORT: 5432
GPLOAD:
//Gpfdist configurations
INPUT:
- SOURCE:
LOCAL_HOSTNAME:
- master
PORT: 8082
FILE:
- /home/ master /SAMPLE.csv
//External table configurations
- COLUMNS:
- column1: numeric
- column2: text
- FORMAT: csv
- DELIMITER: ","
- ESCAPE: '/'
- NULL_AS: '/N'
- QUOTE: '"'
- ENCODING: 'utf8'
- ERROR_LIMIT: 5
- ERROR_TABLE: test.load_error
OUTPUT:
- TABLE: test.sample
- MODE: INSERT
PRELOAD:
The result is as shown:
[master@ master mdp]$ gpload -f test.yml
2013-08-03 14:52:19|INFO|gpload session started