Example: LIMIT OFFSET pushdown v2
This example shows LIMIT OFFSET 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:
Query plan with LIMIT OFFSET pushdown:
Query execution:
Query plan with GUC for LIMIT OFFSET pushdown queries disabled at the session level (by default, LIMIT OFFSET pushdown is enabled):
Query execution:
Query plan with GUC for LIMIT OFFSET pushdown queries enabled at the session level:
Query execution: