Hitachi Vantara Pentaho Community Forums
Results 1 to 4 of 4

Thread: newbie question: how to create outer joins

  1. #1
    Join Date
    Sep 2005
    Posts
    1,403

    Default newbie question: how to create outer joins

    Hi,


    I've started to play with Kettle in the last couple of days and it seems to be the tool I need. However, I can't seem to figure out how to specify an outer join between tables. An inner join seems pretty obvious using Join Rows. Any help is deeply appreciated.



    Thanks a lot,



    Shuo Wang

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

    Default RE: newbie question: how to create outer joins

    Database Join supports this. If you specify "Outer Join" you will get "Outer Join" functionality...
    The Database Lookup always outer joins as well, but only returns the first result.


    Matt

  3. #3
    Join Date
    Sep 2005
    Posts
    1,403

    Default RE: newbie question: how to create outer joins

    Hi Matt,


    Thanks for the quick reply. I am a little confused about the 'database join' UI. It merely has a text area called SQL. Since I didn't find the particular instruction for this function in the manual, I assume that I need to copy and paste the SQL code that performs the outer join, which looks something like this:



    SELECT
    TABLEA.X,
    TABLEB.Y
    FROM TABLEA, TABLEB
    WHERE TABLEA.ID = TABLEB.ID(+)



    If I merely need to copy and paste this code into the text area, then why do I need to check the 'outer join' checkbox? And also what's the purpose of using 'database join' since I can use the sql script option. Am I missing something here?



    Thanks a lot,



    Shuo Wang

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

    Default RE: newbie question: how to create outer joins

    RTFM:

    - spoon-2.2.pdf, page 92, §7.4.32
    - Last weeks Kettle Tip on this forum

    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.