Ask Your Question
1

How to Reset Offset Value for JDBC Multitable Query Consumer

asked 2017-12-18 15:31:29 -0500

jay1988 gravatar image

My Pipeline which has JDBC Multitable Query consumer ran once for Multiple tables.I need to reset the offset and run again to test the data.How can I reset the offset value for the column to Fetch all the data from Source again for same pipeline.

edit retag flag offensive close merge delete

1 Answer

Sort by ยป oldest newest most voted
2

answered 2017-12-18 23:55:56 -0500

Roh gravatar image

updated 2017-12-19 10:05:37 -0500

If you are using Stream sets UI you will find the reset option in the stream sets pipeline. It will basically reset the jdbc origin instead of running the jobs from the last offset column.

To understand more on the JDBC multitable consumer please check out This well written document.

Picture should speak more

edit flag offensive delete link more

Comments

Thanks.That worked for me.

jay1988 gravatar imagejay1988 ( 2017-12-19 17:24:22 -0500 )edit

@jay1988 As it worked, can you mark my answer as correct?

Roh gravatar imageRoh ( 2017-12-20 09:03:48 -0500 )edit
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2017-12-18 15:31:29 -0500

Seen: 135 times

Last updated: Dec 19 '17