I have a table for people. Those people have friends who have friends. All people, friend or not, have the same data. The parent has no other friends but does have a column for that. This mirrors the data that I am getting.
If I create a json Metedata schema of "friend" to house the columns (id, name, friendOf, someValue), how can I pull this data into a parquet file or other flat file or db?
To the point, how can I parse this with Talend? How can I use tMap, tExtractJson or other component on an "n" number of levels of the same data?
Hopefully, the json isn't too butchered.
{
"friends": {
"id": 100,
"name": "Bob",
"friendOf": null,
"someValue": "58",
"children": [
{
"id": 101,
"name": "Sue",
"friendOf": "Bob",
"someValue": "123"
},
{
"id": 102,
"name": "Jan",
"friendOf": "Bob",
"someValue": "99",
"children": [
{
"id": 101,
"name": "Ivy",
"friendOf": "Jan",
"someValue": "10"
}
]
},
{
"id": 103,
"name": "Jon",
"friendOf": "Bob",
"someValue": "90"
},
{
"id": 104,
"name": "Ron",
"friendOf": "Bob",
"someValue": "23",
"children": [
{
"id": 105,
"name": "Cal",
"friendOf": "Ron",
"someValue": "777",
"children": [
{
"id": 106,
"name": "Ann",
"friendOf": "Cal",
"someValue": "777"
},
{
"id": 107,
"name": "Leo",
"friendOf": "Cal",
"someValue": "42"
}
]
}
]
}
]
}
}
