Upgrade to Pro — share decks privately, control downloads, hide ads and more …

Groonga Meatup 2017 muratapo128

muratapo
February 10, 2017

Groonga Meatup 2017 muratapo128

muratapo

February 10, 2017
Tweet

Other Decks in Technology

Transcript

  1. .SPPOHBετϨʔδϞʔυ ɾNBUDI  BHBOTU  Ͱෳ਺JOEFY࢖͑ΔˍGBTU@PSEFS@MJNJU ɾϕΫλΧϥϜ ɾESJMMEPXO େ޷͖ 

    ɾNSPPOHB@DPNNBOEʹΑΔHSPPOHB௚໰͍߹Θͤ ɾͱʹ͔͘଎͍ʢخ͍͠ʣ ʜʜ ɾτϥϯβΫγϣϯ͕ޮ͔ͳͯ͘΋ٽ͔ͳ͍ʂʢྑ͘ٽ͘ʣ ɾͪΐ͍ͪΐ͍᠘͕͋Δ མͱ͕݀͠ɻɻ  ɾυΩϡϝϯτʁιʔεݟΕ͹ྑ͍Μ͡Όͳ͍ʁ
  2. ."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 
  3. ଌఆ 0''4&5        

    4&-&$5 T T T T ."5$)   "("*/45  T T T T NSPPOHB@ DPNNBOE T T T T ˎσʔλͷ෼෍౳؀ڥʹΑΓ·͢ NVMUJQMFDPMVNOJOEFYɺ֤DPMVNOJOEFY͋Γ ֘౰σʔλ  શ  
  4. ଌఆ 0''4&5        4&-&$5

    T T T T ."5$)   "("*/45  T T T T NSPPOHB@ DPNNBOE T T T T ˎσʔλͷ෼෍౳؀ڥʹΑΓ·͢ ଌఆʹNVMUJQMFDPMVNOJOEFY֎ͷ৚݅෇༩ ֘౰σʔλ શ  
  5. ଌఆ 0''4&5        4&-&$5

    T T T T ."5$)   "("*/45  T T T T NSPPOHB@ DPNNBOE T T T T ˎσʔλͷ෼෍౳؀ڥʹΑΓ·͢ NVMUJQMFDPMVNOJOEFY֎ͷ৚݅ ֘౰σʔλ શ  
  6. ݁Ռͷ+40/͕ [ [ 0, 1486552543.139766, 0.0004394054412841797 ], [ [ [

    3261870 ], [ [ "_id", "UInt32" ], [ "title", "ShortText" ] ], [ 1, "HAHAHAHA!" ] ] ] ] 1)1ͰΩϞ͍ɻɻ KKTPO@EFDPEF SFTVMU  DPVOUK<><><> SPXTK<><> DPNNBOE@WFSTJPOͰվળ
  7. ΞϓϦଆݴޠͱͷ૬ੑ͕ ɹˠ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 ');