title: tgreenplumrow-Join and Filter is not woking
body: <p>When i try to execute Multiple Queries in tgreenplumRow component.
  It is not allowing me Join and Filter queries.</p>
  
  <p>Input Info</p>
  
  <p>Source and target table both in greenplum only</p>
  
  <p>Source table - Pointing the External source called HDFS</p>
  
  <p>Target TABLE - regular table in greenplum database</p>
  
  <p>Like this </p>
  
  <p><strong>SQL Transaction</strong> </p>
  
  <pre><code>Begin;
  "insert into target_tbl (select S.* from source_tbl s "LEFT JOIN" target_tbl d ON s."PK"=d."PK" where d."PK" is null) ;
  
  UPDATE target_tbl d
  SET
  "COL" = s."COL"
  FROM source_tbl s 
  WHERE s."PK"=d."PK" and d."COL" != s."COL"
  ;
  END;
  </code></pre>
  
  <p><strong>Error I Get:</strong></p>
  
  <pre><code>Exception in thread "main" java.lang.Error: Unresolved compilation problem: 
  Syntax error on tokens, delete these tokens
  </code></pre>
  
  <p><strong>Actual Data Flow is</strong></p>
  
  <pre><code>              tgreenplumconnection
                          |
  tjdbcinput --&gt;tmap --&gt;thdfsoutput --&gt;tgreenplumrow --&gt;tgreenplumcommit
  </code></pre>
  
  <p><strong>Q1:</strong>  How to run multiple queries with Join and filter in txxxROW component.</p>
  
  <p><strong>Q2:</strong> Is that possible to Handle above  Source and target file scenario in tmap ? </p>
  
  <p>Any Help on this would be much appreciated  ?</p>