Hitachi Vantara Pentaho Community Forums
Results 1 to 2 of 2

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

  1. #1
    Join Date
    Mar 2015
    Posts
    190

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

    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

  2. #2
    Join Date
    Apr 2008
    Posts
    4,663

    Default

    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 - 2017 Pentaho Corporation. All Rights Reserved.