Way to get native SQL pushed down into sources from execution plan?

mvbrocato Sep 2, 2011 5:23 PM

What's the best way to see the actual SQL that TEIID sends into the individual datasources in a federated query? I've tried looked at the execution plan with Designer, but it looks like that contains more of a logical breakdown of the query, but does not include the translated SQL sent to the sources.

Thanks in advance!

1. Re: Way to get native SQL pushed down into sources from execution plan?

tejones Sep 3, 2011 10:22 AM (in response to mvbrocato)

Hi Mark,

You can use Command logging to see the physical source SQL.

See:
http://docs.redhat.com/docs/en-US/JBoss_Enterprise_Data_Services/5/html/Data_Services_Administrator_Guide/logging.html
https://www.icts.uiowa.edu/confluence/display/ICTSit/Teiid+Audit+Logging%28+Command+Logging%29

Thanks,
Ted
Actions
2. Re: Way to get native SQL pushed down into sources from execution plan?

shawkins Sep 6, 2011 1:51 PM (in response to tejones)

Hi Mark,

Unfortunately the command log contains the logical form of the pushdown query, each souce will be different in how or whether an actual source query is logged. For JDBC a trace log is made to org.teiid.CONNECTOR. You can adjust your log4j settings to see the trace logs. Other possibilities include checking into additional logging options in your drivers, usage of a spy driver, or logging an enhancement request.

Steve
Actions

Go to original post