GitHub user nonstop-qfchen opened a pull request:
https://github.com/apache/incubator-trafodion/pull/195
fix JIRA 1654 for Trafodion
Hi,
Could you please review the fix?
The idea is to compute the product of UECs for key columns without
predicates and consider MDAM when that product is within a fraction of the
total UEC.
CQDs re-arranged/created for this new and the existing restriction.
MDAM_APPLY_RESTRICTION_CHECK:
// Specify whic additional restriction check to apply
// 0: no check
// 1: apply majority of keys with predicates check
// 2: apply total UECs on keyless key columns check (default)
// 3: apply both 1) and 2)
MDAM_TOTAL_UEC_CHECK_UEC_THRESHOLD:
// A threshold of total UECs on keyless key columns above which MDAM will
not be considered.
// The threshold is expressed as a percentage of the total RC.
Default to 1 percent of the total RC.
MDAM_TOTAL_UEC_CHECK_MIN_RC_THRESHOLD:
// A threshold of minitmal RC above which the above total UEC check will be
applied. Default to 10,000 rows
You can merge this pull request into a Git repository by running:
$ git pull https://github.com/nonstop-qfchen/incubator-trafodion
mdam_strategy2
Alternatively you can review and apply these changes as the patch at:
https://github.com/apache/incubator-trafodion/pull/195.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 #195
----
commit f8ff39c86fe95cd2889aab94aa513c46338d4517
Author: Qifan Chen <[email protected]>
Date: 2015-11-30T14:55:20Z
fix JIRA 1654 for Trafodion
----
---
If your project is set up for it, you can reply to this email and have your
reply appear on GitHub as well. If your project does not have this feature
enabled and wishes so, or if the feature is enabled but not working, please
contact infrastructure at [email protected] or file a JIRA ticket
with INFRA.
---
