TcassandraOutput - Delete Row - BigDataBatch

[Anonymous]

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? 

[Anonymous]

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 

[Anonymous]

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