Search code examples
jbossteiid

Can I push down a comment in Teiid to the source query?

Is it possible to push down comments to the source database query?

Given example Teiid query:

select /* 'request_id' */ columnA, sum(columnB)
from tableA

I'd like to see the comment pushed down to the source database so that I can capture the request_id in the logs. I've looked at source hints, but have not had any luck getting those pushed down to the source query either.

Solution

  • See http://teiid.github.io/teiid-documents/master/content/reference/JDBC_Translators.html and search for UseCommentsInSourceQuery