Stats can have zero UEC when CQD USTAT_ESTIMATE_HBASE_ROW_COUNT is set to 'on'
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
Trafodion |
In Progress
|
High
|
Barry Fritchman |
Bug Description
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.
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
Changed in trafodion: | |
importance: | Undecided → Critical |
Changed in trafodion: | |
status: | New → In Progress |
Changed in trafodion: | |
importance: | Undecided → High |
Changed in trafodion: | |
milestone: | r0.9 → r1.1 |
Changed in trafodion: | |
milestone: | r1.1 → r2.0 |
After rebasing to git version 127b8c49e24fe77 353d944744299bc 10e770c3fc, reinstall hadoop, the original problem was not reproducible any more.
>>showstats for table stock on every column;
Histogram data for Table TRAFODION. ORDERENTRY. STOCK
Table ID: 140790373550268965
Hist ID # Ints Rowcount UEC Colname(s) ======= ======= ======
========== ====== =========== =========== =======
1506049160 48 200000 200000 S_I_ID
1506049155 1 200000 1 S_W_ID
1506049150 91 200000 91 S_QUANTITY
1506049145 62 200000 200000 S_DIST_01
1506049140 62 200000 200000 S_DIST_02
1506049135 62 200000 200000 S_DIST_03
1506049130 62 200000 200000 S_DIST_04
1506049125 62 200000 200000 S_DIST_05
1506049120 62 200000 200000 S_DIST_06
1506049115 62 200000 200000 S_DIST_07
1506049110 62 200000 200000 S_DIST_08
1506049105 62 200000 200000 S_DIST_09
1506049100 62 200000 200000 S_DIST
1506049095 1 200000 1 S_YTD
1506049090 1 200000 1 S_ORDER_CNT
1506049085 1 200000 1 S_REMOTE_CNT
1506049080 62 200000 200000 S_DATA
1506049075 1 200000 1 "_SALT_"
1506049165 50 200000 200000 "_SALT_", S_W_ID, S_I_ID
>>showstats for table neworder on every column;
Histogram data for Table TRAFODION. ORDERENTRY. NEWORDER
Table ID: 140790373550268398
Hist ID # Ints Rowcount UEC Colname(s) ======= ======= ======
========== ====== =========== =========== =======
1511505062 48 900 900 NO_O_ID
1511505057 1 900 1 NO_D_ID
1511505052 1 900 1 NO_W_ID
1511505047 1 900 1 "_SALT_"
1511505067 50 900 900 "_SALT_", NO_W_ID, NO_D_ID, NO_O_ID