Ask Your Question

Handling JDBC Multitable Consumer to MapR DB JSON

asked 2019-01-06 01:19:25 -0500

Ronald M gravatar image

updated 2019-01-22 05:57:08 -0500

Maithri gravatar image

Has anyone used a JDBC Multitable Consumer origin and a MapR DB / MapR DB JSON destination? We can use ${record:attribute('jdbc.tables')} for the Table Name parameter for MapR DB. However, how do one handle the value for Row Key? Is there a record attribute that will refer to say the primary key of the source tables? Or should there be a processor in the middle to parse the information out?


edit retag flag offensive close merge delete

1 Answer

Sort by ยป oldest newest most voted

answered 2019-01-16 06:03:24 -0500

Ronald M gravatar image

To address the multi table nature of the origin and the need to get the table's primary key, I used several processors to get it done. I used a JDBC Lookup to get the primary key of a given record's table. Once this is available, I used a Jython evaluator to 'build' the value of the primary key (especially if it is a composite one).

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower


Asked: 2019-01-06 01:19:25 -0500

Seen: 147 times

Last updated: Jan 16 '19