How to query nested Struct

I have data in parquet file in HDFS.

One of the columns in that parquet has values in below format of nested struct format. Please help me how to query such data. Just for an example, say there are 2 fields in the parquet file,

UserName, UserValue. UserValue filed has data in struct type.

Say, How should I write the query to query the VDS to find out all users where fieldA=‘Value93’.

[
{
“type”: “fieldA”,
“value”: “Value93”
},
{
“type”: “fieldB”,
“value”: “Value683”
},
{
“type”: “fieldC”,
“value”: “Value9870”
},
{
“type”: “fieldD”,
“value”: “Value09”
}
]

1 Like