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 (22.214.171.12461216_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.
Talend named a Leader.
Kickstart your first data integration and ETL projects.
Watch the recorded webinar!
Pick up some tips and tricks with Context Variables
Learn how media organizations have achieved success with Data Integration
Accelerate your data lake projects with an agile approach