hive使用自定义UDF处理json数据数组

前期准备部分
测试数据

user1;18;male;{"id": 1,"ids": [101,102,103],"total_number": 3} 
user2;20;female;{"id": 2,"ids": [201,202,203,204],"total_number": 4} 
user3;23;male;{"id": 3,"ids": [301,302,303,304,305],"total_number": 5} 
user4;17;male;{"id": 4,"ids": [401,402,403,304],"total_number":5}
user5;35;female;{"id": 5,"ids": [501,502,503],"total_number": 3}

pom.xml所需要的依赖

<dependency> 
    <groupId>org.apache.hive</groupId> 
    <artifactId>hive-exec</artifactId> 
    <version>2.3.7</version> 
    <scope>provided</scope> 
</dependency>

代码部分

package com.lagou.hive.udf;

import com.alibaba.fastjson.JSON;
import com.alibaba.fastjson.JSONArray;