Support Questions
Find answers, ask questions, and share your expertise

How to query uniontype column


How to query uniontype column

Expert Contributor

I have a uniontype column in the table defined like this:


`location` uniontype<struct<latitude:string,longitude:string,country_short:string,country_long:string,region:string,city:string>,boolean>
How do I go about querying: "select location.latitiude, location.latitude from ..." since I get this error using that syntax:

. Operator is only supported on struct or list of struct types


If this is currently not supported via Hive, would appreciate if anyone can throw some light on how to go about this outside of Hive?