阅读背景:

hive:函数:聚合函数:count() 及多用法之count中使用函数

来源:互联网 

业务情景一: 

select
	count(first_interview) first_interviews,
	count(submit_time) submit_time,
	count(length(concat(submit_time,bg_time))>26) submit_time,
	count(followupdate) followupdate,
	count(arrivaldate) arrivaldate,
	count(*) reports
	from dws.dws_awa_t_cal_recomperiods_result2
	group by business_line,region,office,team,fullnameselect
	count(first_intervi



你的当前访问异常,请进行认证后继续阅读剩余内容。

分享到: