You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@hawq.apache.org by qiutongxin <42...@qq.com> on 2017/05/27 08:50:24 UTC
回复: pxf errors
hi,all
Query HDFS data error,but in pxf-public.classpath, i have added /soft/server/hawq/pxf/lib/pxf-hdfs-3.2.0.0.jar
postgres=# CREATE EXTERNAL TABLE pxf_hdfs_textsimple(location text, month text, num_orders int, total_sales float8)
LOCATION ('pxf://172.25.60.38:51200/data/pxf_examples/pxf_hdfs_simple.txt?PROFILE=HdfsTextSimple')
FORMAT 'TEXT' (delimiter=E',');
CREATE EXTERNAL TABLE
postgres=# SELECT * FROM pxf_hdfs_textsimple;
ERROR: remote component error (500) from '172.25.60.38:51200': type Exception report message java.lang.NoClassDefFoundError: Could not initialize class org.apache.hawq.pxf.plugins.hdfs.utilities.HdfsUtilities description The server encountered an internal error that prevented it from fulfilling this request. exception javax.servlet.ServletException: java.lang.NoClassDefFoundError: Could not initialize class org.apache.hawq.pxf.plugins.hdfs.utilities.HdfsUtilities (libchurl.c:897)
------------------ 原始邮件 ------------------
发件人: "Vineet Goel";<vv...@apache.org>;
发送时间: 2017年5月26日(星期五) 上午6:26
收件人: "user"<us...@hawq.incubator.apache.org>;
主题: Re: pxf errors
You could also try to test the external table DDL with a specific host and port number instead of of nameservice and see if that works. Ensure that PXF is installed on your NN host. See: https://hdb.docs.pivotal.io/220/hawq/pxf/PXFExternalTableandAPIReference.html
postgres=# CREATE EXTERNAL TABLE pxf_hdfs_testme(location text, month text, num_orders int, total_sales float8) LOCATION ('pxf://NN_host:51200/data/pxf_examples/pxf_hdfs_simple.txt?PROFILE=HdfsTextSimple') FORMAT 'TEXT' (delimiter=E',');
Thanks
-Vineet
On Thu, May 25, 2017 at 2:39 PM Alex (Oleksandr) Diachenko <od...@pivotal.io> wrote:
Hi,
Do you have your ns1 configured as a name service for HA HDFS?
Regards, Alex.
On Wed, May 24, 2017 at 11:48 PM, qiutongxin <42...@qq.com> wrote:
Hi,all
I use pxf to access HDFS File Data,but now there are some errors appear
postgres=# CREATE EXTERNAL TABLE pxf_hdfs_textsimple(location text, month text, num_orders int, total_sales float8) LOCATION ('pxf://ns1/data/pxf_examples/pxf_hdfs_simple.txt?PROFILE=HdfsTextSimple') FORMAT 'TEXT' (delimiter=E',');
CREATE EXTERNAL TABLE:
postgres=# select * from pxf_hdfs_textsimple;
ERROR: remote component error (0): (libchurl.c:897)
ns1 :hdfs HA namespace