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.6k
巨大Perlプロジェクトに、Dockerが出会った
acidlemon
1
3.5k
KAYAC 社内ISUCON 2017、複数台構成の顛末
acidlemon
1
990
アプリを書くときみんなModelはどうしてるの? って話
acidlemon
2
680
ISUCON3ふりかえり
acidlemon
1
1k
せっかくなのでYokohama.pmでGoとPerlの話
acidlemon
2
1.9k
Other Decks in Technology
See All in Technology
GeometryReaderやスクロールを用いた表現と紐解き方
fumiyasac0921
0
100
なぜfreeeはハブ・アンド・スポーク型の データメッシュアーキテクチャにチャレンジするのか?
shinichiro_joya
2
320
いま現場PMのあなたが、 経営と向き合うPMになるために 必要なこと、腹をくくること
hiro93n
9
7.3k
AWS re:Invent 2024 recap in 20min / JAWSUG 千葉 2025.1.14
shimy
1
100
Docker Desktop で Docker を始めよう
zembutsu
PRO
0
150
Reactフレームワークプロダクトを モバイルアプリにして、もっと便利に。 ユーザに価値を届けよう。/React Framework with Capacitor
rdlabo
0
110
EMConf JP の楽しみ方 / How to enjoy EMConf JP
pauli
2
150
今年一年で頑張ること / What I will do my best this year
pauli
1
220
embedパッケージを深掘りする / Deep Dive into embed Package in Go
task4233
1
200
GoogleのAIエージェント論 Authors: Julia Wiesinger, Patrick Marlow and Vladimir Vuskovic
customercloud
PRO
0
120
.NET 最新アップデート ~ AI とクラウド時代のアプリモダナイゼーション
chack411
0
190
完全自律型AIエージェントとAgentic Workflow〜ワークフロー構築という現実解
pharma_x_tech
0
330
Featured
See All Featured
Testing 201, or: Great Expectations
jmmastey
41
7.2k
The Power of CSS Pseudo Elements
geoffreycrofte
74
5.4k
A Modern Web Designer's Workflow
chriscoyier
693
190k
Embracing the Ebb and Flow
colly
84
4.5k
How STYLIGHT went responsive
nonsquared
96
5.3k
KATA
mclloyd
29
14k
YesSQL, Process and Tooling at Scale
rocio
170
14k
Practical Tips for Bootstrapping Information Extraction Pipelines
honnibal
PRO
10
860
Performance Is Good for Brains [We Love Speed 2024]
tammyeverts
7
570
Facilitating Awesome Meetings
lara
51
6.2k
We Have a Design System, Now What?
morganepeng
51
7.3k
The Pragmatic Product Professional
lauravandoore
32
6.4k
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