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?
Can you successfully use tMSSqlInput component to extract data value from your table which rocks a DATETIME2 field with an index?
Which talend build version you are using? Would you mind posting your tHMap component setting screenshot on forum? Please mask your sensitive data.
our Talend version is: Talend Integration Cloud Hybrid Edition (18.104.22.16861216_1026)
I don't know exactly what you want to see, but here goes:
Thanks for your feedback.
We will make an investigation on your issue to see if it is a bug and will keep you posted.