有时候会将一些信息以json形式存在数据库中,如果太长的话,在取的过程中sql运行会比较慢,如果只取某些键值的话会比较浪费
mysql中使用函数JSON_EXTRACT()
±—±---------------------------------------------------------------+
| id | data |
±—±---------------------------------------------------------------+
| 1 | {“Tel”: “132223232444”, “name”: “david”, “address”: “Beijing”} |
| 2 | {“Tel”: “13390989765”, “name”: “Mike”, “address”: “Guangzhou”} |
±—±---------------------------------------------------------------+
select json_extract('{"name":"Zhaim","tel":"13240133388"}',"$.tel");
spark sql中使用get_json_object()
select get_json_object(i.extra, '$.sale_currency');
select sum(get_json_object(i.extra, '$.sale_price') * i.count) as sale_price;