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

Map data type in Hive.


Map data type in Hive.

New Contributor

I would like more information on using the map data type in Hive, there sems to be minimal documenattaion available. Sample of how to load and access would be good, as well as any commoents on performance and any constraints.


Thank you.


Re: Map data type in Hive.

Cloudera Employee

Here's how to access a Hive Map in a Select:

SELECT somemap["SOMEKEY"] FROM employees


This StackOverflow question gives information on loading.


Our Data Analyst class covers maps and structs in depth.



Don't have an account?
Coming from Hortonworks? Activate your account here