Teiid Expression cannot be pushed to source.

[madhumvgr]

Hi,

I created a teiid view which connected to multiple tables and a function.

While I am previewing the data on view. I am observing below problem.

WARN  [PROCESSOR] Processing exception 'Expression(s) year_(STEPP_Source.MEDMAS.BATDAT) cannot be pushed to source.' for request yDBjnwPSFOGl.3.  Exception type org.teiid.api.exception.query.QueryPlannerException thrown from org.teiid.query.optimizer.relational.rules.RuleAssignOutputElements.assignOutputElements(RuleAssignOutputElements.java:161). Enable more detailed logging to see the entire stacktrace.

Kindly help on fixing the problem. Appreciate the help.

Thanks & Regards,

Madhu Sagar

[rareddy]

Madhu,

The error is indicating that the source does not support "Year_". It could be that the input parameter to the function is wrong, or source does not support the function. How did you add the function? If you are using the designer, add a function in the source model. If you are using dynamic VDB, add function using DDL in a physical model.

Ramesh..

[shawkins]

To add a little more, there are times because of the overall complexity of an expression it needs to be evaluated at a particular source, but a subexpression is not eligible for evaluation - such as the translator lacking support for a function.  We'd have to understand more about the scenario to see if it's something that generally would be unplannable or if for example it should be evaluating the function simply as a scalar at the source, which is supported in Teiid 8.5+ with [TEIID-2571] Generally allow must pushdown function evaluation - JBoss Issue Tracker.  Another possible workaround is to provide a Java based implementation that Teiid can call as needed - User Defined Functions - Teiid 8.7 (draft) - Project Documentation Editor

Steve