How to Reset Offset Value for JDBC Multitable Query Consumer

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

jay1988
87 ●14 ●17 ●20

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

add a comment

1 Answer

Sort by » oldest newest most voted

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

Roh

363 ●22 ●27 ●33

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

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

Comments

Thanks.That worked for me.

jay1988 ( 2017-12-19 17:24:22 -0600 )edit

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

Roh ( 2017-12-20 09:03:48 -0600 )edit

add a comment

Question Tools

1 follower

Stats

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

Seen: 747 times

Last updated: Dec 19 '17

How to Reset Offset Value for JDBC Multitable Query Consumer edit

1 Answer

Comments

Question Tools

Stats

Related questions

How to Reset Offset Value for JDBC Multitable Query Consumer