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

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.