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
