JSON 函数

JSON 函数

一 在CH 中建表

create table tb_json(cont String) engine=Log ;

二 导入表数据

insert into  tb_json values('{"movie":"1207","rate":"4","timeStamp":"978300719","uid":"1"}')
,('{"movie":"2028","rate":"5","timeStamp":"978301619","uid":"1"}')
,('{"movie":"531","rate":"4","timeStamp":"978302149","uid":"1"}')
,('{"movie":"3114","rate":"4","timeStamp":"978302174","uid":"1"}')
,('{"movie":"608","rate":"4","timeStamp":"978301398","uid":"1"}')
,('{"movie":"1246","rate":"4","timeStamp":"978302091","uid":"1"}')
,('{"movie":"1357","rate":"5","timeStamp":"978298709","uid":"2"}') ;

select * from tb_json ;  查询表

方法一

visitParamExtractString(params, name)
查询数据的一个属性

select visitParamExtractString(cont,'movie') from tb_json ;
               取某个参数

方法二 解析 JSON

select JSONExtract(cont,'Tuple(movie String,rate String,uid String)') from tb_json ;

2）

select  JSONExtract(cont, 'Tuple(movie String , rate String , uid String)').3
FROM tb_json