Amazonの Athenaで楽々 ログ集計

2377be1c3f33751ea7c73a7bd8d58996?s=47 T. MOTOOKA
February 18, 2017

Amazonの Athenaで楽々 ログ集計

2017.02.18 中国地方DB勉強会 #19
https://dbstudychugoku.connpass.com/event/46019/

2377be1c3f33751ea7c73a7bd8d58996?s=128

T. MOTOOKA

February 18, 2017
Tweet

Transcript

  1. 2.

    ࣗݾ঺հͦͷ̍ w !U@NPUPPLB w IFBMUIDIFDL௨Βͳ͍αʔόͷ؅ཧऀ w 1)10CKFDUJWF$4XJGU47(1%' w :(){ :|:&

    };:ɹ˞ʮϑΥʔΫര஄ʯͰ͢ɻةݥͰ͢ɻ w ςΫχΧϧΤϯδχΞʢσʔλϕʔεʣ w "84$FSUJpFE4PMVUJPO"SDIJUFDU
 "TTPDJBUF-FWFM
  2. 11.

    4ͱ͸ w 4JNQMF4UPSBHF4FSWJDFΦϒδΣΫτετϨʔδ w ༰ྔ੍ݶɿࣄ্࣮ແ͠ w ߴ͍৑௕ੑʢ৑௕ੑΛԼ͛ͯ҆͘ࡁ·ͤΔϓϥϯ΋͋Δʣ w අ༻ w

    ஷଂσʔλྔʹԠͯ͡ͷ՝ۚɿ͍҆ w SFBEXSJUFϦΫΤετ਺Ͱͷ՝ۚ w ωοτϫʔΫసૹྔͰͷ՝ۚɿ"84ಉҰϦʔδϣϯ಺͸λμ
  3. 12.

    4ͷ༻్ w 8FCΞϓϦͷҰ෦ͱͯ͠ w TUBUJDͳ8FCϖʔδ w ը૾ͳͲͷஔ͖৔ॴ w γεςϜͷҰ෦ͱͯ͠ w

    ϩάͷ௕ظอ؅ɹ˞(MBDJFSͱ͍͏બ୒ࢶ΋ w όοΫΞοϓϑΝΠϧͷஔ͖৔ॴ
  4. 13.

    4ͷ༻్ w 8FCΞϓϦͷҰ෦ͱͯ͠ w TUBUJDͳ8FCϖʔδ w ը૾ͳͲͷஔ͖৔ॴ w γεςϜͷҰ෦ͱͯ͠ w

    ϩάͷ௕ظอ؅ɹ˞(MBDJFSͱ͍͏બ୒ࢶ΋ w όοΫΞοϓϑΝΠϧͷஔ͖৔ॴ
  5. 19.

    σϞͰ঺հͨ͠΋ͷ w ༣ศ൪߸σʔλ w μ΢ϯϩʔυIUUQXXXQPTUKBQBOQPTUKQ[JQDPEFEMLPHBLJ[JQIUNM w ΧϥϜͷઆ໌IUUQXXXQPTUKBQBOQPTUKQ[JQDPEFEMSFBENFIUNM w "UIFOBͰ࣮ࡍʹDSFBUFUBCMF w

    ΫΤϦ w ถࢠͷொͷҰཡ w ௗऔݝͷதͰɺಉ͡༣ศ൪߸͕ෳ਺ͷொͰ࢖ΘΕ͍ͯΔ΋ͷ w ʮҰͭͷ༣ศ൪߸ͰೋҎ্ͷொҬΛද͢৔߹ͷදࣔʯͰ͸ͳ͍ͷʹ ෳ਺ߦ͋Δσʔλ w ͷσʔλ
  6. 20.
  7. 24.

    ׬