Ask Your Question

Json format from Database columns

asked 2020-02-29 08:09:31 -0600

SatyaResdy gravatar image

updated 2020-03-03 03:42:26 -0600

I am reading data from database , I want to segregate that column into groups as json object before pushing to Kafka In streamsets.

edit retag flag offensive close merge delete


Could you give a bit more detail on what you're trying to do? What have you tried so far? What was the result?

metadaddy gravatar imagemetadaddy ( 2020-03-02 11:24:14 -0600 )edit

1 Answer

Sort by ยป oldest newest most voted

answered 2020-03-03 03:42:32 -0600

SatyaResdy gravatar image

updated 2020-03-03 03:46:53 -0600

Thanks metadaddy . As per my requirement i got the solution from your Previous answer I need one more help . Now the order is not correct . Ex: EventType,RequestId,Requestsystem,Rejection I am expecting below out put

{ "EventType":"Cretate" { "RequestDetails": {

"RequestId":"1234", "Requestsystem":"asd" } }, "Rejection":null


Now i am getting

{ "RequestDetails": { "RequestId":"1234", "Requestsystem":"asd" }, "EventType":"Cretate", "Rejection":null }

edit flag offensive delete link more


It's a JSON map. Maps are not ordered. You can use Field Order processor to impose an order if necessary.

metadaddy gravatar imagemetadaddy ( 2020-03-03 12:12:25 -0600 )edit
Login/Signup to Answer

Question Tools

1 follower


Asked: 2020-02-29 08:09:31 -0600

Seen: 82 times

Last updated: Mar 03