hive解析jsonobject jsonarray常用的自定义函数_hive json 转 array

# 加载 + 使用
```hiveql
add jar /Users/thomas990p/IdeaProjects/hiveThomasUDF/target/hiveThomasUDF-1.0-SNAPSHOT-jar-with-dependencies.jar;
 
-- udf
create temporary function size_json_array as "org.thomas.hive.udf.JsonArraySize";
-- select size_json_array('[{"k1":"v1"},{"k2":"v2"}]') ;
    -- 2
 
create temporary function get_json_object_via_path as 'org.thomas.hive.udf.GetJsonObjectViaPath';
-- select get_json_object_via_path('[{"k1":11,"k2":22},{"k1":44,"k2":55}]','$[*].k1') ;
    -- [11,44] 这里不是数组 是string 
 
create temporary function get_json_array_via_path as 'org.thomas.hive.udf.GetJsonArrayViaPath';
-- select get_json_array_via_path('{"k1":100,"k2":[11,22,33]}','$.k2') ;
    -- ["11","22","33"]  Array<String> 
-- select get_json_array_via_path('[{"k1":11,"k2":22},{"k1":44,"k2":55}]','$[*].k1') ;
    -- [11,44] 这里是数组
 
create temporary function castArrayType2Int as 'org.thomas.hive.udf.ArrayCastType.CastArrayT1Cast2Int';
-- select castArrayType2Int(array('1','2')) ;
    -- [1,2]
 
create temporary function castArrayType2Double as 'org.thomas.hive.udf.ArrayCastType.CastArrayT1Cast2Double';
-- select castArrayType2Double(array('1.11','2.22')) ;
-- [1.11,2.23]
 
create temporary function castArrayType2Long as 'org.thomas.hive.udf.ArrayCastType.CastArrayT1Cast2Long';
-- select castArrayType2Long(array(123456789012,1234567890123)) ;
-- [123456789012,1234567890123]
 
create temporary function get_json_array as "org.thomas.hive.udf.GetJsonArray";
-- select name,field_name2 from tb1 lateral view explode(get_json_array('[{"k1":"v1"},{"k2":"v2"}]')) tmp_table_name AS field_name2 limit 2;
    -- +------+-----------+
    -- |name  |field_name2|
    -- +------+-----------+
    -- |thomas|{"k1":"v1"}|
    -- |thomas|{"k2":"v2"}|
    -- +------+-----------+
 
 
-- udtf 
create temporary function explode_json_array as "org.thomas.hive.udtf.ExplodeJsonArray";
-- select name,ainfo from tb1 lateral view explode_json_array('[{"k1":"v1"},{"k2":"v2"}]') tmp_table_name AS ainfo limit 2;
    -- +------+-----------+
    -- |name  |ainfo      |
    -- +------+-----------+
    -- |thomas|{"k1":"v1"}|
    -- |thomas|{"k2":"v2"}|
    -- +------+-----------+
 
 
-- udaf
```
 
 

持续更新

GitHub - yangyongyongyong/hiveThomasUDF at dev