[ https://issues.apache.org/jira/browse/TRAFODION-807?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15210890#comment-15210890 ]
ASF GitHub Bot commented on TRAFODION-807: ------------------------------------------ Github user asfgit closed the pull request at: https://github.com/apache/incubator-trafodion/pull/401 > 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)