topic Re: TcassandraOutput - Delete Row - BigDataBatch in Talend Studio

TcassandraOutput - Delete Row - BigDataBatch

Anonymous — Sat, 16 Nov 2024 07:28:09 GMT

Hi, I am trying to delete some rows using key columns via Talend - Spark job (Big data batch). I use delete option in the component setting and in advanced settings i check the box "Delete if Exist".

Issue is: The column values are getting deleted other than key columns but not the ENTIRE ROW. How to do the row delete using key column values?

Re: TcassandraOutput - Delete Row - BigDataBatch

Anonymous — Mon, 15 Oct 2018 18:59:54 GMT

Anithar,

yes! you can delete the entire row in tCassandraOutput. You should supply the key column in the flow and specify the key column in the schema.

Regards,

Ragu

Re: TcassandraOutput - Delete Row - BigDataBatch

Anonymous — Tue, 16 Oct 2018 08:10:21 GMT

Thanks Ragu. I tried with key columns already. With that only the columns are getting deleted. Without that it will even threw some error.

I tried with

Specifying key columns in schema

Specify the "Delete If exist" in advanced settings

Tried with If condition as well Row key list.

None worked to delete row. instead it deletes the columns to NULL and keep values for PK columns