[ https://issues.apache.org/jira/browse/TRAFODION-1714?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15066995#comment-15066995 ]
ASF GitHub Bot commented on TRAFODION-1714: ------------------------------------------- GitHub user DaveBirdsall opened a pull request: https://github.com/apache/incubator-trafodion/pull/238 [TRAFODION-1714] Sample table population plan now printed before exec… …ution You can merge this pull request into a Git repository by running: $ git pull https://github.com/DaveBirdsall/incubator-trafodion Trafodion1714 Alternatively you can review and apply these changes as the patch at: https://github.com/apache/incubator-trafodion/pull/238.patch To close this pull request, make a commit to your master/trunk branch with (at least) the following in the commit message: This closes #238 ---- commit 8a2085f2dfbf8fc6673bd7fb48099faeae3dd484 Author: Dave Birdsall <dbirds...@apache.org> Date: 2015-12-21T19:49:35Z [TRAFODION-1714] Sample table population plan now printed before execution ---- > ULOG debugging tool does not capture query plan until after execution > --------------------------------------------------------------------- > > Key: TRAFODION-1714 > URL: https://issues.apache.org/jira/browse/TRAFODION-1714 > Project: Apache Trafodion > Issue Type: Bug > Components: sql-cmp > Affects Versions: 2.0-incubating, 1.3-incubating > Environment: All > Reporter: David Wayne Birdsall > Assignee: David Wayne Birdsall > > ULOG is a diagnostic feature that we use when debugging problems with the > UPDATE STATISTICS utility. It logs various information about the code paths > and decisions taken by the utility during the course of its execution. One > useful thing it does is to dump the query plans of any queries that it > executes. Unfortunately, for the Sample Table load query, the plan isn't > dumped until after execution completes. This is a problem because sometimes > (due to other issues) that load query doesn't complete. So the query plan > doesn't get logged in this case, forcing us to use other diagnostic methods > to obtain this information. We would improve the ability to support Trafodion > by dumping the query plans before execution. -- This message was sent by Atlassian JIRA (v6.3.4#6332)