get_json_object&mapjoin

1、get_json_object
select get_json_object('{"store": {"fruit":\[{"weight":8,"type":"apple"},{"weight":9,"type":"pear"}], "bicycle":{"price":19.95,"color":"red"} },  "email":"amy@only_for_json_udf_test.net",  
"owner":"amy" }' , '$.owner'); 
​
select get_json_object('{"store":{"fruit":\["aa","bb","cc"]},"owner":"amy"}','$.store.fruit[0]') ;
​
select get_json_object('{"store":{"fruit":\["aa","bb","cc"]},"owner":"amy"}','$.store.fruit') ;

2， mapjoin
参考：http://flyingdutchman.iteye.com/blog/1871983