Hitachi Vantara Pentaho Community Forums
Results 1 to 3 of 3

Thread: SQL inside Table Input

  1. #1

    Default SQL inside Table Input

    HI,
    I am trying to create a Table input with the following query.

    SELECT
    A.EPM_PRJ_SID
    FROM
    TEST2 A
    LEFT
    OUTERJOIN
    TEST3 B
    ON A.IC_PRJ_SID=B.IC_PRJ_SID

    But LEFT is not taken as a key word (Not highlighted in blue). When i run the transformation, it throws an error. Can you please let me know where i am going wrong.
    If Table Input can take only simple select queries, is there any step where i can use complex select queries?

  2. #2
    Join Date
    Sep 2009
    Posts
    810

    Default

    Hi there,

    please take the syntax highlighting with a grain of salt, as it cannot possibly accommodate all SQL dialects out there. The table input takes any valid query for your DB. Please make sure that your query works in a native DB client if it is non-trivial. It is easiest to develop complex queries in a native client as it is likely to give more meaningful error messages.

    PS: have you tried LEFT OUTER JOIN?

    Cheers
    Slawo

  3. #3

    Default

    Thanks a lot!! LEFT OUTER JOIN inside 'Table Input' is working fine!!!
    Last edited by Ponb; 10-24-2011 at 07:26 AM.

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.