SAP HANA doesn't support FLOOR and CEILING functions for BOOLEAN type.
Compared to postgresql, which also has BOOLEAN data type, it seems inconsistent.
When querying postgres directly:
is not valid query.
But through Teiid, it returns double values corresponding to the boolean value provided:
0.0 for CEILING(false)
1.0 for CELING(true)