Hi,
We have a requirement to query HBASE table which has single column with
nested json:
1. What will be the query to convert the JSON data into table format.
2. Also the query should be generic enough to pick any new columns that may
vary between different json blocks.
3. In below example the 1st JSON block has attribute "taste" and second
JSON block has attribute "type", but the query should be generic enough to
return both type and taste
4. Query should be able to extract any new attribute introduced in future.
{
"id": "0001",
"taste": "donut",
"name": "Cake",
"ppu": 0.55,
"batters":
{
"batter":
[
{ "id": "1001", "type": "Regular" },},
{ "id": "1004", "type": "Devil's Food" }
]
},
"topping":
[
{ "id": "5001", "type": "None" },
{ "id": "5002", "type": "Glazed" }
]
}
{
"id": "0002",
"type": "donut",
"name": "Cake",
"ppu": 0.55,
"batters":
{
"batter":
[
{ "id": "1001", "type": "Regular" },
{ "id": "1004", "type": "Devil's Food" }
]
},
"topping":
[
{ "id": "5001", "type": "None" },
{ "id": "5004", "type": "Maple" }
]
}
|