Description
Currently, Spark DS V2 Top N push-down only supports order by column.
But the SQL show below is very useful and common.
SELECT CASE WHEN ("SALARY" > 8000.00) AND ("SALARY" < 10000.00) THEN "SALARY" ELSE 0.00 END AS key, dept, name FROM "test"."employee" ORDER BY key