how do I query array element in impala : I created a table in impala ,the have two columns ,
+-----------+---------------------+---------+
| name      | type                | comment |
+-----------+---------------------+---------+
| unique_id | string              |         |
| cmap      | array<struct<       |         |
|           |   fieldname:string, |         |
|           |   fieldid:string,   |         |
|           |   fielddata:string  |         |
|           | >>                  |         |
+-----------+---------------------+---------+
i need set condictions for cmap to query unique_id,such as 
(fieldname="ip"and fielddata="192.168.1.145"  ) and(fieldname="wid" and fielddata="15") 

i wrote a this sql but can't query nothing data,but i've insert data in the table  ,pls help me to find is something
wrong? appricate your help.

sql： select unique_id  from s_click_parquet,s_click_parquet.cmap as lst  where ( fieldname="ip" and fieldData="192.168.1.145") and(fieldname="wid" and fielddata="15");








