GreenPlum中的gpload实用程序

问题描述

有人可以使用 greenplum 中的 gpload 实用程序帮助我吗？我是第一次这样做，我已经按照help命令创建了控制文件，但是出现了一些 gpfdist 连接错误。 gpload 实用程序上有任何参考资料或一些我可以参考的示例吗？

Can anyone help me with the gpload utility in greenplum? I am doing this for the first time, I have created the control file as per the help command, but getting some gpfdist connection error. Is there any reference material on gpload utility or some examples I can refer to?

使用gpload时出现以下错误：

I getting below error while using gpload:

2013-05-21 09:34:20|INFO|started gpfdist -p 9096 -P 9097 -f "gpload.test.txt" -t 30
"2013-05-21 09:34:23|ERROR|ERROR:  connection with gpfdist failed for gpfdist://<host-ip>:9096/gpload.test.txt. effective url: http://<host-ip>:9096/gpload.test.txt.  (seg43 slice1 sdw8:40001 pid=19336)"

我尝试做一些更改，但问题仍然存在。
预先感谢，
Sunny

I tried doing few changes but still the problem persist.Thanks in advance,Sunny

推荐答案

关键是要认识到gpload会执行以下操作：

The key is to recognize that gpload does the following:

1. 在运行gpload的侦听端口上启动gpfdist。


2. 使用以下命令创建一个外部表指定为gpfdist：//：/ filename
的位置

3. 执行以下或类似的sql插入select * from;

1. starts gpfdist on the listening on port where you are running gpload.
2. creates an external table with the location specified as gpfdist://:/filename
3. executes the following or similar sql insert into select * from ;

这将导致段连接到运行gpload的服务器。这要求段可以与gpload配置文件中指定的localhost联系。

This causes the segments to connect to the server where gpload is running. This requires that the localhost specified in the gpload config file can be contacted by the segments.

尝试从段之一对运行gpload的服务器执行ping操作。

Try to ping the server where gpload is running from one of the segments.

如果需要其他帮助，请发送.yml文件的副本。

Please send a copy of the .yml file if you need additional assistance.

您可以通过以下方式给我发送电子邮件：LWalstad @ goPivotal.com

You can email me at: [email protected]

这篇关于GreenPlum中的gpload实用程序的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！