[ https://issues.apache.org/jira/browse/TRAFODION-1970?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
David Wayne Birdsall updated TRAFODION-1970: -------------------------------------------- Fix Version/s: 2.0-incubating > 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 > Fix For: 2.0-incubating > > > 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.15#6346)