Hitachi Vantara Pentaho Community Forums
Results 1 to 2 of 2

Thread: My Sql to Pentaho

  1. #1
    Join Date
    Sep 2012

    Default My Sql to Pentaho

    I am new to Pentaho and am trying to use Pentaho to transfer and transform data from one MySql database to another. When I do the table input I get an error saying there are some null values in one of the fields. I only have read access to the Sequel I am pulling from and am using version 4.2

    Can anyone help? I know this is a very beginner question.


  2. #2
    Join Date
    Dec 2011


    seems to be whatever null values are getting for your fields data type should exist as not null in target database...

    step 1 :- if source data type is allowing nulls then you need to allow nulls in target database also.
    step 2:- might be your source extraction uery is wrong becasue of wrong joins we will get a chance to et null data, so we should check extraction query also.

    thank you

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.