SELECT
sum(a.avfassreq_avfsvcass_calldur)AS ass_calldur,
sum(b.avfsvcass_avfasscmp_calldur)AS cmp_calldur,
sum(b.avrasscmp_avfrlsreq_calldur)AS req_calldur,
sum(b.avfrlsreq_kilprc_calldur)AS kilprc_calldur,
sum(c.avfsvcass_avfasscmp_calldur)AS c_cmp_calldur,
sum(c.avrasscmp_avfrlsreq_calldur)AS c_req_calldur,
sum(c.avfrlsreq_kilprc_calldur)AS c_kilprc_calldur, a.bts_code
FROM
cmcs_pm_voice_bssap201003 PARTITION(VB01)a,
cmcs_pm_voice_l3201003 PARTITION(VL01)b,
cmcs_pm_concurrent201003 PARTITION(C01)c
WHERE
a.bts_code=b.bts_code
AND b.bts_code = c.bts_code
AND a.collectdate = b.collectdate
AND b.collectdate = c.collectdate
GROUP BY a.bts_code三张表数据都差不多。大约在150W条。
sum(a.avfassreq_avfsvcass_calldur)AS ass_calldur,
sum(b.avfsvcass_avfasscmp_calldur)AS cmp_calldur,
sum(b.avrasscmp_avfrlsreq_calldur)AS req_calldur,
sum(b.avfrlsreq_kilprc_calldur)AS kilprc_calldur,
sum(c.avfsvcass_avfasscmp_calldur)AS c_cmp_calldur,
sum(c.avrasscmp_avfrlsreq_calldur)AS c_req_calldur,
sum(c.avfrlsreq_kilprc_calldur)AS c_kilprc_calldur, a.bts_code
FROM
cmcs_pm_voice_bssap201003 PARTITION(VB01)a,
cmcs_pm_voice_l3201003 PARTITION(VL01)b,
cmcs_pm_concurrent201003 PARTITION(C01)c
WHERE
a.bts_code=b.bts_code
AND b.bts_code = c.bts_code
AND a.collectdate = b.collectdate
AND b.collectdate = c.collectdate
GROUP BY a.bts_code三张表数据都差不多。大约在150W条。
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货