[ https://issues.apache.org/jira/browse/TRAFODION-807?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
David Wayne Birdsall resolved TRAFODION-807. -------------------------------------------- Resolution: Fixed > LP Bug: 1400489 - Stats can have zero UEC when CQD > USTAT_ESTIMATE_HBASE_ROW_COUNT is set to 'on' > ------------------------------------------------------------------------------------------------ > > Key: TRAFODION-807 > URL: https://issues.apache.org/jira/browse/TRAFODION-807 > Project: Apache Trafodion > Issue Type: Bug > Components: sql-cmp > Reporter: Qifan Chen > Assignee: David Wayne Birdsall > Priority: Critical > Fix For: 2.0-incubating > > > Here are several examples of stats with UEC being 0 (H_DATE, H_D_ID etc). > UEC for column h_w_id is reasonable after turning off the CQD and re-update > the stats. > >>showstats for table history on every column ; > Histogram data for Table TRAFODION.ORDERENTRY.HISTORY > Table ID: 60287988392838310 > Hist ID # Ints Rowcount UEC Colname(s) > ========== ====== =========== =========== =========================== > 964839257 50 1409094 0 H_DATE > 964839251 3 704547 3 H_W_ID > 964839247 10 1409094 0 H_D_ID > 964839240 3 1409094 0 H_C_W_ID > 964839237 10 1409094 0 H_C_D_ID > 964839230 48 1409094 0 H_C_ID > 964839227 1 1409094 0 H_AMOUNT > 964839220 62 1409094 1409094 H_DATA > 964839217 3 1409094 0 "_SALT_" > 964839260 50 1409094 1409094 "_SALT_", H_DATE, H_W_ID, H_D_ID, > H_C_W_ID, H_C_D_ID, H_C_ID -- This message was sent by Atlassian JIRA (v6.3.4#6332)