0: jdbc:hive2://node03:10000> select id, map_keys(info) as map_keys,..............> map_values(info)as map_values
..............>from complex;+-----+-----------------+-----------------+--+| id | map_keys | map_values |+-----+-----------------+-----------------+--+|1|["name","age"]|["john","28"]||2|["name","age"]|["smith","12"]|+-----+-----------------+-----------------+--+
4. array_contains(Array, value)
0: jdbc:hive2://node03:10000> select id, profession, array_contains(profession, 'teacher') as array_contains from complex;+-----+----------------------------+-----------------+--+| id | profession | array_contains |+-----+----------------------------+-----------------+--+|1|["teacher","driver"]|true||2|["student","it","worker"]|false|+-----+----------------------------+-----------------+--+
5. sort_array(Array)
0: jdbc:hive2://node03:10000> select id, sort_array(profession) as sort_array from complex;+-----+----------------------------+--+| id | sort_array |+-----+----------------------------+--+|1|["driver","teacher"]||2|["it","student","worker"]|+-----+----------------------------+--+