[ https://issues.apache.org/jira/browse/HAWQ-1427?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Shivram Mani reassigned HAWQ-1427: ---------------------------------- Assignee: Shivram Mani (was: Ed Espino) > PXF JSON Profile lang3 dependency error > --------------------------------------- > > Key: HAWQ-1427 > URL: https://issues.apache.org/jira/browse/HAWQ-1427 > Project: Apache HAWQ > Issue Type: Bug > Components: PXF > Reporter: Shivram Mani > Assignee: Shivram Mani > > Issue with querying JSON data with PXF > Getting the following error > ``` > ERROR: remote component error (500) from '10.101.170.74:51200': type > Exception report message java.lang.Exception: > java.lang.NoClassDefFoundError: org/apache/commons/lang3/StringUtils > description The server encountered an internal error that prevented it from > fulfilling this request. exception javax.servlet.ServletException: > java.lang.Exception: java.lang.NoClassDefFoundError: > org/apache/commons/lang3/StringUtils (libchurl.c:897) (seg9 > AYCAPSU01TS205:40000 pid=500623) (dispatcher.c:1801) > ``` > We solved it by manually adding `/usr/local/lib/commons-lang3-3.1.jar` on > Advanced pxf-public-classpath through Ambari. We were also to reproduce it > internally just by following the example from the documentation > (http://hdb.docs.pivotal.io/212/hawq/pxf/JsonPXF.html). > Also noticed the libraries loaded for pxf-service are 2.6 instead: > ```[root@hdp1 ~]# pgrep -fl pxf-service | cut -f1 -d' ' | xargs lsof -p | > grep commons-lang > java 372246 pxf mem REG 8,2 284220 1319168 > /usr/hdp/2.5.0.0-1245/hadoop/lib/commons-lang-2.6.jar > java 372246 pxf 62r REG 8,2 284220 1319168 > /usr/hdp/2.5.0.0-1245/hadoop/lib/commons-lang-2.6.jar > ``` > So for some reason PXF needs `commons-lang3-3.1.jar`? -- This message was sent by Atlassian JIRA (v6.3.15#6346)