+ CentOs7 to Linux Alma 9 upgrade on few of the Hadoop Data Nodes.
+ This issue is only observed with PXF queries reading from ORC files in Hadoop and writing to Greenplum tables failing with below listed error, but other format like AVRO/text not failing.
2025-05-06 02:55:43.071 UTC ERROR [1742664020-0004741715:heds2:981] 26667 --- [onse-15012] o.g.p.s.c.PxfErrorReporter : Problem reading file footer hdfs://name2-ord-hdw-prod/default/hive/warehouse/my.db/mytable/partition_start_date=20250505/partition_end_date=20250505/dtm_id0_flag=0/source_code=rtbnobid/partition_region_id=1/part-00001-1110700a-5b86-4b01-8262-f33625fd074e.c000.zlib.1746435600000.orcGPDB 6.28.1
PXF 6.11
OS Linux Alma 9
Libraries were complied for incorrect environment was the cause.
Re-compiled the libraries with the correct environment, and the issue has not occurred since that time.