Reply
New Contributor
Posts: 1
Registered: ‎10-09-2013

Map data type in Hive.

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.

Cloudera Employee
Posts: 9
Registered: ‎08-01-2013

Re: Map data type in Hive.

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.