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?
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.
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
Talend named a Leader.
Kickstart your first data integration and ETL projects.
Learn how to make your data more available, reduce costs and cut your build time
Read about OTTO's experiences with Big Data and Personalized Experiences
Take a look at this video about Talend Integration with Databricks