from_unixtime is also a Teiid system function, but is mapped to timestampadd early in planning. This leads to the exception you are seeing.
The workaround is to reference the impala function specifically:
We should be handling this better - by moving the mapping to timestamp add to later in planning so that sources can declare from_unixtime support. Do you want an issue for that?