Pivotal Knowledge Base

Follow

Query Hive HCatalog via PXF failed with "ERROR: type Exception report message Unable to find output format by given class name"

Environment

HDB 2.2.0

Symptom

When attempting to query Hive HCatalog via PXF, it fails with following errors.

Error Message:

gpadmin=# SELECT * FROM hcatalog.default.users; 
ERROR: remote component error (500) from '10.0.0.1:51200': type Exception report message Unable to find output format by given class name: null description The server encountered an internal error that prevented it from fulfilling this request. exception org.apache.hawq.pxf.api.UnsupportedTypeException: Unable to find output format by given class name: null (libchurl.c:897) 
LINE 1: SELECT * FROM hcatalog.default.users; 

HDB logs regarding this error:

2017-08-02 03:14:36.469858 EDT,"gpadmin","gpadmin",p236393,th-1787639296,"[local]",,2017-08-02 03:04:29 EDT,200332,con19346,cmd4,seg-10000,,,x200332,sx1,"ERROR","XX000","remote component error (500) from '10.0.0.1:51200': type Exception report message Unable to find output format by given class name: null description The server encountered an internal error that prevented it from fulfilling this request. exception org.apache.hawq.pxf.api.UnsupportedTypeException: Unable to find output format by given class name: null (libchurl.c:897)",,,,,,"SELECT * FROM hcatalog.default.users;",15,,"libchurl.c",897,"Stack trace: 
1 0x8c4fe8 postgres errstart + 0x288 
2 0x8c6d6b postgres elog_finish + 0xab 
3 0x5139f6 postgres check_response_code + 0x186 
4 0x513ba6 postgres churl_read_check_connectivity + 0x16 
5 0x518fe9 postgres <symbol not found> + 0x518fe9 
6 0x5191f6 postgres call_rest + 0x46 
7 0x517d3a postgres <symbol not found> + 0x517d3a 
8 0x518700 postgres get_external_metadata + 0x40 
9 0x515887 postgres get_pxf_item_metadata + 0xe7 
10 0x57817f postgres RangeVarGetRelid + 0xbf 
11 0x4c9425 postgres CdbOpenRelationRv + 0x25 
12 0x5d4976 postgres <symbol not found> + 0x5d4976 
13 0x5d5a83 postgres addRangeTableEntry + 0xe3 
14 0x5c6246 postgres <symbol not found> + 0x5c6246 
15 0x5c7178 postgres transformFromClause + 0x68 
16 0x59b6f0 postgres <symbol not found> + 0x59b6f0 
17 0x5a8489 postgres <symbol not found> + 0x5a8489 
18 0x5a9e0e postgres <symbol not found> + 0x5a9e0e 
19 0x5aa14d postgres parse_analyze + 0x3d 
20 0x7e8353 postgres <symbol not found> + 0x7e8353 
21 0x7e9af0 postgres PostgresMain + 0xe00 
22 0x79cf68 postgres <symbol not found> + 0x79cf68 
23 0x79fd49 postgres PostmasterMain + 0x759 
24 0x4a4b69 postgres main + 0x519 
25 0x7f72913e2b35 libc.so.6 __libc_start_main + 0xf5 
26 0x4a4be6 postgres <symbol not found> + 0x4a4be6

Cause

The post-install procedure is not followed, so that outputFormat is not configured in pxf-profiles.xml.

Resolution

Follow the "Post-Install Procedure for HDB 2.2.0" as listed in the HDB Doc to resolve this issue.

Additional Information

 

Comments

Powered by Zendesk