tVerticaOutput issues using action on data 'insert'
Dear Talend Team, I am working on a POC for a client using Talend and Vertica 7.1. We are facing two issues here: 1. While using tVerticaOutput component even if I select Action on data 'Insert', it still uses COPY command on vertica instead of INSERT INTO command. (I have checked it using management console of Vertica which shows active queries). Please tell me how i can make tVerticaOutput to create INSERT INTO command. 2. In earlier versions of Talend i.e 5.5 tVerticaOutput there was output option of viewing query (((String)globalMap.get("tVerticaOutput_1_QUERY"))) thats being used by component but this time its missing. Please help me with this. I am using: Talend Open Studio 6.1.0 M1 Windows Server 2008 R2 SP2 Jdk 1.8 Thanks in Advance, Syed Asif Tanveer
Hi Syed Asif Tanveer, We will make a testing on Talend Open Studio 6.1.0 M1 to see if this issue repro then come back to you as soon as we can. Have you already tried it on studio 6.0 to see if this issue repro? Best regards Sabrina