You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@trafodion.apache.org by "Suresh Subbiah (JIRA)" <ji...@apache.org> on 2015/10/05 17:43:27 UTC
[jira] [Updated] (TRAFODION-807) LP Bug: 1400489 - Stats can have
zero UEC when CQD USTAT_ESTIMATE_HBASE_ROW_COUNT is set to 'on'
[ https://issues.apache.org/jira/browse/TRAFODION-807?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Suresh Subbiah updated TRAFODION-807:
-------------------------------------
Assignee: David Wayne Birdsall (was: Barry Fritchman)
> 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)