ERROR：协议“gphdfs”不存在 [英] ERROR: protocol "gphdfs" does not exist

问题描述

when I

postgres=#   CREATE EXTERNAL TABLE csv_hdfs_lineitem (like a) LOCATION (
    'gphdfs://xxxxx/gptest/lineitem.csv'
) FORMAT 'text' (delimiter E'|' null E'\\N' escape E'off' fill missing fields)
ENCODING 'UTF8'
;

显示

it shows

ERROR：protocolgphdfs不存在

ERROR: protocol "gphdfs" does not exist

我想知道如何配置greenplum以支持gphdfs协议

I want to know how to configure greenplum to support gphdfs protocol

推荐答案

1. 您需要将hadoop客户端安装到所有gpdb节点并添加class_path


2. 安装2 guc，gp_hadoop_target_version和gp_hadoop_home指向hadoop发行版和二进制文件。
   
3. 重新启动gpdb
   
4. 授予协议访问gpadmin的权限。
li>

5. 尝试gphdfs外部表。

1. you need to install hadoop client to all gpdb nodes and add class_path
2. setup 2 guc, gp_hadoop_target_version and gp_hadoop_home pointing to the hadoop distribution and binary.
3. restart gpdb
4. grant protocol access to gpadmin.
5. try gphdfs external table.

有关详细信息，请查看以下链接

For detail, check the following link

http://gpdb.docs.pivotal.io/43110/admin_guide/load/topics/g-one-time-hdfs-protocol-installation.html#topic20

这篇关于ERROR：协议“gphdfs”不存在的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！