Postgres source: UNION ALL preview fails; run succeeds

1 
  DATA_READ ERROR: Source 'local_postgres' returned error 'ERROR: syntax error at or near "UNION"

Position: 401’

plugin local_postgres
sql SELECT “care_site”.“care_site_id”, “care_site”.“care_site_name” COLLATE “C” AS “care_site_name”, “care_site”.“place_of_service_concept_id”, “care_site”.“location_id”, “care_site”.“care_site_source_value” COLLATE “C” AS “care_site_source_value”, “care_site”.“place_of_service_source_value” COLLATE “C” AS “place_of_service_source_value”
FROM “omop”.“care_site” OFFSET 0 ROWS FETCH NEXT 2000 ROWS ONLY
UNION ALL
SELECT “care_site”.“care_site_id”, “care_site”.“care_site_name” COLLATE “C” AS “care_site_name”, “care_site”.“place_of_service_concept_id”, “care_site”.“location_id”, “care_site”.“care_site_source_value” COLLATE “C” AS “care_site_source_value”, “care_site”.“place_of_service_source_value” COLLATE “C” AS “place_of_service_source_value”
FROM “synpuf”.“care_site” OFFSET 0 ROWS FETCH NEXT 2000 ROWS ONLY
SqlOperatorImpl JDBC_SUB_SCAN
Location 0:0:7
SqlOperatorImpl JDBC_SUB_SCAN
Location 0:0:7
Fragment 0:0

2

@paulhanke

Kindly send us the profile, it could be an issue with the pushdown. Alternatively, please try out external query feature where you can run the Postgres SQL directly without using ARP