Pushdown optimization to the source stops at the partition point <transformation name> because an upstream Sorter transformation is not properly partitioned on the distinct sort key.
You configured a sort key for the upstream Sorter transformation that is different from the partition key specified for the key-range partition. The sort key and partition key must match.
Configure the sort key and partition key to match.