1 VERSION: 1.0.0.1
2 DATABASE: tmp_test1
3 USER: gpadmin
4 HOST: 127.0.0.1
5 PORT: 5432
6 GPLOAD:
7 INPUT:
8 - SOURCE:
9 LOCAL_HOSTNAME:
10 - mdw
11 PORT: 8084
12 FILE:
13 - /home/gpadmin/gpload/code_month.csv
14 - COLUMNS:
15 - FORMAT: csv 这为text是报错(原因是csv文件件中decimal字段出有“”号)
16 - DELIMITER: ','
17 - QUOTE: '"'
18 - ERROR_LIMIT: 25
19 OUTPUT:
20 - TABLE: code_month2
21 - MODE: INSERT
转载于:https://blog.51cto.com/bad51men/1311219