Hitachi Vantara Pentaho Community Forums
Results 1 to 2 of 2

Thread: My Sql to Pentaho

  1. #1
    Join Date
    Sep 2012
    Posts
    3

    Default My Sql to Pentaho

    Hello,
    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.

    Thanks!

  2. #2
    Join Date
    Dec 2011
    Posts
    124

    Default

    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.