You are viewing a plain text version of this content. The canonical link for it is here.

Posted to issues@trafodion.apache.org by "David Wayne Birdsall (JIRA)" <ji...@apache.org> on 2016/05/04 16:22:12 UTC

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

David Wayne Birdsall created TRAFODION-1970:
-----------------------------------------------

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