石橋 卓見
ishib****@syste*****
2017年 5月 24日 (水) 18:12:53 JST
$B3F0LMM(B $BBgJQM-MQ$J(BGroonga$B!"$J$i$S$K(BMroonga$B$r$$$D$bMxMQ$5$;$F$$$?$@$$$F$*$j$^$9!#(B $B ＠ P66$H?=$7$^$9!#$*K;$7$$$H$3$m62=L$G$9$,!"#1E@<ALd$r$5$;$F2<$5$$!#(B $B0J2<$N<j=g$K$F!"J8=q%F!<%V%k!J(BLogs$B!K$H!"A4J88!:w$N0Y$N:w0z%F!<%V%k(B $B!J(BTerms - message_index$B!K$r:n ＠ .$7!"J8=q%F!<%V%k$K%5%s%W%k%G!<%?$r(B $B#39T(B $BEPO?CW$7$^$7$?!#(B -------------------------------------------------------------------- $ groonga -n /tmp/sample.db > table_create Logs TABLE_NO_KEY > column_create Logs message COLUMN_SCALAR Text > table_create Terms TABLE_PAT_KEY ShortText \ --default_tokenizer TokenMecab \ --normalizer NormalizerAuto > column_create Terms message_index COLUMN_INDEX|WITH_POSITION Logs message > load --table Logs [ {"message": "$B!Z>W7b![%^%/%I%J%k%I$,8x<0$K!V%Y%C%-!<%P!<%,!<!W$rH/Gd!*(B $B$=$NL#$O%2%9$J$[$I%&%^$+$C$?(B($B>P(B)"}, {"message": "$B%Y%C%-!<!V5$;}$AJ,$+$k!W%N%s%9%?0f>e$K6&46(B"}, {"message": "$B%2%9ITNQ$K$*Gc$$J*CfFG!D(B20$BBe=w;R$,?F$KHkL)$K$7$F$$$k$3$H(B3$BA*(B"}, ] -------------------------------------------------------------------- $B$=$N8e$K!"(Bselect Terms $B$K$F%G!<%?$r3NG'$7$?$H$3$m!"4|BTDL$j(BMecab$B$K$F(B $B%H!<%/%J%$%:$5$l$F$$$k$3$H$r3NG'=PMh$^$7$?!#(B -------------------------------------------------------------------- > select Terms --limit 999 [[0,1495615305.558772,0.0003552436828613281],[[[47],[["_id","UInt32"],["_key","ShortText"],["message_index","UInt32"]],[13,"!",1],[23,"(",1],[25,")",1],[36,"...",1],[37,"20",1],[46,"3",1],[8,"$B!V(B",11],[10,"$B!W(B",13],[1,"$B!Z(B",1],[3,"$B![(B",1],[44,"$B$$$k(B",1],[33,"$B$*(B",1],[21,"$B$+$C(B",1],[5,"$B$,(B",8],[45,"$B$3$H(B",1],[42,"$B$7(B",1],[14,"$B$=$N(B",1],[22,"$B$?(B",1],[43,"$B$F(B",1],[18,"$B$J(B",1],[7,"$B$K(B",11],[16,"$B$O(B",1],[19,"$B$[$I(B",1],[11,"$B$r(B",1],[20,"$B%&%^(B",1],[17,"$B%2%9(B",20],[29,"$B%N%s%9%?(B",1],[26,"$B%Y%C%-!<(B",1],[9,"$B%Y%C%-!<%P!<%,!<(B",1],[4,"$B%^%/%I%J%k%I(B",1],[32,"$BITNQ(B",1],[35,"$BCfFG(B",1],[30,"$B0f>e(B",1],[38,"$BBe(B",1],[6,"$B8x<0(B",1],[31,"$B6&46(B",1],[28,"$BJ,$+$k(B",1],[15,"$BL#(B",1],[39,"$B=w;R(B",1],[27,"$B5$;}$A(B",1],[12,"$BH/Gd(B",1],[41,"$BHkL)(B",1],[24,"$B>P(B",1],[2,"$B>W7b(B",1],[40,"$B?F(B",1],[34,"$BGc$$J*(B",1],[47,"$ BA*(B",1]]]] -------------------------------------------------------------------- $B$3$N;~$N7k2L(B "message_index"$B$K$D$$$F$G$9$,!"$I$N$h$&$J0UL#$,$"$k$N$+$,(B $B$o$+$i$:!":#2s<ALd$r$5$;$F$$$?$@$-$^$7$?!#(B [17,"$B%2%9(B",20]$B!!$N(B20$B$NCM$N0UL#$r65$($F$$$?$@$1$k$H=u$+$j$^$9!&!&!&(B $B$Q$C$H8+$?$H$3$m!"=P8=?t$,B?$$DxBg$-$$$h$&$K8+<u$1$i$l$k$N$G!"%9%3%"$N(B $B$h$&$J$b$N$G$7$g$&$+!)(B $B85!9!"(Bmessage_index$B$K$O!"C18lKh$K!"(BLogs$B%F!<%V%k$N$I$NJ8=q!J(Bid$B!K$K=P8=$7$?$+(B $B$I$&$+$N>pJs$,F~$C$F$$$k$N$+$H;W$C$F$*$j$^$7$?!#(B # $BNc$($P!"!V%2%9!W$H$$$&C18l$G$"$l$P!"(B1,3 $B!"!V%Y%C%-!<!W$O(B 1,2$B!!$N$h$&$J$b$N(B $B$3$N$h$&$J>pJs$O(BGroonga$B$h$j<hF@$G$-$k$N$G$7$g$&$+!#(B Groonga$B$NFbItE*$J;EAH$_$K$D$$$F$h$/$o$+$C$F$*$i$:!"62=L$G$9$,!"%"%I%P%$%9$r(B $BD:$1$k$H=u$+$j$^$9!#(B $B$I$&$>$h$m$7$/$*4j$$CW$7$^$9!#(B -- $B3t<02q<R%7%9%F%`%=%U%H(B $B!!!!!!!!!!%7%9%F%`;v6HIt!!>pJs%F%/%N%m%8It(B $B ＠ P66(B $BBn8+(B <ishib****@syste*****> $B>oCs ＠ h(B ( KDDI$B8&5f=j(BSS$BJ,<<(B ) 049-278-7507 $B7HBSEEOC(B 090-9689-0997 $B<+Bp(B 04-2928-6313
