9 Replies Latest reply: Apr 16, 2012 10:02 AM by Steven Hawkins RSS

Properly registering functions for pushdown in the translator

Mark Addleman Expert

I've got a custom translator (same as before:  direct subclass of JdbcExecutionFactory).  The underlying database supports CONCAT and || but I think I'm not registering support for those functions correctly because, it appears, that the presence of CONCAT or || in the join clause causes Teiid to break the single query into multiple.

 

Attached is a plan that includes the concat operation and another plan that does not.