tHMap and DATETIME2

Anonymous · ‎2017-09-07

Hello Talend folks,

we have a table in our MSSql database, which rocks a DATETIME2 field with an index.

Using a tHMap I can only use HQL for the where-String, which doesn't recognize DATETIME2 as a type to cast to in the following query:

CreatedOn >= CAST('2017-01-01' AS DATETIME2)

If we don't use this cast, we're not using the index on the column, hence it takes longer than it should.

Is there any way to cast to DATETIME2 or make the internal Hibernate aware of this type?

BR,

Max

Anonymous · ‎2017-09-11

Hello,

Can you successfully use tMSSqlInput component to extract data value from your table which rocks a DATETIME2 field with an index?

Best regards

Sabrina

Anonymous · ‎2017-09-11

Hi,

yes, it works perfectly fine with the tMSSqlInput, but not with the tHMap where it complains that DATETIME2 is an unknown data type.

BR,

Max

Anonymous · ‎2017-09-12

Hi,

Which talend build version you are using? Would you mind posting your tHMap component setting screenshot on forum? Please mask your sensitive data.

Best regards

Sabrina

Anonymous · ‎2017-09-12

Hi,

our Talend version is: Talend Integration Cloud Hybrid Edition (6.3.1.20161216_1026)

I don't know exactly what you want to see, but here goes:

Mapper Data

Actual Mapping in tHMap

Data Type for the TableStructure

BR,

Max

Anonymous · ‎2017-09-13

Hello Max,

Thanks for your feedback.

We will make an investigation on your issue to see if it is a bug and will keep you posted.

Best regards

Sabrina

Anonymous · ‎2017-10-24

Hi,

any new info on your side about this issue?

BR,
Max