framework/resources/Functional/union/union_51.sql

(SELECT c2 FROM `union_01.parquet` ORDER BY c5 DESC nulls first) UNION (SELECT c2 FROM `union_02.parquet` ORDER BY c5 ASC nulls first);