SparkSQL函数【get_json_object】

Spark不常用函数之解析Json格式的字段

函数一：get_json_object

数据背景：

CREATE OR REPLACE TEMPORARY VIEW employee_11
AS
SELECT 
  '{"age": "E0100", "Name": "广东"}' AS json_data

SparkSQL把该字段解析成两个字段语法如下：

  SELECT get_json_object(json_data, '$.age') as age,get_json_object(json_data, '$.Name') as Name FROM employee_11

其他用法待补充