Sathish,
Curent version Hive ONLY support union type has two primitive/struct types,
i.e.. {“name”: “alias_host”, “type”: [ “string”, “null” ]} , or {“name”:
“alias_host”, “type”: [{“type”: “array”, “items”: “string”]}, “null”}.
You can consider JSON string as a column type when the column has s
Your "alias_host" column is an array, from your Avro specification, right?
If so, just use [] to access the specified element in the array
select alias_host[0] from array_tests where aliat_host[0] like '%test%'
If you want to query all the elements in the array, google "explode lateral
view" of hi