???????????????
???????????? ???????[ 2014/9/1 16:53:47 ] ??????????????? ???????
?????????????????????????????????з??????—???????
?????????????????????????????????sql????????????????????????????????????????????????????
??????????????????????????????????????????????sqlд???????????????????????????????????????sql?????????????????????????ж??
???????????
????1??????????????????? ?? ????????з?????Щ??????????????
????2?????????????????????????????????λ
???????????
???????? ???????sql
select f.date_id??d.issue_name??sum(f.all_qz_cnt)
from voc_tb_*** f??
voc_issue_*** d??
bi_time_*** t??
voc_prd_*** v
where d.issue_code = f.issue_codes
and v.id = f.prd_id_sk
and t.date_id = f.date_id
and v.prd_id=711
and t.day = 20140316
group by f.issue_code
order by sum(f.all_qz_cnt) desc
????????sql
SELECT bi_time_***.day??voc_prd_***.prd_id??voc_issue_***.issue_code??sum(voc_tb_***.all_qz_cnt) as index_135
FROM voc_tb_*** LEFT JOIN voc_issue_*** ON voc_tb_***.issue_code = voc_issue_***.issue_code and voc_issue_***.flow_step=voc_tb_***.dim7
LEFT JOIN voc_prd_*** ON voc_tb_***.prd_id_sk = voc_prd_***.id
LEFT JOIN bi_time_*** ON voc_tb_***.date_id = bi_time_***.date_id
WHERE voc_prd_***.prd_id=711 and bi_time_***.day=20140316
GROUP BY bi_time_***.day??voc_prd_***.prd_id??voc_issue_***.issue_code
ORDER BY index_135 desc
???????????????voc_issue_***?е?issue_code???????LEFT JOIN?????????issue_code??sum(f.all_qz_cnt)????????????????????voc_issue_***??????λ???????issue_code????????
?????????????????????????
????1??????????????????????????2???????δ?????
????2?????λ??????????????????????????
????????????
????1??????????????????????????????????????????????????????????????????????Ч??
????2??????????????????????????????????????????????????????????Ч???????????
???????????????????????漰???????????????????SPASVOС??(021-61079698-8054)?????????????????????????
??????
??????????????????????????????????????web?????????????????????????????????????Щ???棿???APP?????е??????????????????????????????????????????????????Web???????????????????Espresso????????????App??????????????????????????????2??????????????????????????1????????????????????????????δ??????????????????????????????????棩??????????????Hive???????????
???·???
??????????????????
2023/3/23 14:23:39???д?ò??????????
2023/3/22 16:17:39????????????????????Щ??
2022/6/14 16:14:27??????????????????????????
2021/10/18 15:37:44???????????????
2021/9/17 15:19:29???·???????·
2021/9/14 15:42:25?????????????
2021/5/28 17:25:47??????APP??????????
2021/5/8 17:01:11????????
?????????App Bug???????????????????????Jmeter?????????QC??????APP????????????????app?????е????????jenkins+testng+ant+webdriver??????????????JMeter????HTTP???????Selenium 2.0 WebDriver ??????