Vertica Output Update Error

[Anonymous]

hi,
Im Getting Following errors:
Exception in component tVerticaOutput_1
java.sql.SQLException: (4856) ERROR: Syntax error at or near "WHERE"
at com.vertica.util.ServerErrorData.buildException(Unknown Source)
at com.vertica.io.ProtocolStream.readExpectedMessage(Unknown Source)
at com.vertica.dataengine.VDataEngine.prepareImpl(Unknown Source)
at com.vertica.dataengine.VDataEngine.prepare(Unknown Source)
at com.vertica.dataengine.VDataEngine.prepare(Unknown Source)
at com.vertica.jdbc.SPreparedStatement.<init>(Unknown Source)
at com.vertica.jdbc.VerticaPreparedStatementImpl.<init>(Unknown Source)
at com.vertica.jdbc.VJDBCObjectFactory.createPreparedStatement(Unknown Source)
at com.vertica.jdbc.SConnection.prepareStatement(Unknown Source)
at wtda_etl.wtda_etl_ipbillrerecievedfileexecution_0_1.WTDA_ETL_ipbillReRecievedFileExecution.tFileInputDelimited_1Process(WTDA_ETL_ipbillReRecievedFileExecution.java:787)
at wtda_etl.wtda_etl_ipbillrerecievedfileexecution_0_1.WTDA_ETL_ipbillReRecievedFileExecution.runJobInTOS(WTDA_ETL_ipbillReRecievedFileExecution.java:1342)
disconnected
at wtda_etl.wtda_etl_ipbillrerecievedfileexecution_0_1.WTDA_ETL_ipbillReRecievedFileExecution.main(WTDA_ETL_ipbillReRecievedFileExecution.java:1210)
Caused by: com.vertica.util.ServerException: (4856) ERROR: Syntax error at or near "WHERE"
... 12 more



When i give Action On data as "insert" then there is no error. When I give "Update or Insert" Option above error is coming and job got stopped.
Please Let me know solution for this.
Screen Shots are Added in Post.
Thanks and Regards,
Akshath Hegde

[Anonymous]

Hi,
What's your talend build version and Vertica Version? Is it OK with you when re-create a same job?
Best regards
Sabrina

[Anonymous]

hi,
Thank you for quick response.
Talend Version is : 5.2.2
Vertica Version : 6
and vertica connection with talend working fine, there is no problem in connection. only "update", "insert or update" is giving ERROR.
Regards,
Akshath Hegde

[Anonymous]

Hi,
It seems that all columns in your schema are in the key. Could you please have a try with one key for your update to see if this issue still repro?
Best regards
Sabrina

[Anonymous]

hi,
For one key its working fine. But i needed to use more then one column as key. i Think here its not possible... :-(
Thanks and Regards,
Akshath Hegde

[Anonymous]

Hi tayana_akki,
Could you please take a testing on talend latest version 5.4.1. I have made a testing on 5.4.1, everything is going well.
Feel free let me know if it is OK with you.
Best regards
Sabrina

[_AnonymousUser]

I'm getting this same behaviour with PostgreSQL,
tPostgresqlOutput, all columns marked as keys in
the schema, with both Update or insert and Insert
or update. If one or more columns are not keys,
the problem disappears.
I'm running TOS for Big Data (5.6.0.M1-r118307).
I made a new topic for PostgreSQL here:

JB