Groonga Meatup 2017 muratapo128

1. .SPPOHB(SPPOHB
   4&-&$5ΠϩΠϩ 
   (SPPOHB
   .FBUVQ
   
   NVSBUBQP
2. ΉΒͨΆ ɾגࣜձࣾΫϦʔϚॴଐ
   ɾ%#"తͳԿ͔
   ɾ.Z42-େ޷͖
   ɾ4FOOBͷࠒ͔Βશจݕࡧ
   ɾ͕ͦ͘ΓΖΜ͛
   ɾפ͞ʹऑ͍ॵ͞ʹऑ͍ͱʹ͔͘ऑ͍
3. $SFFNB ϋϯυϝΠυϚʔέοτϓϨΠε
   .SPPOHB(SPPOHB͸࡞඼ݕࡧͷͨΊʹ࢖༻
   ࠷ॳ͸-*,&ͩͬͨ
   
   
   .SPPOHBϥούʔϞʔυ
   
   
   .SPPOHBετϨʔδϞʔυ ΠϚίί
4. .SPPOHBετϨʔδϞʔυ ɾNBUDI 
   BHBOTU  Ͱෳ਺JOEFY࢖͑ΔˍGBTU@PSEFS@MJNJU
   ɾϕΫλΧϥϜ
   ɾESJMMEPXO େ޷͖
   ɾNSPPOHB@DPNNBOEʹΑΔHSPPOHB௚໰͍߹Θͤ
   ɾͱʹ͔͘଎͍ʢخ͍͠ʣ
   ʜʜ
   ɾτϥϯβΫγϣϯ͕ޮ͔ͳͯ͘΋ٽ͔ͳ͍ʂʢྑ͘ٽ͘ʣ
   ɾͪΐ͍ͪΐ͍᠘͕͋Δ མͱ͕݀͠ɻɻ
   ɾυΩϡϝϯτʁιʔεݟΕ͹ྑ͍Μ͡Όͳ͍ʁ
5. ࡞඼ݕࡧͷ೉͠͞ ৭ʑͳ৚݅ શจݕࡧɺΧςΰϦYɺૉࡐɺՁ֨ɺ৭ɺλάʜʜ౳ʑ ιʔτ ਓؾॱɺ৽ணॱɺՁ֨ॱ ߴ͍ॱ͍҆ॱ
6. ɹ
   㱸@㱸
   㱬 ŋшŋ
   ɹɹɹů㱮
   ɹ͠ʕ̟c㲁
   ɹɹɹɹɹਓųƅŢŕ
   ɹɹɹɹɹʊʊ
   ɹɹɹɹɹʘɹʘ */%&9షͬͯΒΕΔ͔ʂ
7. 4&-&$5ΠϩΠϩ ɾ௨ৗͷ4&-&$5
   ɾ."5$) 
   "("*/45  ෇͖4&-&$5
   ɾNSPPOHB@DPNNBOEͰTFMFDU
8. ௨ৗͷ4&-&$5 ɾ.Z42-ͷϧʔϧʹറΒΕΔ
   ɾجຊ͸.VMUJQMF$PMVNO*OEFY
   ɾ8)&3&΋03%&3΋*/%&9Ͱղܾग़དྷͯ
   ɹ0''4&5͕খ͚͞Ε͹࠷଎
   ɾ৚͕݅ෳࡶʹͳΔͱ*/%&9ංେԽ
   ɹˠ
   ֤έʔεʹରԠ͢Δ*/%&9షΔʁ
   ɾ0''4&5͕ڊେʹͳΔͱ஗͍
9. ."5$) 
   "("*/45  ෇͖ ɾશจݕࡧͷ৔߹
   ɹˠ
   '5Ҏ֎ͷෳ਺ͷJOEFY࢖͑Δ
   ɹˠ
   GBTU@PSEFS@MJNJU ɾશจݕࡧ͠ͳͯ͘΋
   ɹˠ
   "--08@$0-6./
   ɹˠ
   ෳ਺ͷJOEFY࢖͑Δ
   ɹˠ
   GBTU@PSEFS@MJNJU
   
10. ."5$) 
    "("*/45  ෇͖ ɾΧϥϜ*OEFYష͓͚ͬͯ͹0,
    ɾ JOEFY࢖ͬͨ ௨ৗͷ4&-&$5ΑΓ͸஗͍
    ɾ0''4&5͕ڊେʹͳΔͱ஗͍ NZTRM
    4&5
    NSPPOHB@CPPMFBO@NPEF@TZOUBY@qBHT
    
    4:/5"9@26&3: "--08@-&"%*/(@/05 "--08@$0-6./
    NZTRM
    4&-&$5
    JE
    '30.
    UBCMF@"
    8)&3&
    ."5$) LFZXPSE
    
    "("*/45  DPOE"
    DPOE#
    */
    #00-&"/
    .0%&
    
    03%&3
    #:
    QSJDF
    "4$
    -*.*5
    
    
11. NSPPOHB@DPNNBOEͰTFMFDU ɾ(SPPOHBʹ௚໰͍߹Θͤ
    ɾESJMMEPXO࢖͏৔߹
    ɾ.Z42-ͷϧʔϧΛແࢹग़དྷΔ
    ɾ$06/5΋ҰॹʹऔಘͰ͖Δ
    ɾ0''4&5͕ڊେʹͳͬͯ΋͋·Γ஗͘ͳΒͳ͍
12. ଌఆ 0''4&5         4&-&$5 T T T T ."5$) 
    "("*/45  T T T T NSPPOHB@ DPNNBOE T T T T ˎσʔλͷ෼෍౳؀ڥʹΑΓ·͢ NVMUJQMFDPMVNOJOEFYɺ֤DPMVNOJOEFY͋Γ
    ֘౰σʔλ  
    
    શ  
13. ଌఆ 0''4&5        4&-&$5 T T T T ."5$) 
    "("*/45  T T T T NSPPOHB@ DPNNBOE T T T T ˎσʔλͷ෼෍౳؀ڥʹΑΓ·͢ ଌఆʹNVMUJQMFDPMVNOJOEFY֎ͷ৚݅෇༩
    ֘౰σʔλ 
    
    શ  
14. ଌఆ 0''4&5        4&-&$5 T T T T ."5$) 
    "("*/45  T T T T NSPPOHB@ DPNNBOE T T T T ˎσʔλͷ෼෍౳؀ڥʹΑΓ·͢ NVMUJQMFDPMVNOJOEFY֎ͷ৚݅
    ֘౰σʔλ 
    
    શ  
15. ͕͜͜ΞϨͩΑ NSPPOHB@DPNNBOE
16. Τεέʔϓ͕ΩϞ͍ .Z42-ͱ(SPPOHBͷΤεέʔϓ͕ࠞͬͯ͟ΩϞ͍ ͜ΕΛݕࡧ͍ͨ͠
    ˠ
    a ?P?  NZTRM
    4&-&$5
    NSPPOHB@DPNNBOE 
    
    TFMFDU
    YYY
    NBUDI@DPMVNOT
    LFZXPSE
    
    RVFSZ
    aaaaaaaaaaaaaaa ?P?aaaa aaa
    
    "4
    SFTVMU PI
17. ݁Ռͷ+40/͕ [ [ 0, 1486552543.139766, 0.0004394054412841797 ], [ [ [ 3261870 ], [ [ "_id", "UInt32" ], [ "title", "ShortText" ] ], [ 1, "HAHAHAHA!" ] ] ] ] 
    1)1ͰΩϞ͍ɻɻ
    K
    
    KTPO@EFDPEF SFTVMU 
    DPVOU
    
    K<><><>
    SPXT
    
    K<><> DPNNBOE@WFSTJPOͰվળ
18. ΞϓϦଆݴޠͱͷ૬ੑ͕
    ɹˠ2VFSZ#VJMEFSʁͳʹͦΕʁ
    ಈతΧϥϜͱ͔ESJMMEPXOͱ͔࢖͍·͘Δͱɻɻɻ select mroonga_command(' select user_attr_log --filter type==2 --columns[pg].stage filtered --columns[pg].type UInt16 --columns[pg].flags COLUMN_SCALAR --columns[pg].value "price<=2000?2000:price<=5000?5000:price<=10000?10000:10001" --output_columns _id --limit 0 --cache no --output_pretty yes --command_version 3 --drilldowns[tkmn].keys category_id,pg --drilldown[tkmn].calc_types AVG --drilldown[tkmn].calc_target price --drilldowns[tkmn].output_columns _value.category_id,_value.pg,_nsubrecs,_avg --drilldowns[tkmn].sort_keys _value.category_id,_value.pg --drilldowns[tkmn].limit 5000 ');
19. ৭ʑ͋Δ͚Ͳ
    .SPPOHB(SPPOHB
    େ޷͖Ͱ͢ʂʂ
20. ͋Γ͕ͱ͏͍͟͝·ͨ͠