It should work starting with 0.7 (both client and server need to be 0.7). As for the keys, see HIVE-1734.
-----Original Message----- From: Sunderlin, Mark [mailto:mark.sunder...@teamaol.com] Sent: Thursday, April 28, 2011 10:57 AM To: 'user@hive.apache.org' Subject: Selecting an entire map, not just one element with Squirrel? OK, feeling a bit dumb here . so I need the hive user group jolt to the head ... Given a table like: describe hive_map_test col_name data_type comment log_record_type int <null> key_pairs map<string,string> <null> ev_date string <null> and given that this works: select key_pairs['kvcity'] from hive_map_test _col0 Ashburn Winchester Selecting the map as a whole should be: select key_pairs from hive_map_test Which works from Hue. But, when I try this with Squirrel, I get: java.sql.SQLException: Inrecognized column type: map<string,string> Any ideas? Also, anyway to get just the keys in a select? --- Mark E. Sunderlin Solutions Architect |AOL Data Warehouse P: 703-256-6935 | C: 540-327-6222 AIM: MESunderlin 22000 AOL Way | Dulles, VA | 20166
