-
1. Re: Teiid embedded type mapping
shawkins Jan 31, 2017 9:05 AM (in response to hend.amin)Mapping to biginteger is possible. Currently only the oracle translator will make that mapping with the useIntegralTypes import setting. You could certainly request the biginteger mapping for precision >= 19 as default behavior.
-
2. Re: Teiid embedded type mapping
hend.amin Feb 1, 2017 9:43 AM (in response to shawkins)Hello Stevens .. is there a similar setting for MSSQL DB ? I have same DB on oracle and on MSSQL. I want to use same virtual view for oracle and MSSQL but i get different column types (bigdecimal for oracle and long for MSSQL). casting solves the problem. I casted the columns to Long so that it would be the same type for MSSQL and oracle. but it made bad performance for oracle.
i want to make the columns biginteger for both DBs (ORACLE/MSSQL) but without casting.
is there a way ?
-
3. Re: Teiid embedded type mapping
shawkins Feb 1, 2017 9:50 AM (in response to hend.amin)Currently you'd have to specify the source DDL, rather than rely upon the import.
Otherwise, you can log an enhancement for the automatic mapping to biginteger.
-
4. Re: Teiid embedded type mapping
hend.amin Feb 2, 2017 4:53 AM (in response to shawkins)Hello Steven,
How to specify the source DDL ?
-
5. Re: Teiid embedded type mapping
rareddy Feb 2, 2017 12:15 PM (in response to hend.amin)1 of 1 people found this helpfulDDL supported Schema Object DDL · Teiid Documentation
Sample: teiid-embedded-examples/portfolio-vdb.xml at master · teiid/teiid-embedded-examples · GitHub
In sample above the DDL is defined on VIRTUAL view, you can do same on PHYSICAL view too. A example like that is
teiid-embedded-examples/mongodb-vdb.xml at master · teiid/teiid-embedded-examples · GitHub
-
6. Re: Teiid embedded type mapping
shawkins Feb 8, 2017 10:53 AM (in response to rareddy)1 of 1 people found this helpful[TEIID-4750] Map to BigInteger in more circumstances - JBoss Issue Tracker was also captured for this.