2018年12月28日
case when then else end
查找住院,门诊的人数: SELECT a.leixing,COUNT(a.leixing)FROM(SELECT case resource_type WHEN 'O' THEN '住院'WHEN 'I' THEN '门诊'ELSE '其他' END as leixingFROM `doc_info Read More
posted @ 2018-12-28 17:23 kwz Views(166) Comments(0) Diggs(0) Edit
spark读文件写入mysql(scala版本)
1 package com.zjlantone.hive 2 3 import java.util.Properties 4 5 import com.zjlantone.hive.SparkOperaterHive.sparkSession 6 import org.apache.spark.rd Read More
posted @ 2018-12-28 16:58 kwz Views(1639) Comments(0) Diggs(0) Edit
mysql语句
1、mysql语句实现年龄分布select nnd as '年龄段',count(*) as '人数' from( select case when age>=1 and age<=10 then '1-10' when age>=11 and age<=20 then '11-20' when a Read More
posted @ 2018-12-28 16:55 kwz Views(457) Comments(0) Diggs(0) Edit