Five Stars

tHMap and DATETIME2

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

6 REPLIES
Moderator

Re: tHMap and DATETIME2

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

--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.
Five Stars

Re: tHMap and DATETIME2

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

Moderator

Re: tHMap and DATETIME2

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

--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.
Five Stars

Re: tHMap and DATETIME2

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 DataMapper Data

 

Actual Mapping in tHMapActual Mapping in tHMap

 

Data Type for the TableStructureData Type for the TableStructure

 

BR,

Max

Moderator

Re: tHMap and DATETIME2

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

 

--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.
Five Stars

Re: tHMap and DATETIME2

Hi,

any new info on your side about this issue?

BR,
Max