[jira] [Commented] (TRAFODION-1970) UPDATE STATS CLEAR gets error 9243 on large tables

["ASF GitHub Bot (JIRA)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/TRAFODION-1970?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=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)