5 Replies Latest reply on Jul 17, 2019 8:48 AM by rareddy

Is Teiid provide any API for validating data before actual insertion?

pranitag Jul 16, 2019 8:02 AM

Hi Team,

There is a facility of implicit and explicit casting in every database. If my target column's datatype mismatch with data I am trying to insert then teiid throws following error on runtime:

Caused by: org.teiid.core.types.TransformationException: TEIID10076 Invalid conversion from type class org.teiid.core.types.BinaryType with value '303130303131303130' to type class java.lang.String

Is there any API which can provide validation for such mismatches beforehand based on database used.

eg. integer -> varchar -- allowed

varchar -> boolean -- not allowed

Teiid handle scenario 1 by itself and throws an error at runtime in case of scenario 2. I want to know these validations before firing the actual query.

Regards,

Pranita G

1. Re: Is Teiid provide any API for validating data before actual insertion?

rareddy Jul 16, 2019 8:59 AM (in response to pranitag)

Are you doing this on a view or source table? If you know the data types do not match can you add an explicit type conversion of value to your insert statement?
Actions
2. Re: Is Teiid provide any API for validating data before actual insertion?

pranitag Jul 16, 2019 9:23 AM (in response to rareddy)

I want to know if TEIID provides any api for checking the compatibility of the source field and target field data types, irrespective of any type of casting.
Actions
3. Re: Is Teiid provide any API for validating data before actual insertion?

rareddy Jul 16, 2019 9:29 AM (in response to pranitag)

Can you elaborate what kind of API you are looking for? Teiid supports implicit conversions when they can be done automatically, if not it provides ways to explicitly convert.
Actions
4. Re: Is Teiid provide any API for validating data before actual insertion?

pranitag Jul 17, 2019 4:23 AM (in response to pranitag)

I am looking for API which can help me to validate data type compatibility before actual implicit or explicit casting is done by teiid. API can check feasibility whether it's eligible for implicit or explicit casting.

E.g. clob to time datatype conversion is not possible by implicit or explicit. So does teiid provide any API which can validate such feasibility rather than throwing an error at runtime ?
Actions
5. Re: Is Teiid provide any API for validating data before actual insertion?

rareddy Jul 17, 2019 8:48 AM (in response to pranitag)

No, Teiid does not have such specific API.
However, we have a Preparser module [1] you can add, where the statement can be modified before it can be executed by the engine. That may be something you can do. The question you want to consider is if you already know different conversions why not submit the converted query?

[1] PreParser · GitBook
Actions

Go to original post