null+****@clear*****
null+****@clear*****
2011年 1月 6日 (木) 14:43:58 JST
Tasuku SUENAGA a.k.a. gunyarakun 2011-01-06 05:43:58 +0000 (Thu, 06 Jan 2011) New Revision: 1884ca37b53c3382315994677b94bcecb87f7d90 Log: Updated tutorial execution results. Modified files: doc/ja/source/example/tutorial01-1.log doc/ja/source/example/tutorial01-10.log doc/ja/source/example/tutorial01-11.log doc/ja/source/example/tutorial01-12.log doc/ja/source/example/tutorial01-13.log doc/ja/source/example/tutorial01-14.log doc/ja/source/example/tutorial01-15.log doc/ja/source/example/tutorial01-16.log doc/ja/source/example/tutorial01-17.log doc/ja/source/example/tutorial01-2.log doc/ja/source/example/tutorial01-3.log doc/ja/source/example/tutorial01-4.log doc/ja/source/example/tutorial01-5.log doc/ja/source/example/tutorial01-6.log doc/ja/source/example/tutorial01-7.log doc/ja/source/example/tutorial01-8.log doc/ja/source/example/tutorial01-9.log doc/ja/source/example/tutorial02-1.log doc/ja/source/example/tutorial02-3.log doc/ja/source/example/tutorial03-1.log doc/ja/source/example/tutorial03-2.log doc/ja/source/example/tutorial03-3.log doc/ja/source/example/tutorial04-1.log doc/ja/source/example/tutorial04-2.log doc/ja/source/example/tutorial04-3.log doc/ja/source/example/tutorial04-4.log doc/ja/source/example/tutorial04-5.log doc/ja/source/example/tutorial04-6.log doc/ja/source/example/tutorial04-7.log doc/ja/source/example/tutorial05-1.log doc/ja/source/example/tutorial05-2.log doc/ja/source/example/tutorial05-3.log doc/ja/source/example/tutorial05-4.log doc/ja/source/example/tutorial05-5.log doc/ja/source/example/tutorial05-6.log doc/ja/source/example/tutorial06-1.log doc/ja/source/example/tutorial06-2.log doc/ja/source/example/tutorial06-3.log doc/ja/source/example/tutorial06-4.log doc/ja/source/example/tutorial06-5.log doc/ja/source/example/tutorial07-1.log doc/ja/source/example/tutorial07-2.log doc/ja/source/example/tutorial07-3.log doc/ja/source/example/tutorial07-4.log doc/ja/source/example/tutorial08-1.log doc/ja/source/example/tutorial10-1.log doc/ja/source/example/tutorial10-10.log doc/ja/source/example/tutorial10-2.log doc/ja/source/example/tutorial10-3.log doc/ja/source/example/tutorial10-4.log doc/ja/source/example/tutorial10-5.log doc/ja/source/example/tutorial10-6.log doc/ja/source/example/tutorial10-7.log doc/ja/source/example/tutorial10-8.log doc/ja/source/example/tutorial10-9.log doc/ja/source/tutorial/tutorial06.txt Modified: doc/ja/source/example/tutorial01-1.log (+1 -1) =================================================================== --- doc/ja/source/example/tutorial01-1.log 2011-01-05 14:40:36 +0000 (71e348a) +++ doc/ja/source/example/tutorial01-1.log 2011-01-06 05:43:58 +0000 (6e85d65) @@ -2,5 +2,5 @@ % groonga /tmp/tutorial.db > status - [[0,1280378897.11968,1.8e-05],{"alloc_count":440,"starttime":1280378807,"uptime":90,"version":"0.7.2-5-g2a77275"}] + [[0,1294292494.18924,3.7116e-05],{"alloc_count":443,"starttime":1294292404,"uptime":90,"version":"1.0.6-10-gba9df76","n_queries":106,"cache_hit_rate":0.943396226415094,"command_version":1,"default_command_version":1,"max_command_version":2}] \ No newline at end of file Modified: doc/ja/source/example/tutorial01-10.log (+1 -1) =================================================================== --- doc/ja/source/example/tutorial01-10.log 2011-01-05 14:40:36 +0000 (93ce818) +++ doc/ja/source/example/tutorial01-10.log 2011-01-06 05:43:58 +0000 (f3ca7e2) @@ -1,5 +1,5 @@ 実行例 :: > select --table Site --query "_key:\"http://example.org/\"" - [[0,1280378902.11978,0.000287],[[[1],[["_id","UInt32"],["_key","ShortText"],["title","ShortText"]],[1,"http://example.org/","This is test record 1!"]]]] + [[0,1294292498.74872,0.00031979],[[[1],[["_id","UInt32"],["_key","ShortText"],["title","ShortText"]],[1,"http://example.org/","This is test record 1!"]]]] \ No newline at end of file Modified: doc/ja/source/example/tutorial01-11.log (+1 -1) =================================================================== --- doc/ja/source/example/tutorial01-11.log 2011-01-05 14:40:36 +0000 (d7d3474) +++ doc/ja/source/example/tutorial01-11.log 2011-01-06 05:43:58 +0000 (ce01c42) @@ -1,5 +1,5 @@ 実行例 :: > select --table Site --query title:@this - [[0,1280378902.32214,0.000302],[[[1],[["_id","UInt32"],["_key","ShortText"],["title","ShortText"]],[1,"http://example.org/","This is test record 1!"]]]] + [[0,1294292498.95104,0.00032904],[[[1],[["_id","UInt32"],["_key","ShortText"],["title","ShortText"]],[1,"http://example.org/","This is test record 1!"]]]] \ No newline at end of file Modified: doc/ja/source/example/tutorial01-12.log (+1 -1) =================================================================== --- doc/ja/source/example/tutorial01-12.log 2011-01-05 14:40:36 +0000 (fd2bb1e) +++ doc/ja/source/example/tutorial01-12.log 2011-01-06 05:43:58 +0000 (c7f541d) @@ -1,5 +1,5 @@ 実行例 :: > select --table Site --match_columns title --query this - [[0,1280378902.52448,0.000367],[[[1],[["_id","UInt32"],["_key","ShortText"],["title","ShortText"]],[1,"http://example.org/","This is test record 1!"]]]] + [[0,1294292499.15359,0.000397943],[[[1],[["_id","UInt32"],["_key","ShortText"],["title","ShortText"]],[1,"http://example.org/","This is test record 1!"]]]] \ No newline at end of file Modified: doc/ja/source/example/tutorial01-13.log (+1 -1) =================================================================== --- doc/ja/source/example/tutorial01-13.log 2011-01-05 14:40:36 +0000 (1955398) +++ doc/ja/source/example/tutorial01-13.log 2011-01-06 05:43:58 +0000 (f3c2f87) @@ -1,5 +1,5 @@ 実行例 :: > select --table Site --output_columns _key,title,_score --query title:@test - [[0,1280378902.72695,0.000387],[[[9],[["_key","ShortText"],["title","ShortText"],["_score","Int32"]],["http://example.org/","This is test record 1!",1],["http://example.net/","test record 2.",1],["http://example.com/","test test record three.",2],["http://example.net/afr","test record four.",1],["http://example.org/aba","test test test record five.",3],["http://example.com/rab","test test test test record six.",4],["http://example.net/atv","test test test record seven.",3],["http://example.org/gat","test test record eight.",2],["http://example.com/vdw","test test record nine.",2]]]] + [[0,1294292499.35613,0.000371444],[[[9],[["_key","ShortText"],["title","ShortText"],["_score","Int32"]],["http://example.org/","This is test record 1!",1],["http://example.net/","test record 2.",1],["http://example.com/","test test record three.",2],["http://example.net/afr","test record four.",1],["http://example.org/aba","test test test record five.",3],["http://example.com/rab","test test test test record six.",4],["http://example.net/atv","test test test record seven.",3],["http://example.org/gat","test test record eight.",2],["http://example.com/vdw","test test record nine.",2]]]] \ No newline at end of file Modified: doc/ja/source/example/tutorial01-14.log (+3 -3) =================================================================== --- doc/ja/source/example/tutorial01-14.log 2011-01-05 14:40:36 +0000 (3248fde) +++ doc/ja/source/example/tutorial01-14.log 2011-01-06 05:43:58 +0000 (ef3888a) @@ -1,9 +1,9 @@ 実行例 :: > select --table Site --offset 0 --limit 3 - [[0,1280378902.93367,0.000106],[[[9],[["_id","UInt32"],["_key","ShortText"],["title","ShortText"]],[1,"http://example.org/","This is test record 1!"],[2,"http://example.net/","test record 2."],[3,"http://example.com/","test test record three."]]]] + [[0,1294292499.56296,0.00011524],[[[9],[["_id","UInt32"],["_key","ShortText"],["title","ShortText"]],[1,"http://example.org/","This is test record 1!"],[2,"http://example.net/","test record 2."],[3,"http://example.com/","test test record three."]]]] > select --table Site --offset 3 --limit 3 - [[0,1280378903.13653,9.8e-05],[[[9],[["_id","UInt32"],["_key","ShortText"],["title","ShortText"]],[4,"http://example.net/afr","test record four."],[5,"http://example.org/aba","test test test record five."],[6,"http://example.com/rab","test test test test record six."]]]] + [[0,1294292499.76592,0.000110122],[[[9],[["_id","UInt32"],["_key","ShortText"],["title","ShortText"]],[4,"http://example.net/afr","test record four."],[5,"http://example.org/aba","test test test record five."],[6,"http://example.com/rab","test test test test record six."]]]] > select --table Site --offset 7 --limit 3 - [[0,1280378903.33964,9.3e-05],[[[9],[["_id","UInt32"],["_key","ShortText"],["title","ShortText"]],[8,"http://example.org/gat","test test record eight."],[9,"http://example.com/vdw","test test record nine."]]]] + [[0,1294292499.96901,0.00010214],[[[9],[["_id","UInt32"],["_key","ShortText"],["title","ShortText"]],[8,"http://example.org/gat","test test record eight."],[9,"http://example.com/vdw","test test record nine."]]]] \ No newline at end of file Modified: doc/ja/source/example/tutorial01-15.log (+1 -1) =================================================================== --- doc/ja/source/example/tutorial01-15.log 2011-01-05 14:40:36 +0000 (fe304cd) +++ doc/ja/source/example/tutorial01-15.log 2011-01-06 05:43:58 +0000 (be88adb) @@ -1,5 +1,5 @@ 実行例 :: > select --table Site --sortby -_id - [[0,1280378903.5424,0.000233],[[[9],[["_id","UInt32"],["_key","ShortText"],["title","ShortText"]],[9,"http://example.com/vdw","test test record nine."],[8,"http://example.org/gat","test test record eight."],[7,"http://example.net/atv","test test test record seven."],[6,"http://example.com/rab","test test test test record six."],[5,"http://example.org/aba","test test test record five."],[4,"http://example.net/afr","test record four."],[3,"http://example.com/","test test record three."],[2,"http://example.net/","test record 2."],[1,"http://example.org/","This is test record 1!"]]]] + [[0,1294292500.17182,0.000239255],[[[9],[["_id","UInt32"],["_key","ShortText"],["title","ShortText"]],[9,"http://example.com/vdw","test test record nine."],[8,"http://example.org/gat","test test record eight."],[7,"http://example.net/atv","test test test record seven."],[6,"http://example.com/rab","test test test test record six."],[5,"http://example.org/aba","test test test record five."],[4,"http://example.net/afr","test record four."],[3,"http://example.com/","test test record three."],[2,"http://example.net/","test record 2."],[1,"http://example.org/","This is test record 1!"]]]] \ No newline at end of file Modified: doc/ja/source/example/tutorial01-16.log (+1 -1) =================================================================== --- doc/ja/source/example/tutorial01-16.log 2011-01-05 14:40:36 +0000 (a496b76) +++ doc/ja/source/example/tutorial01-16.log 2011-01-06 05:43:58 +0000 (1a7b16b) @@ -1,5 +1,5 @@ 実行例 :: > select --table Site --query title:@test --output_columns _id,_score,title --sortby _score - [[0,1280378903.74908,0.000431],[[[9],[["_id","UInt32"],["_score","Int32"],["title","ShortText"]],[1,1,"This is test record 1!"],[2,1,"test record 2."],[4,1,"test record four."],[3,2,"test test record three."],[9,2,"test test record nine."],[8,2,"test test record eight."],[7,3,"test test test record seven."],[5,3,"test test test record five."],[6,4,"test test test test record six."]]]] + [[0,1294292500.37864,0.000452891],[[[9],[["_id","UInt32"],["_score","Int32"],["title","ShortText"]],[1,1,"This is test record 1!"],[2,1,"test record 2."],[4,1,"test record four."],[3,2,"test test record three."],[9,2,"test test record nine."],[8,2,"test test record eight."],[7,3,"test test test record seven."],[5,3,"test test test record five."],[6,4,"test test test test record six."]]]] \ No newline at end of file Modified: doc/ja/source/example/tutorial01-17.log (+1 -1) =================================================================== --- doc/ja/source/example/tutorial01-17.log 2011-01-05 14:40:36 +0000 (c554e9b) +++ doc/ja/source/example/tutorial01-17.log 2011-01-06 05:43:58 +0000 (3760314) @@ -1,5 +1,5 @@ 実行例 :: > select --table Site --query title:@test --output_columns _id,_score,title --sortby _score,_id - [[0,1280378903.95387,0.000427],[[[9],[["_id","UInt32"],["_score","Int32"],["title","ShortText"]],[1,1,"This is test record 1!"],[2,1,"test record 2."],[4,1,"test record four."],[3,2,"test test record three."],[8,2,"test test record eight."],[9,2,"test test record nine."],[5,3,"test test test record five."],[7,3,"test test test record seven."],[6,4,"test test test test record six."]]]] + [[0,1294292500.58351,0.000449563],[[[9],[["_id","UInt32"],["_score","Int32"],["title","ShortText"]],[1,1,"This is test record 1!"],[2,1,"test record 2."],[4,1,"test record four."],[3,2,"test test record three."],[8,2,"test test record eight."],[9,2,"test test record nine."],[5,3,"test test test record five."],[7,3,"test test test record seven."],[6,4,"test test test test record six."]]]] \ No newline at end of file Modified: doc/ja/source/example/tutorial01-2.log (+1 -1) =================================================================== --- doc/ja/source/example/tutorial01-2.log 2011-01-05 14:40:36 +0000 (5e695fa) +++ doc/ja/source/example/tutorial01-2.log 2011-01-06 05:43:58 +0000 (d0579c1) @@ -1,5 +1,5 @@ 実行例 :: > table_create --name Site --flags TABLE_HASH_KEY --key_type ShortText - [[0,1280378897.32146,0.105979],true] + [[0,1294292494.39228,0.080407899],true] \ No newline at end of file Modified: doc/ja/source/example/tutorial01-3.log (+1 -1) =================================================================== --- doc/ja/source/example/tutorial01-3.log 2011-01-05 14:40:36 +0000 (77c2f8d) +++ doc/ja/source/example/tutorial01-3.log 2011-01-06 05:43:58 +0000 (9372fc1) @@ -1,5 +1,5 @@ 実行例 :: > select --table Site - [[0,1280378897.62847,0.000124],[[[0],[["_id","UInt32"],["_key","ShortText"]]]]] + [[0,1294292494.67374,0.000159976],[[[0],[["_id","UInt32"],["_key","ShortText"]]]]] \ No newline at end of file Modified: doc/ja/source/example/tutorial01-4.log (+2 -2) =================================================================== --- doc/ja/source/example/tutorial01-4.log 2011-01-05 14:40:36 +0000 (10a1fec) +++ doc/ja/source/example/tutorial01-4.log 2011-01-06 05:43:58 +0000 (eca3719) @@ -1,7 +1,7 @@ 実行例 :: > column_create --table Site --name title --flags COLUMN_SCALAR --type ShortText - [[0,1280378897.82996,0.098188],true] + [[0,1294292494.87523,0.073160479],true] > select --table Site - [[0,1280378898.12897,0.000124],[[[0],[["_id","UInt32"],["_key","ShortText"],["title","ShortText"]]]]] + [[0,1294292495.14923,0.000136609],[[[0],[["_id","UInt32"],["_key","ShortText"],["title","ShortText"]]]]] \ No newline at end of file Modified: doc/ja/source/example/tutorial01-5.log (+1 -1) =================================================================== --- doc/ja/source/example/tutorial01-5.log 2011-01-05 14:40:36 +0000 (77ac0c6) +++ doc/ja/source/example/tutorial01-5.log 2011-01-06 05:43:58 +0000 (7cb88bd) @@ -1,5 +1,5 @@ 実行例 :: > table_create --name Terms --flags TABLE_PAT_KEY|KEY_NORMALIZE --key_type ShortText --default_tokenizer TokenBigram - [[0,1280378898.33069,0.089422],true] + [[0,1294292495.351,0.064287537],true] \ No newline at end of file Modified: doc/ja/source/example/tutorial01-6.log (+1 -1) =================================================================== --- doc/ja/source/example/tutorial01-6.log 2011-01-05 14:40:36 +0000 (249721d) +++ doc/ja/source/example/tutorial01-6.log 2011-01-06 05:43:58 +0000 (9fc15ef) @@ -1,5 +1,5 @@ 実行例 :: > column_create --table Terms --name blog_title --flags COLUMN_INDEX|WITH_POSITION --type Site --source title - [[0,1280378898.93701,0.16927],true] + [[0,1294292495.6163,0.118577336],true] \ No newline at end of file Modified: doc/ja/source/example/tutorial01-7.log (+1 -1) =================================================================== --- doc/ja/source/example/tutorial01-7.log 2011-01-05 14:40:36 +0000 (229d777) +++ doc/ja/source/example/tutorial01-7.log 2011-01-06 05:43:58 +0000 (1a3b4c8) @@ -12,5 +12,5 @@ > {"_key":"http://example.org/gat","title":"test test record eight."}, > {"_key":"http://example.com/vdw","title":"test test record nine."}, > ] - [[0,1280378899.30731,2.202854],9] + [[0,1294292495.93593,2.202904311],9] \ No newline at end of file Modified: doc/ja/source/example/tutorial01-8.log (+1 -1) =================================================================== --- doc/ja/source/example/tutorial01-8.log 2011-01-05 14:40:36 +0000 (40f8665) +++ doc/ja/source/example/tutorial01-8.log 2011-01-06 05:43:58 +0000 (0dac6fa) @@ -1,5 +1,5 @@ 実行例 :: > select --table Site - [[0,1280378901.71103,0.00014],[[[9],[["_id","UInt32"],["_key","ShortText"],["title","ShortText"]],[1,"http://example.org/","This is test record 1!"],[2,"http://example.net/","test record 2."],[3,"http://example.com/","test test record three."],[4,"http://example.net/afr","test record four."],[5,"http://example.org/aba","test test test record five."],[6,"http://example.com/rab","test test test test record six."],[7,"http://example.net/atv","test test test record seven."],[8,"http://example.org/gat","test test record eight."],[9,"http://example.com/vdw","test test record nine."]]]] + [[0,1294292498.33981,0.000163623],[[[9],[["_id","UInt32"],["_key","ShortText"],["title","ShortText"]],[1,"http://example.org/","This is test record 1!"],[2,"http://example.net/","test record 2."],[3,"http://example.com/","test test record three."],[4,"http://example.net/afr","test record four."],[5,"http://example.org/aba","test test test record five."],[6,"http://example.com/rab","test test test test record six."],[7,"http://example.net/atv","test test test record seven."],[8,"http://example.org/gat","test test record eight."],[9,"http://example.com/vdw","test test record nine."]]]] \ No newline at end of file Modified: doc/ja/source/example/tutorial01-9.log (+1 -1) =================================================================== --- doc/ja/source/example/tutorial01-9.log 2011-01-05 14:40:36 +0000 (63258c8) +++ doc/ja/source/example/tutorial01-9.log 2011-01-06 05:43:58 +0000 (a2fb429) @@ -1,5 +1,5 @@ 実行例 :: > select --table Site --query _id:1 - [[0,1280378901.91744,0.000364],[[[1],[["_id","UInt32"],["_key","ShortText"],["title","ShortText"]],[1,"http://example.org/","This is test record 1!"]]]] + [[0,1294292498.54636,0.000363938],[[[1],[["_id","UInt32"],["_key","ShortText"],["title","ShortText"]],[1,"http://example.org/","This is test record 1!"]]]] \ No newline at end of file Modified: doc/ja/source/example/tutorial02-1.log (+1 -1) =================================================================== --- doc/ja/source/example/tutorial02-1.log 2011-01-05 14:40:36 +0000 (89d4dc0) +++ doc/ja/source/example/tutorial02-1.log 2011-01-06 05:43:58 +0000 (4b4e722) @@ -2,7 +2,7 @@ % groonga -c > status - [[0,1280378896.10941,1.8e-05],{"alloc_count":463,"starttime":1280378807,"uptime":89,"version":"0.7.2-5-g2a77275"}] + [[0,1294292493.17513,3.4655e-05],{"alloc_count":466,"starttime":1294292404,"uptime":89,"version":"1.0.6-10-gba9df76","n_queries":105,"cache_hit_rate":0.0,"command_version":1,"default_command_version":1,"max_command_version":2}] > ctrl-d % \ No newline at end of file Modified: doc/ja/source/example/tutorial02-3.log (+2 -2) =================================================================== --- doc/ja/source/example/tutorial02-3.log 2011-01-05 14:40:36 +0000 (1bcffca) +++ doc/ja/source/example/tutorial02-3.log 2011-01-06 05:43:58 +0000 (ab42c45) @@ -3,10 +3,10 @@ http://[IPまたはホスト名]:[ポート番号]/d/status 実行される処理: > status - [[0,1280378896.31131,1.4e-05],{"alloc_count":463,"starttime":1280378807,"uptime":89,"version":"0.7.2-5-g2a77275"}] + [[0,1294292493.37913,2.8547e-05],{"alloc_count":466,"starttime":1294292404,"uptime":89,"version":"1.0.6-10-gba9df76","n_queries":105,"cache_hit_rate":0.0,"command_version":1,"default_command_version":1,"max_command_version":2}] http://[IPまたはホスト名]:[ポート番号]/d/select?table=Site&query=title:@this 実行される処理: > select --table Site --query title:@this - [[0,1280378896.51281,6.0e-05],[[[1],[["_id","UInt32"],["_key","ShortText"],["title","ShortText"]],[1,"http://example.org/","This is test record 1!"]]]] + [[0,1294292493.58185,6.4853e-05],[[[1],[["_id","UInt32"],["_key","ShortText"],["title","ShortText"]],[1,"http://example.org/","This is test record 1!"]]]] \ No newline at end of file Modified: doc/ja/source/example/tutorial03-1.log (+3 -7) =================================================================== --- doc/ja/source/example/tutorial03-1.log 2011-01-05 14:40:36 +0000 (d24a5a2) +++ doc/ja/source/example/tutorial03-1.log 2011-01-06 05:43:58 +0000 (f262782) @@ -1,18 +1,14 @@ 実行例 :: > table_create --name Type --flags TABLE_HASH_KEY --key_type ShortText - [[0,1280378823.87922,0.063618],true] + [[0,1294292421.12314,0.058638912],true] > column_create --table Type --name number --type Int32 - [[0,1280378824.14361,0.066276],true] + [[0,1294292421.38263,0.049456503],true] > column_create --table Type --name float --type Float - [[0,1280378824.41063,0.0673],true] + [[0,1294292421.63286,0.049592924],true] > column_create --table Type --name string --type ShortText - [[0,1280378824.67863,0.067213],true] > column_create --table Type --name time --type Time - [[0,1280378824.94662,0.05711],true] > load --table Type > [{"_key":"sample","number":12345,"float":42.195,"string":"GROONGA","time":1234567890.12}] - [[0,1280378825.20443,0.201835],1] > select --table Type - [[0,1280378825.60691,0.000155],[[[1],[["_id","UInt32"],["_key","ShortText"],["time","Time"],["string","ShortText"],["number","Int32"],["float","Float"]],[1,"sample",1234567890.0,"GROONGA",12345,42.195]]]] \ No newline at end of file Modified: doc/ja/source/example/tutorial03-2.log (+7 -3) =================================================================== --- doc/ja/source/example/tutorial03-2.log 2011-01-05 14:40:36 +0000 (a462fe7) +++ doc/ja/source/example/tutorial03-2.log 2011-01-06 05:43:58 +0000 (a75f8d2) @@ -1,10 +1,14 @@ 実行例 :: > column_create --table Site --name link --type Site - [[0,1280378825.80958,0.094424],true] + [[0,1294292421.88324,1.758091494],true] + [[0,1294292423.64139,0.096956537],true] + [[0,1294292423.73839,0.001444368],1] + [[0,1294292423.73987,0.000161184],[[[1],[["_id","UInt32"],["_key","ShortText"],["time","Time"],["string","ShortText"],["number","Int32"],["float","Float"]],[1,"sample",1234567890.0,"GROONGA",12345,42.195]]]] + [[0,1294292423.74005,0.057032974],true] > load --table Site > [{"_key":"http://example.org/","link":"http://example.net/"}] - [[0,1280378826.10477,0.200507],1] + [[0,1294292423.99784,0.200585743],1] > select --table Site --output_columns _key,title,link._key,link.title --query title:@this - [[0,1280378826.50595,0.000522],[[[1],[["_key","ShortText"],["title","ShortText"],["link._key","ShortText"],["link.title","ShortText"]],["http://example.org/","This is test record 1!","http://example.net/","test record 2."]]]] + [[0,1294292424.39909,0.000545272],[[[1],[["_key","ShortText"],["title","ShortText"],["link._key","ShortText"],["link.title","ShortText"]],["http://example.org/","This is test record 1!","http://example.net/","test record 2."]]]] \ No newline at end of file Modified: doc/ja/source/example/tutorial03-3.log (+3 -3) =================================================================== --- doc/ja/source/example/tutorial03-3.log 2011-01-05 14:40:36 +0000 (f0ef503) +++ doc/ja/source/example/tutorial03-3.log 2011-01-06 05:43:58 +0000 (c6ba2a9) @@ -1,10 +1,10 @@ 実行例 :: > column_create --table Site --name links --flags COLUMN_VECTOR --type Site - [[0,1280378826.70921,0.087662],true] + [[0,1294292424.60248,0.062420461],true] > load --table Site > [{"_key":"http://example.org/","links":["http://example.net/","http://example.org/","http://example.com/"]}] - [[0,1280378826.99769,0.200643],1] + [[0,1294292424.86574,0.200708196],1] > select --table Site --output_columns _key,title,links._key,links.title --query title:@this - [[0,1280378827.39899,0.000499],[[[1],[["_key","ShortText"],["title","ShortText"],["links._key","ShortText"],["links.title","ShortText"]],["http://example.org/","This is test record 1!",["http://example.net/","http://example.org/","http://example.com/"],["test record 2.","This is test record 1!","test test record three."]]]]] + [[0,1294292425.26717,0.000522302],[[[1],[["_key","ShortText"],["title","ShortText"],["links._key","ShortText"],["links.title","ShortText"]],["http://example.org/","This is test record 1!",["http://example.net/","http://example.org/","http://example.com/"],["test record 2.","This is test record 1!","test test record three."]]]]] \ No newline at end of file Modified: doc/ja/source/example/tutorial04-1.log (+1 -1) =================================================================== --- doc/ja/source/example/tutorial04-1.log 2011-01-05 14:40:36 +0000 (db785d7) +++ doc/ja/source/example/tutorial04-1.log 2011-01-06 05:43:58 +0000 (a400760) @@ -1,5 +1,5 @@ 実行例 :: > select --table Site --filter "_id <= 1" --output_columns _id,_key - [[0,1280378885.95759,0.000306],[[[1],[["_id","UInt32"],["_key","ShortText"]],[1,"http://example.org/"]]]] + [[0,1294292483.15552,0.000315671],[[[1],[["_id","UInt32"],["_key","ShortText"]],[1,"http://example.org/"]]]] \ No newline at end of file Modified: doc/ja/source/example/tutorial04-2.log (+2 -2) =================================================================== --- doc/ja/source/example/tutorial04-2.log 2011-01-05 14:40:36 +0000 (4411286) +++ doc/ja/source/example/tutorial04-2.log 2011-01-06 05:43:58 +0000 (831bf0c) @@ -1,7 +1,7 @@ 実行例 :: > select --table Site --filter "_id >= 4 && _id <= 6" --output_columns _id,_key - [[0,1280378886.15944,0.000311],[[[3],[["_id","UInt32"],["_key","ShortText"]],[4,"http://example.net/afr"],[5,"http://example.org/aba"],[6,"http://example.com/rab"]]]] + [[0,1294292483.35765,0.000332343],[[[3],[["_id","UInt32"],["_key","ShortText"]],[4,"http://example.net/afr"],[5,"http://example.org/aba"],[6,"http://example.com/rab"]]]] > select --table Site --filter "_id <= 2 || _id >= 7" --output_columns _id,_key - [[0,1280378886.36174,0.000321],[[[5],[["_id","UInt32"],["_key","ShortText"]],[1,"http://example.org/"],[2,"http://example.net/"],[7,"http://example.net/atv"],[8,"http://example.org/gat"],[9,"http://example.com/vdw"]]]] + [[0,1294292483.55992,0.000325242],[[[5],[["_id","UInt32"],["_key","ShortText"]],[1,"http://example.org/"],[2,"http://example.net/"],[7,"http://example.net/atv"],[8,"http://example.org/gat"],[9,"http://example.com/vdw"]]]] \ No newline at end of file Modified: doc/ja/source/example/tutorial04-3.log (+2 -2) =================================================================== --- doc/ja/source/example/tutorial04-3.log 2011-01-05 14:40:36 +0000 (b3d7285) +++ doc/ja/source/example/tutorial04-3.log 2011-01-06 05:43:58 +0000 (4a17e20) @@ -1,7 +1,7 @@ 実行例 :: > select --table Site --filter "1" --scorer "_score = rand()" --output_columns _id,_key,_score --sortby _score - [[0,1280378886.56471,0.000504],[[[9],[["_id","UInt32"],["_key","ShortText"],["_score","Int32"]],[3,"http://example.com/",35005211],[9,"http://example.com/vdw",278722862],[5,"http://example.org/aba",294702567],[1,"http://example.org/",304089172],[7,"http://example.net/atv",336465782],[4,"http://example.net/afr",521595368],[8,"http://example.org/gat",861021530],[2,"http://example.net/",1303455736],[6,"http://example.com/rab",1726956429]]]] + [[0,1294292483.76306,0.00050586],[[[9],[["_id","UInt32"],["_key","ShortText"],["_score","Int32"]],[3,"http://example.com/",35005211],[9,"http://example.com/vdw",278722862],[5,"http://example.org/aba",294702567],[1,"http://example.org/",304089172],[7,"http://example.net/atv",336465782],[4,"http://example.net/afr",521595368],[8,"http://example.org/gat",861021530],[2,"http://example.net/",1303455736],[6,"http://example.com/rab",1726956429]]]] > select --table Site --filter "1" --scorer "_score = rand()" --output_columns _id,_key,_score --sortby _score - [[0,1280378886.76988,0.00049],[[[9],[["_id","UInt32"],["_key","ShortText"],["_score","Int32"]],[1,"http://example.org/",233665123],[3,"http://example.com/",468703135],[7,"http://example.net/atv",635723058],[4,"http://example.net/afr",1101513929],[9,"http://example.com/vdw",1125898167],[6,"http://example.com/rab",1315634022],[8,"http://example.org/gat",1369133069],[5,"http://example.org/aba",1801979802],[2,"http://example.net/",2145174067]]]] + [[0,1294292483.96835,0.000502458],[[[9],[["_id","UInt32"],["_key","ShortText"],["_score","Int32"]],[1,"http://example.org/",233665123],[3,"http://example.com/",468703135],[7,"http://example.net/atv",635723058],[4,"http://example.net/afr",1101513929],[9,"http://example.com/vdw",1125898167],[6,"http://example.com/rab",1315634022],[8,"http://example.org/gat",1369133069],[5,"http://example.org/aba",1801979802],[2,"http://example.net/",2145174067]]]] \ No newline at end of file Modified: doc/ja/source/example/tutorial04-4.log (+3 -3) =================================================================== --- doc/ja/source/example/tutorial04-4.log 2011-01-05 14:40:36 +0000 (664a915) +++ doc/ja/source/example/tutorial04-4.log 2011-01-06 05:43:58 +0000 (7d9b092) @@ -1,13 +1,13 @@ 実行例 :: > column_create --table Site --name location --type WGS84GeoPoint - [[0,1280378886.97522,0.109348],true] + [[0,1294292484.17389,0.064924593],true] > load --table Site > [ > {"_key":"http://example.org/","location":"128452975x503157902"} > {"_key":"http://example.net/","location":"128487316x502920929"}, > ] - [[0,1280378887.28534,0.801067],2] + [[0,1294292484.43963,0.801132263],2] > select --table Site --query "_id:1 OR _id:2" --output_columns _key,location - [[0,1280378888.28703,0.000371],[[[2],[["_key","ShortText"],["location","WGS84GeoPoint"]],["http://example.org/","128452975x503157902"],["http://example.net/","128487316x502920929"]]]] + [[0,1294292485.44153,0.000398502],[[[2],[["_key","ShortText"],["location","WGS84GeoPoint"]],["http://example.org/","128452975x503157902"],["http://example.net/","128487316x502920929"]]]] \ No newline at end of file Modified: doc/ja/source/example/tutorial04-5.log (+1 -1) =================================================================== --- doc/ja/source/example/tutorial04-5.log 2011-01-05 14:40:36 +0000 (0a7004e) +++ doc/ja/source/example/tutorial04-5.log 2011-01-06 05:43:58 +0000 (fc95ec1) @@ -1,5 +1,5 @@ 実行例 :: > select --table Site --query "_id:1 OR _id:2" --output_columns _key,location,_score --scorer '_score = geo_distance(location, "128515259x503187188")' - [[0,1280378888.48983,0.000429],[[[2],[["_key","ShortText"],["location","WGS84GeoPoint"],["_score","Int32"]],["http://example.org/","128452975x503157902",2054],["http://example.net/","128487316x502920929",6720]]]] + [[0,1294292485.64428,0.00042649],[[[2],[["_key","ShortText"],["location","WGS84GeoPoint"],["_score","Int32"]],["http://example.org/","128452975x503157902",2054],["http://example.net/","128487316x502920929",6720]]]] \ No newline at end of file Modified: doc/ja/source/example/tutorial04-6.log (+1 -1) =================================================================== --- doc/ja/source/example/tutorial04-6.log 2011-01-05 14:40:36 +0000 (ad904b7) +++ doc/ja/source/example/tutorial04-6.log 2011-01-06 05:43:58 +0000 (afbcd5b) @@ -1,5 +1,5 @@ 実行例 :: > select --table Site --query "_id:1 OR _id:2" --output_columns _key,location,_score --scorer '_score = geo_distance(location, "128515259x503187188")' --sortby -_score - [[0,1280378888.69281,0.000524],[[[2],[["_key","ShortText"],["location","WGS84GeoPoint"],["_score","Int32"]],["http://example.net/","128487316x502920929",6720],["http://example.org/","128452975x503157902",2054]]]] + [[0,1294292485.84748,0.000516522],[[[2],[["_key","ShortText"],["location","WGS84GeoPoint"],["_score","Int32"]],["http://example.net/","128487316x502920929",6720],["http://example.org/","128452975x503157902",2054]]]] \ No newline at end of file Modified: doc/ja/source/example/tutorial04-7.log (+1 -1) =================================================================== --- doc/ja/source/example/tutorial04-7.log 2011-01-05 14:40:36 +0000 (a3acde5) +++ doc/ja/source/example/tutorial04-7.log 2011-01-06 05:43:58 +0000 (9a9e7c4) @@ -1,5 +1,5 @@ 実行例 :: > select --table Site --output_columns _key,location --filter 'geo_in_circle(location, "128515259x503187188", 5000)' - [[0,1280378888.89597,0.000335],[[[1],[["_key","ShortText"],["location","WGS84GeoPoint"]],["http://example.org/","128452975x503157902"]]]] + [[0,1294292486.0507,0.000333268],[[[1],[["_key","ShortText"],["location","WGS84GeoPoint"]],["http://example.org/","128452975x503157902"]]]] \ No newline at end of file Modified: doc/ja/source/example/tutorial05-1.log (+5 -5) =================================================================== --- doc/ja/source/example/tutorial05-1.log 2011-01-05 14:40:36 +0000 (abdde49) +++ doc/ja/source/example/tutorial05-1.log 2011-01-06 05:43:58 +0000 (ed7197d) @@ -1,13 +1,13 @@ 実行例 :: > table_create --name SiteDomain --flags TABLE_HASH_KEY --key_type ShortText - [[0,1280378842.01708,0.06822],true] + [[0,1294292439.68952,0.086450272],true] > table_create --name SiteCountry --flags TABLE_HASH_KEY --key_type ShortText - [[0,1280378842.28607,0.066339],true] + [[0,1294292439.97679,0.049583906],true] > column_create --table Site --name domain --flags COLUMN_SCALAR --type SiteDomain - [[0,1280378842.55314,0.066281],true] + [[0,1294292440.22716,0.04950764],true] > column_create --table Site --name country --flags COLUMN_SCALAR --type SiteCountry - [[0,1280378842.82013,0.057988],true] + [[0,1294292440.47743,0.049554444],true] > load --table Site > [ > {"_key":"http://example.org/","domain":".org","country":"japan"}, @@ -20,5 +20,5 @@ > {"_key":"http://example.org/gat","domain":".org","country":"usa"}, > {"_key":"http://example.com/vdw","domain":".com","country":"japan"} > ] - [[0,1280378843.07883,2.202888],9] + [[0,1294292440.72776,2.203006717],9] \ No newline at end of file Modified: doc/ja/source/example/tutorial05-2.log (+1 -1) =================================================================== --- doc/ja/source/example/tutorial05-2.log 2011-01-05 14:40:36 +0000 (0d5ce12) +++ doc/ja/source/example/tutorial05-2.log 2011-01-06 05:43:58 +0000 (fa84107) @@ -1,5 +1,5 @@ 実行例 :: > select --table Site --limit 0 --drilldown domain - [[0,1280378845.48263,0.00043],[[[9],[["_id","UInt32"],["_key","ShortText"],["title","ShortText"],["location","WGS84GeoPoint"],["links","Site"],["link","Site"],["domain","SiteDomain"],["country","SiteCountry"]]],[[3],[["_key","ShortText"],["_nsubrecs","Int32"]],[".org",3],[".net",3],[".com",3]]]] + [[0,1294292443.13172,0.000424923],[[[9],[["_id","UInt32"],["_key","ShortText"],["title","ShortText"],["location","WGS84GeoPoint"],["links","Site"],["link","Site"],["domain","SiteDomain"],["country","SiteCountry"]]],[[3],[["_key","ShortText"],["_nsubrecs","Int32"]],[".org",3],[".net",3],[".com",3]]]] \ No newline at end of file Modified: doc/ja/source/example/tutorial05-3.log (+1 -1) =================================================================== --- doc/ja/source/example/tutorial05-3.log 2011-01-05 14:40:36 +0000 (2acfc52) +++ doc/ja/source/example/tutorial05-3.log 2011-01-06 05:43:58 +0000 (293dfce) @@ -1,5 +1,5 @@ 実行例 :: > select --table Site --limit 0 --drilldown domain --drilldown_output_columns _id,_key,_nsubrecs - [[0,1280378845.68647,0.000267],[[[9],[["_id","UInt32"],["_key","ShortText"],["title","ShortText"],["location","WGS84GeoPoint"],["links","Site"],["link","Site"],["domain","SiteDomain"],["country","SiteCountry"]]],[[3],[["_id","UInt32"],["_key","ShortText"],["_nsubrecs","Int32"]],[1,".org",3],[2,".net",3],[3,".com",3]]]] + [[0,1294292443.33582,0.00027157],[[[9],[["_id","UInt32"],["_key","ShortText"],["title","ShortText"],["location","WGS84GeoPoint"],["links","Site"],["link","Site"],["domain","SiteDomain"],["country","SiteCountry"]]],[[3],[["_id","UInt32"],["_key","ShortText"],["_nsubrecs","Int32"]],[1,".org",3],[2,".net",3],[3,".com",3]]]] \ No newline at end of file Modified: doc/ja/source/example/tutorial05-4.log (+1 -1) =================================================================== --- doc/ja/source/example/tutorial05-4.log 2011-01-05 14:40:36 +0000 (43bb56f) +++ doc/ja/source/example/tutorial05-4.log 2011-01-06 05:43:58 +0000 (edc26d5) @@ -1,5 +1,5 @@ 実行例 :: > select --table Site --limit 0 --drilldown domain,country - [[0,1280378845.8903,0.000368],[[[9],[["_id","UInt32"],["_key","ShortText"],["title","ShortText"],["location","WGS84GeoPoint"],["links","Site"],["link","Site"],["domain","SiteDomain"],["country","SiteCountry"]]],[[3],[["_key","ShortText"],["_nsubrecs","Int32"]],[".org",3],[".net",3],[".com",3]],[[5],[["_key","ShortText"],["_nsubrecs","Int32"]],["japan",3],["brazil",1],["usa",2],["korea",1],["china",2]]]] + [[0,1294292443.53984,0.000373005],[[[9],[["_id","UInt32"],["_key","ShortText"],["title","ShortText"],["location","WGS84GeoPoint"],["links","Site"],["link","Site"],["domain","SiteDomain"],["country","SiteCountry"]]],[[3],[["_key","ShortText"],["_nsubrecs","Int32"]],[".org",3],[".net",3],[".com",3]],[[5],[["_key","ShortText"],["_nsubrecs","Int32"]],["japan",3],["brazil",1],["usa",2],["korea",1],["china",2]]]] \ No newline at end of file Modified: doc/ja/source/example/tutorial05-5.log (+1 -1) =================================================================== --- doc/ja/source/example/tutorial05-5.log 2011-01-05 14:40:36 +0000 (4a3f61a) +++ doc/ja/source/example/tutorial05-5.log 2011-01-06 05:43:58 +0000 (99e035f) @@ -1,5 +1,5 @@ 実行例 :: > select --table Site --limit 0 --drilldown country --drilldown_sortby _nsubrecs - [[0,1280378846.09517,0.000359],[[[9],[["_id","UInt32"],["_key","ShortText"],["title","ShortText"],["location","WGS84GeoPoint"],["links","Site"],["link","Site"],["domain","SiteDomain"],["country","SiteCountry"]]],[[5],[["_key","ShortText"],["_nsubrecs","Int32"]],["brazil",1],["korea",1],["usa",2],["china",2],["japan",3]]]] + [[0,1294292443.74477,0.000352156],[[[9],[["_id","UInt32"],["_key","ShortText"],["title","ShortText"],["location","WGS84GeoPoint"],["links","Site"],["link","Site"],["domain","SiteDomain"],["country","SiteCountry"]]],[[5],[["_key","ShortText"],["_nsubrecs","Int32"]],["brazil",1],["korea",1],["usa",2],["china",2],["japan",3]]]] \ No newline at end of file Modified: doc/ja/source/example/tutorial05-6.log (+1 -1) =================================================================== --- doc/ja/source/example/tutorial05-6.log 2011-01-05 14:40:36 +0000 (a229a04) +++ doc/ja/source/example/tutorial05-6.log 2011-01-06 05:43:58 +0000 (77c9363) @@ -1,5 +1,5 @@ 実行例 :: > select --table Site --limit 0 --drilldown country --drilldown_sortby _nsubrecs --drilldown_limit 2 --drilldown_offset 2 - [[0,1280378846.2992,0.000326],[[[9],[["_id","UInt32"],["_key","ShortText"],["title","ShortText"],["location","WGS84GeoPoint"],["links","Site"],["link","Site"],["domain","SiteDomain"],["country","SiteCountry"]]],[[5],[["_key","ShortText"],["_nsubrecs","Int32"]],["usa",2],["china",2]]]] + [[0,1294292443.94881,0.000324308],[[[9],[["_id","UInt32"],["_key","ShortText"],["title","ShortText"],["location","WGS84GeoPoint"],["links","Site"],["link","Site"],["domain","SiteDomain"],["country","SiteCountry"]]],[[5],[["_key","ShortText"],["_nsubrecs","Int32"]],["usa",2],["china",2]]]] \ No newline at end of file Modified: doc/ja/source/example/tutorial06-1.log (+6 -6) =================================================================== --- doc/ja/source/example/tutorial06-1.log 2011-01-05 14:40:36 +0000 (a1ccb69) +++ doc/ja/source/example/tutorial06-1.log 2011-01-06 05:43:58 +0000 (60d478e) @@ -1,15 +1,15 @@ 実行例 :: > table_create --name Video --flags TABLE_HASH_KEY --key_type UInt32 - [[0,1280378923.03769,0.060105],true] + [[0,1294292519.76797,0.049499306],true] > table_create --name Tag --flags TABLE_HASH_KEY --key_type ShortText - [[0,1280378923.29856,0.057985],true] + [[0,1294292520.01828,0.057850258],true] > column_create --table Video --name title --flags COLUMN_SCALAR --type ShortText - [[0,1280378923.55728,0.067165],true] + [[0,1294292520.27693,0.050379447],true] > column_create --table Video --name tags --flags COLUMN_VECTOR --type Tag - [[0,1280378923.82522,0.066382],true] + [[0,1294292520.52812,0.049635833],true] > column_create --table Tag --name index_tags --flags COLUMN_INDEX --type Video --source tags - [[0,1280378924.0924,0.122744],true] + [[0,1294292520.77859,0.105692363],true] > load --table Video > [ > {"_key":1,"title":"Soccer 2010","tags":["Sports","Soccer"]}, @@ -21,5 +21,5 @@ > {"_key":7,"title":"Draw 8 Month","tags":["Animation","Raccoon"]}, > {"_key":8,"title":"K.O.","tags":["Animation","Music"]} > ] - [[0,1280378924.41589,2.002628],8] + [[0,1294292521.0851,2.002679112],8] \ No newline at end of file Modified: doc/ja/source/example/tutorial06-2.log (+3 -3) =================================================================== --- doc/ja/source/example/tutorial06-2.log 2011-01-05 14:40:36 +0000 (5ce5d02) +++ doc/ja/source/example/tutorial06-2.log 2011-01-06 05:43:58 +0000 (3864e93) @@ -1,9 +1,9 @@ 実行例 :: > select --table Video --query tags:@Variety --output_columns _key,title - [[0,1280378926.6193,0.000444],[[[2],[["_key","UInt32"],["title","ShortText"]],[2,"Zenigata Kinjirou"],[5,"Hex Gone!"]]]] + [[0,1294292523.28874,0.000475294],[[[2],[["_key","UInt32"],["title","ShortText"]],[2,"Zenigata Kinjirou"],[5,"Hex Gone!"]]]] > select --table Video --query tags:@Sports --output_columns _key,title - [[0,1280378926.82132,0.000302],[[[2],[["_key","UInt32"],["title","ShortText"]],[1,"Soccer 2010"],[4,"Moero!! Ultra Baseball"]]]] + [[0,1294292523.49078,0.000311404],[[[2],[["_key","UInt32"],["title","ShortText"]],[1,"Soccer 2010"],[4,"Moero!! Ultra Baseball"]]]] > select --table Video --query tags:@Animation --output_columns _key,title - [[0,1280378927.02314,0.000295],[[[3],[["_key","UInt32"],["title","ShortText"]],[6,"Pikonyan 1"],[7,"Draw 8 Month"],[8,"K.O."]]]] + [[0,1294292523.69268,0.000299391],[[[3],[["_key","UInt32"],["title","ShortText"]],[6,"Pikonyan 1"],[7,"Draw 8 Month"],[8,"K.O."]]]] \ No newline at end of file Modified: doc/ja/source/example/tutorial06-3.log (+5 -5) =================================================================== --- doc/ja/source/example/tutorial06-3.log 2011-01-05 14:40:36 +0000 (acc2736) +++ doc/ja/source/example/tutorial06-3.log 2011-01-06 05:43:58 +0000 (c8c6073) @@ -1,13 +1,13 @@ 実行例 :: > table_create --name User --flags TABLE_HASH_KEY --key_type ShortText - [[0,1280378927.22516,0.091699],true] + [[0,1294292523.89479,0.074787397],true] > column_create --table User --name username --flags COLUMN_SCALAR --type ShortText - [[0,1280378927.51764,0.067062],true] + [[0,1294292524.1704,0.050363618],true] > column_create --table User --name friends --flags COLUMN_VECTOR --type User - [[0,1280378927.78548,0.05804],true] + [[0,1294292524.42158,0.049597919],true] > column_create --table User --name index_friends --flags COLUMN_INDEX --type User --source friends - [[0,1280378928.04428,0.113384],true] + [[0,1294292524.67201,0.104947934],true] > load --table User > [ > {"_key":"ken","username":"健作","friends":["taro","jiro","tomo","moritapo"]} @@ -17,5 +17,5 @@ > {"_key":"tomo","username":"トモちゃん","friends":["ken","hana"]} > {"_key":"hana","username":"花子","friends":["ken","taro","jiro","moritapo","tomo"]} > ] - [[0,1280378928.35845,1.602101],6] + [[0,1294292524.97774,1.60223701],6] \ No newline at end of file Modified: doc/ja/source/example/tutorial06-4.log (+2 -2) =================================================================== --- doc/ja/source/example/tutorial06-4.log 2011-01-05 14:40:36 +0000 (a51556b) +++ doc/ja/source/example/tutorial06-4.log 2011-01-06 05:43:58 +0000 (8e7016a) @@ -1,7 +1,7 @@ 実行例 :: > select --table User --query friends:@tomo --output_columns _key,username - [[0,1280378930.16145,0.000464],[[[5],[["_key","ShortText"],["username","ShortText"]],["ken","健作"],["taro","ぐるんが太郎"],["jiro","ぐるんが次郎"],["moritapo","森田"],["hana","花子"]]]] + [[0,1294292526.78097,0.000456954],[[[5],[["_key","ShortText"],["username","ShortText"]],["ken","健作"],["taro","ぐるんが太郎"],["jiro","ぐるんが次郎"],["moritapo","森田"],["hana","花子"]]]] > select --table User --query friends:@jiro --output_columns _key,username - [[0,1280378930.36419,0.000293],[[[3],[["_key","ShortText"],["username","ShortText"]],["ken","健作"],["taro","ぐるんが太郎"],["hana","花子"]]]] + [[0,1294292526.9838,0.000304224],[[[3],[["_key","ShortText"],["username","ShortText"]],["ken","健作"],["taro","ぐるんが太郎"],["hana","花子"]]]] \ No newline at end of file Modified: doc/ja/source/example/tutorial06-5.log (+1 -1) =================================================================== --- doc/ja/source/example/tutorial06-5.log 2011-01-05 14:40:36 +0000 (b6cd1fb) +++ doc/ja/source/example/tutorial06-5.log 2011-01-06 05:43:58 +0000 (6a5086c) @@ -1,5 +1,5 @@ 実行例 :: > select --table User --limit 0 --drilldown friends - [[0,1280378930.56663,0.000267],[[[6],[["_id","UInt32"],["_key","ShortText"],["username","ShortText"],["index_friends","User"],["friends","User"]]],[[6],[["_key","ShortText"],["_nsubrecs","Int32"]],["taro",3],["jiro",3],["tomo",5],["moritapo",2],["ken",3],["hana",1]]]] + [[0,1294292527.18622,0.000269477],[[[6],[["_id","UInt32"],["_key","ShortText"],["username","ShortText"],["index_friends","User"],["friends","User"]]],[[6],[["_key","ShortText"],["_nsubrecs","Int32"]],["taro",3],["jiro",3],["tomo",5],["moritapo",2],["ken",3],["hana",1]]]] \ No newline at end of file Modified: doc/ja/source/example/tutorial07-1.log (+7 -7) =================================================================== --- doc/ja/source/example/tutorial07-1.log 2011-01-05 14:40:36 +0000 (f490105) +++ doc/ja/source/example/tutorial07-1.log 2011-01-06 05:43:58 +0000 (da3739b) @@ -1,22 +1,22 @@ 実行例 :: > table_create --name Blog1 --flags TABLE_HASH_KEY --key_type ShortText - [[0,1280378807.97095,0.074659],true] + [[0,1294292405.5139,0.046640501],true] > column_create --table Blog1 --name title --flags COLUMN_SCALAR --type ShortText - [[0,1280378808.24637,0.058739],true] + [[0,1294292405.76135,0.05035077],true] > column_create --table Blog1 --name message --flags COLUMN_SCALAR --type ShortText - [[0,1280378808.50589,0.074658],true] + [[0,1294292406.01251,0.049535938],true] > table_create --name IndexBlog1 --flags TABLE_PAT_KEY|KEY_NORMALIZE --key_type ShortText --default_tokenizer TokenBigram - [[0,1280378808.78136,0.065557],true] + [[0,1294292406.2629,0.040450231],true] > column_create --table IndexBlog1 --name index_title --flags COLUMN_INDEX|WITH_POSITION --type Blog1 --source title - [[0,1280378809.04764,0.147413],true] + [[0,1294292406.50413,0.089260402],true] > column_create --table IndexBlog1 --name index_message --flags COLUMN_INDEX|WITH_POSITION --type Blog1 --source message - [[0,1280378809.39584,0.124963],true] + [[0,1294292406.7942,0.116405104],true] > load --table Blog1 > [ > {"_key":"grn1","title":"groonga test","message":"groonga message"}, > {"_key":"grn2","title":"baseball result","message":"rakutan eggs 4 - 4 groonga moritars"}, > {"_key":"grn3","title":"groonga message","message":"none"} > ] - [[0,1280378809.72157,1.001442],3] + [[0,1294292407.11144,1.001433691],3] \ No newline at end of file Modified: doc/ja/source/example/tutorial07-2.log (+3 -3) =================================================================== --- doc/ja/source/example/tutorial07-2.log 2011-01-05 14:40:36 +0000 (9f261f9) +++ doc/ja/source/example/tutorial07-2.log 2011-01-06 05:43:58 +0000 (207545c) @@ -1,9 +1,9 @@ 実行例 :: > select --table Blog1 --match_columns title||message --query groonga - [[0,1280378810.92387,0.0008],[[[3],[["_id","UInt32"],["_key","ShortText"],["title","ShortText"],["message","ShortText"]],[1,"grn1","groonga test","groonga message"],[3,"grn3","groonga message","none"],[2,"grn2","baseball result","rakutan eggs 4 - 4 groonga moritars"]]]] + [[0,1294292408.31388,0.000823528],[[[3],[["_id","UInt32"],["_key","ShortText"],["title","ShortText"],["message","ShortText"]],[1,"grn1","groonga test","groonga message"],[3,"grn3","groonga message","none"],[2,"grn2","baseball result","rakutan eggs 4 - 4 groonga moritars"]]]] > select --table Blog1 --match_columns title||message --query message - [[0,1280378811.12754,0.000547],[[[2],[["_id","UInt32"],["_key","ShortText"],["title","ShortText"],["message","ShortText"]],[3,"grn3","groonga message","none"],[1,"grn1","groonga test","groonga message"]]]] + [[0,1294292408.5178,0.000566064],[[[2],[["_id","UInt32"],["_key","ShortText"],["title","ShortText"],["message","ShortText"]],[3,"grn3","groonga message","none"],[1,"grn1","groonga test","groonga message"]]]] > select --table Blog1 --match_columns title --query message - [[0,1280378811.33043,0.000482],[[[1],[["_id","UInt32"],["_key","ShortText"],["title","ShortText"],["message","ShortText"]],[3,"grn3","groonga message","none"]]]] + [[0,1294292408.72074,0.0004798],[[[1],[["_id","UInt32"],["_key","ShortText"],["title","ShortText"],["message","ShortText"]],[3,"grn3","groonga message","none"]]]] \ No newline at end of file Modified: doc/ja/source/example/tutorial07-3.log (+6 -6) =================================================================== --- doc/ja/source/example/tutorial07-3.log 2011-01-05 14:40:36 +0000 (e998817) +++ doc/ja/source/example/tutorial07-3.log 2011-01-06 05:43:58 +0000 (87d15dc) @@ -1,20 +1,20 @@ 実行例 :: > table_create --name Blog2 --flags TABLE_HASH_KEY --key_type ShortText - [[0,1280378811.53299,0.099804],true] + [[0,1294292408.92333,0.107518903],true] > column_create --table Blog2 --name title --flags COLUMN_SCALAR --type ShortText - [[0,1280378811.83359,0.058761],true] + [[0,1294292409.23168,0.050369538],true] > column_create --table Blog2 --name message --flags COLUMN_SCALAR --type ShortText - [[0,1280378812.09316,0.05801],true] + [[0,1294292409.48288,0.049530167],true] > table_create --name IndexBlog2 --flags TABLE_PAT_KEY|KEY_NORMALIZE --key_type ShortText --default_tokenizer TokenBigram - [[0,1280378812.35194,0.057196],true] + [[0,1294292409.73325,0.04885075],true] > column_create --table IndexBlog2 --name index_blog --flags COLUMN_INDEX|WITH_POSITION|WITH_SECTION --type Blog2 --source title,message - [[0,1280378812.60988,0.113983],true] + [[0,1294292409.98288,0.105489516],true] > load --table Blog2 > [ > {"_key":"grn1","title":"groonga test","message":"groonga message"}, > {"_key":"grn2","title":"baseball result","message":"rakutan eggs 4 - 4 groonga moritars"}, > {"_key":"grn3","title":"groonga message","message":"none"} > ] - [[0,1280378812.92463,1.001314],3] + [[0,1294292410.28918,1.001414874],3] \ No newline at end of file Modified: doc/ja/source/example/tutorial07-4.log (+3 -3) =================================================================== --- doc/ja/source/example/tutorial07-4.log 2011-01-05 14:40:36 +0000 (16a6680) +++ doc/ja/source/example/tutorial07-4.log 2011-01-06 05:43:58 +0000 (0bef469) @@ -1,9 +1,9 @@ 実行例 :: > select --table Blog2 --match_columns title||message --query groonga - [[0,1280378814.12681,0.000585],[[[3],[["_id","UInt32"],["_key","ShortText"],["title","ShortText"],["message","ShortText"]],[1,"grn1","groonga test","groonga message"],[2,"grn2","baseball result","rakutan eggs 4 - 4 groonga moritars"],[3,"grn3","groonga message","none"]]]] + [[0,1294292411.49151,0.000575701],[[[3],[["_id","UInt32"],["_key","ShortText"],["title","ShortText"],["message","ShortText"]],[1,"grn1","groonga test","groonga message"],[2,"grn2","baseball result","rakutan eggs 4 - 4 groonga moritars"],[3,"grn3","groonga message","none"]]]] > select --table Blog2 --match_columns title||message --query message - [[0,1280378814.33044,0.000508],[[[2],[["_id","UInt32"],["_key","ShortText"],["title","ShortText"],["message","ShortText"]],[1,"grn1","groonga test","groonga message"],[3,"grn3","groonga message","none"]]]] + [[0,1294292411.69532,0.000523916],[[[2],[["_id","UInt32"],["_key","ShortText"],["title","ShortText"],["message","ShortText"]],[1,"grn1","groonga test","groonga message"],[3,"grn3","groonga message","none"]]]] > select --table Blog2 --match_columns title --query message - [[0,1280378814.53323,0.000486],[[[1],[["_id","UInt32"],["_key","ShortText"],["title","ShortText"],["message","ShortText"]],[3,"grn3","groonga message","none"]]]] + [[0,1294292411.89825,0.000508446],[[[1],[["_id","UInt32"],["_key","ShortText"],["title","ShortText"],["message","ShortText"]],[3,"grn3","groonga message","none"]]]] \ No newline at end of file Modified: doc/ja/source/example/tutorial08-1.log (+3 -3) =================================================================== --- doc/ja/source/example/tutorial08-1.log 2011-01-05 14:40:36 +0000 (b037951) +++ doc/ja/source/example/tutorial08-1.log 2011-01-06 05:43:58 +0000 (3b24168) @@ -1,14 +1,14 @@ 実行例 :: > table_create --name PatPre --flags TABLE_PAT_KEY --key_type ShortText - [[0,1280378814.93737,0.10571],true] + [[0,1294292412.30259,0.079878298],true] > load --table PatPre > [ > {"_key":"ひろゆき"}, > {"_key":"まろゆき"}, > {"_key":"ひろあき"} > ] - [[0,1280378815.24384,1.001289],3] + [[0,1294292412.58327,1.001299934],3] > select --table PatPre --query _key:@ひろ - [[0,1280378816.44578,0.022706],[[[2],[["_id","UInt32"],["_key","ShortText"]],[3,"ひろあき"],[1,"ひろゆき"]]]] + [[0,1294292413.78527,0.000581025],[[[2],[["_id","UInt32"],["_key","ShortText"]],[3,"ひろあき"],[1,"ひろゆき"]]]] \ No newline at end of file Modified: doc/ja/source/example/tutorial10-1.log (+1 -1) =================================================================== --- doc/ja/source/example/tutorial10-1.log 2011-01-05 14:40:36 +0000 (0f221f9) +++ doc/ja/source/example/tutorial10-1.log 2011-01-06 05:43:58 +0000 (f91085a) @@ -1,5 +1,5 @@ 実行例 :: > select --table Users --match_columns name,location_str,description --query 東京 --output_columns _key,name - [[0,1280378873.00607,0.00053],[[[2],[["_key","ShortText"],["name","ShortText"]],["tasukuchan","グニャラくん"],["OffGao","OffGao"]]]] + [[0,1294292470.41307,0.000532663],[[[2],[["_key","ShortText"],["name","ShortText"]],["tasukuchan","グニャラくん"],["OffGao","OffGao"]]]] \ No newline at end of file Modified: doc/ja/source/example/tutorial10-10.log (+1 -1) =================================================================== --- doc/ja/source/example/tutorial10-10.log 2011-01-05 14:40:36 +0000 (a9dff31) +++ doc/ja/source/example/tutorial10-10.log 2011-01-06 05:43:58 +0000 (5fd7944) @@ -1,5 +1,5 @@ 実行例 :: > select Comments --filter 'last_modified<=1268802000' --output_columns posted_by.name,comment,last_modified --drilldown hash_tags,posted_by - [[0,1280378874.83883,0.000681],[[[5],[["posted_by.name","ShortText"],["comment","ShortText"],["last_modified","Time"]],["hsiomaneki","マイクロブログ作ってみました(甘栗むいちゃいました的な感じで)。",1268795100.0],["グニャラくん","初の書き込み。テストテスト。",1268794800.0],["hsiomaneki","@tasukuchan ようこそ!!!",1268795100.0],["グニャラくん","@daijiro ありがとう!",1268798400.0],["グニャラくん","groongaなう #groonga",1268802000.0]],[[1],[["_key","ShortText"],["_nsubrecs","Int32"]],["groonga",1]],[[2],[["_key","ShortText"],["_nsubrecs","Int32"]],["daijiro",2],["tasukuchan",3]]]] + [[0,1294292472.24623,0.000634424],[[[5],[["posted_by.name","ShortText"],["comment","ShortText"],["last_modified","Time"]],["hsiomaneki","マイクロブログ作ってみました(甘栗むいちゃいました的な感じで)。",1268795100.0],["グニャラくん","初の書き込み。テストテスト。",1268794800.0],["hsiomaneki","@tasukuchan ようこそ!!!",1268795100.0],["グニャラくん","@daijiro ありがとう!",1268798400.0],["グニャラくん","groongaなう #groonga",1268802000.0]],[[1],[["_key","ShortText"],["_nsubrecs","Int32"]],["groonga",1]],[[2],[["_key","ShortText"],["_nsubrecs","Int32"]],["daijiro",2],["tasukuchan",3]]]] \ No newline at end of file Modified: doc/ja/source/example/tutorial10-2.log (+1 -1) =================================================================== --- doc/ja/source/example/tutorial10-2.log 2011-01-05 14:40:36 +0000 (b3afd1b) +++ doc/ja/source/example/tutorial10-2.log 2011-01-06 05:43:58 +0000 (8b4fe91) @@ -1,5 +1,5 @@ 実行例 :: > select --table Users --filter 'geo_in_circle(location,"128484216x502919856",5000)' --output_columns _key,name - [[0,1280378873.20845,0.000337],[[[2],[["_key","ShortText"],["name","ShortText"]],["tasukuchan","グニャラくん"],["OffGao","OffGao"]]]] + [[0,1294292470.6155,0.000343137],[[[2],[["_key","ShortText"],["name","ShortText"]],["tasukuchan","グニャラくん"],["OffGao","OffGao"]]]] \ No newline at end of file Modified: doc/ja/source/example/tutorial10-3.log (+1 -1) =================================================================== --- doc/ja/source/example/tutorial10-3.log 2011-01-05 14:40:36 +0000 (fc2bd8a) +++ doc/ja/source/example/tutorial10-3.log 2011-01-06 05:43:58 +0000 (69b85e2) @@ -1,5 +1,5 @@ 実行例 :: > select --table Users --query follower:@tasukuchan --output_columns _key,name - [[0,1280378873.4108,0.000311],[[[2],[["_key","ShortText"],["name","ShortText"]],["daijiro","hsiomaneki"],["OffGao","OffGao"]]]] + [[0,1294292470.81784,0.000305006],[[[2],[["_key","ShortText"],["name","ShortText"]],["daijiro","hsiomaneki"],["OffGao","OffGao"]]]] \ No newline at end of file Modified: doc/ja/source/example/tutorial10-4.log (+1 -1) =================================================================== --- doc/ja/source/example/tutorial10-4.log 2011-01-05 14:40:36 +0000 (c4b50df) +++ doc/ja/source/example/tutorial10-4.log 2011-01-06 05:43:58 +0000 (e8cf076) @@ -1,5 +1,5 @@ 実行例 :: > select --table Comments --filter 'geo_in_circle(location,"127975798x502919856",20000)' --output_columns posted_by.name,comment --drilldown hash_tags,posted_by - [[0,1280378873.61299,0.000702],[[[4],[["posted_by.name","ShortText"],["comment","ShortText"]],["OffGao","@daijiro @tasukuchan 登録してみましたよー!"],["グニャラくん","groongaなう #groonga"],["グニャラくん","groonga開発合宿のため羽田空港に来ました! #groonga #travel"],["OffGao","中野ブロードウェイなうなう"]],[[2],[["_key","ShortText"],["_nsubrecs","Int32"]],["groonga",2],["travel",1]],[[2],[["_key","ShortText"],["_nsubrecs","Int32"]],["OffGao",2],["tasukuchan",2]]]] + [[0,1294292471.01995,0.000683663],[[[4],[["posted_by.name","ShortText"],["comment","ShortText"]],["OffGao","@daijiro @tasukuchan 登録してみましたよー!"],["グニャラくん","groongaなう #groonga"],["グニャラくん","groonga開発合宿のため羽田空港に来ました! #groonga #travel"],["OffGao","中野ブロードウェイなうなう"]],[[2],[["_key","ShortText"],["_nsubrecs","Int32"]],["groonga",2],["travel",1]],[[2],[["_key","ShortText"],["_nsubrecs","Int32"]],["OffGao",2],["tasukuchan",2]]]] \ No newline at end of file Modified: doc/ja/source/example/tutorial10-5.log (+1 -1) =================================================================== --- doc/ja/source/example/tutorial10-5.log 2011-01-05 14:40:36 +0000 (56a5b1d) +++ doc/ja/source/example/tutorial10-5.log 2011-01-06 05:43:58 +0000 (222e45c) @@ -1,5 +1,5 @@ 実行例 :: > select --table Comments --query comment:@なう --output_columns comment,_score - [[0,1280378873.81946,0.000332],[[[2],[["comment","ShortText"],["_score","Int32"]],["groongaなう #groonga",1],["中野ブロードウェイなうなう",2]]]] + [[0,1294292471.22683,0.000339904],[[[2],[["comment","ShortText"],["_score","Int32"]],["groongaなう #groonga",1],["中野ブロードウェイなうなう",2]]]] \ No newline at end of file Modified: doc/ja/source/example/tutorial10-6.log (+1 -1) =================================================================== --- doc/ja/source/example/tutorial10-6.log 2011-01-05 14:40:36 +0000 (9b5125f) +++ doc/ja/source/example/tutorial10-6.log 2011-01-06 05:43:58 +0000 (f5d9948) @@ -1,5 +1,5 @@ 実行例 :: > select --table Comments --query comment:@羽田 --filter 'geo_in_circle(location,"127975798x502919856",20000)' --output_columns posted_by.name,comment --drilldown hash_tags,posted_by - [[0,1280378874.02194,0.000669],[[[1],[["posted_by.name","ShortText"],["comment","ShortText"]],["グニャラくん","groonga開発合宿のため羽田空港に来ました! #groonga #travel"]],[[2],[["_key","ShortText"],["_nsubrecs","Int32"]],["groonga",1],["travel",1]],[[1],[["_key","ShortText"],["_nsubrecs","Int32"]],["tasukuchan",1]]]] + [[0,1294292471.42922,0.00063973],[[[1],[["posted_by.name","ShortText"],["comment","ShortText"]],["グニャラくん","groonga開発合宿のため羽田空港に来ました! #groonga #travel"]],[[2],[["_key","ShortText"],["_nsubrecs","Int32"]],["groonga",1],["travel",1]],[[1],[["_key","ShortText"],["_nsubrecs","Int32"]],["tasukuchan",1]]]] \ No newline at end of file Modified: doc/ja/source/example/tutorial10-7.log (+1 -1) =================================================================== --- doc/ja/source/example/tutorial10-7.log 2011-01-05 14:40:36 +0000 (71d691c) +++ doc/ja/source/example/tutorial10-7.log 2011-01-06 05:43:58 +0000 (4905e67) @@ -1,5 +1,5 @@ 実行例 :: > select --table Comments --query hash_tags:@groonga --output_columns posted_by.name,comment --drilldown posted_by - [[0,1280378874.22658,0.000485],[[[2],[["posted_by.name","ShortText"],["comment","ShortText"]],["グニャラくん","groongaなう #groonga"],["グニャラくん","groonga開発合宿のため羽田空港に来ました! #groonga #travel"]],[[1],[["_key","ShortText"],["_nsubrecs","Int32"]],["tasukuchan",2]]]] + [[0,1294292471.6339,0.000473975],[[[2],[["posted_by.name","ShortText"],["comment","ShortText"]],["グニャラくん","groongaなう #groonga"],["グニャラくん","groonga開発合宿のため羽田空港に来ました! #groonga #travel"]],[[1],[["_key","ShortText"],["_nsubrecs","Int32"]],["tasukuchan",2]]]] \ No newline at end of file Modified: doc/ja/source/example/tutorial10-8.log (+1 -1) =================================================================== --- doc/ja/source/example/tutorial10-8.log 2011-01-05 14:40:36 +0000 (f2d5bd0) +++ doc/ja/source/example/tutorial10-8.log 2011-01-06 05:43:58 +0000 (9299769) @@ -1,5 +1,5 @@ 実行例 :: > select --table Comments --query posted_by:tasukuchan --output_columns comment --drilldown hash_tags - [[0,1280378874.43074,0.000502],[[[4],[["comment","ShortText"]],["初の書き込み。テストテスト。"],["@daijiro ありがとう!"],["groongaなう #groonga"],["groonga開発合宿のため羽田空港に来ました! #groonga #travel"]],[[2],[["_key","ShortText"],["_nsubrecs","Int32"]],["groonga",2],["travel",1]]]] + [[0,1294292471.83804,0.000471649],[[[4],[["comment","ShortText"]],["初の書き込み。テストテスト。"],["@daijiro ありがとう!"],["groongaなう #groonga"],["groonga開発合宿のため羽田空港に来ました! #groonga #travel"]],[[2],[["_key","ShortText"],["_nsubrecs","Int32"]],["groonga",2],["travel",1]]]] \ No newline at end of file Modified: doc/ja/source/example/tutorial10-9.log (+1 -1) =================================================================== --- doc/ja/source/example/tutorial10-9.log 2011-01-05 14:40:36 +0000 (bb8f2d0) +++ doc/ja/source/example/tutorial10-9.log 2011-01-06 05:43:58 +0000 (85e6d0e) @@ -1,5 +1,5 @@ 実行例 :: > select --table Users --query _key:tasukuchan --output_columns favorites.posted_by,favorites.comment - [[0,1280378874.63511,0.000327],[[[1],[["favorites.posted_by","Users"],["favorites.comment","ShortText"]],[["daijiro","OffGao"],["マイクロブログ作ってみました(甘栗むいちゃいました的な感じで)。","@daijiro @tasukuchan 登録してみましたよー!"]]]]] + [[0,1294292472.04238,0.000320089],[[[1],[["favorites.posted_by","Users"],["favorites.comment","ShortText"]],[["daijiro","OffGao"],["マイクロブログ作ってみました(甘栗むいちゃいました的な感じで)。","@daijiro @tasukuchan 登録してみましたよー!"]]]]] \ No newline at end of file Modified: doc/ja/source/tutorial/tutorial06.txt (+18 -0) =================================================================== --- doc/ja/source/tutorial/tutorial06.txt 2011-01-05 14:40:36 +0000 (8cce830) +++ doc/ja/source/tutorial/tutorial06.txt 2011-01-06 05:43:58 +0000 (74cd926) @@ -1,6 +1,8 @@ .. highlightlang:: none .. groonga-include : tutorial05.txt +.. groonga-command +.. table_remove GeoIndex タグ検索・参照関係の逆引き ========================== @@ -89,3 +91,19 @@ groongaはテーブル間の参照関係の逆引きを高速に行うための .. select --table User --limit 0 --drilldown friends このように、テーブルの参照関係を逆にたどる検索ができました。 + +インデックス付きジオサーチ +-------------------------- + +位置情報のカラムに対して、インデックスを付与することが出来ます。大量の位置情報レコードを検索する場合に、検索速度が速くなります。 + +.. groonga-command +.. include:: ../ex/tutorial06-6.log +.. table_create --name GeoIndex --flags TABLE_HASH_KEY --key_type WGS84GeoPoint +.. column_create --table GeoIndex --name index_point --type Site --flags COLUMN_INDEX --source location +.. load --table Site +.. [ +.. {"_key":"http://example.org/","location":"128452975x503157902"} +.. {"_key":"http://example.net/","location":"128487316x502920929"}, +.. ] +.. select --table Site --filter 'geo_in_circle(location, "128515259x503187188", 5000)' --output_columns _key,location