Hitachi Vantara Pentaho Community Forums
Results 1 to 2 of 2

Thread: 3.0 Problem

  1. #1
    Join Date
    Jun 2007
    Posts
    476

    Default 3.0 Problem

    Hi, i'm just starting to use 3.0 RC2, with a simple Table input i get data from a mysql table and the fields are all Integers, when i do a simple SELECT * FROM table in kettle i get the results but they are filled with '0' at the left, I don't know if this is a bug, or is something of my configuration or what i'm doing wrong, but i should get a 45 and i get ' 000000045'.

    If you could guide me with this I'll appreciate it.
    Thanks. Rodrigo

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

    Default

    An integer is an integer.
    The preview was made the same as the output data on file would look like without applying any other mask.
    Typically, this shouldn't have any effect at all.

    See the data conversion part over here: (also linked from your welcome page in 3.0GA)

    See also: http://wiki.pentaho.org/display/EAI/...igration+guide

    HTH,

    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.