hive> select * from temp;
OK
A1 {"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;
OK
A1 show
A2 show
A3 show
A4 show
A5 show
Time taken: 0.177 seconds, Fetched: 5 row(s)
