Json Structure was :
{"site":
[{"siteid":"site1","sitename":"sitename1"},{"siteid":"site2","sitename":"sitename2"}]}
Parquet data when i query through Drill explorer:
site as a column name: below is the value
{
"array" : [ {
"siteid" : "site1",
"sitename" : "sitename1"
}, {
"siteid" : "site2",
"sitename" : "sitename2"
} ]
}
The work "array" is shown with the data. By which Drill is not able to read the
data set using the FLATTEN Function.
Is there any way to read the data using Flatten function.
Thanks
Vinupriyaa