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.5k
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.8k
巨大Perlプロジェクトに、Dockerが出会った
acidlemon
1
3.5k
KAYAC 社内ISUCON 2017、複数台構成の顛末
acidlemon
1
1k
アプリを書くときみんなModelはどうしてるの? って話
acidlemon
2
690
ISUCON3ふりかえり
acidlemon
1
1.1k
せっかくなのでYokohama.pmでGoとPerlの話
acidlemon
2
1.9k
Other Decks in Technology
See All in Technology
Lakebaseを使ったAIエージェントを実装してみる
kameitomohiro
0
170
Lufthansa ®️ USA Contact Numbers: Complete 2025 Support Guide
lufthanahelpsupport
0
230
開発生産性を測る前にやるべきこと - 組織改善の実践 / Before Measuring Dev Productivity
kaonavi
14
8k
関数型プログラミングで 「脳がバグる」を乗り越える
manabeai
2
220
〜『世界中の家族のこころのインフラ』を目指して”次の10年”へ〜 SREが導いたグローバルサービスの信頼性向上戦略とその舞台裏 / Towards the Next Decade: Enhancing Global Service Reliability
kohbis
2
900
衛星運用をソフトウェアエンジニアに依頼したときにできあがるもの
sankichi92
1
210
How to Quickly Call American Airlines®️ U.S. Customer Care : Full Guide
flyaahelpguide
0
240
cdk initで生成されるあのファイル達は何なのか/cdk-init-generated-files
tomoki10
1
430
Reach American Airlines®️ Instantly: 19 Calling Methods for Fast Support in the USA
flyamerican
1
180
freeeのアクセシビリティの現在地 / freee's Current Position on Accessibility
ymrl
2
260
Copilot coding agentにベットしたいCTOが開発組織で取り組んだこと / GitHub Copilot coding agent in Team
tnir
0
120
全部AI、全員Cursor、ドキュメント駆動開発 〜DevinやGeminiも添えて〜
rinchsan
0
360
Featured
See All Featured
Adopting Sorbet at Scale
ufuk
77
9.5k
The Pragmatic Product Professional
lauravandoore
35
6.7k
[RailsConf 2023 Opening Keynote] The Magic of Rails
eileencodes
29
9.6k
Statistics for Hackers
jakevdp
799
220k
Automating Front-end Workflow
addyosmani
1370
200k
Speed Design
sergeychernyshev
32
1k
Code Review Best Practice
trishagee
69
19k
Designing for humans not robots
tammielis
253
25k
StorybookのUI Testing Handbookを読んだ
zakiyama
30
5.9k
I Don’t Have Time: Getting Over the Fear to Launch Your Podcast
jcasabona
32
2.4k
[RailsConf 2023] Rails as a piece of cake
palkan
55
5.7k
Making the Leap to Tech Lead
cromwellryan
134
9.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