> we observed that teiid hints are getting ovveriden. Is there any property with which we can ask teiid to append the hints rather than ovveriding them ?
The source hint's primary intent was for usage in the user query and not in view layers, thus depending upon how you use your view the source hint will in many circumstances be ignored. https://issues.jboss.org/browse/TEIID-2381 covers some possibilities for expanding the usage of source hints. Can you vote for that issue and add any relevant comments there?