You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@trafodion.apache.org by "ASF GitHub Bot (JIRA)" <ji...@apache.org> on 2017/05/18 23:49:04 UTC
[jira] [Commented] (TRAFODION-2618) SET ROWCOUNT option in UPDATE
STATISTICS doesn't suppress rowcount logic
[ https://issues.apache.org/jira/browse/TRAFODION-2618?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16016671#comment-16016671 ]
ASF GitHub Bot commented on TRAFODION-2618:
-------------------------------------------
GitHub user zellerh opened a pull request:
https://github.com/apache/incubator-trafodion/pull/1100
[TRAFODION-2618] Option to skip rowcount estimation in update stats
Don't call the rowcount estimation interface when the SET ROWCOUNT
option is specified, we will discard that estimate anyway.
You can merge this pull request into a Git repository by running:
$ git pull https://github.com/zellerh/incubator-trafodion bug/cses_jan-17
Alternatively you can review and apply these changes as the patch at:
https://github.com/apache/incubator-trafodion/pull/1100.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 #1100
----
commit 790b04acbe25bf3b3bd304777caa03c7d2f30d3f
Author: Hans Zeller <hz...@apache.org>
Date: 2017-05-18T20:45:00Z
[TRAFODION-2618] Option to skip rowcount estimation in update stats
Don't call the rowcount estimation interface when the SET ROWCOUNT
option is specified, we will discard that estimate anyway.
----
> SET ROWCOUNT option in UPDATE STATISTICS doesn't suppress rowcount logic
> ------------------------------------------------------------------------
>
> Key: TRAFODION-2618
> URL: https://issues.apache.org/jira/browse/TRAFODION-2618
> Project: Apache Trafodion
> Issue Type: Improvement
> Components: sql-cmp
> Affects Versions: 2.0-incubating
> Environment: Any
> Reporter: Hans Zeller
> Assignee: Hans Zeller
>
> There is an undocumented option in the update statistics command:
> update statistics ... sample ... set rowcount <num>
> This "set rowcount" option is meant to avoid the need to get an approximate rowcount of the table before reading a sample. However, it seems that update statistics still invokes at least some code to get a rowcount, even in the presence of this option.
> This issue is somewhat related to TRAFODION-2617. We tried the "set rowcount" option as a possible workaround for TRAFODION-2617 but still got the same error.
--
This message was sent by Atlassian JIRA
(v6.3.15#6346)