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