热门标签
热门文章
- 1【Python】已解决：WARNING: pip is configured with locations that require TLS/SSL, however the ssl module i
- 2基于RTMP协议流媒体直播的整体解决方案_rtmp流媒体
- 3LinuxUNIX系统编程手册——（十四）系统编程概念
- 4Hadoop集群中hive搭建_hadoop集群搭建hive
- 5解决 git：OpenSSL SSL_read: SSL_ERROR_SYSCALL, errno 0
- 6时隔两年，盘点ECCV 2018影响力最大的20篇论文_eccv 2018 image inpainting for irregular holes usi
- 7Python中常用的自然语言处理(NLP)框架_python自然语言提取 框架
- 8【Java】Win11 Java/JDK 安装教程（超详细，内置 JDK 安装包）_jdk11安装包
- 9Qt树形控件QTreeView使用1——节点的添加删除操作_qtreeview删除节点后有空行_qtreeview添加子节点
- 10android:exported =true,什么是具有相同用户ID的Android应用程序_android 带有相同用户id的应用程序
当前位置: article > 正文
hive的复杂json数组对象中包含的数组对象扁平化解析_hive嵌套json转换扁平化json
作者：木道寻08 | 2024-07-31 23:12:52
赞
踩
hive嵌套json转换扁平化json
一、原始json格式如下
{ "primaryScheme": { "groupCode": "TJ-hba1cG7L8-ageG60-bmiG28", "regimenType": "drug", "regimens": [ { "drugTypes": [ { "drugs": [ { "dose": "0.5g或1g，单日最大累积剂量2g", "drugGenericCode": "XA10BAE021", "drugGenericName": "二甲双胍", "frequency": "每天两次或每天三次，推荐餐后", "remark": "由于老年患者可能出现肾功能减退，应定期检查肾功能并根据肾功能调整二甲双胍的剂量", "usage": "口服" } ], "notes": [ { "decrements": [ ], "disables": [ "二甲双胍" ], "recommends": [ ], "target": "60>=eGFR>30", "type": "肾功能禁忌" }, { "decrements": [ ], "disables": [ "二甲双胍" ], "recommends": [ ], "target": "30>=eGFR", "type": "肾功能禁忌" }, { "decrements": [ ], "disables": [ "二甲双胍" ], "recommends": [ ], "target": "谷草谷丙>=100", "type": "肝功能禁忌" } ], "typeCode": "XA10BA", "typeName": "双胍类" } ], "priority": 1, "reason": "", "regimenCode": "TJ-hba1cG7L8-ageG60-bmiG28-reg1", "regimenName": "【优选】二甲双胍" }, { "drugTypes": [ { "drugs": [ { "dose": "50mg-100mg，单次最大剂量200mg", "drugGenericCode": "XA10BFA025", "drugGenericName": "阿卡波糖", "frequency": "每天三次，餐中", "remark": "", "usage": "口服" }, { "dose": "0.2mg，单次最大剂量0.3mg", "drugGenericCode": "XA10BFF058", "drugGenericName": "伏格列波糖", "frequency": "每天三次，餐中", "remark": "", "usage": "口服" }, { "dose": "25mg起始，单次最大剂量100mg", "drugGenericCode": "XA10BFM097", "drugGenericName": "米格列醇", "frequency": "每天三次，餐中", "remark": "", "usage": "口服" } ], "notes": [ { "decrements": [ ], "disables": [ "伏格列波糖", "米格列醇", "阿卡波糖" ], "recommends": [ ], "target": "30>=eGFR", "type": "肾功能禁忌" }, { "decrements": [ ], "disables": [ "伏格列波糖", "阿卡波糖" ], "recommends": [ ], "target": "谷草谷丙>=100", "type": "肝功能禁忌" } ], "typeCode": "XA10BF", "typeName": "α⁃糖苷酶抑制剂" } ], "priority": 2, "reason": "", "regimenCode": "TJ-hba1cG7L8-ageG60-bmiG28-reg2", "regimenName": "【可用】α-糖苷酶抑制剂" }, { "drugTypes": [ { "drugs": [ { "dose": "0.6mg一周后无明显胃肠道反应后可加至1.2mg，单日最大剂量1.8mg", "drugGenericCode": "XA10BJL326", "drugGenericName": "利拉鲁肽", "frequency": "每天一次", "remark": "", "usage": "皮下注射" }, { "dose": "0.25mg或0.5mg起始，每周最大推荐剂量为1mg", "drugGenericCode": "XA10BJS279", "drugGenericName": "司美格鲁肽", "frequency": "每周一次", "remark": "", "usage": "皮下注射" }, { "dose": "0.75 mg起始，每周最大推荐剂量为 1.5 mg", "drugGenericCode": "XA10BJD332", "drugGenericName": "度拉糖肽", "frequency": "每周一次", "remark": "", "usage": "皮下注射" }, { "dose": "5 μg起始，单次最大剂量10mg", "drugGenericCode": "XA10BJA085", "drugGenericName": "艾塞那肽", "frequency": "每天二次，早餐、晚餐前 60 分钟内", "remark": "对患有胰腺炎的患者，禁用本品。不推荐本品用于终末期肾病或严重肾功能 不全(肌酐清除率<30 ml/min)的患者", "usage": "皮下注射" }, { "dose": "10μg应用14天，后调整为20μg维持", "drugGenericCode": "XA10BJL366", "drugGenericName": "利司那肽", "frequency": "每天一次", "remark": "", "usage": "皮下注射" }, { "dose": "0.1mg，每周最大推荐剂量为0.2mg", "drugGenericCode": "XA10BJJ237", "drugGenericName": "洛塞那肽", "frequency": "每周一次", "remark": "", "usage": "皮下注射" } ], "notes": [ { "decrements": [ "洛塞那肽" ], "disables": [ ], "recommends": [ ], "target": "60>=eGFR>30", "type": "肾功能禁忌" }, { "decrements": [ ], "disables": [ "度拉糖肽", "司美格鲁肽", "利拉鲁肽", "艾塞那肽", "利司那肽", "洛塞那肽" ], "recommends": [ ], "target": "30>=eGFR", "type": "肾功能禁忌" }, { "decrements": [ ], "disables": [ "利拉鲁肽", "司美格鲁肽" ], "recommends": [ ], "target": "谷草谷丙>=100", "type": "肝功能禁忌" }, { "decrements": [ ], "disables": [ ], "recommends": [ "度拉糖肽", "司美格鲁肽", "利拉鲁肽", "艾塞那肽", "利司那肽", "洛塞那肽" ], "target": "冠心病/心衰", "type": "心血管功能禁忌" } ], "typeCode": "XA10BJ", "typeName": "GLP-1RA" }, { "drugs": [ { "dose": "10mg起始，单日最大剂量25mg", "drugGenericCode": "XA10BKE079", "drugGenericName": "恩格列净", "frequency": "每天一次", "remark": "", "usage": "口服" }, { "dose": "100mg起始，单日最大剂量300mg", "drugGenericCode": "XA10BKK130", "drugGenericName": "卡格列净", "frequency": "每天一次", "remark": "", "usage": "口服" }, { "dose": "5mg", "drugGenericCode": "XA10BKA338", "drugGenericName": "艾托格列净", "frequency": "每天一次", "remark": "", "usage": "口服" }, { "dose": "5mg起始，单日最大剂量10mg", "drugGenericCode": "XA10BKD256", "drugGenericName": "达格列净", "frequency": "每天一次", "remark": "", "usage": "口服" } ], "notes": [ { "decrements": [ ], "disables": [ "卡格列净", "恩格列净", "艾托格列净" ], "recommends": [ ], "target": "60>=eGFR>30", "type": "肾功能禁忌" }, { "decrements": [ ], "disables": [ "卡格列净", "达格列净", "恩格列净", "艾托格列净" ], "recommends": [ ], "target": "30>=eGFR", "type": "肾功能禁忌" }, { "decrements": [ ], "disables": [ "卡格列净", "达格列净", "恩格列净", "艾托格列净" ], "recommends": [ ], "target": "谷草谷丙>=100", "type": "肝功能禁忌" }, { "decrements": [ ], "disables": [ ], "recommends": [ "卡格列净", "达格列净", "恩格列净", "艾托格列净" ], "target": "冠心病/心衰", "type": "心血管功能禁忌" } ], "typeCode": "XA10BK", "typeName": "SGLT-2抑制剂" }, { "drugs": [ { "dose": "50mg", "drugGenericCode": "XA10BHW104", "drugGenericName": "维格列汀", "frequency": "每天两次", "remark": "", "usage": "口服" }, { "dose": "100mg", "drugGenericCode": "XA10BHX202", "drugGenericName": "西格列汀", "frequency": "每天一次", "remark": "", "usage": "口服" }, { "dose": "5mg", "drugGenericCode": "XA10BHL343", "drugGenericName": "利格列汀", "frequency": "每天一次", "remark": "", "usage": "口服" }, { "dose": "5mg", "drugGenericCode": "XA10BHS231", "drugGenericName": "沙格列汀", "frequency": "每天一次", "remark": "", "usage": "口服" }, { "dose": "25mg", "drugGenericCode": "XA10BHA283", "drugGenericName": "阿格列汀", "frequency": "每天一次", "remark": "", "usage": "口服" } ], "notes": [ { "decrements": [ "维格列汀", "西格列汀", "阿格列汀", "沙格列汀" ], "disables": [ ], "recommends": [ ], "target": "60>=eGFR>30", "type": "肾功能禁忌" }, { "decrements": [ "维格列汀" ], "disables": [ "沙格列汀", "西格列汀", "阿格列汀" ], "recommends": [ ], "target": "30>=eGFR", "type": "肾功能禁忌" }, { "decrements": [ ], "disables": [ "维格列汀" ], "recommends": [ ], "target": "谷草谷丙>=100", "type": "肝功能禁忌" }, { "decrements": [ ], "disables": [ ], "recommends": [ "维格列汀", "西格列汀", "沙格列汀", "阿格列汀", "利格列汀" ], "target": "冠心病/心衰", "type": "心血管功能禁忌" } ], "typeCode": "XA10BH", "typeName": "DPP⁃4抑制剂" } ], "priority": 3, "reason": "", "regimenCode": "TJ-hba1cG7L8-ageG60-bmiG28-reg3", "regimenName": "【可用】GLP-1RA或SGLT-2抑制剂或DPP-4抑制剂" } ] }, "specialistScheme": { "groupCode": "HS-hba1cG7L8-ageG60-bmiG28", "regimenType": "drug", "regimens": [ { "drugTypes": [ { "drugs": [ { "dose": "0.6mg一周后无明显胃肠道反应后可加至1.2mg，单日最大剂量1.8mg", "drugGenericCode": "XA10BJL326", "drugGenericName": "利拉鲁肽", "frequency": "每天一次", "remark": "", "usage": "皮下注射" }, { "dose": "0.25mg或0.5mg起始，每周最大推荐剂量为1mg", "drugGenericCode": "XA10BJS279", "drugGenericName": "司美格鲁肽", "frequency": "每周一次", "remark": "", "usage": "皮下注射" }, { "dose": "0.75 mg起始，每周最大推荐剂量为 1.5 mg", "drugGenericCode": "XA10BJD332", "drugGenericName": "度拉糖肽", "frequency": "每周一次", "remark": "", "usage": "皮下注射" }, { "dose": "5 μg起始，单次最大剂量10mg", "drugGenericCode": "XA10BJA085", "drugGenericName": "艾塞那肽", "frequency": "每天二次，早餐、晚餐前 60 分钟内", "remark": "对患有胰腺炎的患者，禁用本品。不推荐本品用于终末期肾病或严重肾功能 不全(肌酐清除率<30 ml/min)的患者", "usage": "皮下注射" }, { "dose": "10μg应用14天，后调整为20μg维持", "drugGenericCode": "XA10BJL366", "drugGenericName": "利司那肽", "frequency": "每天一次", "remark": "", "usage": "皮下注射" }, { "dose": "0.1mg，每周最大推荐剂量为0.2mg", "drugGenericCode": "XA10BJJ237", "drugGenericName": "洛塞那肽", "frequency": "每周一次", "remark": "", "usage": "皮下注射" } ], "notes": [ { "decrements": [ "洛塞那肽" ], "disables": [ ], "recommends": [ ], "target": "60>=eGFR>30", "type": "肾功能禁忌" }, { "decrements": [ ], "disables": [ "利拉鲁肽", "利司那肽", "艾塞那肽", "度拉糖肽", "司美格鲁肽", "洛塞那肽" ], "recommends": [ ], "target": "30>=eGFR", "type": "肾功能禁忌" }, { "decrements": [ ], "disables": [ "司美格鲁肽", "利拉鲁肽" ], "recommends": [ ], "target": "谷草谷丙>=100", "type": "肝功能禁忌" }, { "decrements": [ ], "disables": [ ], "recommends": [ "利拉鲁肽", "利司那肽", "艾塞那肽", "度拉糖肽", "司美格鲁肽", "洛塞那肽" ], "target": "冠心病/心衰", "type": "心血管功能禁忌" } ], "typeCode": "XA10BJ", "typeName": "GLP-1RA" }, { "drugs": [ { "dose": "10mg起始，单日最大剂量25mg", "drugGenericCode": "XA10BKE079", "drugGenericName": "恩格列净", "frequency": "每天一次", "remark": "", "usage": "口服" }, { "dose": "100mg起始，单日最大剂量300mg", "drugGenericCode": "XA10BKK130", "drugGenericName": "卡格列净", "frequency": "每天一次", "remark": "", "usage": "口服" }, { "dose": "5mg", "drugGenericCode": "XA10BKA338", "drugGenericName": "艾托格列净", "frequency": "每天一次", "remark": "", "usage": "口服" }, { "dose": "5mg起始，单日最大剂量10mg", "drugGenericCode": "XA10BKD256", "drugGenericName": "达格列净", "frequency": "每天一次", "remark": "", "usage": "口服" } ], "notes": [ { "decrements": [ ], "disables": [ "卡格列净", "艾托格列净", "恩格列净" ], "recommends": [ ], "target": "60>=eGFR>30", "type": "肾功能禁忌" }, { "decrements": [ ], "disables": [ "卡格列净", "达格列净", "艾托格列净", "恩格列净" ], "recommends": [ ], "target": "30>=eGFR", "type": "肾功能禁忌" }, { "decrements": [ ], "disables": [ "卡格列净", "达格列净", "艾托格列净", "恩格列净" ], "recommends": [ ], "target": "谷草谷丙>=100", "type": "肝功能禁忌" }, { "decrements": [ ], "disables": [ ], "recommends": [ "卡格列净", "达格列净", "艾托格列净", "恩格列净" ], "target": "冠心病/心衰", "type": "心血管功能禁忌" } ], "typeCode": "XA10BK", "typeName": "SGLT-2抑制剂" } ], "priority": 1, "reason": "", "regimenCode": "HS-hba1cG7L8-ageG60-bmiG28-reg1", "regimenName": "【优选】GLP-1RA（或加用SGLT-2抑制剂）" }, { "drugTypes": [ { "drugs": [ { "dose": "10mg起始，单日最大剂量25mg", "drugGenericCode": "XA10BKE079", "drugGenericName": "恩格列净", "frequency": "每天一次", "remark": "", "usage": "口服" }, { "dose": "100mg起始，单日最大剂量300mg", "drugGenericCode": "XA10BKK130", "drugGenericName": "卡格列净", "frequency": "每天一次", "remark": "", "usage": "口服" }, { "dose": "5mg", "drugGenericCode": "XA10BKA338", "drugGenericName": "艾托格列净", "frequency": "每天一次", "remark": "", "usage": "口服" }, { "dose": "5mg起始，单日最大剂量10mg", "drugGenericCode": "XA10BKD256", "drugGenericName": "达格列净", "frequency": "每天一次", "remark": "", "usage": "口服" } ], "notes": [ { "decrements": [ ], "disables": [ "卡格列净", "艾托格列净", "恩格列净" ], "recommends": [ ], "target": "60>=eGFR>30", "type": "肾功能禁忌" }, { "decrements": [ ], "disables": [ "卡格列净", "达格列净", "艾托格列净", "恩格列净" ], "recommends": [ ], "target": "30>=eGFR", "type": "肾功能禁忌" }, { "decrements": [ ], "disables": [ "卡格列净", "达格列净", "艾托格列净", "恩格列净" ], "recommends": [ ], "target": "谷草谷丙>=100", "type": "肝功能禁忌" }, { "decrements": [ ], "disables": [ ], "recommends": [ "卡格列净", "达格列净", "艾托格列净", "恩格列净" ], "target": "冠心病/心衰", "type": "心血管功能禁忌" } ], "typeCode": "XA10BK", "typeName": "SGLT-2抑制剂" } ], "priority": 2, "reason": "", "regimenCode": "HS-hba1cG7L8-ageG60-bmiG28-reg2", "regimenName": "【优选】SGLT-2抑制剂" }, { "drugTypes": [ { "drugs": [ { "dose": "0.5g或1g，单日最大累积剂量2g", "drugGenericCode": "XA10BAE021", "drugGenericName": "二甲双胍", "frequency": "每天两次或每天三次，推荐餐后", "remark": "由于老年患者可能出现肾功能减退，应定期检查肾功能并根据肾功能调整二甲双胍的剂量", "usage": "口服" } ], "notes": [ { "decrements": [ ], "disables": [ "二甲双胍" ], "recommends": [ ], "target": "60>=eGFR>30", "type": "肾功能禁忌" }, { "decrements": [ ], "disables": [ "二甲双胍" ], "recommends": [ ], "target": "30>=eGFR", "type": "肾功能禁忌" }, { "decrements": [ ], "disables": [ "二甲双胍" ], "recommends": [ ], "target": "谷草谷丙>=100", "type": "肝功能禁忌" } ], "typeCode": "XA10BA", "typeName": "双胍类" }, { "drugs": [ { "dose": "50mg", "drugGenericCode": "XA10BHW104", "drugGenericName": "维格列汀", "frequency": "每天两次", "remark": "", "usage": "口服" }, { "dose": "100mg", "drugGenericCode": "XA10BHX202", "drugGenericName": "西格列汀", "frequency": "每天一次", "remark": "", "usage": "口服" }, { "dose": "5mg", "drugGenericCode": "XA10BHL343", "drugGenericName": "利格列汀", "frequency": "每天一次", "remark": "", "usage": "口服" }, { "dose": "5mg", "drugGenericCode": "XA10BHS231", "drugGenericName": "沙格列汀", "frequency": "每天一次", "remark": "", "usage": "口服" }, { "dose": "25mg", "drugGenericCode": "XA10BHA283", "drugGenericName": "阿格列汀", "frequency": "每天一次", "remark": "", "usage": "口服" } ], "notes": [ { "decrements": [ "沙格列汀", "维格列汀", "阿格列汀", "西格列汀" ], "disables": [ ], "recommends": [ ], "target": "60>=eGFR>30", "type": "肾功能禁忌" }, { "decrements": [ "维格列汀" ], "disables": [ "沙格列汀", "阿格列汀", "西格列汀" ], "recommends": [ ], "target": "30>=eGFR", "type": "肾功能禁忌" }, { "decrements": [ ], "disables": [ "维格列汀" ], "recommends": [ ], "target": "谷草谷丙>=100", "type": "肝功能禁忌" }, { "decrements": [ ], "disables": [ ], "recommends": [ "维格列汀", "西格列汀", "利格列汀", "阿格列汀", "沙格列汀" ], "target": "冠心病/心衰", "type": "心血管功能禁忌" } ], "typeCode": "XA10BH", "typeName": "DPP⁃4抑制剂" }, { "drugs": [ { "dose": "10mg起始，单日最大剂量25mg", "drugGenericCode": "XA10BKE079", "drugGenericName": "恩格列净", "frequency": "每天一次", "remark": "", "usage": "口服" }, { "dose": "100mg起始，单日最大剂量300mg", "drugGenericCode": "XA10BKK130", "drugGenericName": "卡格列净", "frequency": "每天一次", "remark": "", "usage": "口服" }, { "dose": "5mg", "drugGenericCode": "XA10BKA338", "drugGenericName": "艾托格列净", "frequency": "每天一次", "remark": "", "usage": "口服" }, { "dose": "5mg起始，单日最大剂量10mg", "drugGenericCode": "XA10BKD256", "drugGenericName": "达格列净", "frequency": "每天一次", "remark": "", "usage": "口服" } ], "notes": [ { "decrements": [ ], "disables": [ "卡格列净", "艾托格列净", "恩格列净" ], "recommends": [ ], "target": "60>=eGFR>30", "type": "肾功能禁忌" }, { "decrements": [ ], "disables": [ "卡格列净", "达格列净", "艾托格列净", "恩格列净" ], "recommends": [ ], "target": "30>=eGFR", "type": "肾功能禁忌" }, { "decrements": [ ], "disables": [ "卡格列净", "达格列净", "艾托格列净", "恩格列净" ], "recommends": [ ], "target": "谷草谷丙>=100", "type": "肝功能禁忌" }, { "decrements": [ ], "disables": [ ], "recommends": [ "卡格列净", "达格列净", "艾托格列净", "恩格列净" ], "target": "冠心病/心衰", "type": "心血管功能禁忌" } ], "typeCode": "XA10BK", "typeName": "SGLT-2抑制剂" }, { "drugs": [ { "dose": "0.6mg一周后无明显胃肠道反应后可加至1.2mg，单日最大剂量1.8mg", "drugGenericCode": "XA10BJL326", "drugGenericName": "利拉鲁肽", "frequency": "每天一次", "remark": "", "usage": "皮下注射" }, { "dose": "0.25mg或0.5mg起始，每周最大推荐剂量为1mg", "drugGenericCode": "XA10BJS279", "drugGenericName": "司美格鲁肽", "frequency": "每周一次", "remark": "", "usage": "皮下注射" }, { "dose": "0.75 mg起始，每周最大推荐剂量为 1.5 mg", "drugGenericCode": "XA10BJD332", "drugGenericName": "度拉糖肽", "frequency": "每周一次", "remark": "", "usage": "皮下注射" }, { "dose": "5 μg起始，单次最大剂量10mg", "drugGenericCode": "XA10BJA085", "drugGenericName": "艾塞那肽", "frequency": "每天二次，早餐、晚餐前 60 分钟内", "remark": "对患有胰腺炎的患者，禁用本品。不推荐本品用于终末期肾病或严重肾功能 不全(肌酐清除率<30 ml/min)的患者", "usage": "皮下注射" }, { "dose": "10μg应用14天，后调整为20μg维持", "drugGenericCode": "XA10BJL366", "drugGenericName": "利司那肽", "frequency": "每天一次", "remark": "", "usage": "皮下注射" }, { "dose": "0.1mg，每周最大推荐剂量为0.2mg", "drugGenericCode": "XA10BJJ237", "drugGenericName": "洛塞那肽", "frequency": "每周一次", "remark": "", "usage": "皮下注射" } ], "notes": [ { "decrements": [ "洛塞那肽" ], "disables": [ ], "recommends": [ ], "target": "60>=eGFR>30", "type": "肾功能禁忌" }, { "decrements": [ ], "disables": [ "利拉鲁肽", "利司那肽", "艾塞那肽", "度拉糖肽", "司美格鲁肽", "洛塞那肽" ], "recommends": [ ], "target": "30>=eGFR", "type": "肾功能禁忌" }, { "decrements": [ ], "disables": [ "司美格鲁肽", "利拉鲁肽" ], "recommends": [ ], "target": "谷草谷丙>=100", "type": "肝功能禁忌" }, { "decrements": [ ], "disables": [ ], "recommends": [ "利拉鲁肽", "利司那肽", "艾塞那肽", "度拉糖肽", "司美格鲁肽", "洛塞那肽" ], "target": "冠心病/心衰", "type": "心血管功能禁忌" } ], "typeCode": "XA10BJ", "typeName": "GLP-1RA" } ], "priority": 3, "reason": "", "regimenCode": "HS-hba1cG7L8-ageG60-bmiG28-reg3", "regimenName": "【优选】二甲双胍（或加用DPP-4抑制剂或SGLT-2抑制剂或GLP-1RA）" }, { "drugTypes": [ { "drugs": [ { "dose": "4mg，单日最大剂量8mg", "drugGenericCode": "XA10BGL261", "drugGenericName": "罗格列酮", "frequency": "每天一次", "remark": "", "usage": "口服" }, { "dose": "15mg-30mg，单日最大剂量45mg", "drugGenericCode": "XA10BGB091", "drugGenericName": "吡格列酮", "frequency": "每天一次", "remark": "老年患者应谨慎给药，密切观察服用期间是否发生不良反应", "usage": "口服" } ], "notes": [ { "decrements": [ ], "disables": [ "吡格列酮" ], "recommends": [ ], "target": "60>=eGFR>30", "type": "肾功能禁忌" }, { "decrements": [ ], "disables": [ "吡格列酮", "罗格列酮" ], "recommends": [ ], "target": "30>=eGFR", "type": "肾功能禁忌" }, { "decrements": [ ], "disables": [ "吡格列酮", "罗格列酮" ], "recommends": [ ], "target": "谷草谷丙>=100", "type": "肝功能禁忌" } ], "typeCode": "XA10BG", "typeName": "噻唑烷二酮类" }, { "drugs": [ { "dose": "50mg-100mg，单次最大剂量200mg", "drugGenericCode": "XA10BFA025", "drugGenericName": "阿卡波糖", "frequency": "每天三次，餐中", "remark": "", "usage": "口服" }, { "dose": "0.2mg，单次最大剂量0.3mg", "drugGenericCode": "XA10BFF058", "drugGenericName": "伏格列波糖", "frequency": "每天三次，餐中", "remark": "", "usage": "口服" }, { "dose": "25mg起始，单次最大剂量100mg", "drugGenericCode": "XA10BFM097", "drugGenericName": "米格列醇", "frequency": "每天三次，餐中", "remark": "", "usage": "口服" } ], "notes": [ { "decrements": [ ], "disables": [ "伏格列波糖", "米格列醇", "阿卡波糖" ], "recommends": [ ], "target": "30>=eGFR", "type": "肾功能禁忌" }, { "decrements": [ ], "disables": [ "伏格列波糖", "阿卡波糖" ], "recommends": [ ], "target": "谷草谷丙>=100", "type": "肝功能禁忌" } ], "typeCode": "XA10BF", "typeName": "α⁃糖苷酶抑制剂" }, { "drugs": [ { "dose": "0.1-0.2U/kg/d起始，根据空腹血糖调整用量", "drugGenericCode": "XA10AEC074", "drugGenericName": "甘精胰岛素", "frequency": "每天一次，睡前", "remark": "", "usage": "皮下注射" }, { "dose": "0.1-0.2U/kg/d起始，根据空腹血糖调整用量", "drugGenericCode": "XA10AED087", "drugGenericName": "地特胰岛素", "frequency": "每天一次，睡前", "remark": "", "usage": "皮下注射" }, { "dose": "0.1-0.2U/kg/d起始，根据空腹血糖调整用量", "drugGenericCode": "XA10AED318", "drugGenericName": "德谷胰岛素", "frequency": "每天一次，睡前", "remark": "", "usage": "皮下注射" } ], "notes": [ ], "typeCode": "XA10AE", "typeName": "基础胰岛素" } ], "priority": 4, "reason": "", "regimenCode": "HS-hba1cG7L8-ageG60-bmiG28-reg4", "regimenName": "【可用】噻唑烷二酮类、α-糖苷酶抑制剂（优选方案基础上加用）" } ] } }
- 1
- 2
- 3
- 4
- 5
- 6
- 7
- 8
- 9
- 10
- 11
- 12
- 13
- 14
- 15
- 16
- 17
- 18
- 19
- 20
- 21
- 22
- 23
- 24
- 25
- 26
- 27
- 28
- 29
- 30
- 31
- 32
- 33
- 34
- 35
- 36
- 37
- 38
- 39
- 40
- 41
- 42
- 43
- 44
- 45
- 46
- 47
- 48
- 49
- 50
- 51
- 52
- 53
- 54
- 55
- 56
- 57
- 58
- 59
- 60
- 61
- 62
- 63
- 64
- 65
- 66
- 67
- 68
- 69
- 70
- 71
- 72
- 73
- 74
- 75
- 76
- 77
- 78
- 79
- 80
- 81
- 82
- 83
- 84
- 85
- 86
- 87
- 88
- 89
- 90
- 91
- 92
- 93
- 94
- 95
- 96
- 97
- 98
- 99
- 100
- 101
- 102
- 103
- 104
- 105
- 106
- 107
- 108
- 109
- 110
- 111
- 112
- 113
- 114
- 115
- 116
- 117
- 118
- 119
- 120
- 121
- 122
- 123
- 124
- 125
- 126
- 127
- 128
- 129
- 130
- 131
- 132
- 133
- 134
- 135
- 136
- 137
- 138
- 139
- 140
- 141
- 142
- 143
- 144
- 145
- 146
- 147
- 148
- 149
- 150
- 151
- 152
- 153
- 154
- 155
- 156
- 157
- 158
- 159
- 160
- 161
- 162
- 163
- 164
- 165
- 166
- 167
- 168
- 169
- 170
- 171
- 172
- 173
- 174
- 175
- 176
- 177
- 178
- 179
- 180
- 181
- 182
- 183
- 184
- 185
- 186
- 187
- 188
- 189
- 190
- 191
- 192
- 193
- 194
- 195
- 196
- 197
- 198
- 199
- 200
- 201
- 202
- 203
- 204
- 205
- 206
- 207
- 208
- 209
- 210
- 211
- 212
- 213
- 214
- 215
- 216
- 217
- 218
- 219
- 220
- 221
- 222
- 223
- 224
- 225
- 226
- 227
- 228
- 229
- 230
- 231
- 232
- 233
- 234
- 235
- 236
- 237
- 238
- 239
- 240
- 241
- 242
- 243
- 244
- 245
- 246
- 247
- 248
- 249
- 250
- 251
- 252
- 253
- 254
- 255
- 256
- 257
- 258
- 259
- 260
- 261
- 262
- 263
- 264
- 265
- 266
- 267
- 268
- 269
- 270
- 271
- 272
- 273
- 274
- 275
- 276
- 277
- 278
- 279
- 280
- 281
- 282
- 283
- 284
- 285
- 286
- 287
- 288
- 289
- 290
- 291
- 292
- 293
- 294
- 295
- 296
- 297
- 298
- 299
- 300
- 301
- 302
- 303
- 304
- 305
- 306
- 307
- 308
- 309
- 310
- 311
- 312
- 313
- 314
- 315
- 316
- 317
- 318
- 319
- 320
- 321
- 322
- 323
- 324
- 325
- 326
- 327
- 328
- 329
- 330
- 331
- 332
- 333
- 334
- 335
- 336
- 337
- 338
- 339
- 340
- 341
- 342
- 343
- 344
- 345
- 346
- 347
- 348
- 349
- 350
- 351
- 352
- 353
- 354
- 355
- 356
- 357
- 358
- 359
- 360
- 361
- 362
- 363
- 364
- 365
- 366
- 367
- 368
- 369
- 370
- 371
- 372
- 373
- 374
- 375
- 376
- 377
- 378
- 379
- 380
- 381
- 382
- 383
- 384
- 385
- 386
- 387
- 388
- 389
- 390
- 391
- 392
- 393
- 394
- 395
- 396
- 397
- 398
- 399
- 400
- 401
- 402
- 403
- 404
- 405
- 406
- 407
- 408
- 409
- 410
- 411
- 412
- 413
- 414
- 415
- 416
- 417
- 418
- 419
- 420
- 421
- 422
- 423
- 424
- 425
- 426
- 427
- 428
- 429
- 430
- 431
- 432
- 433
- 434
- 435
- 436
- 437
- 438
- 439
- 440
- 441
- 442
- 443
- 444
- 445
- 446
- 447
- 448
- 449
- 450
- 451
- 452
- 453
- 454
- 455
- 456
- 457
- 458
- 459
- 460
- 461
- 462
- 463
- 464
- 465
- 466
- 467
- 468
- 469
- 470
- 471
- 472
- 473
- 474
- 475
- 476
- 477
- 478
- 479
- 480
- 481
- 482
- 483
- 484
- 485
- 486
- 487
- 488
- 489
- 490
- 491
- 492
- 493
- 494
- 495
- 496
- 497
- 498
- 499
- 500
- 501
- 502
- 503
- 504
- 505
- 506
- 507
- 508
- 509
- 510
- 511
- 512
- 513
- 514
- 515
- 516
- 517
- 518
- 519
- 520
- 521
- 522
- 523
- 524
- 525
- 526
- 527
- 528
- 529
- 530
- 531
- 532
- 533
- 534
- 535
- 536
- 537
- 538
- 539
- 540
- 541
- 542
- 543
- 544
- 545
- 546
- 547
- 548
- 549
- 550
- 551
- 552
- 553
- 554
- 555
- 556
- 557
- 558
- 559
- 560
- 561
- 562
- 563
- 564
- 565
- 566
- 567
- 568
- 569
- 570
- 571
- 572
- 573
- 574
- 575
- 576
- 577
- 578
- 579
- 580
- 581
- 582
- 583
- 584
- 585
- 586
- 587
- 588
- 589
- 590
- 591
- 592
- 593
- 594
- 595
- 596
- 597
- 598
- 599
- 600
- 601
- 602
- 603
- 604
- 605
- 606
- 607
- 608
- 609
- 610
- 611
- 612
- 613
- 614
- 615
- 616
- 617
- 618
- 619
- 620
- 621
- 622
- 623
- 624
- 625
- 626
- 627
- 628
- 629
- 630
- 631
- 632
- 633
- 634
- 635
- 636
- 637
- 638
- 639
- 640
- 641
- 642
- 643
- 644
- 645
- 646
- 647
- 648
- 649
- 650
- 651
- 652
- 653
- 654
- 655
- 656
- 657
- 658
- 659
- 660
- 661
- 662
- 663
- 664
- 665
- 666
- 667
- 668
- 669
- 670
- 671
- 672
- 673
- 674
- 675
- 676
- 677
- 678
- 679
- 680
- 681
- 682
- 683
- 684
- 685
- 686
- 687
- 688
- 689
- 690
- 691
- 692
- 693
- 694
- 695
- 696
- 697
- 698
- 699
- 700
- 701
- 702
- 703
- 704
- 705
- 706
- 707
- 708
- 709
- 710
- 711
- 712
- 713
- 714
- 715
- 716
- 717
- 718
- 719
- 720
- 721
- 722
- 723
- 724
- 725
- 726
- 727
- 728
- 729
- 730
- 731
- 732
- 733
- 734
- 735
- 736
- 737
- 738
- 739
- 740
- 741
- 742
- 743
- 744
- 745
- 746
- 747
- 748
- 749
- 750
- 751
- 752
- 753
- 754
- 755
- 756
- 757
- 758
- 759
- 760
- 761
- 762
- 763
- 764
- 765
- 766
- 767
- 768
- 769
- 770
- 771
- 772
- 773
- 774
- 775
- 776
- 777
- 778
- 779
- 780
- 781
- 782
- 783
- 784
- 785
- 786
- 787
- 788
- 789
- 790
- 791
- 792
- 793
- 794
- 795
- 796
- 797
- 798
- 799
- 800
- 801
- 802
- 803
- 804
- 805
- 806
- 807
- 808
- 809
- 810
- 811
- 812
- 813
- 814
- 815
- 816
- 817
- 818
- 819
- 820
- 821
- 822
- 823
- 824
- 825
- 826
- 827
- 828
- 829
- 830
- 831
- 832
- 833
- 834
- 835
- 836
- 837
- 838
- 839
- 840
- 841
- 842
- 843
- 844
- 845
- 846
- 847
- 848
- 849
- 850
- 851
- 852
- 853
- 854
- 855
- 856
- 857
- 858
- 859
- 860
- 861
- 862
- 863
- 864
- 865
- 866
- 867
- 868
- 869
- 870
- 871
- 872
- 873
- 874
- 875
- 876
- 877
- 878
- 879
- 880
- 881
- 882
- 883
- 884
- 885
- 886
- 887
- 888
- 889
- 890
- 891
- 892
- 893
- 894
- 895
- 896
- 897
- 898
- 899
- 900
- 901
- 902
- 903
- 904
- 905
- 906
- 907
- 908
- 909
- 910
- 911
- 912
- 913
- 914
- 915
- 916
- 917
- 918
- 919
- 920
- 921
- 922
- 923
- 924
- 925
- 926
- 927
- 928
- 929
- 930
- 931
- 932
- 933
- 934
- 935
- 936
- 937
- 938
- 939
- 940
- 941
- 942
- 943
- 944
- 945
- 946
- 947
- 948
- 949
- 950
- 951
- 952
- 953
- 954
- 955
- 956
- 957
- 958
- 959
- 960
- 961
- 962
- 963
- 964
- 965
- 966
- 967
- 968
- 969
- 970
- 971
- 972
- 973
- 974
- 975
- 976
- 977
- 978
- 979
- 980
- 981
- 982
- 983
- 984
- 985
- 986
- 987
- 988
- 989
- 990
- 991
- 992
- 993
- 994
- 995
- 996
- 997
- 998
- 999
- 1000
- 1001
- 1002
- 1003
- 1004
- 1005
- 1006
- 1007
- 1008
- 1009
- 1010
- 1011
- 1012
- 1013
- 1014
- 1015
- 1016
- 1017
- 1018
- 1019
- 1020
- 1021
- 1022
- 1023
- 1024
- 1025
- 1026
- 1027
- 1028
- 1029
- 1030
- 1031
- 1032
- 1033
- 1034
- 1035
- 1036
- 1037
- 1038
- 1039
- 1040
- 1041
- 1042
- 1043
- 1044
- 1045
- 1046
- 1047
- 1048
- 1049
- 1050
- 1051
- 1052
- 1053
- 1054
- 1055
- 1056
- 1057
- 1058
- 1059
- 1060
- 1061
- 1062
- 1063
- 1064
- 1065
- 1066
- 1067
- 1068
- 1069
- 1070
- 1071
- 1072
- 1073
- 1074
- 1075
- 1076
- 1077
- 1078
- 1079
- 1080
- 1081
- 1082
- 1083
- 1084
- 1085
- 1086
- 1087
- 1088
- 1089
- 1090
- 1091
- 1092
- 1093
- 1094
- 1095
- 1096
- 1097
- 1098
- 1099
- 1100
- 1101
- 1102
- 1103
- 1104
- 1105
- 1106
- 1107
- 1108
- 1109
- 1110
- 1111
- 1112
- 1113
- 1114
- 1115
- 1116
- 1117
- 1118
- 1119
- 1120
- 1121
- 1122
- 1123
- 1124
- 1125
- 1126
- 1127
- 1128
- 1129
- 1130
- 1131
- 1132
- 1133
- 1134
- 1135
- 1136
- 1137
- 1138
- 1139
- 1140
- 1141
- 1142
- 1143
- 1144
- 1145
- 1146
- 1147
- 1148
- 1149
- 1150
- 1151
- 1152
- 1153
- 1154
- 1155
- 1156
- 1157
- 1158
- 1159
- 1160
- 1161
- 1162
- 1163
- 1164
- 1165
- 1166
- 1167
- 1168
- 1169
- 1170
- 1171
- 1172
- 1173
- 1174
- 1175
- 1176
- 1177
- 1178
- 1179
- 1180
- 1181
- 1182
- 1183
- 1184
- 1185
- 1186
- 1187
- 1188
- 1189
- 1190
- 1191
- 1192
- 1193
- 1194
- 1195
- 1196
- 1197
- 1198
- 1199
- 1200
- 1201
- 1202
- 1203
- 1204
- 1205
- 1206
- 1207
- 1208
- 1209
- 1210
- 1211
- 1212
- 1213
- 1214
- 1215
- 1216
- 1217
- 1218
- 1219
- 1220
- 1221
- 1222
- 1223
- 1224
- 1225
- 1226
- 1227
- 1228
- 1229
- 1230
- 1231
- 1232
- 1233
- 1234
- 1235
- 1236
- 1237
- 1238
- 1239
- 1240
- 1241
- 1242
- 1243
- 1244
- 1245
- 1246
- 1247
- 1248
- 1249
- 1250
- 1251
- 1252
- 1253
- 1254
- 1255
- 1256
- 1257
- 1258
- 1259
- 1260
- 1261
- 1262
- 1263
- 1264
- 1265
- 1266
- 1267
- 1268
- 1269
- 1270
- 1271
- 1272
- 1273
- 1274
- 1275
- 1276
- 1277
- 1278
- 1279
- 1280
- 1281
- 1282
- 1283
- 1284
- 1285
- 1286
- 1287
- 1288
- 1289
- 1290
- 1291
- 1292
- 1293
- 1294
- 1295
- 1296
- 1297
- 1298
- 1299
- 1300
- 1301
- 1302
- 1303
- 1304
- 1305
- 1306
- 1307
- 1308
- 1309
- 1310
- 1311
- 1312
- 1313
- 1314
- 1315
- 1316
- 1317
- 1318
- 1319
- 1320
- 1321
- 1322
- 1323
- 1324
- 1325
- 1326
- 1327
- 1328
- 1329
- 1330
- 1331
- 1332
- 1333
- 1334
- 1335
- 1336
- 1337
- 1338
- 1339
- 1340
- 1341
- 1342
- 1343
- 1344
- 1345
- 1346
- 1347
- 1348
- 1349
- 1350
- 1351
- 1352
- 1353
- 1354
- 1355
- 1356
- 1357
- 1358
- 1359
- 1360
- 1361
- 1362
- 1363
- 1364
- 1365
- 1366
- 1367
- 1368
- 1369
- 1370
- 1371
- 1372
- 1373
- 1374
- 1375
- 1376
- 1377
- 1378
- 1379
- 1380
- 1381
- 1382
- 1383
- 1384
- 1385
- 1386
- 1387
二、使用lateral VIEW posexplode ( split ( space( drugTypes_num -1), ‘’ ) ) t AS drugTypes_pos, val 炸裂解析
select t5.*, get_json_object(oper_result, concat('$.specialistScheme.regimens[',regimens_pos,'].drugTypes[',drugTypes_pos,'].drugs[',drugs_pos,'].drugGenericCode')) as drug_generic_code, get_json_object(oper_result, concat('$.specialistScheme.regimens[',regimens_pos,'].drugTypes[',drugTypes_pos,'].drugs[',drugs_pos,'].drug_generic_name')) as drug_generic_name , get_json_object(oper_result, concat('$.specialistScheme.regimens[',regimens_pos,'].drugTypes[',drugTypes_pos,'].drugs[',drugs_pos,'].dose')) as dose , get_json_object(oper_result, concat('$.specialistScheme.regimens[',regimens_pos,'].drugTypes[',drugTypes_pos,'].drugs[',drugs_pos,'].usage')) as usage , get_json_object(oper_result, concat('$.specialistScheme.regimens[',regimens_pos,'].drugTypes[',drugTypes_pos,'].drugs[',drugs_pos,'].frequency')) as frequency, get_json_object(oper_result, concat('$.specialistScheme.regimens[',regimens_pos,'].drugTypes[',drugTypes_pos,'].drugs[',drugs_pos,'].remark')) as remark from ( select t4.*, drugs_pos from ( select t3.*, size(split(regexp_replace(t3.drug_generic_codes,'\\[|\\]',''),',')) as drugs_num from ( select t2.*, get_json_object(oper_result, concat('$.specialistScheme.regimens[',regimens_pos,'].drugTypes[',drugTypes_pos,'].typeCode')) as durg_type_code, get_json_object(oper_result, concat('$.specialistScheme.regimens[',regimens_pos,'].drugTypes[',drugTypes_pos,'].typeName')) as durg_type_name, get_json_object(oper_result, concat('$.specialistScheme.regimens[',regimens_pos,'].drugTypes[',drugTypes_pos,'].drugs[*].drugGenericCode')) as drug_generic_codes, get_json_object(oper_result, concat('$.specialistScheme.regimens[',regimens_pos,'].drugTypes[',drugTypes_pos,'].drugs[*].drug_generic_name')) as drug_generic_names , get_json_object(oper_result, concat('$.specialistScheme.regimens[',regimens_pos,'].drugTypes[',drugTypes_pos,'].drugs[*].dose')) as doses , get_json_object(oper_result, concat('$.specialistScheme.regimens[',regimens_pos,'].drugTypes[',drugTypes_pos,'].drugs[*].usage')) as usages , get_json_object(oper_result, concat('$.specialistScheme.regimens[',regimens_pos,'].drugTypes[',drugTypes_pos,'].drugs[*].frequency')) as frequencys, get_json_object(oper_result, concat('$.specialistScheme.regimens[',regimens_pos,'].drugTypes[',drugTypes_pos,'].drugs[*].remark')) as remarks from ( select t1.*, drugTypes_pos from ( select t0.*, size(split(regexp_replace(t0.typeCodes,'\\[|\\]',''),',')) as drugTypes_num from ( select t.*, oper_result_primaryScheme_groupCode as group_code, get_json_object(oper_result, concat('$.specialistScheme.regimens[',regimens_pos,'].regimenCode')) as regimenCode, get_json_object(oper_result, concat('$.specialistScheme.regimens[',regimens_pos,'].regimenName')) as regimenName, get_json_object(oper_result, concat('$.specialistScheme.regimens[',regimens_pos,'].reason')) as reason, get_json_object(oper_result, concat('$.specialistScheme.regimens[',regimens_pos,'].priority')) as priority, get_json_object(oper_result, concat('$.specialistScheme.regimens[',regimens_pos,'].drugTypes[*].typeCode')) as typeCodes, get_json_object(oper_result, concat('$.specialistScheme.regimens[',regimens_pos,'].drugTypes[*].typeName')) as typeNames, 2 as origin_type from ( select n.*, regimens_pos from wedw_dw.ai_base_recommended_plan_detail_df_tmp1 n lateral VIEW posexplode ( split ( space( specialistScheme_regimens_num -1), '' ) ) t AS regimens_pos, val ) t ) t0 ) t1 lateral VIEW posexplode ( split ( space( drugTypes_num -1), '' ) ) t AS drugTypes_pos, val ) t2 ) t3 ) t4 lateral VIEW posexplode ( split ( space( drugs_num -1), '' ) ) t AS drugs_pos, val ) t5
- 1
- 2
- 3
- 4
- 5
- 6
- 7
- 8
- 9
- 10
- 11
- 12
- 13
- 14
- 15
- 16
- 17
- 18
- 19
- 20
- 21
- 22
- 23
- 24
- 25
- 26
- 27
- 28
- 29
- 30
- 31
- 32
- 33
- 34
- 35
- 36
- 37
- 38
- 39
- 40
- 41
- 42
- 43
- 44
- 45
- 46
- 47
- 48
- 49
- 50
- 51
- 52
- 53
- 54
- 55
- 56
- 57
- 58
- 59
- 60
声明：本文内容由网友自发贡献，不代表【wpsshop博客】立场，版权归原作者所有，本站不承担相应法律责任。如您发现有侵权的内容，请联系我们。转载请注明出处：https://www.wpsshop.cn/w/木道寻08/article/detail/911167
推荐阅读
相关标签
