Hadoop????SQL?????????·
???????????? ???????[ 2016/12/27 10:58:48 ] ????????SQL Server ?????
????????Batch??????????????????????????????????I/O?????????????????????????????????????????η??????????????????????????CPU??????
????In List
????????????????????????????????????????????ID????????????ЩID??????????????????????????????????????
????????????????????ID??????????????????????
????for: var in ids[] do begin
????SELECT * FROM table_name WHERE id=:var;
????end;
????????????????????????????????????????????????????????????????????????????????ID InList??????????????????ν??????????η?????????????????
????SELECT * FROM table_name
????WHERE id IN ids[];
???????洢????
????Inceptor???洢??????????????洢?????????????????????洢????????SQL?????????????????????顣??????????????????????????????????????????????????洢?????е??????????????????????????????????????????????У??????????????洢????????У????????SQL???????????
??????????????洢?????????????????????
??????????????????????Ч???
?????????罻???д??????????SQL??????????貧???Щ???????????????????????????????????Ч???
????4. ??????????????
????CPU????SQL?л????????????????????????CPU???????????????Щ???????????????????????磬???ж?????????????????????????????????????????????????????CPU????????????????????????????????????????м??????????????????????????????????????????????????????ι滮????????????????
????????????SQL?е???????????Inceptor????????????????(??????????)?н???????????????????CPU???????????????????????????衣??LIKE????????????????CPU??????????????????????????????????????????????????????????????????御????In-List???LIKE????In-List?а???LIKE???п?????????
????????3??????????????????
????SELECT * FROM table_name
????WHERE column_name LIKE ‘%abc%’;
???????????????????????????‘cabc’??‘abce’??‘cabe’???????????????????????????
????SELECT * FROM table_name
????WHERE column_name IN (‘cabc’?? ‘abce’?? ‘cabe’);
????????4?????In-List??????????SELECT??????????????????м?С?????In?б????????????????????????????????м?????
????SELECT * FROM table_name
????WHERE column_name IN (
????SELECT col_name FROM tbl WHERE gender = ‘f’
????);
????????????????????Hadoop???г????SQL????·???????????·?????????????????????????????????????Щ?·??????????????????SQL??????????Щ???????
?????????????????Щ????·?????ó????
????1???????????ο?????μ??????????;
????2??????SELECT?????????????μ??????????;
????3????????漰????????????????????????????????????????????????;
????4????????????????????????????CPU????
????5???????????????????????????棬???????????SQL??????Hadoop?????и????????????
???????????????????????漰???????????????????SPASVOС??(021-61079698-8054)?????????????????????????
??????
?????????????????????????Щ????????????????????TC???????????????Щ???????????????????????????????????????????????(java .net ?????)???mysql???????????????????ж????д???Python???????????????(DB2)??????BufferPool????????????????????????????????6??????????????????滮???????????????-????????SQL Server???????????????????λ?????PHP??SQL????????????????????Pythonд???NoSQL????????? SQL ?е????????????? SQL ?е?????????Java???????:?????MySQL???????
???·???
??????????????????
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 ??????