Init query in the StreamSets JDBC Query Consumer not working for Delete previous data
I use Streamsets Data Collector to Load data from Stage 2 database tables (JDBC Query Consumer) using a query and Write loaded data to another Stage 2 Database table (JDBC Producer). I use Init Query as below to delete the previous records before loading data. But this does not delete any record from the table. It would be great if someone can help me.
I was using Init Query in the JDBC Query Consumer to delete previous records; it did not work. I removed the init query from the JDBC Query Consumer and added a Start Event. It deletes previous records, and the pipeline works as I expected.
My question in the community: https://community.streamsets.com/show-us-your-pipelines-71/init-query-in-the-jdbc-query-consumer-not-working-for-delete-previous-data-2028?postid=4733#post4733
- Can Streamsets Data Collector CDC read from and write to multiple tables?
- Init query in the StreamSets JDBC Query Consumer not working for Delete previous data
- I only have row key inside my mapr-db JSON table
- I'm trying to create and pass a new record which contains a map from the jython processor in streamsets but getting this error?
- Cant find Avro schema in divolte and kafka docker
- Shell to run StreamSets Pipeline
- Kafka vs StreamSets
- I am using regex in stream selector in streamsets but it is not working as expected
- How to install Streamsets on aws?
- Add text annotation to SDC pipeline?
- How to capture error on JDBC connection failure
- Streamsets Javascript scripting error loading JQuery
- How to Import Streamsets pipeline in Dockerfile without container exiting
- how to connect from oracle origin with streamsets
- Streamsets Data Collector: Replace a Field With Its Child Value
- How to transition a StreamSets pipeline to Finished state if the Origin does not 'Produce Events'?
- I can't execute sudo streamsets dc to start streamsets
- geo_point mapping python and StreamSets fails with Elasticsearch
- StreamSets processor cant find the Redis libs
- Not able to dump JSON response to a FTP server in a CSV file using streamsets
- Target file name using file name expression in streamsets
- Streamsets Transformer - JDBC Origin without offset column
- Not able to read data from Google Cloud Platform in StreamSets Data Collector
- Streamsets: SpoolDIR_01 Failed to process file
- Reset Origin of a StreamSets Pipeline using another pipeline
- Writing data to AWS Aurora using StreamSets
- How to get StreamSets Record Fields Type inside Jython Evaluator
- File is not Loaded Into HDFS from Local Using Streamsets (validated Successfully!)
- Modify time:now() to be less one hour
- Streamsets gives this error trying to parse a valid JSON