我的GP集群只有4台，一台mdw,一台备的sdw，两台segment节点，没有创建etl节点，生产中受网络，磁盘等影响，建议使用etl节点操作。
mdw:
一、在gpadmin家目录随便创建一个demo.txt
[gpadmin@gp-mdw ~]$ vi demo.txt
[gpadmin@gp-mdw ~]$ cat demo.txt
This|is|andyxi
GP|etl
[gpadmin@gp-mdw ~]$ pwd
/home/gpadmin
二、数据库中创建表
[gpadmin@gp-mdw 20221215]$ psql
psql (9.4.26)
Type "help" for help.
etl=# \dt+
List of relations
Schema | Name | Type | Owner | Storage | Size | Description
--------+------------+-------+---------+---------+---------+-------------
public | sales | table | gpadmin | heap | 64 kB |
public | t1 | table | gpadmin | heap | 1184 kB |
public | t2 | table | gpadmin | heap | 224 kB |
public | t3 | table | gpadmin | heap | 384 kB |
public | testdblink | table | gpadmin | heap | 288 kB |
(5 rows)
etl=# create table demo(c1 text,c2 text,c3 text);
NOTICE: Table doesn't have 'DISTRIBUTED BY' clause -- Using column named 'c1' as the Greenplum Database data distribution key for this table.
HINT: The 'DISTRIBUTED BY' clause determines the distribution of data. Make sure column(s) chosen are the optimal data distribution key to minimize skew.
CREATE TABLE
etl=# select * from demo;
c1 | c2 | c3
----+----+----
(0 rows)
etl=# \d demo;
Table "public.demo"
Column | Type | Modifiers
--------+------+-----------
c1 | text |
c2 | text |
c3 | text |
Distributed by: (c1)
三、创建扩展映射
etl=# create external table demo_ext(like demo) location('gpfdist://gp-mdw/demo.txt') format 'text' (delimiter '|');
CREATE EXTERNAL TABLE
etl=# \q
四、mdw开启gpdfist
[gpadmin@gp-mdw ~]$ gpfdist
2022-12-17 15:24:57 23569 INFO Before opening listening sockets - following listening sockets are available:
2022-12-17 15:24:57 23569 INFO IPV6 socket: [::]:8080
2022-12-17 15:24:57 23569 INFO IPV4 socket: 0.0.0.0:8080
2022-12-17 15:24:57 23569 INFO Trying to open listening socket:
2022-12-17 15:24:57 23569 INFO IPV6 socket: [::]:8080
2022-12-17 15:24:57 23569 INFO Opening listening socket succeeded
2022-12-17 15:24:57 23569 INFO Trying to open listening socket:
2022-12-17 15:24:57 23569 INFO IPV4 socket: 0.0.0.0:8080
2022-12-17 15:24:57 23569 INFO Opening listening socket succeeded
Serving HTTP on port 8080, directory /home/gpadmin
五、sdw验证
[root@gp-smdw ~]# curl -H "X-GP-PROTO: 0" 192.168.159.142:8080/demo.txt
This|is|andyxi
GP|etl
[root@gp-smdw ~]#
标签：24,15,GP,demo,57,23569,简单,gpadmin,gpfdist From： https://www.cnblogs.com/chinaops/p/16989057.html