Hitachi Vantara Pentaho Community Forums
Results 1 to 8 of 8

Thread: database join

  1. #1

    Default database join

    je travaille avec la version 3 de kettle, en faisant la jointure entre deux tables j'ai reçu le message d'erreur suivant:

    Erreur inattendue : [ :
    2008/01/03 10:44:23 - Jointure Base de données.0 - ERROR (version 3.0.0, build 500 from 2007/11/14 14:59:11) : org.pentaho.di.core.exception.KettleRowException:

    2008/01/03 10:44:23 - Jointure Base de données.0 - ERROR (version 3.0.0, build 500 from 2007/11/14 14:59:11) : PDI a détecté des lignes avec un nombre de champs différents, ce qui est interdit dans une transformation. La première ligne contient 28 champs, une autre 27

    est ce que les deux tables doivent avoir le meme nombre de lignes? ce n'est pas logique ça, non?!!

    Thank you
    Last edited by chaddou2010; 01-03-2008 at 06:10 AM.

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

    Default

    Pleas use English... for your problem, it's not a problem in the join itself... apparently you were able to put rows with a different number of columns on a hop.

    ALL rows that flow over a single hop have to be of the same structure... think of a hop as a temporary database table

    Regards,
    Sven

  3. #3

    Default

    I'm so sorry for using frensh!!

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

    Default

    Don't worry ... reading german or french usually is not a problem

    Now find your varying rows!!

    Regards,
    Sven

  5. #5

    Default

    Thank you.

    I tested with database join, but I got as a result:

    In place of 11 lines , I obtained 22 lines cad twice!

    I've do:
    -connexion1 to table1
    -connexion2 to table2
    -use databese join; in code sql:
    SELECT t1.c1, t1.c2,t2.c11,t2.c22
    FROM t1,t2
    WHERE t1.id=t2.idid;


    -alimenter file .csv

    [IMG]file:///C:/DOCUME%7E1/CELLAJ%7E1/LOCALS%7E1/Temp/moz-screenshot.jpg[/IMG][IMG]file:///C:/DOCUME%7E1/CELLAJ%7E1/LOCALS%7E1/Temp/moz-screenshot-1.jpg[/IMG]
    Attached Images Attached Images  

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

    Default

    That's now how database join works "if you want to combine the 2 table inputs"

    So do you want to join the 2 table inputs, or do you want to join both your table inputs with a 3rd table?

    Regards,
    Sven

  7. #7

    Default

    I want to join the 2 table inputs;
    tab1.database1 et tab2.database1



    Regards,
    Sven

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

    Default

    Then you should have only 1 table input and do a join in the "Database join" with the other table.

    Alternatively use 2 table inputs and use a merge join step.

    Regards,
    Sven

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.