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.4k
KAYAC 社内ISUCON 2017、複数台構成の顛末
acidlemon
1
930
アプリを書くときみんなModelはどうしてるの? って話
acidlemon
2
670
ISUCON3ふりかえり
acidlemon
1
980
せっかくなのでYokohama.pmでGoとPerlの話
acidlemon
2
1.8k
Other Decks in Technology
See All in Technology
Dojo 20240830 COBOL to Java on Z
ichikawayasuhisa
0
240
ログラスが面白いと思う理由をマネージャーがエモく語ってみる / 20240829 vs LT
yoshikiiida
1
530
ロボットアームを遠隔制御の話 & LLMをつかったIoTの話もしたい
soracom
PRO
1
220
LLM を現場で評価する
asei
4
700
四国のあのイベントの〇〇システムを45日間で構築した話 / cloudohenro2024_tachibana
biatunky
0
280
2024年版 運用者たちのLLM
nwiizo
3
410
Building Static Websites with Sculpin
opdavies
0
1.5k
四国クラウドお遍路 2024 in 高知 オープニング
yukataoka
0
160
HolidayJp.jl を作りました
mrkn
0
110
Oracle Database 23ai 新機能 #3 Oracle Globally Distributed Database(GDD)
oracle4engineer
PRO
1
170
Namespace, Now and Then
tagomoris
0
170
サイボウズ 開発本部採用ピッチ / Cybozu Engineer Recruit
cybozuinsideout
PRO
9
41k
Featured
See All Featured
Typedesign – Prime Four
hannesfritz
39
2.3k
WebSockets: Embracing the real-time Web
robhawkes
59
7.3k
No one is an island. Learnings from fostering a developers community.
thoeni
18
2.9k
How To Stay Up To Date on Web Technology
chriscoyier
785
250k
Design and Strategy: How to Deal with People Who Don’t "Get" Design
morganepeng
123
18k
Designing the Hi-DPI Web
ddemaree
278
34k
KATA
mclloyd
27
13k
The Mythical Team-Month
searls
218
43k
How STYLIGHT went responsive
nonsquared
93
5.1k
In The Pink: A Labor of Love
frogandcode
139
22k
Stop Working from a Prison Cell
hatefulcrawdad
267
20k
Ruby is Unlike a Banana
tanoku
96
10k
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