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.

Want to insert the entire content of a json file into postgre DB.

Want to insert the entire content of a json file into postgre DB.

New Contributor

HI

I Want to insert the entire content of a json file as is into a column in my postgre DB (with 2 columns: id & value).

My json is (also contains an array):


{

"visits": [

{

"buildingCode": "xxxx",

"buildingName": "xxxx",

"entrance": "xxx",

"createdDate": "xxx",

"checkedInDate": "xxx",

"checkedOutDate": null,

"hasWifi": xx,

"visitCode": "xxxx",

"cancelled": xx

},

{

"buildingCode": "xxx",

"buildingName": "xxxx",

"entrance": "xx",

"createdDate": "xxx",

"checkedInDate": "xxx",

"checkedOutDate": nxxull,

"hasWifi": xx,

"visitCode": "xx",

"cancelled": xx

}]

}


Can you pllease suggest me with the flow.