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.

How to convert denormalized customer record set into a nested json??

Highlighted

How to convert denormalized customer record set into a nested json??

New Contributor

Say I have the following attributes related to customer data -

1. Customer ID

2. Customer Name

3. Customer Addresses (Multiple Like Home, Work, etc)

4. Customer Phone (Multiple like Home, Work, Mobile, Fax, etc)


When I query relational DB to capture all of this information, I get a denormalized dataset, wherein the customer id and customer name repeats for all the entries of addresses and phones.

I want to convert this data into a nested JSON which will have id and name fields only once, but an array of addresses and phone numbers.


How to achieve this in HDF or Apache NiFi

Don't have an account?
Coming from Hortonworks? Activate your account here