Teiid embedded type mapping

[hend.amin]

Hello,

I am using teiid embedded. I have oracle database. Column type NUMBER(20,0) this column is mapped to bigdecimal although it is an integer number.

Is that a correct behavior. should it map to biginteger  ??

Thanks

Hend

[shawkins]

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.

[hend.amin]

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 ?

[shawkins]

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.

[hend.amin]

Hello Steven,

How to specify the source DDL ?

[rareddy]

DDL 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 

[shawkins]

[TEIID-4750] Map to BigInteger in more circumstances - JBoss Issue Tracker was also captured for this.