Hitachi Vantara Pentaho Community Forums
Results 1 to 1 of 1

Thread: Pentaho cannot import from Merge Join step

  1. #1
    Join Date
    Nov 2007
    Posts
    2

    Unhappy Pentaho cannot import from Merge Join step

    We are a student group working on integrating Pentaho and PDI with DHIS (the District Health Information System), part of the HISP (Health Information Systems Project). As a part of our project we are prototyping the requisite connections between Pentaho, PDI and the underlying MySQL and MS Access databases.

    Our problem is getting Pentaho to reliably read the output of Kettle-transformation steps. From our prototype transformation, Pentaho is able to read from Table input (both for MySQL and Access), Filter rows and Select / Rename values steps when these are specified as the importstep in Pentaho's .xaction file. When we specify a Merge Join step, however, Pentaho display an empty result. Why does this happen? What can we do to get our result?

    Another symptom is that any steps following the Merge Join cannot "Get Fields" automatically in Spoon. "Get Fields" works for all steps up to and including the Merge Join.

    Versions:
    Spoon v. 2.5.1
    Pentaho BI Platform v. 1.6.0-RC2.820

    We have placed the contents of the attached zip file in a folder called "integrationtest" under pentaho-demo/pentaho-solutions/samples. For your convenience I have attached the .xaction file (shows our use of importstep) and the transformation separately. In case you want the test databases, they are attached.

    Thanks in advance for any insight.

    Leif Arne Storset
    MozBos student group, HISP
    Contact information: http://www.hisp.info/inf5750/wiki/Mo...actInformation
    Attached Files Attached Files
    Last edited by lastorset; 11-06-2007 at 02:05 PM. Reason: Contact information

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.