Reply
Highlighted
Expert Contributor
Posts: 139
Registered: ‎07-21-2014

How to query uniontype column

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?

 

Thanks!