[jira] [Commented] (TRAFODION-1970) UPDATE STATS CLEAR gets error 9243 on large tables
[ https://issues.apache.org/jira/browse/TRAFODION-1970?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15278252#comment-15278252 ] David Wayne Birdsall commented on TRAFODION-1970: - With the fix, the UPDATE STATS CLEAR command will succeed. The error 9243 is no longer raised. > UPDATE STATS CLEAR gets error 9243 on large tables > -- > > Key: TRAFODION-1970 > URL: https://issues.apache.org/jira/browse/TRAFODION-1970 > Project: Apache Trafodion > Issue Type: Bug > Components: sql-cmp >Affects Versions: 2.0-incubating > Environment: All >Reporter: David Wayne Birdsall >Assignee: David Wayne Birdsall > > A table wssstats96 has about 8M rows. One of the operations done on it is: > UPDATE STATISTICS FOR TABLE wssstats96 ON ("_SALT_", "_DIVISION_1_") clear ; > This command consistently fails with error: > >>UPDATE STATISTICS FOR TABLE wssstats96 ON ("_SALT_", "_DIVISION_1_") clear ; > *** ERROR[9243] This UPDATE STATISTICS command may take too long. It is > recommended to use the SAMPLE clause instead. If you wish to do this without > a SAMPLE clause, specify NO SAMPLE explicitly. > --- SQL operation failed with errors. -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[jira] [Commented] (TRAFODION-1970) UPDATE STATS CLEAR gets error 9243 on large tables
[ https://issues.apache.org/jira/browse/TRAFODION-1970?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15272505#comment-15272505 ] ASF GitHub Bot commented on TRAFODION-1970: --- Github user asfgit closed the pull request at: https://github.com/apache/incubator-trafodion/pull/464 > UPDATE STATS CLEAR gets error 9243 on large tables > -- > > Key: TRAFODION-1970 > URL: https://issues.apache.org/jira/browse/TRAFODION-1970 > Project: Apache Trafodion > Issue Type: Bug > Components: sql-cmp >Affects Versions: 2.0-incubating > Environment: All >Reporter: David Wayne Birdsall >Assignee: David Wayne Birdsall > > A table wssstats96 has about 8M rows. One of the operations done on it is: > UPDATE STATISTICS FOR TABLE wssstats96 ON ("_SALT_", "_DIVISION_1_") clear ; > This command consistently fails with error: > >>UPDATE STATISTICS FOR TABLE wssstats96 ON ("_SALT_", "_DIVISION_1_") clear ; > *** ERROR[9243] This UPDATE STATISTICS command may take too long. It is > recommended to use the SAMPLE clause instead. If you wish to do this without > a SAMPLE clause, specify NO SAMPLE explicitly. > --- SQL operation failed with errors. -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[jira] [Commented] (TRAFODION-1970) UPDATE STATS CLEAR gets error 9243 on large tables
[ https://issues.apache.org/jira/browse/TRAFODION-1970?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15271117#comment-15271117 ] ASF GitHub Bot commented on TRAFODION-1970: --- GitHub user DaveBirdsall opened a pull request: https://github.com/apache/incubator-trafodion/pull/464 [TRAFODION-1970] UPDATE STATS CLEAR gets error 9243 on large tables You can merge this pull request into a Git repository by running: $ git pull https://github.com/DaveBirdsall/incubator-trafodion Trafodion1970 Alternatively you can review and apply these changes as the patch at: https://github.com/apache/incubator-trafodion/pull/464.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 #464 > UPDATE STATS CLEAR gets error 9243 on large tables > -- > > Key: TRAFODION-1970 > URL: https://issues.apache.org/jira/browse/TRAFODION-1970 > Project: Apache Trafodion > Issue Type: Bug > Components: sql-cmp >Affects Versions: 2.0-incubating > Environment: All >Reporter: David Wayne Birdsall >Assignee: David Wayne Birdsall > > A table wssstats96 has about 8M rows. One of the operations done on it is: > UPDATE STATISTICS FOR TABLE wssstats96 ON ("_SALT_", "_DIVISION_1_") clear ; > This command consistently fails with error: > >>UPDATE STATISTICS FOR TABLE wssstats96 ON ("_SALT_", "_DIVISION_1_") clear ; > *** ERROR[9243] This UPDATE STATISTICS command may take too long. It is > recommended to use the SAMPLE clause instead. If you wish to do this without > a SAMPLE clause, specify NO SAMPLE explicitly. > --- SQL operation failed with errors. -- This message was sent by Atlassian JIRA (v6.3.4#6332)