Upgrade to Pro
— share decks privately, control downloads, hide ads and more …
Speaker Deck
Features
Speaker Deck
PRO
Sign in
Sign up for free
Search
Search
Apache Drillで 身の回りのログを集計してみる
Search
acidlemon
September 15, 2015
Technology
0
1.4k
Apache Drillで 身の回りのログを集計してみる
Tokyo Apache Drill Meetup (2015/09/15)の資料です。
acidlemon
September 15, 2015
Tweet
Share
More Decks by acidlemon
See All by acidlemon
開発期間数年のサービスの完成間際にcontext対応をぶち込む / introduce context.Context into long term project
acidlemon
0
3.4k
巨大Perlプロジェクトに、Dockerが出会った
acidlemon
1
3.3k
KAYAC 社内ISUCON 2017、複数台構成の顛末
acidlemon
1
900
アプリを書くときみんなModelはどうしてるの? って話
acidlemon
2
660
ISUCON3ふりかえり
acidlemon
1
970
せっかくなのでYokohama.pmでGoとPerlの話
acidlemon
2
1.7k
Other Decks in Technology
See All in Technology
[NIKKEI Tech Talk]Bias for Action!! 実践から学ぶための仕組とコミュニティ / Community for Practice and Learning
kanamasa
0
260
サービス開発を前に進めるために 新米リードエンジニアが 取り組んだこと / Steps Taken by a Novice Lead Engineer to Advance Service Development
nologyance
0
180
セキュリティ研修 Day1【MIXI 24新卒技術研修】
mixi_engineers
PRO
0
150
20240724_cm_odyssey_hibiyatech
hiashisan
0
110
AOAI Dev Day - Opening Session
yoshidashingo
2
430
ソフトウェアエンジニアリングの知見を活かして データ基盤をいい感じにする on Snowflake [MIERUNE BBQ #10]
mtpooh
2
150
データ分析を支える技術 生成AI再入門
ishikawa_satoru
0
380
DDDにおける認可の扱いとKotlinにおける実装パターン / authorization-for-ddd-and-kotlin-implement-pattern
urmot
4
390
ACRiルーム最新情報とAMD GPUサーバーのご紹介
anjn
0
150
E2Eテスト自動化プラットフォームにおけるAIの活用
shift_evolve
0
180
[NIKKEI Tech Talk] KDDI/KAG Scrum & Community for Engineering Training
curanosuke
2
220
MySQLのロックの種類とその競合
yoku0825
6
1.6k
Featured
See All Featured
Facilitating Awesome Meetings
lara
46
5.8k
Design and Strategy: How to Deal with People Who Don’t "Get" Design
morganepeng
121
18k
A designer walks into a library…
pauljervisheath
201
24k
Atom: Resistance is Futile
akmur
261
25k
Designing Experiences People Love
moore
136
23k
GitHub's CSS Performance
jonrohan
1026
450k
A Tale of Four Properties
chriscoyier
155
22k
Java REST API Framework Comparison - PWX 2021
mraible
PRO
20
7.2k
Intergalactic Javascript Robots from Outer Space
tanoku
266
26k
Designing for humans not robots
tammielis
247
25k
Being A Developer After 40
akosma
72
580k
4 Signs Your Business is Dying
shpigford
178
21k
Transcript
"QBDIF%SJMMͰ ͷճΓͷϩάΛूܭͯ͠ΈΔ -FU`TUSZUPBHHSFHBUF JOEJWJEVBMMPHTVTJOH"QBDIF%SJMM 5PLZP"QBDIF%SJMM.FFUVQ !BDJEMFNPO
"CPVU.F w 1SPHSBNNJOH(PMBOH 1FSM $ w %#%8).Z42-3FETIJGU w "QBDIF%SJMMIJTUPSZXFFLT
!BDJEMFNPO .BTBUPTIJ,BXB[PF 4PGUXBSF&OHJOFFS BU,":"$*OD
"QBDIF%SJMM w 4DIFNBGSFF42-&OHJOF NPEF w %JTUSJCVUJPO.PEF XJUI)BEPPQ /P42- $MPVE4UPSBHF
w &NCFEEFE.PEF XJUI-PDBMpMF +40/ $47 547 147 5SZUIJTUPEBZ
8IZ%SJMM .Z3FBTPO w 8IFO*OFFEUPJNQSPWFXFCBQQ QFSGPSNBODFʜ w *XBOUUPBHHSFHBUFSFTQPOTFUJNF QFSFOEQPJOUʜ w %SJMMDPVMESVORVFSZUP+40/
ZFBI
2VJDL4UBSU w 4FF0GpDJBM5VUPSJBM%PDVNFOU l%SJMMJONJOVUFTz IUUQTESJMMBQBDIFPSHEPDTESJMMJONJOVUFT w PS%FWFMPQFST*0#MPH&OUSZBCPVU "QBDIF%SJMM*NQSFTTJPO IUUQEFWDMBTTNFUIPEKQDMPVEBXTBQBDIFESJMMpSTUJNQSFTTJPO
w 'PS.BD6TFSVTF)PNFCSFX SFRVJSFT+%,PSMBUFS $ brew install apache-drill
$POWFSUOHJOYMPH w 8FVTFl-547zGPSNBUGPSOHJOYMPH w -547-BCFMFE5BCTFQBSBUFE7BMVFT IUUQMUTWPSH w "QBDIF%SJMMEPFTOPUTVQQPSU-547ZFU TP DPOWFSUMPHGSPN-547UP+40/
w VTFMUTWJFXDPNNBOE WJBSVCZHFNT host:217.235.96.155 time:2015-09-14T00:00:00+09:00 method:POST uri:/api/hunting/challenge protocol:HTTP/1.1 status:200 size: 5790 request_time:0.383 upstream_response_time:0.438 referer:- user_agent:MyApp/11000 CFNetwork/711.3.18 Darwin/14.0.0 user_id: 76005617 geo:JP
%FNP .MJOFT .#+40/
$VU2VFSZ4USJOH w (SPVQCZVSJ CVUVSJDPOUBJOT2VFSZ4USJOHʜ w 4PMVUJPO 3&(&91@3&1-"$& VSJ `a
BTQBUI +------------------------------------------------------------------------------------------------------------+----------+ | uri | maxtime | +------------------------------------------------------------------------------------------------------------+----------+ | /api/costume/hunting_item/equip | 9.695 | | /api/hunting/families?hunting_id=4000222&session=XXXXXXXXe937077b8cbc06ad3aec80fe&client_data_version=1329 | 9.273 | | /api/mypage?os_type=1&platform_type=1&session=XXXXXXXX7968eb69dd20d2bb1aec3943&client_data_version=1329 | 8.316 | | /api/mypage?os_type=2&platform_type=2&session=XXXXXXXXb63727f12bd2724ab9725885&client_data_version=1329 | 8.279 | | /api/hunting/families?hunting_id=4026012&session=XXXXXXXX2dc4a6668288c5f4a675f071&client_data_version=1330 | 7.926 | | /api/hunting/families?hunting_id=4025518&session=XXXXXXXX04634d3293a8c2317454b6a3&client_data_version=1329 | 7.896 |
1BSTFUJNFTUSJOH w UJNF5 w KVTUBTUSJOH OPUUJNFTUBNQʜ where `time` >
‘2015-09-14 07:00:00’ EPFTOPUXPSLBTFYQFDUFEʜ w 4PMVUJPO 50@5*.&45".1 AUJNFA `ZZZZ..EE5))NNTT; "4BDDFTT@UJNF
%FNP (3061#: QFSDFOUJMFBOBMZTJT
$PODMVTJPO w "QBDIF%SJMMJTSFBTPOBCMZGBTU w 5FNQPSBSZUBCMFJTVTFGVMGPSMPOH RVFSZ w $"45JTJNQPSUBOUUPSVORVFSZ w 4UJMMMJUUMFIBSEUPVTFZFU
SFBE EPDVNFOUDBSFGVMMZ
5IBOLZPV