Search code examples
greenplum

How to use gpload utility?

I have YAML file below:

---
VERSION: 1.0.0.1
DATABASE: xxx
USER: xxx
HOST: xxx
PORT: 5432
GPLOAD:
   INPUT:
    - SOURCE:
         LOCAL_HOSTNAME: 
           - 192.168.0.21
         PORT: 8081
         FILE: 
           - /home/root/test_input.txt
    - COLUMNS:
           - age: int4
           - name: varchar
           - surname: varchar
    - FORMAT: text
    - DELIMITER: '|'
    - ERROR_LIMIT: 2
    - LOG_ERRORS: true
   OUTPUT:
    - TABLE: sf_dfs.test_gpload
    - MODE: INSERT
   PRELOAD:
    - REUSE_TABLES: true

But i recieve a error: error when connecting to gpfdist http://192.168.0.21:8081//home/root/test_input.txt, quit after 11 tries (seg0 slice1 192.168.0.23:6000 pid=2021845) encountered while running INSERT INTO

Maybe somebody have experience about this program?

Solution

  • Looks like it is a port issue. If the database is up then please rerun the job with different port. Ensure that firewall is not blocking this port.