Hi..please remove me also from the mailing list. Regards, Swethak On May 20, 2016 2:13 PM, "Will Wagner" <[email protected]> wrote:
> Hello, > > I requested 3 times already to be removed from the list. Emailing to > [email protected] > > Thank you, > Will > > Sent from Yahoo Mail on Android > <https://overview.mail.yahoo.com/mobile/?.src=Android> > > On Fri, May 20, 2016 at 10:50 AM, Shivram Mani > <[email protected]> wrote: > You can instead set Porfile=HdfsTextSimple insteado f setting > fragmenter,accessor and resolver. > > On Wed, May 18, 2016 at 1:47 AM, jin tao <[email protected]> wrote: > >> Thanks. >> >> resolved it by using the full java class path. >> >> the correct ddl: >> create external table test_pxf( >> a int, >> b char(1) >> ) >> LOCATION >> ('pxf://vb2.hdp:51200/tmpdata/test.csv?Fragmenter=org.apache.hawq.pxf.plugins.hdfs.HdfsDataFragmenter&ACCESSOR=org.apache.hawq.pxf.plugins.hdfs.LineBreakAccessor&Resolver=org.apache.hawq.pxf.plugins.hdfs.StringPassResolver')FORMAT >> 'CSV'(DELIMITER = E','); >> >> >> On 05/18/2016 03:02 PM, jin tao wrote: >> >>> Hi, >>> >>> I installed hawq 2.0 and pxf 3.0 in a cluster using ambari successfully. >>> 1 master,3 salves,4 pxf client on each machine. >>> While I use PXF to query data on hdfs,it >>> shows:java.lang.ClassNotFoundException: HdfsDataFragmenter. >>> the DDL is : >>> create external table test_pxf( >>> a int, >>> b char(1) >>> ) >>> LOCATION >>> ('pxf://vb2.hdp:51200/tmpdata/test.csv?Fragmenter=HdfsDataFragmenter&ACCESSOR=LineBreakAccessor&Resolver=TextResolver')FORMAT >>> 'CSV'(DELIMITER = E','); >>> >>> when I run: >>> postgres=# select * from test_pxf; >>> ERROR: remote component error (500) from '192.168.81.11:51200': type >>> Exception report message java.lang.ClassNotFoundException: >>> HdfsDataFragmenter description The server encountered an internal error >>> that prevented it from fulfilling this request. exception >>> javax.servlet.ServletException: java.lang.ClassNotFoundException: >>> HdfsDataFragmenter (libchurl.c:878) >>> >>> Pleas anyone could help me to fix this issue? >>> Thanks a lot. >>> >>> Bset regards! >>> >>> jin tao >>> >> >> > > > -- > shivram mani > >
