Importing datetime2 column from sql is giving error


(saisn) #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


(saisn) #2

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


(system) #3

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