Example: ORDER BY pushdown v2
This example shows ORDER BY pushdown between the foreign tables of the same remote HIVE/SPARK server as the remote HIVE/SPARK server.
Tables on HIVE/SPARK server:
Tables on Postgres server:
Enable/disable GUC for ORDER BY pushdown queries at the session level:
Note
You can also enable/disable ORDER BY pushdown at the server/table level using a GUC. For more information, see create server and create foreign table.