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

["David Wayne Birdsall (JIRA)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/TRAFODION-1970?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

David Wayne Birdsall resolved TRAFODION-1970.
---------------------------------------------
    Resolution: Fixed

> 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)