hive函数 get_json_object的使用，对于数组类型的例如格式： [{"commoditytype":1,"skuid":"1111111","storeid":"0000","storename":""},{"commoditytype":2,"skuid":"2222222","storeid":"0000","storename":""},{"commoditytype":2,"skuid":"333333","storeid":"0000","storename":""}]使用get_json_object解析，select get_json_object('[{"commoditytype":1,"skuid":"1111111","storeid":"0000","storename":""},{"commoditytype":2,"skuid":"2222222","storeid":"0000","storename":""},{"commoditytype":2,"skuid":"333333","storeid":"0000","storename":""}]','$.[0,2].skuid')