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

Elastic Stack Logstash
1

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:
image
input-jdbc log:

image
image.png1882×149 35.9 KB

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

2

You must CAST it in your SQL statement.

3

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.

1 Like
4

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