Teiid's DAYOFWEEK function:
is pushed down as:
but this function returns string representation of the day.
More appropriate would be to push DAYOFWEEK as WEEKDAY function, but the returned value has to be adapted to Teiid's representation (Sunday=1 and Saturday=7, vs. HANA's Monday=0,Sunday=6). So the solution would be to push: