Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

Insert MongoDB Data into Mysql Using PutSQL giving error

Insert MongoDB Data into Mysql Using PutSQL giving error

Expert Contributor

Hello All,

Iam trying to put mongodb data into mysql server.

My GetMongo processor details:-

92398-screenshot-16.png

My sample Json looks like this:-

{
  "_id" : "MMH",
  "_class" : "com.SwipecardLocationDetails",
  "location_description" : "INDIA"
} 

PutSQL:-

92400-screenshot-13.png

DBCPConnectionPool:-

92401-screenshot-14.png

I have used putsql query as:

insert into locations values (${_id}, ${_class},${location_description})


But it giving me error as

92402-screenshot-15.png

@Shu please correct me.

Thanks,

Mohan V