Hadoop Foreign Data Wrapper 2.3.0 release notes v2

Released: 06 Jan 2023

Enhancements, bug fixes, and other changes in Hadoop Foreign Data Wrapper 2.3 include:

TypeDescription
FeatureWhen possible, we push the ORDER BY clause to the remote server. This approach provides the ordered result set from the foreign server, which can help to enable an efficient merge join.
FeaturePush down LIMIT/OFFSET to remote HDFS servers: Where possible, perform LIMIT and OFFSET operations on the remote server. This reduces network traffic between local Postgres and remote HDFS/Hive servers.