Hitachi Vantara Pentaho Community Forums
Results 1 to 2 of 2

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

Hybrid View

Previous Post Previous Post   Next Post Next Post
  1. #1
    Join Date
    Mar 2015

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


    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.


  2. #2
    Join Date
    Apr 2008


    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.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
Privacy Policy | Legal Notices | Safe Harbor Privacy Policy

Copyright © 2005 - 2019 Hitachi Vantara Corporation. All Rights Reserved.