Importing datetime2 column from sql is giving error

Elastic Stack Logstash
1

Hi,

I'm importing a table from SQL using logstash and one of the fields in table has a 'datetime2' field which gives an error as below

Exception when executing JDBC query {:exception=>#<Sequel::DatabaseError: Java::ComMicrosoftSqlserverJdbc::SQLServerException: Operand type clash: datetime2 is incompatible with int>, :level=>:warn}

can someone tell me as how this error can be fixed.

Thanks

2

This is happening because i'm using the field as a tracking column in my configuration. Otherwise, i dont see an issue

3

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.