topic Re: tHMap and DATETIME2 in Talend Studio

tHMap and DATETIME2

Anonymous — Thu, 07 Sep 2017 15:34:09 GMT

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 — Mon, 11 Sep 2017 08:13:10 GMT

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 — Mon, 11 Sep 2017 08:53:59 GMT

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 — Tue, 12 Sep 2017 04:55:26 GMT

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 — Tue, 12 Sep 2017 14:37:09 GMT

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 — Wed, 13 Sep 2017 04:08:44 GMT

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 — Tue, 24 Oct 2017 09:25:53 GMT

Hi,

any new info on your side about this issue?

BR,
Max