Upgrade to Pro
— share decks privately, control downloads, hide ads and more …
Speaker Deck
Speaker Deck
PRO
Sign in
Sign up
for free
Apache Drillで 身の回りのログを集計してみる
acidlemon
September 15, 2015
Technology
0
970
Apache Drillで 身の回りのログを集計してみる
Tokyo Apache Drill Meetup (2015/09/15)の資料です。
acidlemon
September 15, 2015
Tweet
Share
More Decks by acidlemon
See All by acidlemon
acidlemon
0
700
acidlemon
1
2.6k
acidlemon
1
370
acidlemon
2
600
acidlemon
1
810
acidlemon
2
1.3k
Other Decks in Technology
See All in Technology
viva_tweet_x
1
430
kanaugust
PRO
0
160
oliva
7
1.2k
sansandsoc
0
230
dena_tech
3
560
pg0084
1
140
nisshii0313
1
170
lmi
3
1.2k
tnmt
3
250
yuji1484
3
790
simosako
1
140
dena_tech
1
400
Featured
See All Featured
sachag
267
17k
jcasabona
8
550
rasmusluckow
318
18k
jrom
116
7.2k
zakiwarfel
88
3.4k
jonrohan
1021
380k
garrettdimon
288
110k
andyhume
63
3.7k
reverentgeek
167
7.3k
tmm1
61
9.4k
mongodb
23
3.9k
zenorocha
296
40k
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