clickhouse — clickhouse解析复杂JSON数组

举例

– 查数据

select _id,doctorId,patientId,diagnosisList from patient_disease final where diagnosisList is not null limit 3;

– 解析数组

SELECT _id,doctorId,patientId,visitParamExtractRaw(diagnosisList,'diagnosisName') FROM patient_disease final where _id in ('655b882da7f855000d5ea34b','655b887ea7f855000d5ea34c','655b889f8d72a3000d4b4a49');

– 去掉引号

 SELECT _id,doctorId,patientId,substring(visitParamExtractRaw(diagnosisList,'diagnosisName'),3,-1) FROM patient_disease final where _id in ('655b882da7f855000d5ea34b','655b887ea7f855000d5ea34c','655b889f8d72a3000d4b4a49');

代码007普通

打赏 收藏 海报 链接