SELECT on AVRO causing PXF server error : java.lang.NullPointerException

Products

• VMware Tanzu Data Suite
• VMware Tanzu Greenplum
• VMware Tanzu Greenplum / Gemfire

Issue/Introduction

SELECT statement on a external table defined on an AVRO format data file hosted on Hadoop/HDFS resulting into below error -

2025-10-31 22:12:05.054633 UTC,"gpadmin","dbname",p239987,th1774454912,"[local]",,2025-10-31 22:11:52 UTC,0,con6240921,cmd3,seg-1,,,,sx1,"ERROR","08000","PXF server error : java.lang.NullPointerException  (seg540 slice1 10.x.222.x:40000 pid=230880)",,"Check the PXF logs located in the '/usr/local/pxf-gp6/logs' directory on host 'localhost' or 'set client_min_messages=LOG' for additional details.",,,"External table table01_ext","select * from public.table01_ext;",0,,"libchurl.c",1067,"Stack trace:
1    0xc0ad97 postgres errstart (elog.c:557)
2    0xc0e1c5 postgres ThrowErrorData (elog.c:1990)
3    0xcb0bba postgres CdbDispatchHandleError (cdbdisp.c:280)
4    0x8e1661 postgres mppExecutorCleanup (execUtils.c:2272)
5    0x8c5852 postgres standard_ExecutorRun (execMain.c:1190)
6    0x8c5915 postgres ExecutorRun (execMain.c:992)
7    0xaa54a7 postgres <symbol not found> (pquery.c:1174)
8    0xaa7581 postgres PortalRun (pquery.c:1021)
9    0xaa13e0 postgres <symbol not found> (postgres.c:1857)
10   0xaa45f4 postgres PostgresMain (postgres.c:5338)

 

Environment

Greenplum Database all versions

PXF all versions

Hadoop all versions

Resolution

This issue is identified as a bug and will be fixed in PXF release 6.11.3