Pro Yearly is on sale from $80 to $50! »

Groonga Meatup 2017 muratapo128

32a1d4fe9174c50ff8cff70cd28788b8?s=47 muratapo
February 10, 2017

Groonga Meatup 2017 muratapo128

32a1d4fe9174c50ff8cff70cd28788b8?s=128

muratapo

February 10, 2017
Tweet

Transcript

  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͕ڊେʹͳΔͱ஗͍

    NZTRM4&5NSPPOHB@CPPMFBO@NPEF@TZOUBY@qBHT 4:/5"9@26&3: "--08@-&"%*/(@/05 "--08@$0-6./ NZTRM4&-&$5JE'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?  NZTRM4&-&$5NSPPOHB@DPNNBOE  TFMFDUYYYNBUDI@DPMVNOTLFZXPSE RVFSZaaaaaaaaaaaaaaa ?P?aaaa

    aaa  "4SFTVMU PI
  17. ݁Ռͷ+40/͕ [ [ 0, 1486552543.139766, 0.0004394054412841797 ], [ [ [

    3261870 ], [ [ "_id", "UInt32" ], [ "title", "ShortText" ] ], [ 1, "HAHAHAHA!" ] ] ] ] 1)1ͰΩϞ͍ɻɻ KKTPO@EFDPEF SFTVMU  DPVOUK<><><> SPXTK<><> 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. ͋Γ͕ͱ͏͍͟͝·ͨ͠