建表导入测试数据
CREATE TABLE IF NOT EXISTS jsont1(
username string,
age int,
sex string,
json string )
row format delimited fields terminated by ';';
load data local inpath '/data/lagoudw/data/weibo.json' overwrite into table jsont1;
内置函数一:get_json_object(string json_string, string path)
解析json字符串json_string,返回path指定的内容;
取单层值
select username, age, sex,
get_json_object(json, "$.id") id,
get_json_object(json, "$.ids") ids,
get_json_object(j