In JDBC Lookup processor, how can I use my previous stage (MySQL Binary Log) field data to write query in JDBC Lookup and write to some destination?

asked 2018-01-24 06:09:35 -0600

updated 2018-01-24 11:11:29 -0600

metadaddy gravatar image

I am using MySQL Binary Log as origin and JDBC Lookup as processor. I want to query data in JDBC Lookup on the basis of my previous stage (MySQL Binary Log) data. But I am not able to use that passed data in my query and write to some destination. Can anyone suggest something?

edit retag flag offensive close merge delete

Comments

This seems like a duplicate of https://ask.streamsets.com/question/1147 - is it basically the same question?

metadaddy gravatar imagemetadaddy ( 2018-01-24 11:10:39 -0600 )edit

What specific problems are you hitting? You should be able to reference fields in the record from the JDBC Lookup.

metadaddy gravatar imagemetadaddy ( 2018-01-24 11:12:07 -0600 )edit

I want to perform some join operation in jdbc lookup based on the changed data ( id ) coming from mysql binary log.

ImPranjalk gravatar imageImPranjalk ( 2018-01-24 11:47:01 -0600 )edit