Ask Your Question
1

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 -0500

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

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 -0500 )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 -0500 )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 -0500 )edit

1 Answer

Sort by ยป oldest newest most voted
0

answered 2020-06-11 18:19:19 -0500

iamontheinet gravatar image

Hi!

Here's how you can reference record field value set in the stages prior to JDBC Lookup processor. For example, in my case I am looking up records based on record field called pid with this expression ${record:value('/pid')} in the where clause.

image description

Cheers, Dash

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2018-01-24 06:09:35 -0500

Seen: 266 times

Last updated: Jun 11