This release includes the following:
Features:
-
Push down ORDER BY to remote hdfs servers.
If possible, consider a path that adds the ORDER BY clause to the remote SQL so that we get the ordered result set from the foreign server itself. It might help us to have an efficient merge join. -
Push down LIMIT/OFFSET to remote hdfs servers.
Wherever applicable, perform LIMIT and OFFSET operations on the remote server. This reduces network traffic between local PostgreSQL and remote HDFS servers.