Unknown type 245 in column 0 of 1 in binary-encoded

[ranala]

Hi,

PDI 6.1, MySQL database.

We are getting this error Unknown type 245 in column 0 of 1 in binary-encoded. could you please help on this.

When we are trying to load the json data using table input step, we are getting it.

Thanks

[gutlez]

Did you do a web-search first?

Your error is complaining about not understanding the JSON column type.

JSON is not a column type that PDI natively speaks. Even if you were were to upgrade to 8.2
You have to convert the JSON column type (which according to MySQL themselves takes the same DB space as a TEXT column...) before you can try to use it in PDI. PDI will never try to patch the data... So using JSON column type at the DB level really doesn't get you much.