Hitachi Vantara Pentaho Community Forums
Results 1 to 3 of 3

Thread: PDI Reading mysql tinyint(1) field as boolean. I need to read as INT/NUMBER.

  1. #1
    Join Date
    Oct 2013
    Posts
    23

    Question PDI Reading mysql tinyint(1) field as boolean. I need to read as INT/NUMBER.

    Hi guys,

    I have a table with a tinyint(1) field that when i read on mysql workbench i see values 0 or 1.
    But inside a PDI transformation when i read the table pentaho is reading as 'Y' AND 'N'.
    When it tries to send this data to a Teradata table smallint field is returning me error.
    On PDI i´m using MYSQL native (JDBC) connection.
    How can i force pentaho to read the tinyint(1) values as a number/INT and not as boolean?
    I´m using PDI version 6.1.

    Thanks.

  2. #2
    Join Date
    Jun 2012
    Posts
    5,534

    Default

    What about your tinyIntxxx driver options?
    So long, and thanks for all the fish.

  3. #3
    Join Date
    Oct 2013
    Posts
    23

    Default

    Quote Originally Posted by marabu View Post
    What about your tinyIntxxx driver options?
    Thank you very much.
    I´ve set tinyInt1isBit=false and it worked as expected.

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.