Why the input-jdbc plugin automatically converts the MySQL database tinyint data type to boolean type?

Scopy · July 23, 2018, 7:48am

Hi,everyone!
I‘m a green hand to logstash.’This is the first attempt to synchronize MySQL data with logstash today.However, when I used the JDBC plugin, it encountered some problems. MySQL data is set to tinyint, it turns to boolean with input-jdbc which I don't expect.
MySQL data type:

input-jdbc log:

What should I do to make it not automatically converted?
We look forward to your reply, and will be appreciate.

guyboertje · July 23, 2018, 10:34am

You must CAST it in your SQL statement.

Scopy · July 24, 2018, 5:46am

Thank you for your reply.I've solved this problem.I added a parameter(tinyInt1isBit=false) to the value of jdbc_connection_string, and then it will work properly.

system · August 21, 2018, 5:46am

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