Hi all,
I have a bucket containing various sorts of data. Each document exists of multiple JSON objects. Below, is the output for SELECT * FROM test
statement. How may I list every distinct field name for each sub-document?
For the output below, I want to be able to get data1, data2, data3, data4, data5, data6
[
{
"test": [
{
"data1": "data1",
"data2": "data2",
"data3": "data3",
"data4": "data4"
}
]
},
{
"test": [
{
"data1": "data1",
"data2": "data2",
"data3": "data3",
"data4": "data4"
}
]
},
{
"test": [
{
"data1": "data1",
"data2": "data2",
"data3": "data3",
"data4": "data4",
"data5": "data5"
}
]
},
{
"test": [
{
"data1": "data1",
"data2": "data2",
"data3": "data3"
}
]
},
{
"test": [
{
"data1": "data1"
},
{
"data1": "data1",
"data2": "data2"
},
{
"data1": "data1",
"data2": "data2",
"data3": "data3",
"data4": "data4",
"data5": "data5",
"data6": "data6"
},
{
"data1": "data1",
"data2": "data2",
"data3": "data3",
"data4": "data4"
},
{
"data1": "data1",
"data2": "data2",
"data3": "data3"
}
]
}
]