Description
Currently, Spark DS V2 aggregate push-down only supports group 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, SUM("SALARY") FROM "test"."employee" GROUP BY key