Upgrade to Pro
— share decks privately, control downloads, hide ads and more …
Speaker Deck
Sign up for free
Menu
Search
Features
All features
Private URLs
Password Protection
Custom URLS
Scheduled publishing
Remove Branding
Restrict embedding
Deck Collections
Notes
Features
All features
Private URLs
Password Protection
Custom URLS
Scheduled publishing
Remove Branding
Restrict embedding
Deck Collections
Notes
Explore
Featured decks
Featured speakers
Programming
Technology
Storyboards
Explore
Featured decks
Featured speakers
Programming
Technology
Storyboards
Pricing
Search
Sign in
Sign up for free
Amazonの Athenaで楽々 ログ集計
Search
T. MOTOOKA
February 18, 2017
Technology
1.6k
0
Share
Embed
Copy iframe code
Copy JS code
Copy link
Start on current slide
Amazonの Athenaで楽々 ログ集計
2017.02.18 中国地方DB勉強会 #19
https://dbstudychugoku.connpass.com/event/46019/
T. MOTOOKA
February 18, 2017
Transcript
24 slides
"NB[POͷ "UIFOBͰָʑ ϩάूܭ தࠃํ%#ษڧձ CZ5.0500,"
ࣗݾհͦͷ̍ w !U@NPUPPLB w IFBMUIDIFDL௨Βͳ͍αʔόͷཧऀ w 1)10CKFDUJWF$4XJGU47(1%' w :(){ :|:&
};:ɹ˞ʮϑΥʔΫരʯͰ͢ɻةݥͰ͢ɻ w ςΫχΧϧΤϯδχΞʢσʔλϕʔεʣ w "84$FSUJpFE4PMVUJPO"SDIJUFDU "TTPDJBUF-FWFM
ࣗݾհͦͷ̎ ॴଐͱɺॴଐઌͷͷհɺͰͨ͠ɻ ʢձͰͷΈͷ͝հʣ
ࣗݾհͦͷ̏ w 1PTUHSF42-Y࣌ͷ৺ͳϢʔβ w ͻͨ͢ΒެࣜϚχϡΞϧΛಡΉੜ׆ w 4MPOZͰͷϨϓϦέʔγϣϯ w ࣄͷ߹ʢస৬ʣͰ.Z42-ʹվफ w
ଞʹɿ42-4FSWFS 0SBDMF w ΄Μͷͪΐͬͱ͚ͩɿ%# 42-JUF
ͱ͜ΖͰ
ϩάͷूܭௐࠪ Ͳ͏ͯ͠·͔͢ʁ
ϩάͷूܭௐࠪ w ઐ༻ͷπʔϧʹಥͬࠐΉʁ w ͕ࣗऔΓ͍߲ͨɺऔΕ·͔͢ʁ 42-ͰΫΤϦॻ͖͍ͨͰ͢ΑͶʙ w ηοτΞοϓ͕໘ͩͬͨΓ w 3%#ʹ৯ΘͤͯΫΤϦॻ͖·͔͢ʁ
w ͏ͬɺσΟεΫαΠζ͕͕͕ʜʜ
͜ΕΒͷ՝Λ ղܾͰ͖Δ͔͠Εͳ͍ πʔϧΛ͝հ͠·͠ΐ͏
࣍ w 4ͱʁ w "84"UIFOBͱʁ w ࣮ࡍʹͬͯΈ·͠ΐ͏ w UJQT
4ͱ "NB[PO"UIFOBͷͷલʹ
4ͱ w 4JNQMF4UPSBHF4FSWJDFΦϒδΣΫτετϨʔδ w ༰ྔ੍ݶɿࣄ্࣮ແ͠ w ߴ͍ੑʢੑΛԼ͛ͯ҆͘ࡁ·ͤΔϓϥϯ͋Δʣ w අ༻ w
ஷଂσʔλྔʹԠͯ͡ͷ՝ۚɿ͍҆ w SFBEXSJUFϦΫΤετͰͷ՝ۚ w ωοτϫʔΫసૹྔͰͷ՝ۚɿ"84ಉҰϦʔδϣϯλμ
4ͷ༻్ w 8FCΞϓϦͷҰ෦ͱͯ͠ w TUBUJDͳ8FCϖʔδ w ը૾ͳͲͷஔ͖ॴ w γεςϜͷҰ෦ͱͯ͠ w
ϩάͷظอɹ˞(MBDJFSͱ͍͏બࢶ w όοΫΞοϓϑΝΠϧͷஔ͖ॴ
4ͷ༻్ w 8FCΞϓϦͷҰ෦ͱͯ͠ w TUBUJDͳ8FCϖʔδ w ը૾ͳͲͷஔ͖ॴ w γεςϜͷҰ෦ͱͯ͠ w
ϩάͷظอɹ˞(MBDJFSͱ͍͏બࢶ w όοΫΞοϓϑΝΠϧͷஔ͖ॴ
"NB[PO"UIFOB ͱ
"NB[PO"UIFOBͱ w 4ʹஔ͍ͨϑΝΠϧΛ w 42-ͰॲཧʢTFMFDUʣͯ͘͠ΕΔ w 4͔ΒಡΈࠐΜͩσʔλྔͰ՝ۚ w ΫΤϦ݁Ռ4ʹอଘͯ͘͠ΕΔ w
TJODF/PW
"UIFOBଞͱͷҧ͍ σʔλूܭαʔϏεɺଞʹ͍Ζ͍Ζ͋Δ͚ΕͲʜ w αʔόεϖοΫؾʹ͠ͳ͍͍ͯ͘ w ઃఆDSFBUFUBCMF͘Β͍ w ެ͕ࣜݴ͏ʹʮBEIPD͖ʯ w "1*උ͞Ε͍ͯͳ͍
w ͦͷ࣌ͷճݶΓͷΫΤϦɺ࣌ʑྲྀ͢ΫΤϦ͖
"UIFOBͲ͏͏ͷ͔ʁ w 4ʹஔ͍͍ͯΔϑΝΠϧͰDSFBUFUBCMF w ඞཁͳΒύʔςΟγϣϯઃఆ w 42-Λॻ͍࣮ͯߦʂ w ܁Γฦ͠͏ΫΤϦอଘ
࣮ࡍʹͬͯΈ·͠ΐ͏ w DSFBUFUBCMF w ΫΤϦΛྲྀͯ͠ΈΔ
σϞͰհͨ͠ͷ w ༣ศ൪߸σʔλ w μϯϩʔυIUUQXXXQPTUKBQBOQPTUKQ[JQDPEFEMLPHBLJ[JQIUNM w ΧϥϜͷઆ໌IUUQXXXQPTUKBQBOQPTUKQ[JQDPEFEMSFBENFIUNM w "UIFOBͰ࣮ࡍʹDSFBUFUBCMF w
ΫΤϦ w ถࢠͷொͷҰཡ w ௗऔݝͷதͰɺಉ͡༣ศ൪߸͕ෳͷொͰΘΕ͍ͯΔͷ w ʮҰͭͷ༣ศ൪߸ͰೋҎ্ͷொҬΛද͢߹ͷදࣔʯͰͳ͍ͷʹ ෳߦ͋Δσʔλ w ͷσʔλ
UJQT
͏্ͰͷUJQT w 65' w EFMJNJUFS͕୯७Ͱͳ͍ͱ͖ɿ ɹਖ਼نදݱΛ׆༻ w ࠷ॳਖ਼نදݱΛΘͳ͍ϑΥʔϚοτͰ࿅श ɹ˞׳Εͯͳ͍ͱϋϚΔ w
σΟϨΫτϦͷதΛશ෦ಡΉ ɹ༨ܭͳϑΝΠϧೖΕͳ͍Α͏ʹ͠Α͏
ίετݮUJQT w 4ͱ"UIFOBಉ͡Ϧʔδϣϯʹஔ͜͏ 㲎σʔλసૹྉۚ w ύʔςΟγϣϯΕΔߏΛߟ͑Α͏ 㲎ͦͦϑΝΠϧʹΞΫηεͤ͞ͳ͍ w H[JQΛ͓͏ w
ྻࢤͷϑΝΠϧϑΥʔϚοτ
·ͱΊ w VQEBUFEFMFUFͰ͖ͳ͍ w 42-ͷ࿅शʹ͑Δ͔ w ϩάΛஔ͍ͱ͘4 w ΫΤϦྲྀͤΔ"UIFOBʹͯ w
͠͝ͱָ͘͠Ͱ͖ͪΌ͏Ͷ
More Decks by T. MOTOOKA
See All by T. MOTOOKA
業務を観察する
motooka
0
150
一意に定まらない話
motooka
0
260
自動化した処理を止めてしまった話
motooka
0
340
StoredFunctionのすゝめ
motooka
1
350
コメントは英語で書く!
motooka
1
160
TCPポート使い切り事件
motooka
1
550
SVG画像をPHPで生成しよう
motooka
0
1.6k
Working with Database Replications in CakePHP
motooka
1
2.3k
文字とPDFとPDFKit
motooka
2
2.6k
Other Decks in Technology
See All in Technology
サーバーラックは作る時代! 3Dプリンターで作る10インチラックのススメ
jacopen
2
520
20261113_JAWS_Osaka
takuyay0ne
1
610
HTTP通信に使おうとすると実はめんどくさいfile_get_contents
maguroalternative
0
260
落とし穴にハマってわかった 開発生産性を測るときに気をつけたいこと
munakata
3
490
[DBRE Summit 26] DBRE はデータベース運用をどう変えたのか
_awache
0
130
お風呂場をサーバルームにしよう
yusuke427
0
390
NutanixへのSSHアクセスの今後について
shadowhat
0
170
認知負荷の減らし方 ~開発にも日常業務にも活かせるノウハウ~
minorun365
PRO
16
10k
HTTP QUERY時代の型安全な検索APIをKotlinで設計する
sansantech
PRO
1
130
AWS Client VPNの設定でハマったポイントとその過程での気づき
amarelo_n24
1
440
SBOM 生成ツールで 2026 Minimum Elements はどこまで満たせるのか
gokken
0
160
クラウドでも使えるNetApp -現場目線での設計とクラウドバックアップの活用
ryutakondo
1
320
Featured
See All Featured
Lightning talk: Run Django tests with GitHub Actions
sabderemane
0
330
Mobile First: as difficult as doing things right
swwweet
225
10k
State of Search Keynote: SEO is Dead Long Live SEO
ryanjones
0
360
Crafting Experiences
bethany
1
460
A Tale of Four Properties
chriscoyier
163
24k
Refactoring Trust on Your Teams (GOTO; Chicago 2020)
rmw
35
3.9k
Principles of Awesome APIs and How to Build Them.
keavy
128
18k
Fantastic passwords and where to find them - at NoRuKo
philnash
53
4k
svc-hook: hooking system calls on ARM64 by binary rewriting
retrage
2
690
[RailsConf 2023] Rails as a piece of cake
palkan
59
7.2k
Taking LLMs out of the black box: A practical guide to human-in-the-loop distillation
inesmontani
PRO
3
2.5k
How To Speak Unicorn (iThemes Webinar)
marktimemedia
1
640