[
https://issues.apache.org/jira/browse/TRAFODION-2683?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16087329#comment-16087329
]
ASF GitHub Bot commented on TRAFODION-2683:
-------------------------------------------
Github user asfgit closed the pull request at:
https://github.com/apache/incubator-trafodion/pull/1179
> add a new explain option to mask variant fields in output
> ---------------------------------------------------------
>
> Key: TRAFODION-2683
> URL: https://issues.apache.org/jira/browse/TRAFODION-2683
> Project: Apache Trafodion
> Issue Type: Improvement
> Reporter: Anoop Sharma
> Assignee: Anoop Sharma
> Priority: Minor
>
> Full explain returns detailed information about a query plan which is very
> useful in
> determining if the chosen plan is as expected and other details about it.
> But returned output contains information that may vary from run to run, or
> from one
> system to another, or may be data dependent, and so on.
> Some examples are UIDs, or cost/memory estimates, or number of cpus/nodes,
> etc.
> Currently these variations are handled by checking in the new expected files
> (bad idea),
> or creating known diff files, or adding filters, or selecting specific fields
> from explain virtual
> table, or just not using explain.
> This jira proposes a new option which when specified, will filter and mask
> fields that
> are variant and change.
> The option is called 'c' (cleanse) and could be specified as part
> of explain "options '<str>' " clause. It works with both full explain and
> formatted explain.
>
> This option is useful when running regressions where one need to validate
> enhancements
> and other changes that do not involve costing/estimates/dop etc related
> values.
> This option should not be used when those values are important.
> For ex, if a scan is expected to return 100 rows and explain need to show
> that, or
> if a query should use 4 esps, then using the 'c' option will mask it.
--
This message was sent by Atlassian JIRA
(v6.4.14#64029)
