[
https://issues.jboss.org/browse/TEIIDDES-2026?page=com.atlassian.jira.plu...
]
Colin Mondesir commented on TEIIDDES-2026:
------------------------------------------
After running "EXEC dbms_stats.gather_schema_stats(’CMONDESIR’,
cascade=>TRUE)" to generate stats for tables under my schema, I checked the number
of distinct and null values for a specific table:
SQL> SELECT COLUMN_NAME, NUM_DISTINCT, NUM_NULLS FROM DBA_TAB_COL_STATISTICS WHERE
TABLE_NAME ='JBM_POSTOFFICE' and OWNER = 'CMONDESIR' ORDER BY
COLUMN_NAME;
COLUMN_NAME NUM_DISTINCT NUM_NULLS
------------------------------ ------------ ----------
ALL_NODES 1 0
CHANNEL_ID 117 0
CLUSTERED 2 0
COND 57 0
NODE_ID 4 0
POSTOFFICE_NAME 1 0
QUEUE_NAME 57 0
SELECTOR 0 117
Then [Import] --> [Teiid Designer] --> [JDBC Database >> Source Model] add
select the table above
One the table metadata has been imported click through each field and notice that
"Distinct Value Count" and "Null Value Count" display as
"-1".
Checking the .xmi I see that there are no "distinctValueCount" or
"nullValueCount" entries.
Missed metadata on import
-------------------------
Key: TEIIDDES-2026
URL:
https://issues.jboss.org/browse/TEIIDDES-2026
Project: Teiid Designer
Issue Type: Bug
Components: Import/Export
Affects Versions: 7.7, 8.3
Reporter: Johnathon Lee
After import, NUM_DISTINCT and NUM_NULLS metadata found in the source system shows as
"-1" when the underlying datasource has values.
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see:
http://www.atlassian.com/software/jira