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

Groonga Meatup 2017 muratapo128

Avatar for muratapo muratapo
February 10, 2017

Groonga Meatup 2017 muratapo128

Avatar for muratapo

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 ');