Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

How to query uniontype column

Highlighted

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?

 

Thanks!