We have a MySQL table which contains a status field with tinyint(1) type.
This field has several values (from 1 to 20)
When we read data of this table, Dremio interprets them by ‘true’ or ‘false’ values (true if 0, false otherwise).
It’s the standard behaviour for reading this kind of data type : by default, tinyint(1) is consider as a boolean.
We have the same behaviour with logstash for instance.
But we can provide an option for a different interpretation by jdbc property.
Is it possible to configure Dremio MySQL source with this option ?