HiveSQL-get

hive> select * from temp;OKA1{"id":10001,"type":"show","from":"home","source":"his"}A2{"id":10001,"type":"show","from":"home","source":"his"}A3{"id":10001,"type":"show","from":"home","source":"his"}A4{"id":10001,"type":"show","from":"home","source":"his"}A5{"id":10001,"type":"show","from":"home","source":"his"}Time taken: 0.093 seconds, Fetched: 5 row(s)hive> select id,get_json_object(str,"$.type") as tp from temp;OKA1showA2showA3showA4showA5showTime taken: 0.177 seconds, Fetched: 5 row(s)