Casting any value obtained from an Osisoft PI datasource results in NULL, regardless of the original value.
E.g. a query such as
returns result set full of NULLs.
The SOURCE SRC COMMAND in teiid-command.log for this query is however
i.e. the cast is not pushed down (as Osisoft doesn't support bigdecimal datatype).