TcassandraOutput - Delete Row - BigDataBatch

Highlighted
Five Stars

TcassandraOutput - Delete Row - BigDataBatch

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? 

Highlighted
Six Stars

Re: TcassandraOutput - Delete Row - BigDataBatch

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. 

 

tcassandra_delete.png

 

Regards,

Ragu 

Highlighted
Five Stars

Re: TcassandraOutput - Delete Row - BigDataBatch

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

2019 GARTNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

Put Massive Amounts of Data to Work

Learn how to make your data more available, reduce costs and cut your build time

Watch Now

How OTTO Utilizes Big Data to Deliver Personalized Experiences

Read about OTTO's experiences with Big Data and Personalized Experiences

Blog

Talend Integration with Databricks

Take a look at this video about Talend Integration with Databricks

Watch Now