Hitachi Vantara Pentaho Community Forums
Results 1 to 4 of 4

Thread: problem converting data type in 3.0

  1. #1

    Default problem converting data type in 3.0

    Hy, i've a problem
    I've done a transformation with kettle 2.5.1 and it works well
    When i do the same trasformation with 3.0, i have problems with cast of values
    If i do a lookup i receive a cast error, but in previous version the same tranformation work well.....

  2. #2
    Join Date
    May 2006
    Posts
    4,882

    Default

    You're very vague... at least post your transformation (preferably one changed as not to use databases).

    Also have a look at http://wiki.pentaho.org/display/EAI/...igration+guide under data conversion gotchas.

    Regards,
    Sven

  3. #3

    Default

    Thanx, i've solved doing cast operation in step Table Input.
    But i've seen that there are difference between 2.5.x and 3.0. In 3.0 version, it's necessary to do lookup operation on same data type.
    If i have two tables:
    1) 1,2,3
    2) 1,2
    If i want to do a lookup on column 1, the data type must be the same, i can't do it if one is INT and the other is BIGINT
    I hope someone can understand me....

  4. #4
    Join Date
    Nov 1999
    Posts
    9,729

    Default

    Code:
     I hope someone can understand me....
    Well, let's say some details would be nice to have.

    Matt

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.