null+****@clear*****
null+****@clear*****
2012年 5月 8日 (火) 18:18:28 JST
Kouhei Sutou 2012-05-08 18:18:28 +0900 (Tue, 08 May 2012) New Revision: 0b2d9ad4db02e4a14fba54702fc5cc349551cd66 Log: doc: update execution examples Modified files: doc/example/indexing-data.log doc/example/indexing-offline-index-construction.log doc/example/indexing-online-index-construction.log doc/example/indexing-schema.log doc/example/indexing-search-after-offline-index-construction.log doc/example/indexing-search-after-online-index-construction.log doc/example/indexing-search-without-index.log doc/source/commands/suggest-completion.log doc/source/commands/suggest-correction.log doc/source/commands/suggest-learn-completion.log doc/source/commands/suggest-learn-correction.log doc/source/commands/suggest-learn-suggestion.log doc/source/commands/suggest-mixed.log doc/source/commands/suggest-suggestion.log doc/source/example/commands/select/filter_equal.log doc/source/example/commands/select/filter_less_than.log doc/source/example/commands/select/match_columns_simple.log doc/source/example/commands/select/match_columns_some_columns.log doc/source/example/commands/select/match_columns_weight.log doc/source/example/commands/select/match_escalation_threshold.log doc/source/example/commands/select/no_limit.log doc/source/example/commands/select/paging.log doc/source/example/commands/select/query_and.log doc/source/example/commands/select/query_equal.log doc/source/example/commands/select/query_less_than.log doc/source/example/commands/select/query_or.log doc/source/example/commands/select/simple_filter.log doc/source/example/commands/select/simple_query.log doc/source/example/commands/select/simple_usage.log doc/source/example/commands/select/table_nonexistent.log doc/source/example/commands/select/usage_setup.log doc/source/example/completion-1.log doc/source/example/correction-1.log doc/source/example/suggestion-1.log doc/source/example/tutorial/data-1.log doc/source/example/tutorial/data-2.log doc/source/example/tutorial/data-3.log doc/source/example/tutorial/data-4.log doc/source/example/tutorial/data-5.log doc/source/example/tutorial/data-6.log doc/source/example/tutorial/data-7.log doc/source/example/tutorial/data-8.log doc/source/example/tutorial/index-1.log doc/source/example/tutorial/index-2.log doc/source/example/tutorial/index-3.log doc/source/example/tutorial/index-4.log doc/source/example/tutorial/index-5.log doc/source/example/tutorial/index-6.log doc/source/example/tutorial/index-7.log doc/source/example/tutorial/match_columns-1.log doc/source/example/tutorial/match_columns-2.log doc/source/example/tutorial/match_columns-3.log doc/source/example/tutorial/match_columns-4.log doc/source/example/tutorial/micro_blog-1.log doc/source/example/tutorial/micro_blog-10.log doc/source/example/tutorial/micro_blog-2.log doc/source/example/tutorial/micro_blog-3.log doc/source/example/tutorial/micro_blog-4.log doc/source/example/tutorial/micro_blog-5.log doc/source/example/tutorial/micro_blog-6.log doc/source/example/tutorial/micro_blog-7.log doc/source/example/tutorial/micro_blog-8.log doc/source/example/tutorial/micro_blog-9.log doc/source/example/tutorial/network-1.log doc/source/example/tutorial/network-2.log doc/source/example/tutorial/network-3.log doc/source/example/tutorial/patricia_trie-1.log doc/source/example/tutorial/patricia_trie-2.log doc/source/example/tutorial/query_expansion-1.log doc/source/example/tutorial/query_expansion-2.log doc/source/example/tutorial/query_expansion-3.log Modified: doc/example/indexing-data.log (+7 -8) =================================================================== --- doc/example/indexing-data.log 2012-05-08 18:18:08 +0900 (f42887f) +++ doc/example/indexing-data.log 2012-05-08 18:18:28 +0900 (297219f) @@ -1,10 +1,9 @@ Execution example:: - > load --table Tweets - > [ - > {"content":"Hello!"}, - > {"content":"I just start it!"}, - > {"content":"I'm sleepy... Have a nice day... Good night..."} - > ] - [[0,1335519575.72702,1.00192642211914],3] - \ No newline at end of file + load --table Tweets + [ + {"content":"Hello!"}, + {"content":"I just start it!"}, + {"content":"I'm sleepy... Have a nice day... Good night..."} + ] + # [[0,1336468377.09131,0.200614929199219],3] Modified: doc/example/indexing-offline-index-construction.log (+2 -3) =================================================================== --- doc/example/indexing-offline-index-construction.log 2012-05-08 18:18:08 +0900 (63e5f14) +++ doc/example/indexing-offline-index-construction.log 2012-05-08 18:18:28 +0900 (b0478fa) @@ -1,5 +1,4 @@ Execution example:: - > column_create Lexicon tweet COLUMN_INDEX|WITH_POSITION Tweets content - [[0,1335519577.13347,0.00795507431030273],true] - \ No newline at end of file + column_create Lexicon tweet COLUMN_INDEX|WITH_POSITION Tweets content + # [[0,1336468377.69422,0.00441122055053711],true] Modified: doc/example/indexing-online-index-construction.log (+6 -7) =================================================================== --- doc/example/indexing-online-index-construction.log 2012-05-08 18:18:08 +0900 (4919fed) +++ doc/example/indexing-online-index-construction.log 2012-05-08 18:18:28 +0900 (bfa7993) @@ -1,9 +1,8 @@ Execution example:: - > load --table Tweets - > [ - > {"content":"Good morning! Nice day."}, - > {"content":"Let's go shopping."} - > ] - [[0,1335519577.54547,0.801515579223633],2] - \ No newline at end of file + load --table Tweets + [ + {"content":"Good morning! Nice day."}, + {"content":"Let's go shopping."} + ] + # [[0,1336468378.10136,0.200676679611206],2] Modified: doc/example/indexing-schema.log (+6 -7) =================================================================== --- doc/example/indexing-schema.log 2012-05-08 18:18:08 +0900 (4fecbd6) +++ doc/example/indexing-schema.log 2012-05-08 18:18:28 +0900 (1cc4aa5) @@ -1,9 +1,8 @@ Execution example:: - > table_create Tweets TABLE_NO_KEY - [[0,1335519575.12183,0.000383138656616211],true] - > column_create Tweets content COLUMN_SCALAR ShortText - [[0,1335519575.32371,0.000842571258544922],true] - > table_create Lexicon TABLE_HASH_KEY|KEY_NORMALIZE ShortText --default_tokenizer TokenBigram - [[0,1335519575.52538,0.000417470932006836],true] - \ No newline at end of file + table_create Tweets TABLE_NO_KEY + # [[0,1336468376.48821,0.000118255615234375],true] + column_create Tweets content COLUMN_SCALAR ShortText + # [[0,1336468376.68921,0.000538349151611328],true] + table_create Lexicon TABLE_HASH_KEY|KEY_NORMALIZE ShortText --default_tokenizer TokenBigram + # [[0,1336468376.89027,0.000240325927734375],true] Modified: doc/example/indexing-search-after-offline-index-construction.log (+29 -30) =================================================================== --- doc/example/indexing-search-after-offline-index-construction.log 2012-05-08 18:18:08 +0900 (460dae7) +++ doc/example/indexing-search-after-offline-index-construction.log 2012-05-08 18:18:28 +0900 (490e966) @@ -1,32 +1,31 @@ Execution example:: - > select Tweets --match_columns content --query 'good nice' - [ - [ - 0, - 1335519577.34259, - 0.000716209411621094 - ], - [ - [ - [ - 1 - ], - [ - [ - "_id", - "UInt32" - ], - [ - "content", - "ShortText" - ] - ], - [ - 3, - "I'm sleepy... Have a nice day... Good night..." - ] - ] - ] - ] - \ No newline at end of file + select Tweets --match_columns content --query 'good nice' + # [ + # [ + # 0, + # 1336468377.89941, + # 0.000522375106811523 + # ], + # [ + # [ + # [ + # 1 + # ], + # [ + # [ + # "_id", + # "UInt32" + # ], + # [ + # "content", + # "ShortText" + # ] + # ], + # [ + # 3, + # "I'm sleepy... Have a nice day... Good night..." + # ] + # ] + # ] + # ] Modified: doc/example/indexing-search-after-online-index-construction.log (+33 -34) =================================================================== --- doc/example/indexing-search-after-online-index-construction.log 2012-05-08 18:18:08 +0900 (8c1e2e5) +++ doc/example/indexing-search-after-online-index-construction.log 2012-05-08 18:18:28 +0900 (d91bfab) @@ -1,36 +1,35 @@ Execution example:: - > select Tweets --match_columns content --query 'good nice' - [ - [ - 0, - 1335519578.54813, - 0.000664234161376953 - ], - [ - [ - [ - 2 - ], - [ - [ - "_id", - "UInt32" - ], - [ - "content", - "ShortText" - ] - ], - [ - 3, - "I'm sleepy... Have a nice day... Good night..." - ], - [ - 4, - "Good morning! Nice day." - ] - ] - ] - ] - \ No newline at end of file + select Tweets --match_columns content --query 'good nice' + # [ + # [ + # 0, + # 1336468378.5029, + # 0.000379085540771484 + # ], + # [ + # [ + # [ + # 2 + # ], + # [ + # [ + # "_id", + # "UInt32" + # ], + # [ + # "content", + # "ShortText" + # ] + # ], + # [ + # 3, + # "I'm sleepy... Have a nice day... Good night..." + # ], + # [ + # 4, + # "Good morning! Nice day." + # ] + # ] + # ] + # ] Modified: doc/example/indexing-search-without-index.log (+25 -26) =================================================================== --- doc/example/indexing-search-without-index.log 2012-05-08 18:18:08 +0900 (bd1ac44) +++ doc/example/indexing-search-without-index.log 2012-05-08 18:18:28 +0900 (5678840) @@ -1,28 +1,27 @@ Execution example:: - > select Tweets --match_columns content --query 'good nice' - [ - [ - 0, - 1335519576.93011, - 0.000945568084716797 - ], - [ - [ - [ - 0 - ], - [ - [ - "_id", - "UInt32" - ], - [ - "content", - "ShortText" - ] - ] - ] - ] - ] - \ No newline at end of file + select Tweets --match_columns content --query 'good nice' + # [ + # [ + # 0, + # 1336468377.49266, + # 0.000493049621582031 + # ], + # [ + # [ + # [ + # 0 + # ], + # [ + # [ + # "_id", + # "UInt32" + # ], + # [ + # "content", + # "ShortText" + # ] + # ] + # ] + # ] + # ] Modified: doc/source/commands/suggest-completion.log (+29 -30) =================================================================== --- doc/source/commands/suggest-completion.log 2012-05-08 18:18:08 +0900 (421baf2) +++ doc/source/commands/suggest-completion.log 2012-05-08 18:18:28 +0900 (23e14d9) @@ -1,32 +1,31 @@ Execution example:: - > suggest --table item_query --column kana --types complete --frequency_threshold 1 --query en - [ - [ - 0, - 1335519589.6131, - 0.000982522964477539 - ], - { - "complete": [ - [ - 1 - ], - [ - [ - "_key", - "ShortText" - ], - [ - "_score", - "Int32" - ] - ], - [ - "engine", - 1 - ] - ] - } - ] - \ No newline at end of file + suggest --table item_query --column kana --types complete --frequency_threshold 1 --query en + # [ + # [ + # 0, + # 1336468381.88596, + # 0.000516891479492188 + # ], + # { + # "complete": [ + # [ + # 1 + # ], + # [ + # [ + # "_key", + # "ShortText" + # ], + # [ + # "_score", + # "Int32" + # ] + # ], + # [ + # "engine", + # 1 + # ] + # ] + # } + # ] Modified: doc/source/commands/suggest-correction.log (+29 -30) =================================================================== --- doc/source/commands/suggest-correction.log 2012-05-08 18:18:08 +0900 (4727098) +++ doc/source/commands/suggest-correction.log 2012-05-08 18:18:28 +0900 (0b7297a) @@ -1,32 +1,31 @@ Execution example:: - > suggest --table item_query --column kana --types correct --frequency_threshold 1 --query saerch - [ - [ - 0, - 1335519589.81612, - 0.000555992126464844 - ], - { - "correct": [ - [ - 1 - ], - [ - [ - "_key", - "ShortText" - ], - [ - "_score", - "Int32" - ] - ], - [ - "search", - 1 - ] - ] - } - ] - \ No newline at end of file + suggest --table item_query --column kana --types correct --frequency_threshold 1 --query saerch + # [ + # [ + # 0, + # 1336468382.08764, + # 0.000277519226074219 + # ], + # { + # "correct": [ + # [ + # 1 + # ], + # [ + # [ + # "_key", + # "ShortText" + # ], + # [ + # "_score", + # "Int32" + # ] + # ], + # [ + # "search", + # 1 + # ] + # ] + # } + # ] Modified: doc/source/commands/suggest-learn-completion.log (+10 -11) =================================================================== --- doc/source/commands/suggest-learn-completion.log 2012-05-08 18:18:08 +0900 (82fee06) +++ doc/source/commands/suggest-learn-completion.log 2012-05-08 18:18:28 +0900 (60ec2d5) @@ -1,13 +1,12 @@ Execution example:: - > load --table event_query --each 'suggest_preparer(_id, type, item, sequence, time, pair_query)' - > [ - > {"sequence": "1", "time": 1312950803.86057, "item": "e"}, - > {"sequence": "1", "time": 1312950803.96857, "item": "en"}, - > {"sequence": "1", "time": 1312950804.26057, "item": "eng"}, - > {"sequence": "1", "time": 1312950804.56057, "item": "engi"}, - > {"sequence": "1", "time": 1312950804.76057, "item": "engin"}, - > {"sequence": "1", "time": 1312950805.86057, "item": "engine", "type": "submit"} - > ] - [[0,1335519584.62528,1.57926440238953],6] - \ No newline at end of file + load --table event_query --each 'suggest_preparer(_id, type, item, sequence, time, pair_query)' + [ + {"sequence": "1", "time": 1312950803.86057, "item": "e"}, + {"sequence": "1", "time": 1312950803.96857, "item": "en"}, + {"sequence": "1", "time": 1312950804.26057, "item": "eng"}, + {"sequence": "1", "time": 1312950804.56057, "item": "engi"}, + {"sequence": "1", "time": 1312950804.76057, "item": "engin"}, + {"sequence": "1", "time": 1312950805.86057, "item": "engine", "type": "submit"} + ] + # [[0,1336468380.68818,0.192910671234131],6] Modified: doc/source/commands/suggest-learn-correction.log (+12 -13) =================================================================== --- doc/source/commands/suggest-learn-correction.log 2012-05-08 18:18:08 +0900 (453cae5) +++ doc/source/commands/suggest-learn-correction.log 2012-05-08 18:18:28 +0900 (0f57240) @@ -1,15 +1,14 @@ Execution example:: - > load --table event_query --each 'suggest_preparer(_id, type, item, sequence, time, pair_query)' - > [ - > {"sequence": "2", "time": 1312950803.86057, "item": "s"}, - > {"sequence": "2", "time": 1312950803.96857, "item": "sa"}, - > {"sequence": "2", "time": 1312950804.26057, "item": "sae"}, - > {"sequence": "2", "time": 1312950804.56057, "item": "saer"}, - > {"sequence": "2", "time": 1312950804.76057, "item": "saerc"}, - > {"sequence": "2", "time": 1312950805.76057, "item": "saerch", "type": "submit"}, - > {"sequence": "2", "time": 1312950809.76057, "item": "serch"}, - > {"sequence": "2", "time": 1312950810.86057, "item": "search", "type": "submit"} - > ] - [[0,1335519586.4057,2.00371694564819],8] - \ No newline at end of file + load --table event_query --each 'suggest_preparer(_id, type, item, sequence, time, pair_query)' + [ + {"sequence": "2", "time": 1312950803.86057, "item": "s"}, + {"sequence": "2", "time": 1312950803.96857, "item": "sa"}, + {"sequence": "2", "time": 1312950804.26057, "item": "sae"}, + {"sequence": "2", "time": 1312950804.56057, "item": "saer"}, + {"sequence": "2", "time": 1312950804.76057, "item": "saerc"}, + {"sequence": "2", "time": 1312950805.76057, "item": "saerch", "type": "submit"}, + {"sequence": "2", "time": 1312950809.76057, "item": "serch"}, + {"sequence": "2", "time": 1312950810.86057, "item": "search", "type": "submit"} + ] + # [[0,1336468381.08186,0.201012372970581],8] Modified: doc/source/commands/suggest-learn-suggestion.log (+6 -7) =================================================================== --- doc/source/commands/suggest-learn-suggestion.log 2012-05-08 18:18:08 +0900 (14fe908) +++ doc/source/commands/suggest-learn-suggestion.log 2012-05-08 18:18:28 +0900 (049c0a8) @@ -1,9 +1,8 @@ Execution example:: - > load --table event_query --each 'suggest_preparer(_id, type, item, sequence, time, pair_query)' - > [ - > {"sequence": "3", "time": 1312950803.86057, "item": "search engine", "type": "submit"}, - > {"sequence": "3", "time": 1312950808.86057, "item": "web search realtime", "type": "submit"} - > ] - [[0,1335519588.61046,0.801591634750366],2] - \ No newline at end of file + load --table event_query --each 'suggest_preparer(_id, type, item, sequence, time, pair_query)' + [ + {"sequence": "3", "time": 1312950803.86057, "item": "search engine", "type": "submit"}, + {"sequence": "3", "time": 1312950808.86057, "item": "web search realtime", "type": "submit"} + ] + # [[0,1336468381.48425,0.200975894927979],2] Modified: doc/source/commands/suggest-mixed.log (+75 -76) =================================================================== --- doc/source/commands/suggest-mixed.log 2012-05-08 18:18:08 +0900 (5addb45) +++ doc/source/commands/suggest-mixed.log 2012-05-08 18:18:28 +0900 (5a929b4) @@ -1,78 +1,77 @@ Execution example:: - > suggest --table item_query --column kana --types complete|correct|suggest --frequency_threshold 1 --query search - [ - [ - 0, - 1335519590.22114, - 0.00113773345947266 - ], - { - "suggest": [ - [ - 2 - ], - [ - [ - "_key", - "ShortText" - ], - [ - "_score", - "Int32" - ] - ], - [ - "search engine", - 1 - ], - [ - "web search realtime", - 1 - ] - ], - "complete": [ - [ - 2 - ], - [ - [ - "_key", - "ShortText" - ], - [ - "_score", - "Int32" - ] - ], - [ - "search", - 2 - ], - [ - "search engine", - 2 - ] - ], - "correct": [ - [ - 1 - ], - [ - [ - "_key", - "ShortText" - ], - [ - "_score", - "Int32" - ] - ], - [ - "search", - 2 - ] - ] - } - ] - \ No newline at end of file + suggest --table item_query --column kana --types complete|correct|suggest --frequency_threshold 1 --query search + # [ + # [ + # 0, + # 1336468382.49047, + # 0.000645160675048828 + # ], + # { + # "suggest": [ + # [ + # 2 + # ], + # [ + # [ + # "_key", + # "ShortText" + # ], + # [ + # "_score", + # "Int32" + # ] + # ], + # [ + # "search engine", + # 1 + # ], + # [ + # "web search realtime", + # 1 + # ] + # ], + # "complete": [ + # [ + # 2 + # ], + # [ + # [ + # "_key", + # "ShortText" + # ], + # [ + # "_score", + # "Int32" + # ] + # ], + # [ + # "search", + # 2 + # ], + # [ + # "search engine", + # 2 + # ] + # ], + # "correct": [ + # [ + # 1 + # ], + # [ + # [ + # "_key", + # "ShortText" + # ], + # [ + # "_score", + # "Int32" + # ] + # ], + # [ + # "search", + # 2 + # ] + # ] + # } + # ] Modified: doc/source/commands/suggest-suggestion.log (+33 -34) =================================================================== --- doc/source/commands/suggest-suggestion.log 2012-05-08 18:18:08 +0900 (0194825) +++ doc/source/commands/suggest-suggestion.log 2012-05-08 18:18:28 +0900 (7e4246c) @@ -1,36 +1,35 @@ Execution example:: - > suggest --table item_query --column kana --types suggest --frequency_threshold 1 --query search - [ - [ - 0, - 1335519590.01861, - 0.000383615493774414 - ], - { - "suggest": [ - [ - 2 - ], - [ - [ - "_key", - "ShortText" - ], - [ - "_score", - "Int32" - ] - ], - [ - "search engine", - 1 - ], - [ - "web search realtime", - 1 - ] - ] - } - ] - \ No newline at end of file + suggest --table item_query --column kana --types suggest --frequency_threshold 1 --query search + # [ + # [ + # 0, + # 1336468382.28905, + # 0.000260353088378906 + # ], + # { + # "suggest": [ + # [ + # 2 + # ], + # [ + # [ + # "_key", + # "ShortText" + # ], + # [ + # "_score", + # "Int32" + # ] + # ], + # [ + # "search engine", + # 1 + # ], + # [ + # "web search realtime", + # 1 + # ] + # ] + # } + # ] Modified: doc/source/example/commands/select/filter_equal.log (+39 -40) =================================================================== --- doc/source/example/commands/select/filter_equal.log 2012-05-08 18:18:08 +0900 (d041378) +++ doc/source/example/commands/select/filter_equal.log 2012-05-08 18:18:28 +0900 (a112d7c) @@ -1,42 +1,41 @@ Execution example:: - > select Entries --filter '_key == "Groonga"' - [ - [ - 0, - 1336462400.98305, - 0.000327587127685547 - ], - [ - [ - [ - 1 - ], - [ - [ - "_id", - "UInt32" - ], - [ - "_key", - "ShortText" - ], - [ - "content", - "Text" - ], - [ - "n_likes", - "UInt32" - ] - ], - [ - 2, - "Groonga", - "I started to use groonga. It's very fast!", - 10 - ] - ] - ] - ] - \ No newline at end of file + select Entries --filter '_key == "Groonga"' + # [ + # [ + # 0, + # 1336468386.94773, + # 0.000296354293823242 + # ], + # [ + # [ + # [ + # 1 + # ], + # [ + # [ + # "_id", + # "UInt32" + # ], + # [ + # "_key", + # "ShortText" + # ], + # [ + # "content", + # "Text" + # ], + # [ + # "n_likes", + # "UInt32" + # ] + # ], + # [ + # 2, + # "Groonga", + # "I started to use groonga. It's very fast!", + # 10 + # ] + # ] + # ] + # ] Modified: doc/source/example/commands/select/filter_less_than.log (+45 -46) =================================================================== --- doc/source/example/commands/select/filter_less_than.log 2012-05-08 18:18:08 +0900 (97e409d) +++ doc/source/example/commands/select/filter_less_than.log 2012-05-08 18:18:28 +0900 (c195c52) @@ -1,48 +1,47 @@ Execution example:: - > select Entries --filter 'n_likes < 11' - [ - [ - 0, - 1336462401.18486, - 0.000334024429321289 - ], - [ - [ - [ - 2 - ], - [ - [ - "_id", - "UInt32" - ], - [ - "_key", - "ShortText" - ], - [ - "content", - "Text" - ], - [ - "n_likes", - "UInt32" - ] - ], - [ - 1, - "The first post!", - "Welcome! This is my first post!", - 5 - ], - [ - 2, - "Groonga", - "I started to use groonga. It's very fast!", - 10 - ] - ] - ] - ] - \ No newline at end of file + select Entries --filter 'n_likes < 11' + # [ + # [ + # 0, + # 1336468387.14931, + # 0.000354528427124023 + # ], + # [ + # [ + # [ + # 2 + # ], + # [ + # [ + # "_id", + # "UInt32" + # ], + # [ + # "_key", + # "ShortText" + # ], + # [ + # "content", + # "Text" + # ], + # [ + # "n_likes", + # "UInt32" + # ] + # ], + # [ + # 1, + # "The first post!", + # "Welcome! This is my first post!", + # 5 + # ], + # [ + # 2, + # "Groonga", + # "I started to use groonga. It's very fast!", + # 10 + # ] + # ] + # ] + # ] Modified: doc/source/example/commands/select/match_columns_simple.log (+33 -34) =================================================================== --- doc/source/example/commands/select/match_columns_simple.log 2012-05-08 18:18:08 +0900 (ad8393f) +++ doc/source/example/commands/select/match_columns_simple.log 2012-05-08 18:18:28 +0900 (04aa28a) @@ -1,36 +1,35 @@ Execution example:: - > select Entries --match_columns content --query fast --output_columns '_key, _score' - [ - [ - 0, - 1335519593.88754, - 0.000384092330932617 - ], - [ - [ - [ - 2 - ], - [ - [ - "_key", - "ShortText" - ], - [ - "_score", - "Int32" - ] - ], - [ - "Groonga", - 1 - ], - [ - "Mroonga", - 2 - ] - ] - ] - ] - \ No newline at end of file + select Entries --match_columns content --query fast --output_columns '_key, _score' + # [ + # [ + # 0, + # 1336468385.53409, + # 0.000331878662109375 + # ], + # [ + # [ + # [ + # 2 + # ], + # [ + # [ + # "_key", + # "ShortText" + # ], + # [ + # "_score", + # "Int32" + # ] + # ], + # [ + # "Groonga", + # 1 + # ], + # [ + # "Mroonga", + # 2 + # ] + # ] + # ] + # ] Modified: doc/source/example/commands/select/match_columns_some_columns.log (+29 -30) =================================================================== --- doc/source/example/commands/select/match_columns_some_columns.log 2012-05-08 18:18:08 +0900 (1b58c61) +++ doc/source/example/commands/select/match_columns_some_columns.log 2012-05-08 18:18:28 +0900 (cce9d05) @@ -1,32 +1,31 @@ Execution example:: - > select Entries --match_columns '_key * 10 || content' --query groonga --output_columns '_key, _score' - [ - [ - 0, - 1335594540.29792, - 0.000547885894775391 - ], - [ - [ - [ - 1 - ], - [ - [ - "_key", - "ShortText" - ], - [ - "_score", - "Int32" - ] - ], - [ - "Groonga", - 11 - ] - ] - ] - ] - \ No newline at end of file + select Entries --match_columns '_key * 10 || content' --query groonga --output_columns '_key, _score' + # [ + # [ + # 0, + # 1336468385.93695, + # 0.000330209732055664 + # ], + # [ + # [ + # [ + # 1 + # ], + # [ + # [ + # "_key", + # "ShortText" + # ], + # [ + # "_score", + # "Int32" + # ] + # ], + # [ + # "Groonga", + # 11 + # ] + # ] + # ] + # ] Modified: doc/source/example/commands/select/match_columns_weight.log (+33 -34) =================================================================== --- doc/source/example/commands/select/match_columns_weight.log 2012-05-08 18:18:08 +0900 (14592f4) +++ doc/source/example/commands/select/match_columns_weight.log 2012-05-08 18:18:28 +0900 (b479018) @@ -1,36 +1,35 @@ Execution example:: - > select Entries --match_columns 'content * 2' --query fast --output_columns '_key, _score' - [ - [ - 0, - 1335519594.08917, - 0.0003814697265625 - ], - [ - [ - [ - 2 - ], - [ - [ - "_key", - "ShortText" - ], - [ - "_score", - "Int32" - ] - ], - [ - "Groonga", - 2 - ], - [ - "Mroonga", - 4 - ] - ] - ] - ] - \ No newline at end of file + select Entries --match_columns 'content * 2' --query fast --output_columns '_key, _score' + # [ + # [ + # 0, + # 1336468385.73556, + # 0.00034332275390625 + # ], + # [ + # [ + # [ + # 2 + # ], + # [ + # [ + # "_key", + # "ShortText" + # ], + # [ + # "_score", + # "Int32" + # ] + # ], + # [ + # "Groonga", + # 2 + # ], + # [ + # "Mroonga", + # 4 + # ] + # ] + # ] + # ] Modified: doc/source/example/commands/select/match_escalation_threshold.log (+72 -73) =================================================================== --- doc/source/example/commands/select/match_escalation_threshold.log 2012-05-08 18:18:08 +0900 (9964cc7) +++ doc/source/example/commands/select/match_escalation_threshold.log 2012-05-08 18:18:28 +0900 (5803e58) @@ -1,75 +1,74 @@ Execution example:: - > select Entries --match_columns content --query groo - [ - [ - 0, - 1336466929.13937, - 0.000423669815063477 - ], - [ - [ - [ - 1 - ], - [ - [ - "_id", - "UInt32" - ], - [ - "_key", - "ShortText" - ], - [ - "content", - "Text" - ], - [ - "n_likes", - "UInt32" - ] - ], - [ - 2, - "Groonga", - "I started to use groonga. It's very fast!", - 10 - ] - ] - ] - ] - > select Entries --match_columns content --query groo --match_escalation_threshold -1 - [ - [ - 0, - 1336466929.3408, - 0.00037693977355957 - ], - [ - [ - [ - 0 - ], - [ - [ - "_id", - "UInt32" - ], - [ - "_key", - "ShortText" - ], - [ - "content", - "Text" - ], - [ - "n_likes", - "UInt32" - ] - ] - ] - ] - ] - \ No newline at end of file + select Entries --match_columns content --query groo + # [ + # [ + # 0, + # 1336468387.35126, + # 0.000413894653320312 + # ], + # [ + # [ + # [ + # 1 + # ], + # [ + # [ + # "_id", + # "UInt32" + # ], + # [ + # "_key", + # "ShortText" + # ], + # [ + # "content", + # "Text" + # ], + # [ + # "n_likes", + # "UInt32" + # ] + # ], + # [ + # 2, + # "Groonga", + # "I started to use groonga. It's very fast!", + # 10 + # ] + # ] + # ] + # ] + select Entries --match_columns content --query groo --match_escalation_threshold -1 + # [ + # [ + # 0, + # 1336468387.55269, + # 0.000319004058837891 + # ], + # [ + # [ + # [ + # 0 + # ], + # [ + # [ + # "_id", + # "UInt32" + # ], + # [ + # "_key", + # "ShortText" + # ], + # [ + # "content", + # "Text" + # ], + # [ + # "n_likes", + # "UInt32" + # ] + # ] + # ] + # ] + # ] Modified: doc/source/example/commands/select/no_limit.log (+33 -30) =================================================================== --- doc/source/example/commands/select/no_limit.log 2012-05-08 18:18:08 +0900 (393e89f) +++ doc/source/example/commands/select/no_limit.log 2012-05-08 18:18:28 +0900 (79754f5) @@ -1,32 +1,35 @@ Execution example:: - > select Entries --limit 0 - [ - [ - 0, - 1335519593.48351, - 0.000329017639160156 - ], - [ - [ - [ - 3 - ], - [ - [ - "_id", - "UInt32" - ], - [ - "_key", - "ShortText" - ], - [ - "content", - "Text" - ] - ] - ] - ] - ] - \ No newline at end of file + select Entries --limit 0 + # [ + # [ + # 0, + # 1336468385.13137, + # 0.000172138214111328 + # ], + # [ + # [ + # [ + # 3 + # ], + # [ + # [ + # "_id", + # "UInt32" + # ], + # [ + # "_key", + # "ShortText" + # ], + # [ + # "content", + # "Text" + # ], + # [ + # "n_likes", + # "UInt32" + # ] + # ] + # ] + # ] + # ] Modified: doc/source/example/commands/select/paging.log (+39 -35) =================================================================== --- doc/source/example/commands/select/paging.log 2012-05-08 18:18:08 +0900 (1dd9ba7) +++ doc/source/example/commands/select/paging.log 2012-05-08 18:18:28 +0900 (6df6128) @@ -1,37 +1,41 @@ Execution example:: - > select Entries --offset 1 --limit 1 - [ - [ - 0, - 1335519593.28077, - 0.000288248062133789 - ], - [ - [ - [ - 3 - ], - [ - [ - "_id", - "UInt32" - ], - [ - "_key", - "ShortText" - ], - [ - "content", - "Text" - ] - ], - [ - 2, - "Groonga", - "I started to use groonga. It's very fast!" - ] - ] - ] - ] - \ No newline at end of file + select Entries --offset 1 --limit 1 + # [ + # [ + # 0, + # 1336468384.93004, + # 0.000171661376953125 + # ], + # [ + # [ + # [ + # 3 + # ], + # [ + # [ + # "_id", + # "UInt32" + # ], + # [ + # "_key", + # "ShortText" + # ], + # [ + # "content", + # "Text" + # ], + # [ + # "n_likes", + # "UInt32" + # ] + # ], + # [ + # 2, + # "Groonga", + # "I started to use groonga. It's very fast!", + # 10 + # ] + # ] + # ] + # ] Modified: doc/source/example/commands/select/query_and.log (+39 -40) =================================================================== --- doc/source/example/commands/select/query_and.log 2012-05-08 18:18:08 +0900 (e91cd31) +++ doc/source/example/commands/select/query_and.log 2012-05-08 18:18:28 +0900 (096d817) @@ -1,42 +1,41 @@ Execution example:: - > select Entries --match_columns content --query "fast groonga" - [ - [ - 0, - 1336461519.8022, - 0.000402688980102539 - ], - [ - [ - [ - 1 - ], - [ - [ - "_id", - "UInt32" - ], - [ - "_key", - "ShortText" - ], - [ - "content", - "Text" - ], - [ - "n_likes", - "UInt32" - ] - ], - [ - 2, - "Groonga", - "I started to use groonga. It's very fast!", - 10 - ] - ] - ] - ] - \ No newline at end of file + select Entries --match_columns content --query "fast groonga" + # [ + # [ + # 0, + # 1336468386.13964, + # 0.000435829162597656 + # ], + # [ + # [ + # [ + # 1 + # ], + # [ + # [ + # "_id", + # "UInt32" + # ], + # [ + # "_key", + # "ShortText" + # ], + # [ + # "content", + # "Text" + # ], + # [ + # "n_likes", + # "UInt32" + # ] + # ], + # [ + # 2, + # "Groonga", + # "I started to use groonga. It's very fast!", + # 10 + # ] + # ] + # ] + # ] Modified: doc/source/example/commands/select/query_equal.log (+39 -40) =================================================================== --- doc/source/example/commands/select/query_equal.log 2012-05-08 18:18:08 +0900 (8e8256c) +++ doc/source/example/commands/select/query_equal.log 2012-05-08 18:18:28 +0900 (b3af178) @@ -1,42 +1,41 @@ Execution example:: - > select Entries --query _key:Groonga - [ - [ - 0, - 1336461520.20626, - 0.000345230102539062 - ], - [ - [ - [ - 1 - ], - [ - [ - "_id", - "UInt32" - ], - [ - "_key", - "ShortText" - ], - [ - "content", - "Text" - ], - [ - "n_likes", - "UInt32" - ] - ], - [ - 2, - "Groonga", - "I started to use groonga. It's very fast!", - 10 - ] - ] - ] - ] - \ No newline at end of file + select Entries --query _key:Groonga + # [ + # [ + # 0, + # 1336468386.54406, + # 0.00028681755065918 + # ], + # [ + # [ + # [ + # 1 + # ], + # [ + # [ + # "_id", + # "UInt32" + # ], + # [ + # "_key", + # "ShortText" + # ], + # [ + # "content", + # "Text" + # ], + # [ + # "n_likes", + # "UInt32" + # ] + # ], + # [ + # 2, + # "Groonga", + # "I started to use groonga. It's very fast!", + # 10 + # ] + # ] + # ] + # ] Modified: doc/source/example/commands/select/query_less_than.log (+45 -46) =================================================================== --- doc/source/example/commands/select/query_less_than.log 2012-05-08 18:18:08 +0900 (ac82258) +++ doc/source/example/commands/select/query_less_than.log 2012-05-08 18:18:28 +0900 (058080e) @@ -1,48 +1,47 @@ Execution example:: - > select Entries --query n_likes:<11 - [ - [ - 0, - 1336461520.40798, - 0.000315427780151367 - ], - [ - [ - [ - 2 - ], - [ - [ - "_id", - "UInt32" - ], - [ - "_key", - "ShortText" - ], - [ - "content", - "Text" - ], - [ - "n_likes", - "UInt32" - ] - ], - [ - 1, - "The first post!", - "Welcome! This is my first post!", - 5 - ], - [ - 2, - "Groonga", - "I started to use groonga. It's very fast!", - 10 - ] - ] - ] - ] - \ No newline at end of file + select Entries --query n_likes:<11 + # [ + # [ + # 0, + # 1336468386.74599, + # 0.000313997268676758 + # ], + # [ + # [ + # [ + # 2 + # ], + # [ + # [ + # "_id", + # "UInt32" + # ], + # [ + # "_key", + # "ShortText" + # ], + # [ + # "content", + # "Text" + # ], + # [ + # "n_likes", + # "UInt32" + # ] + # ], + # [ + # 1, + # "The first post!", + # "Welcome! This is my first post!", + # 5 + # ], + # [ + # 2, + # "Groonga", + # "I started to use groonga. It's very fast!", + # 10 + # ] + # ] + # ] + # ] Modified: doc/source/example/commands/select/query_or.log (+45 -46) =================================================================== --- doc/source/example/commands/select/query_or.log 2012-05-08 18:18:08 +0900 (0e1f3b0) +++ doc/source/example/commands/select/query_or.log 2012-05-08 18:18:28 +0900 (fc07bae) @@ -1,48 +1,47 @@ Execution example:: - > select Entries --match_columns content --query "groonga OR mroonga" - [ - [ - 0, - 1336461520.00432, - 0.000370264053344727 - ], - [ - [ - [ - 2 - ], - [ - [ - "_id", - "UInt32" - ], - [ - "_key", - "ShortText" - ], - [ - "content", - "Text" - ], - [ - "n_likes", - "UInt32" - ] - ], - [ - 2, - "Groonga", - "I started to use groonga. It's very fast!", - 10 - ], - [ - 3, - "Mroonga", - "I also started to use mroonga. It's also very fast! Really fast!", - 15 - ] - ] - ] - ] - \ No newline at end of file + select Entries --match_columns content --query "groonga OR mroonga" + # [ + # [ + # 0, + # 1336468386.34177, + # 0.000362157821655273 + # ], + # [ + # [ + # [ + # 2 + # ], + # [ + # [ + # "_id", + # "UInt32" + # ], + # [ + # "_key", + # "ShortText" + # ], + # [ + # "content", + # "Text" + # ], + # [ + # "n_likes", + # "UInt32" + # ] + # ], + # [ + # 2, + # "Groonga", + # "I started to use groonga. It's very fast!", + # 10 + # ], + # [ + # 3, + # "Mroonga", + # "I also started to use mroonga. It's also very fast! Really fast!", + # 15 + # ] + # ] + # ] + # ] Modified: doc/source/example/commands/select/simple_filter.log (+39 -35) =================================================================== --- doc/source/example/commands/select/simple_filter.log 2012-05-08 18:18:08 +0900 (62c2763) +++ doc/source/example/commands/select/simple_filter.log 2012-05-08 18:18:28 +0900 (15ddc57) @@ -1,37 +1,41 @@ Execution example:: - > select Entries --filter 'content @ "fast" && _key == "Groonga"' - [ - [ - 0, - 1335520300.98383, - 0.000544071197509766 - ], - [ - [ - [ - 1 - ], - [ - [ - "_id", - "UInt32" - ], - [ - "_key", - "ShortText" - ], - [ - "content", - "Text" - ] - ], - [ - 2, - "Groonga", - "I started to use groonga. It's very fast!" - ] - ] - ] - ] - \ No newline at end of file + select Entries --filter 'content @ "fast" && _key == "Groonga"' + # [ + # [ + # 0, + # 1336468384.7285, + # 0.00033116340637207 + # ], + # [ + # [ + # [ + # 1 + # ], + # [ + # [ + # "_id", + # "UInt32" + # ], + # [ + # "_key", + # "ShortText" + # ], + # [ + # "content", + # "Text" + # ], + # [ + # "n_likes", + # "UInt32" + # ] + # ], + # [ + # 2, + # "Groonga", + # "I started to use groonga. It's very fast!", + # 10 + # ] + # ] + # ] + # ] Modified: doc/source/example/commands/select/simple_query.log (+45 -40) =================================================================== --- doc/source/example/commands/select/simple_query.log 2012-05-08 18:18:08 +0900 (c7ea6cb) +++ doc/source/example/commands/select/simple_query.log 2012-05-08 18:18:28 +0900 (64e2fe4) @@ -1,42 +1,47 @@ Execution example:: - > select Entries --match_columns content --query fast - [ - [ - 0, - 1335519592.87374, - 0.000868797302246094 - ], - [ - [ - [ - 2 - ], - [ - [ - "_id", - "UInt32" - ], - [ - "_key", - "ShortText" - ], - [ - "content", - "Text" - ] - ], - [ - 2, - "Groonga", - "I started to use groonga. It's very fast!" - ], - [ - 3, - "Mroonga", - "I also started to use mroonga. It's also very fast! Really fast!" - ] - ] - ] - ] - \ No newline at end of file + select Entries --match_columns content --query fast + # [ + # [ + # 0, + # 1336468384.52646, + # 0.000507831573486328 + # ], + # [ + # [ + # [ + # 2 + # ], + # [ + # [ + # "_id", + # "UInt32" + # ], + # [ + # "_key", + # "ShortText" + # ], + # [ + # "content", + # "Text" + # ], + # [ + # "n_likes", + # "UInt32" + # ] + # ], + # [ + # 2, + # "Groonga", + # "I started to use groonga. It's very fast!", + # 10 + # ], + # [ + # 3, + # "Mroonga", + # "I also started to use mroonga. It's also very fast! Really fast!", + # 15 + # ] + # ] + # ] + # ] Modified: doc/source/example/commands/select/simple_usage.log (+51 -45) =================================================================== --- doc/source/example/commands/select/simple_usage.log 2012-05-08 18:18:08 +0900 (17c2136) +++ doc/source/example/commands/select/simple_usage.log 2012-05-08 18:18:28 +0900 (586f3b8) @@ -1,47 +1,53 @@ Execution example:: - > select Entries - [ - [ - 0, - 1335519592.67133, - 0.000493049621582031 - ], - [ - [ - [ - 3 - ], - [ - [ - "_id", - "UInt32" - ], - [ - "_key", - "ShortText" - ], - [ - "content", - "Text" - ] - ], - [ - 1, - "The first post!", - "Welcome! This is my first post!" - ], - [ - 2, - "Groonga", - "I started to use groonga. It's very fast!" - ], - [ - 3, - "Mroonga", - "I also started to use mroonga. It's also very fast! Really fast!" - ] - ] - ] - ] - \ No newline at end of file + select Entries + # [ + # [ + # 0, + # 1336468384.32453, + # 0.000257015228271484 + # ], + # [ + # [ + # [ + # 3 + # ], + # [ + # [ + # "_id", + # "UInt32" + # ], + # [ + # "_key", + # "ShortText" + # ], + # [ + # "content", + # "Text" + # ], + # [ + # "n_likes", + # "UInt32" + # ] + # ], + # [ + # 1, + # "The first post!", + # "Welcome! This is my first post!", + # 5 + # ], + # [ + # 2, + # "Groonga", + # "I started to use groonga. It's very fast!", + # 10 + # ], + # [ + # 3, + # "Mroonga", + # "I also started to use mroonga. It's also very fast! Really fast!", + # 15 + # ] + # ] + # ] + # ] Modified: doc/source/example/commands/select/table_nonexistent.log (+16 -17) =================================================================== --- doc/source/example/commands/select/table_nonexistent.log 2012-05-08 18:18:08 +0900 (4ffbd33) +++ doc/source/example/commands/select/table_nonexistent.log 2012-05-08 18:18:28 +0900 (b3e9d70) @@ -1,19 +1,18 @@ Execution example:: - > select Nonexistent - [ - [ - -22, - 1335519593.68574, - 0.000583171844482422, - "invalid table name: <Nonexistent>", - [ - [ - "grn_select", - "proc.c", - 542 - ] - ] - ] - ] - \ No newline at end of file + select Nonexistent + # [ + # [ + # -22, + # 1336468385.33269, + # 0.000337600708007812, + # "invalid table name: <Nonexistent>", + # [ + # [ + # "grn_select", + # "proc.c", + # 542 + # ] + # ] + # ] + # ] Modified: doc/source/example/commands/select/usage_setup.log (+25 -17) =================================================================== --- doc/source/example/commands/select/usage_setup.log 2012-05-08 18:18:08 +0900 (5c768d9) +++ doc/source/example/commands/select/usage_setup.log 2012-05-08 18:18:28 +0900 (a8f9856) @@ -1,19 +1,27 @@ Execution example:: - > table_create Entries TABLE_HASH_KEY ShortText - [[0,1335594537.43378,0.000381708145141602],true] - > column_create Entries content COLUMN_SCALAR Text - [[0,1335594537.63582,0.000931501388549805],true] - > table_create Terms TABLE_PAT_KEY|KEY_NORMALIZE ShortText --default_tokenizer TokenBigram - [[0,1335594537.83776,0.000288009643554688],true] - > column_create Terms entries_key_index COLUMN_INDEX|WITH_POSITION Entries _key - [[0,1335594538.03901,0.0059964656829834],true] - > column_create Terms entries_content_index COLUMN_INDEX|WITH_POSITION Entries content - [[0,1335594538.24584,0.00617790222167969],true] - > load --table Entries - > [ - > {"_key": "The first post!", "content": "Welcome! This is my first post!"}, - > {"_key": "Groonga", "content": "I started to use groonga. It's very fast!"} - > {"_key": "Mroonga", "content": "I also started to use mroonga. It's also very fast! Really fast!"} - > ] - \ No newline at end of file + table_create Entries TABLE_HASH_KEY ShortText + # [[0,1336468382.70925,0.000218391418457031],true] + column_create Entries content COLUMN_SCALAR Text + # [[0,1336468382.91008,0.000534534454345703],true] + column_create Entries n_likes COLUMN_SCALAR UInt32 + # [[0,1336468383.11114,0.00021815299987793],true] + table_create Terms TABLE_PAT_KEY|KEY_NORMALIZE ShortText --default_tokenizer TokenBigram + # [[0,1336468383.31188,0.000239849090576172],true] + column_create Terms entries_key_index COLUMN_INDEX|WITH_POSITION Entries _key + # [[0,1336468383.51263,0.00399947166442871],true] + column_create Terms entries_content_index COLUMN_INDEX|WITH_POSITION Entries content + # [[0,1336468383.71716,0.00355195999145508],true] + load --table Entries + [ + {"_key": "The first post!", + "content": "Welcome! This is my first post!", + "n_likes": 5}, + {"_key": "Groonga", + "content": "I started to use groonga. It's very fast!", + "n_likes": 10}, + {"_key": "Mroonga", + "content": "I also started to use mroonga. It's also very fast! Really fast!", + "n_likes": 15} + ] + # [[0,1336468383.92122,0.202519655227661],3] Modified: doc/source/example/completion-1.log (+29 -30) =================================================================== --- doc/source/example/completion-1.log 2012-05-08 18:18:08 +0900 (99787d7) +++ doc/source/example/completion-1.log 2012-05-08 18:18:28 +0900 (1578305) @@ -1,32 +1,31 @@ Execution example:: - > suggest --table item_query --column kana --types complete --frequency_threshold 1 --query en - [ - [ - 0, - 1335519580.61411, - 0.00101041793823242 - ], - { - "complete": [ - [ - 1 - ], - [ - [ - "_key", - "ShortText" - ], - [ - "_score", - "Int32" - ] - ], - [ - "engine", - 1 - ] - ] - } - ] - \ No newline at end of file + suggest --table item_query --column kana --types complete --frequency_threshold 1 --query en + # [ + # [ + # 0, + # 1336468379.14295, + # 0.000610589981079102 + # ], + # { + # "complete": [ + # [ + # 1 + # ], + # [ + # [ + # "_key", + # "ShortText" + # ], + # [ + # "_score", + # "Int32" + # ] + # ], + # [ + # "engine", + # 1 + # ] + # ] + # } + # ] Modified: doc/source/example/correction-1.log (+29 -30) =================================================================== --- doc/source/example/correction-1.log 2012-05-08 18:18:08 +0900 (06448db) +++ doc/source/example/correction-1.log 2012-05-08 18:18:28 +0900 (c2cd372) @@ -1,32 +1,31 @@ Execution example:: - > suggest --table item_query --column kana --types correction --frequency_threshold 1 --query saerch - [ - [ - 0, - 1335519584.34144, - 0.000605106353759766 - ], - { - "correct": [ - [ - 1 - ], - [ - [ - "_key", - "ShortText" - ], - [ - "_score", - "Int32" - ] - ], - [ - "search", - 1 - ] - ] - } - ] - \ No newline at end of file + suggest --table item_query --column kana --types correction --frequency_threshold 1 --query saerch + # [ + # [ + # 0, + # 1336468380.42915, + # 0.000398397445678711 + # ], + # { + # "correct": [ + # [ + # 1 + # ], + # [ + # [ + # "_key", + # "ShortText" + # ], + # [ + # "_score", + # "Int32" + # ] + # ], + # [ + # "search", + # 1 + # ] + # ] + # } + # ] Modified: doc/source/example/suggestion-1.log (+33 -34) =================================================================== --- doc/source/example/suggestion-1.log 2012-05-08 18:18:08 +0900 (937ccf9) +++ doc/source/example/suggestion-1.log 2012-05-08 18:18:28 +0900 (5005abe) @@ -1,36 +1,35 @@ Execution example:: - > suggest --table item_query --column kana --types suggest --frequency_threshold 1 --query search - [ - [ - 0, - 1335519581.87931, - 0.000770807266235352 - ], - { - "suggest": [ - [ - 2 - ], - [ - [ - "_key", - "ShortText" - ], - [ - "_score", - "Int32" - ] - ], - [ - "search engine", - 1 - ], - [ - "web search realtime", - 1 - ] - ] - } - ] - \ No newline at end of file + suggest --table item_query --column kana --types suggest --frequency_threshold 1 --query search + # [ + # [ + # 0, + # 1336468379.78154, + # 0.000372171401977539 + # ], + # { + # "suggest": [ + # [ + # 2 + # ], + # [ + # [ + # "_key", + # "ShortText" + # ], + # [ + # "_score", + # "Int32" + # ] + # ], + # [ + # "search engine", + # 1 + # ], + # [ + # "web search realtime", + # 1 + # ] + # ] + # } + # ] Modified: doc/source/example/tutorial/data-1.log (+2 -3) =================================================================== --- doc/source/example/tutorial/data-1.log 2012-05-08 18:18:08 +0900 (95f1123) +++ doc/source/example/tutorial/data-1.log 2012-05-08 18:18:28 +0900 (933a2bb) @@ -1,5 +1,4 @@ Execution example:: - > table_create --name ToyBox --flags TABLE_HASH_KEY --key_type ShortText - [[0,1335519604.4465,0.000195741653442383],true] - \ No newline at end of file + table_create --name ToyBox --flags TABLE_HASH_KEY --key_type ShortText + # [[0,1336468394.04655,0.000269889831542969],true] Modified: doc/source/example/tutorial/data-2.log (+44 -45) =================================================================== --- doc/source/example/tutorial/data-2.log 2012-05-08 18:18:08 +0900 (db25453) +++ doc/source/example/tutorial/data-2.log 2012-05-08 18:18:28 +0900 (88cfb21) @@ -1,49 +1,48 @@ Execution example:: - > column_create --table ToyBox --name is_animal --type Bool - [[0,1335519604.64795,0.000276803970336914],true] - > load --table ToyBox - > [ - > {"_key":"Monkey","is_animal":true} - > {"_key":"Flower","is_animal":false} - > {"_key":"Block"} - > ] - [[0,1335519604.84886,1.00171399116516],3] - > select --table ToyBox --output_columns _key,is_animal + column_create --table ToyBox --name is_animal --type Bool + # [[0,1336468394.24776,0.000195503234863281],true] + load --table ToyBox [ - [ - 0, - 1335519606.05127, - 0.000250577926635742 - ], - [ - [ - [ - 3 - ], - [ - [ - "_key", - "ShortText" - ], - [ - "is_animal", - "Bool" - ] - ], - [ - "Monkey", - true - ], - [ - "Flower", - false - ], - [ - "Block", - false - ] - ] - ] + {"_key":"Monkey","is_animal":true} + {"_key":"Flower","is_animal":false} + {"_key":"Block"} ] - \ No newline at end of file + # [[0,1336468394.44844,0.20062780380249],3] + select --table ToyBox --output_columns _key,is_animal + # [ + # [ + # 0, + # 1336468394.84955, + # 0.000217676162719727 + # ], + # [ + # [ + # [ + # 3 + # ], + # [ + # [ + # "_key", + # "ShortText" + # ], + # [ + # "is_animal", + # "Bool" + # ] + # ], + # [ + # "Monkey", + # true + # ], + # [ + # "Flower", + # false + # ], + # [ + # "Block", + # false + # ] + # ] + # ] + # ] Modified: doc/source/example/tutorial/data-3.log (+53 -54) =================================================================== --- doc/source/example/tutorial/data-3.log 2012-05-08 18:18:08 +0900 (1c73637) +++ doc/source/example/tutorial/data-3.log 2012-05-08 18:18:28 +0900 (a6def39) @@ -1,58 +1,57 @@ Execution example:: - > column_create --table ToyBox --name price --type Int8 - [[0,1335519606.2531,0.000290155410766602],true] - > column_create --table ToyBox --name weight --type Float - [[0,1335519606.45421,0.000332832336425781],true] - > load --table ToyBox - > [ - > {"_key":"Monkey","price":15.9} - > {"_key":"Flower","price":200,"weight":0.13} - > {"_key":"Block","weight":25.7} - > ] - [[0,1335519606.65545,1.00174689292908],3] - > select --table ToyBox --output_columns _key,price,weight + column_create --table ToyBox --name price --type Int8 + # [[0,1336468395.05099,0.000190258026123047],true] + column_create --table ToyBox --name weight --type Float + # [[0,1336468395.25174,0.00020289421081543],true] + load --table ToyBox [ - [ - 0, - 1335519607.85801, - 0.000263452529907227 - ], - [ - [ - [ - 3 - ], - [ - [ - "_key", - "ShortText" - ], - [ - "price", - "Int8" - ], - [ - "weight", - "Float" - ] - ], - [ - "Monkey", - 15, - 0.0 - ], - [ - "Flower", - -56, - 0.13 - ], - [ - "Block", - 0, - 25.7 - ] - ] - ] + {"_key":"Monkey","price":15.9} + {"_key":"Flower","price":200,"weight":0.13} + {"_key":"Block","weight":25.7} ] - \ No newline at end of file + # [[0,1336468395.45248,0.200597286224365],3] + select --table ToyBox --output_columns _key,price,weight + # [ + # [ + # 0, + # 1336468395.8535, + # 0.000161170959472656 + # ], + # [ + # [ + # [ + # 3 + # ], + # [ + # [ + # "_key", + # "ShortText" + # ], + # [ + # "price", + # "Int8" + # ], + # [ + # "weight", + # "Float" + # ] + # ], + # [ + # "Monkey", + # 15, + # 0.0 + # ], + # [ + # "Flower", + # -56, + # 0.13 + # ], + # [ + # "Block", + # 0, + # 25.7 + # ] + # ] + # ] + # ] Modified: doc/source/example/tutorial/data-4.log (+43 -44) =================================================================== --- doc/source/example/tutorial/data-4.log 2012-05-08 18:18:08 +0900 (05740ed) +++ doc/source/example/tutorial/data-4.log 2012-05-08 18:18:28 +0900 (95310cc) @@ -1,48 +1,47 @@ Execution example:: - > column_create --table ToyBox --name name --type ShortText - [[0,1335519608.06052,0.000979185104370117],true] - > load --table ToyBox - > [ - > {"_key":"Monkey","name":"Grease"} - > {"_key":"Flower","name":"Rose"} - > ] - [[0,1335519608.26235,0.8014075756073],2] - > select --table ToyBox --output_columns _key,name + column_create --table ToyBox --name name --type ShortText + # [[0,1336468396.05497,0.000494003295898438],true] + load --table ToyBox [ - [ - 0, - 1335519609.26462, - 0.000252008438110352 - ], - [ - [ - [ - 3 - ], - [ - [ - "_key", - "ShortText" - ], - [ - "name", - "ShortText" - ] - ], - [ - "Monkey", - "Grease" - ], - [ - "Flower", - "Rose" - ], - [ - "Block", - "" - ] - ] - ] + {"_key":"Monkey","name":"Grease"} + {"_key":"Flower","name":"Rose"} ] - \ No newline at end of file + # [[0,1336468396.25599,0.200543642044067],2] + select --table ToyBox --output_columns _key,name + # [ + # [ + # 0, + # 1336468396.65701, + # 0.000139951705932617 + # ], + # [ + # [ + # [ + # 3 + # ], + # [ + # [ + # "_key", + # "ShortText" + # ], + # [ + # "name", + # "ShortText" + # ] + # ], + # [ + # "Monkey", + # "Grease" + # ], + # [ + # "Flower", + # "Rose" + # ], + # [ + # "Block", + # "" + # ] + # ] + # ] + # ] Modified: doc/source/example/tutorial/data-5.log (+43 -44) =================================================================== --- doc/source/example/tutorial/data-5.log 2012-05-08 18:18:08 +0900 (0b476a6) +++ doc/source/example/tutorial/data-5.log 2012-05-08 18:18:28 +0900 (1ade1bc) @@ -1,48 +1,47 @@ Execution example:: - > column_create --table ToyBox --name time --type Time - [[0,1335519609.46723,0.000249862670898438],true] - > load --table ToyBox - > [ - > {"_key":"Flower","time":1234567890.1234569999} - > {"_key":"Block","time":-1234567890} - > ] - [[0,1335519609.66827,0.801551818847656],2] - > select --table ToyBox --output_columns _key,time + column_create --table ToyBox --name time --type Time + # [[0,1336468396.85832,0.000158786773681641],true] + load --table ToyBox [ - [ - 0, - 1335519610.67062, - 0.000240564346313477 - ], - [ - [ - [ - 3 - ], - [ - [ - "_key", - "ShortText" - ], - [ - "time", - "Time" - ] - ], - [ - "Monkey", - 0.0 - ], - [ - "Flower", - 1234567890.12346 - ], - [ - "Block", - -1234567890.0 - ] - ] - ] + {"_key":"Flower","time":1234567890.1234569999} + {"_key":"Block","time":-1234567890} ] - \ No newline at end of file + # [[0,1336468397.05898,0.200578927993774],2] + select --table ToyBox --output_columns _key,time + # [ + # [ + # 0, + # 1336468397.46003, + # 0.000164031982421875 + # ], + # [ + # [ + # [ + # 3 + # ], + # [ + # [ + # "_key", + # "ShortText" + # ], + # [ + # "time", + # "Time" + # ] + # ], + # [ + # "Monkey", + # 0.0 + # ], + # [ + # "Flower", + # 1234567890.12346 + # ], + # [ + # "Block", + # -1234567890.0 + # ] + # ] + # ] + # ] Modified: doc/source/example/tutorial/data-6.log (+43 -44) =================================================================== --- doc/source/example/tutorial/data-6.log 2012-05-08 18:18:08 +0900 (2d3d3c4) +++ doc/source/example/tutorial/data-6.log 2012-05-08 18:18:28 +0900 (9dc3a7b) @@ -1,48 +1,47 @@ Execution example:: - > column_create --table ToyBox --name location --type WGS84GeoPoint - [[0,1335519610.87363,0.00025629997253418],true] - > load --table ToyBox - > [ - > {"_key":"Monkey","location":"128452975x503157902"} - > {"_key":"Block","location":"35.6813819x139.7660839"} - > ] - [[0,1335519611.07464,0.801477193832397],2] - > select --table ToyBox --output_columns _key,location + column_create --table ToyBox --name location --type WGS84GeoPoint + # [[0,1336468397.6614,0.00018763542175293],true] + load --table ToyBox [ - [ - 0, - 1335519612.07663, - 0.000145435333251953 - ], - [ - [ - [ - 3 - ], - [ - [ - "_key", - "ShortText" - ], - [ - "location", - "WGS84GeoPoint" - ] - ], - [ - "Monkey", - "128452975x503157902" - ], - [ - "Flower", - "0x0" - ], - [ - "Block", - "128452975x503157902" - ] - ] - ] + {"_key":"Monkey","location":"128452975x503157902"} + {"_key":"Block","location":"35.6813819x139.7660839"} ] - \ No newline at end of file + # [[0,1336468397.86209,0.200498580932617],2] + select --table ToyBox --output_columns _key,location + # [ + # [ + # 0, + # 1336468398.26311, + # 0.000158071517944336 + # ], + # [ + # [ + # [ + # 3 + # ], + # [ + # [ + # "_key", + # "ShortText" + # ], + # [ + # "location", + # "WGS84GeoPoint" + # ] + # ], + # [ + # "Monkey", + # "128452975x503157902" + # ], + # [ + # "Flower", + # "0x0" + # ], + # [ + # "Block", + # "128452975x503157902" + # ] + # ] + # ] + # ] Modified: doc/source/example/tutorial/data-7.log (+44 -45) =================================================================== --- doc/source/example/tutorial/data-7.log 2012-05-08 18:18:08 +0900 (cea1837) +++ doc/source/example/tutorial/data-7.log 2012-05-08 18:18:28 +0900 (64f9be8) @@ -1,47 +1,46 @@ Execution example:: - > column_create --table Site --name link --type Site - [[0,1335519612.27812,0.000259876251220703],true] - > load --table Site - > [{"_key":"http://example.org/","link":"http://example.net/"}] - [[0,1335519612.47892,0.200559377670288],1] - > select --table Site --output_columns _key,title,link._key,link.title --query title:@this - [ - [ - 0, - 1335519612.88015, - 0.000769853591918945 - ], - [ - [ - [ - 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 + column_create --table Site --name link --type Site + # [[0,1336468398.46454,0.00023341178894043],true] + load --table Site + [{"_key":"http://example.org/","link":"http://example.net/"}] + select --table Site --output_columns _key,title,link._key,link.title --query title:@this + # [[0,1336468398.66529,0.200507402420044],1] + # [ + # [ + # 0, + # 1336468398.86583, + # 0.00056004524230957 + # ], + # [ + # [ + # [ + # 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." + # ] + # ] + # ] + # ] Modified: doc/source/example/tutorial/data-8.log (+52 -53) =================================================================== --- doc/source/example/tutorial/data-8.log 2012-05-08 18:18:08 +0900 (fd57e6a) +++ doc/source/example/tutorial/data-8.log 2012-05-08 18:18:28 +0900 (d094f8f) @@ -1,55 +1,54 @@ Execution example:: - > column_create --table Site --name links --flags COLUMN_VECTOR --type Site - [[0,1335519613.08263,0.00126886367797852],true] - > load --table Site - > [{"_key":"http://example.org/","links":["http://example.net/","http://example.org/","http://example.com/"]}] - [[0,1335519613.28473,0.200579166412354],1] - > select --table Site --output_columns _key,title,links._key,links.title --query title:@this - [ - [ - 0, - 1335519613.68602, - 0.000647306442260742 - ], - [ - [ - [ - 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 + column_create --table Site --name links --flags COLUMN_VECTOR --type Site + # [[0,1336468399.06797,0.00054478645324707],true] + load --table Site + [{"_key":"http://example.org/","links":["http://example.net/","http://example.org/","http://example.com/"]}] + select --table Site --output_columns _key,title,links._key,links.title --query title:@this + # [[0,1336468399.26902,0.200450658798218],1] + # [ + # [ + # 0, + # 1336468399.4695, + # 0.000309467315673828 + # ], + # [ + # [ + # [ + # 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." + # ] + # ] + # ] + # ] + # ] Modified: doc/source/example/tutorial/index-1.log (+22 -23) =================================================================== --- doc/source/example/tutorial/index-1.log 2012-05-08 18:18:08 +0900 (b779fbb) +++ doc/source/example/tutorial/index-1.log 2012-05-08 18:18:28 +0900 (39fa09a) @@ -1,25 +1,24 @@ Execution example:: - > table_create --name Video --flags TABLE_HASH_KEY --key_type UInt32 - [[0,1335519627.03224,0.000266790390014648],true] - > table_create --name Tag --flags TABLE_HASH_KEY --key_type ShortText - [[0,1335519627.23315,0.000222206115722656],true] - > column_create --table Video --name title --flags COLUMN_SCALAR --type ShortText - [[0,1335519627.43389,0.000550031661987305],true] - > column_create --table Video --name tags --flags COLUMN_VECTOR --type Tag - [[0,1335519627.63497,0.000490188598632812],true] - > column_create --table Tag --name index_tags --flags COLUMN_INDEX --type Video --source tags - [[0,1335519627.83602,0.0032198429107666],true] - > load --table Video - > [ - > {"_key":1,"title":"Soccer 2010","tags":["Sports","Soccer"]}, - > {"_key":2,"title":"Zenigata Kinjirou","tags":["Variety","Money"]}, - > {"_key":3,"title":"groonga Demo","tags":["IT","Server","groonga"]}, - > {"_key":4,"title":"Moero!! Ultra Baseball","tags":["Sports","Baseball"]}, - > {"_key":5,"title":"Hex Gone!","tags":["Variety","Quiz"]}, - > {"_key":6,"title":"Pikonyan 1","tags":["Animation","Pikonyan"]}, - > {"_key":7,"title":"Draw 8 Month","tags":["Animation","Raccoon"]}, - > {"_key":8,"title":"K.O.","tags":["Animation","Music"]} - > ] - [[0,1335519628.03974,2.00352549552917],8] - \ No newline at end of file + table_create --name Video --flags TABLE_HASH_KEY --key_type UInt32 + # [[0,1336468408.59485,0.000248908996582031],true] + table_create --name Tag --flags TABLE_HASH_KEY --key_type ShortText + # [[0,1336468408.79565,0.000237226486206055],true] + column_create --table Video --name title --flags COLUMN_SCALAR --type ShortText + # [[0,1336468408.9964,0.000552892684936523],true] + column_create --table Video --name tags --flags COLUMN_VECTOR --type Tag + # [[0,1336468409.19748,0.000529050827026367],true] + column_create --table Tag --name index_tags --flags COLUMN_INDEX --type Video --source tags + # [[0,1336468409.39853,0.00356459617614746],true] + load --table Video + [ + {"_key":1,"title":"Soccer 2010","tags":["Sports","Soccer"]}, + {"_key":2,"title":"Zenigata Kinjirou","tags":["Variety","Money"]}, + {"_key":3,"title":"groonga Demo","tags":["IT","Server","groonga"]}, + {"_key":4,"title":"Moero!! Ultra Baseball","tags":["Sports","Baseball"]}, + {"_key":5,"title":"Hex Gone!","tags":["Variety","Quiz"]}, + {"_key":6,"title":"Pikonyan 1","tags":["Animation","Pikonyan"]}, + {"_key":7,"title":"Draw 8 Month","tags":["Animation","Raccoon"]}, + {"_key":8,"title":"K.O.","tags":["Animation","Music"]} + ] + # [[0,1336468409.60264,0.201507091522217],8] Modified: doc/source/example/tutorial/index-2.log (+103 -104) =================================================================== --- doc/source/example/tutorial/index-2.log 2012-05-08 18:18:08 +0900 (a89e413) +++ doc/source/example/tutorial/index-2.log 2012-05-08 18:18:28 +0900 (ae929aa) @@ -1,106 +1,105 @@ Execution example:: - > select --table Video --query tags:@Variety --output_columns _key,title - [ - [ - 0, - 1335519630.24437, - 0.000667810440063477 - ], - [ - [ - [ - 2 - ], - [ - [ - "_key", - "UInt32" - ], - [ - "title", - "ShortText" - ] - ], - [ - 2, - "Zenigata Kinjirou" - ], - [ - 5, - "Hex Gone!" - ] - ] - ] - ] - > select --table Video --query tags:@Sports --output_columns _key,title - [ - [ - 0, - 1335519630.44675, - 0.000470399856567383 - ], - [ - [ - [ - 2 - ], - [ - [ - "_key", - "UInt32" - ], - [ - "title", - "ShortText" - ] - ], - [ - 1, - "Soccer 2010" - ], - [ - 4, - "Moero!! Ultra Baseball" - ] - ] - ] - ] - > select --table Video --query tags:@Animation --output_columns _key,title - [ - [ - 0, - 1335519630.64889, - 0.000455856323242188 - ], - [ - [ - [ - 3 - ], - [ - [ - "_key", - "UInt32" - ], - [ - "title", - "ShortText" - ] - ], - [ - 6, - "Pikonyan 1" - ], - [ - 7, - "Draw 8 Month" - ], - [ - 8, - "K.O." - ] - ] - ] - ] - \ No newline at end of file + select --table Video --query tags:@Variety --output_columns _key,title + # [ + # [ + # 0, + # 1336468410.00491, + # 0.000417709350585938 + # ], + # [ + # [ + # [ + # 2 + # ], + # [ + # [ + # "_key", + # "UInt32" + # ], + # [ + # "title", + # "ShortText" + # ] + # ], + # [ + # 2, + # "Zenigata Kinjirou" + # ], + # [ + # 5, + # "Hex Gone!" + # ] + # ] + # ] + # ] + select --table Video --query tags:@Sports --output_columns _key,title + # [ + # [ + # 0, + # 1336468410.20624, + # 0.000339508056640625 + # ], + # [ + # [ + # [ + # 2 + # ], + # [ + # [ + # "_key", + # "UInt32" + # ], + # [ + # "title", + # "ShortText" + # ] + # ], + # [ + # 1, + # "Soccer 2010" + # ], + # [ + # 4, + # "Moero!! Ultra Baseball" + # ] + # ] + # ] + # ] + select --table Video --query tags:@Animation --output_columns _key,title + # [ + # [ + # 0, + # 1336468410.40778, + # 0.00030517578125 + # ], + # [ + # [ + # [ + # 3 + # ], + # [ + # [ + # "_key", + # "UInt32" + # ], + # [ + # "title", + # "ShortText" + # ] + # ], + # [ + # 6, + # "Pikonyan 1" + # ], + # [ + # 7, + # "Draw 8 Month" + # ], + # [ + # 8, + # "K.O." + # ] + # ] + # ] + # ] Modified: doc/source/example/tutorial/index-3.log (+18 -19) =================================================================== --- doc/source/example/tutorial/index-3.log 2012-05-08 18:18:08 +0900 (045781b) +++ doc/source/example/tutorial/index-3.log 2012-05-08 18:18:28 +0900 (264d207) @@ -1,21 +1,20 @@ Execution example:: - > table_create --name User --flags TABLE_HASH_KEY --key_type ShortText - [[0,1335519630.85121,0.00020289421081543],true] - > column_create --table User --name username --flags COLUMN_SCALAR --type ShortText - [[0,1335519631.05176,0.00130391120910645],true] - > column_create --table User --name friends --flags COLUMN_VECTOR --type User - [[0,1335519631.25402,0.000970840454101562],true] - > column_create --table User --name index_friends --flags COLUMN_INDEX --type User --source friends - [[0,1335519631.45581,0.00640487670898438],true] - > load --table User - > [ - > {"_key":"ken","username":"健作","friends":["taro","jiro","tomo","moritapo"]} - > {"_key":"moritapo","username":"森田","friends":["ken","tomo"]} - > {"_key":"taro","username":"ぐるんが太郎","friends":["jiro","tomo"]} - > {"_key":"jiro","username":"ぐるんが次郎","friends":["taro","tomo"]} - > {"_key":"tomo","username":"トモちゃん","friends":["ken","hana"]} - > {"_key":"hana","username":"花子","friends":["ken","taro","jiro","moritapo","tomo"]} - > ] - [[0,1335519631.6631,1.60283184051514],6] - \ No newline at end of file + table_create --name User --flags TABLE_HASH_KEY --key_type ShortText + # [[0,1336468410.61002,0.000179052352905273],true] + column_create --table User --name username --flags COLUMN_SCALAR --type ShortText + # [[0,1336468410.81085,0.000480890274047852],true] + column_create --table User --name friends --flags COLUMN_VECTOR --type User + # [[0,1336468411.01181,0.000520944595336914],true] + column_create --table User --name index_friends --flags COLUMN_INDEX --type User --source friends + # [[0,1336468411.21288,0.00342512130737305],true] + load --table User + [ + {"_key":"ken","username":"健作","friends":["taro","jiro","tomo","moritapo"]} + {"_key":"moritapo","username":"森田","friends":["ken","tomo"]} + {"_key":"taro","username":"ぐるんが太郎","friends":["jiro","tomo"]} + {"_key":"jiro","username":"ぐるんが次郎","friends":["taro","tomo"]} + {"_key":"tomo","username":"トモちゃん","friends":["ken","hana"]} + {"_key":"hana","username":"花子","friends":["ken","taro","jiro","moritapo","tomo"]} + ] + # [[0,1336468411.41682,0.201314687728882],6] Modified: doc/source/example/tutorial/index-4.log (+82 -83) =================================================================== --- doc/source/example/tutorial/index-4.log 2012-05-08 18:18:08 +0900 (8bd3ab2) +++ doc/source/example/tutorial/index-4.log 2012-05-08 18:18:28 +0900 (630de4f) @@ -1,85 +1,84 @@ Execution example:: - > select --table User --query friends:@tomo --output_columns _key,username - [ - [ - 0, - 1335519633.46704, - 0.000623941421508789 - ], - [ - [ - [ - 5 - ], - [ - [ - "_key", - "ShortText" - ], - [ - "username", - "ShortText" - ] - ], - [ - "ken", - "健作" - ], - [ - "taro", - "ぐるんが太郎" - ], - [ - "jiro", - "ぐるんが次郎" - ], - [ - "moritapo", - "森田" - ], - [ - "hana", - "花子" - ] - ] - ] - ] - > select --table User --query friends:@jiro --output_columns _key,username - [ - [ - 0, - 1335519633.67028, - 0.000344514846801758 - ], - [ - [ - [ - 3 - ], - [ - [ - "_key", - "ShortText" - ], - [ - "username", - "ShortText" - ] - ], - [ - "ken", - "健作" - ], - [ - "taro", - "ぐるんが太郎" - ], - [ - "hana", - "花子" - ] - ] - ] - ] - \ No newline at end of file + select --table User --query friends:@tomo --output_columns _key,username + # [ + # [ + # 0, + # 1336468411.81889, + # 0.000313997268676758 + # ], + # [ + # [ + # [ + # 5 + # ], + # [ + # [ + # "_key", + # "ShortText" + # ], + # [ + # "username", + # "ShortText" + # ] + # ], + # [ + # "ken", + # "健作" + # ], + # [ + # "taro", + # "ぐるんが太郎" + # ], + # [ + # "jiro", + # "ぐるんが次郎" + # ], + # [ + # "moritapo", + # "森田" + # ], + # [ + # "hana", + # "花子" + # ] + # ] + # ] + # ] + select --table User --query friends:@jiro --output_columns _key,username + # [ + # [ + # 0, + # 1336468412.0203, + # 0.000349998474121094 + # ], + # [ + # [ + # [ + # 3 + # ], + # [ + # [ + # "_key", + # "ShortText" + # ], + # [ + # "username", + # "ShortText" + # ] + # ], + # [ + # "ken", + # "健作" + # ], + # [ + # "taro", + # "ぐるんが太郎" + # ], + # [ + # "hana", + # "花子" + # ] + # ] + # ] + # ] Modified: doc/source/example/tutorial/index-5.log (+76 -77) =================================================================== --- doc/source/example/tutorial/index-5.log 2012-05-08 18:18:08 +0900 (1dec4e2) +++ doc/source/example/tutorial/index-5.log 2012-05-08 18:18:28 +0900 (958741d) @@ -1,79 +1,78 @@ Execution example:: - > select --table User --limit 0 --drilldown friends - [ - [ - 0, - 1335519633.87264, - 0.000327825546264648 - ], - [ - [ - [ - 6 - ], - [ - [ - "_id", - "UInt32" - ], - [ - "_key", - "ShortText" - ], - [ - "friends", - "User" - ], - [ - "index_friends", - "User" - ], - [ - "username", - "ShortText" - ] - ] - ], - [ - [ - 6 - ], - [ - [ - "_key", - "ShortText" - ], - [ - "_nsubrecs", - "Int32" - ] - ], - [ - "taro", - 3 - ], - [ - "jiro", - 3 - ], - [ - "tomo", - 5 - ], - [ - "moritapo", - 2 - ], - [ - "ken", - 3 - ], - [ - "hana", - 1 - ] - ] - ] - ] - \ No newline at end of file + select --table User --limit 0 --drilldown friends + # [ + # [ + # 0, + # 1336468412.22189, + # 0.000318527221679688 + # ], + # [ + # [ + # [ + # 6 + # ], + # [ + # [ + # "_id", + # "UInt32" + # ], + # [ + # "_key", + # "ShortText" + # ], + # [ + # "friends", + # "User" + # ], + # [ + # "index_friends", + # "User" + # ], + # [ + # "username", + # "ShortText" + # ] + # ] + # ], + # [ + # [ + # 6 + # ], + # [ + # [ + # "_key", + # "ShortText" + # ], + # [ + # "_nsubrecs", + # "Int32" + # ] + # ], + # [ + # "taro", + # 3 + # ], + # [ + # "jiro", + # 3 + # ], + # [ + # "tomo", + # 5 + # ], + # [ + # "moritapo", + # 2 + # ], + # [ + # "ken", + # 3 + # ], + # [ + # "hana", + # 1 + # ] + # ] + # ] + # ] Modified: doc/source/example/tutorial/index-6.log (+37 -38) =================================================================== --- doc/source/example/tutorial/index-6.log 2012-05-08 18:18:08 +0900 (e50445d) +++ doc/source/example/tutorial/index-6.log 2012-05-08 18:18:28 +0900 (653eea5) @@ -1,42 +1,41 @@ Execution example:: - > table_create --name GeoIndex --flags TABLE_PAT_KEY --key_type WGS84GeoPoint - [[0,1335519634.07459,0.00024867057800293],true] - > column_create --table GeoIndex --name index_point --type Site --flags COLUMN_INDEX --source location - [[0,1335519634.2754,0.00743818283081055],true] - > load --table Site - > [ - > {"_key":"http://example.org/","location":"128452975x503157902"}, - > {"_key":"http://example.net/","location":"128487316x502920929"} - > ] - [[0,1335519634.48372,0.801371812820435],2] - > select --table Site --filter 'geo_in_circle(location, "128515259x503187188", 5000)' --output_columns _key,location + table_create --name GeoIndex --flags TABLE_PAT_KEY --key_type WGS84GeoPoint + # [[0,1336468412.42386,0.000223398208618164],true] + column_create --table GeoIndex --name index_point --type Site --flags COLUMN_INDEX --source location + # [[0,1336468412.62459,0.00424361228942871],true] + load --table Site [ - [ - 0, - 1335519635.48562, - 0.000363826751708984 - ], - [ - [ - [ - 1 - ], - [ - [ - "_key", - "ShortText" - ], - [ - "location", - "WGS84GeoPoint" - ] - ], - [ - "http://example.org/", - "128452975x503157902" - ] - ] - ] + {"_key":"http://example.org/","location":"128452975x503157902"}, + {"_key":"http://example.net/","location":"128487316x502920929"} ] - \ No newline at end of file + # [[0,1336468412.82931,0.200539588928223],2] + select --table Site --filter 'geo_in_circle(location, "128515259x503187188", 5000)' --output_columns _key,location + # [ + # [ + # 0, + # 1336468413.2306, + # 0.000440359115600586 + # ], + # [ + # [ + # [ + # 1 + # ], + # [ + # [ + # "_key", + # "ShortText" + # ], + # [ + # "location", + # "WGS84GeoPoint" + # ] + # ], + # [ + # "http://example.org/", + # "128452975x503157902" + # ] + # ] + # ] + # ] Modified: doc/source/example/tutorial/index-7.log (+39 -40) =================================================================== --- doc/source/example/tutorial/index-7.log 2012-05-08 18:18:08 +0900 (ef1a2f4) +++ doc/source/example/tutorial/index-7.log 2012-05-08 18:18:28 +0900 (25ce10b) @@ -1,42 +1,41 @@ Execution example:: - > select --table Site --filter 'geo_in_circle(location, "128515259x503187188", 50000)' --output_columns _key,location,_score --sortby '-geo_distance(location, "128515259x503187188")' --scorer '_score = geo_distance(location, "128515259x503187188")' - [ - [ - 0, - 1335519635.68736, - 0.000502824783325195 - ], - [ - [ - [ - 2 - ], - [ - [ - "_key", - "ShortText" - ], - [ - "location", - "WGS84GeoPoint" - ], - [ - "_score", - "Int32" - ] - ], - [ - "http://example.org/", - "128452975x503157902", - 2054 - ], - [ - "http://example.net/", - "128487316x502920929", - 6720 - ] - ] - ] - ] - \ No newline at end of file + select --table Site --filter 'geo_in_circle(location, "128515259x503187188", 50000)' --output_columns _key,location,_score --sortby '-geo_distance(location, "128515259x503187188")' --scorer '_score = geo_distance(location, "128515259x503187188")' + # [ + # [ + # 0, + # 1336468413.43257, + # 0.000459194183349609 + # ], + # [ + # [ + # [ + # 2 + # ], + # [ + # [ + # "_key", + # "ShortText" + # ], + # [ + # "location", + # "WGS84GeoPoint" + # ], + # [ + # "_score", + # "Int32" + # ] + # ], + # [ + # "http://example.org/", + # "128452975x503157902", + # 2054 + # ], + # [ + # "http://example.net/", + # "128487316x502920929", + # 6720 + # ] + # ] + # ] + # ] Modified: doc/source/example/tutorial/match_columns-1.log (+19 -20) =================================================================== --- doc/source/example/tutorial/match_columns-1.log 2012-05-08 18:18:08 +0900 (7ad9ef8) +++ doc/source/example/tutorial/match_columns-1.log 2012-05-08 18:18:28 +0900 (9061ffa) @@ -1,22 +1,21 @@ Execution example:: - > table_create --name Blog1 --flags TABLE_HASH_KEY --key_type ShortText - [[0,1335519613.90326,0.00016021728515625],true] - > column_create --table Blog1 --name title --flags COLUMN_SCALAR --type ShortText - [[0,1335519614.10411,0.00106573104858398],true] - > column_create --table Blog1 --name message --flags COLUMN_SCALAR --type ShortText - [[0,1335519614.30595,0.00101113319396973],true] - > table_create --name IndexBlog1 --flags TABLE_PAT_KEY|KEY_NORMALIZE --key_type ShortText --default_tokenizer TokenBigram - [[0,1335519614.50779,0.000327587127685547],true] - > column_create --table IndexBlog1 --name index_title --flags COLUMN_INDEX|WITH_POSITION --type Blog1 --source title - [[0,1335519614.70891,0.00641822814941406],true] - > column_create --table IndexBlog1 --name index_message --flags COLUMN_INDEX|WITH_POSITION --type Blog1 --source message - [[0,1335519614.91621,0.00670051574707031],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,1335519615.1238,1.00167393684387],3] - \ No newline at end of file + table_create --name Blog1 --flags TABLE_HASH_KEY --key_type ShortText + # [[0,1336468399.6861,0.000176429748535156],true] + column_create --table Blog1 --name title --flags COLUMN_SCALAR --type ShortText + # [[0,1336468399.88692,0.000572443008422852],true] + column_create --table Blog1 --name message --flags COLUMN_SCALAR --type ShortText + # [[0,1336468400.08803,0.000512361526489258],true] + table_create --name IndexBlog1 --flags TABLE_PAT_KEY|KEY_NORMALIZE --key_type ShortText --default_tokenizer TokenBigram + # [[0,1336468400.28907,0.000239133834838867],true] + column_create --table IndexBlog1 --name index_title --flags COLUMN_INDEX|WITH_POSITION --type Blog1 --source title + # [[0,1336468400.48983,0.00376629829406738],true] + column_create --table IndexBlog1 --name index_message --flags COLUMN_INDEX|WITH_POSITION --type Blog1 --source message + # [[0,1336468400.69408,0.00344538688659668],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,1336468400.89804,0.202517986297607],3] Modified: doc/source/example/tutorial/match_columns-2.log (+135 -136) =================================================================== --- doc/source/example/tutorial/match_columns-2.log 2012-05-08 18:18:08 +0900 (6025800) +++ doc/source/example/tutorial/match_columns-2.log 2012-05-08 18:18:28 +0900 (9e81b80) @@ -1,138 +1,137 @@ Execution example:: - > select --table Blog1 --match_columns title||message --query groonga - [ - [ - 0, - 1335519616.32664, - 0.00108003616333008 - ], - [ - [ - [ - 3 - ], - [ - [ - "_id", - "UInt32" - ], - [ - "_key", - "ShortText" - ], - [ - "message", - "ShortText" - ], - [ - "title", - "ShortText" - ] - ], - [ - 1, - "grn1", - "groonga message", - "groonga test" - ], - [ - 3, - "grn3", - "none", - "groonga message" - ], - [ - 2, - "grn2", - "rakutan eggs 4 - 4 groonga moritars", - "baseball result" - ] - ] - ] - ] - > select --table Blog1 --match_columns title||message --query message - [ - [ - 0, - 1335519616.5306, - 0.000397920608520508 - ], - [ - [ - [ - 2 - ], - [ - [ - "_id", - "UInt32" - ], - [ - "_key", - "ShortText" - ], - [ - "message", - "ShortText" - ], - [ - "title", - "ShortText" - ] - ], - [ - 3, - "grn3", - "none", - "groonga message" - ], - [ - 1, - "grn1", - "groonga message", - "groonga test" - ] - ] - ] - ] - > select --table Blog1 --match_columns title --query message - [ - [ - 0, - 1335519616.73219, - 0.000369548797607422 - ], - [ - [ - [ - 1 - ], - [ - [ - "_id", - "UInt32" - ], - [ - "_key", - "ShortText" - ], - [ - "message", - "ShortText" - ], - [ - "title", - "ShortText" - ] - ], - [ - 3, - "grn3", - "none", - "groonga message" - ] - ] - ] - ] - \ No newline at end of file + select --table Blog1 --match_columns title||message --query groonga + # [ + # [ + # 0, + # 1336468401.3015, + # 0.000590324401855469 + # ], + # [ + # [ + # [ + # 3 + # ], + # [ + # [ + # "_id", + # "UInt32" + # ], + # [ + # "_key", + # "ShortText" + # ], + # [ + # "message", + # "ShortText" + # ], + # [ + # "title", + # "ShortText" + # ] + # ], + # [ + # 1, + # "grn1", + # "groonga message", + # "groonga test" + # ], + # [ + # 3, + # "grn3", + # "none", + # "groonga message" + # ], + # [ + # 2, + # "grn2", + # "rakutan eggs 4 - 4 groonga moritars", + # "baseball result" + # ] + # ] + # ] + # ] + select --table Blog1 --match_columns title||message --query message + # [ + # [ + # 0, + # 1336468401.5036, + # 0.000405550003051758 + # ], + # [ + # [ + # [ + # 2 + # ], + # [ + # [ + # "_id", + # "UInt32" + # ], + # [ + # "_key", + # "ShortText" + # ], + # [ + # "message", + # "ShortText" + # ], + # [ + # "title", + # "ShortText" + # ] + # ], + # [ + # 3, + # "grn3", + # "none", + # "groonga message" + # ], + # [ + # 1, + # "grn1", + # "groonga message", + # "groonga test" + # ] + # ] + # ] + # ] + select --table Blog1 --match_columns title --query message + # [ + # [ + # 0, + # 1336468401.70521, + # 0.000378131866455078 + # ], + # [ + # [ + # [ + # 1 + # ], + # [ + # [ + # "_id", + # "UInt32" + # ], + # [ + # "_key", + # "ShortText" + # ], + # [ + # "message", + # "ShortText" + # ], + # [ + # "title", + # "ShortText" + # ] + # ], + # [ + # 3, + # "grn3", + # "none", + # "groonga message" + # ] + # ] + # ] + # ] Modified: doc/source/example/tutorial/match_columns-3.log (+17 -18) =================================================================== --- doc/source/example/tutorial/match_columns-3.log 2012-05-08 18:18:08 +0900 (8b28f6d) +++ doc/source/example/tutorial/match_columns-3.log 2012-05-08 18:18:28 +0900 (ea81ede) @@ -1,20 +1,19 @@ Execution example:: - > table_create --name Blog2 --flags TABLE_HASH_KEY --key_type ShortText - [[0,1335519616.93386,0.000204801559448242],true] - > column_create --table Blog2 --name title --flags COLUMN_SCALAR --type ShortText - [[0,1335519617.13462,0.000517606735229492],true] - > column_create --table Blog2 --name message --flags COLUMN_SCALAR --type ShortText - [[0,1335519617.33589,0.000973939895629883],true] - > table_create --name IndexBlog2 --flags TABLE_PAT_KEY|KEY_NORMALIZE --key_type ShortText --default_tokenizer TokenBigram - [[0,1335519617.53761,0.000263690948486328],true] - > column_create --table IndexBlog2 --name index_blog --flags COLUMN_INDEX|WITH_POSITION|WITH_SECTION --type Blog2 --source title,message - [[0,1335519617.73843,0.00370573997497559],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,1335519617.94267,1.00162434577942],3] - \ No newline at end of file + table_create --name Blog2 --flags TABLE_HASH_KEY --key_type ShortText + # [[0,1336468401.90693,0.000187397003173828],true] + column_create --table Blog2 --name title --flags COLUMN_SCALAR --type ShortText + # [[0,1336468402.10767,0.000550508499145508],true] + column_create --table Blog2 --name message --flags COLUMN_SCALAR --type ShortText + # [[0,1336468402.30881,0.00057530403137207],true] + table_create --name IndexBlog2 --flags TABLE_PAT_KEY|KEY_NORMALIZE --key_type ShortText --default_tokenizer TokenBigram + # [[0,1336468402.50999,0.000248193740844727],true] + column_create --table IndexBlog2 --name index_blog --flags COLUMN_INDEX|WITH_POSITION|WITH_SECTION --type Blog2 --source title,message + # [[0,1336468402.71084,0.00389933586120605],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,1336468402.91537,0.201383829116821],3] Modified: doc/source/example/tutorial/match_columns-4.log (+135 -136) =================================================================== --- doc/source/example/tutorial/match_columns-4.log 2012-05-08 18:18:08 +0900 (eef9280) +++ doc/source/example/tutorial/match_columns-4.log 2012-05-08 18:18:28 +0900 (6556fac) @@ -1,138 +1,137 @@ Execution example:: - > select --table Blog2 --match_columns title||message --query groonga - [ - [ - 0, - 1335519619.14503, - 0.000397443771362305 - ], - [ - [ - [ - 3 - ], - [ - [ - "_id", - "UInt32" - ], - [ - "_key", - "ShortText" - ], - [ - "message", - "ShortText" - ], - [ - "title", - "ShortText" - ] - ], - [ - 1, - "grn1", - "groonga message", - "groonga test" - ], - [ - 2, - "grn2", - "rakutan eggs 4 - 4 groonga moritars", - "baseball result" - ], - [ - 3, - "grn3", - "none", - "groonga message" - ] - ] - ] - ] - > select --table Blog2 --match_columns title||message --query message - [ - [ - 0, - 1335519619.34666, - 0.000356435775756836 - ], - [ - [ - [ - 2 - ], - [ - [ - "_id", - "UInt32" - ], - [ - "_key", - "ShortText" - ], - [ - "message", - "ShortText" - ], - [ - "title", - "ShortText" - ] - ], - [ - 1, - "grn1", - "groonga message", - "groonga test" - ], - [ - 3, - "grn3", - "none", - "groonga message" - ] - ] - ] - ] - > select --table Blog2 --match_columns title --query message - [ - [ - 0, - 1335519619.54817, - 0.000360250473022461 - ], - [ - [ - [ - 1 - ], - [ - [ - "_id", - "UInt32" - ], - [ - "_key", - "ShortText" - ], - [ - "message", - "ShortText" - ], - [ - "title", - "ShortText" - ] - ], - [ - 3, - "grn3", - "none", - "groonga message" - ] - ] - ] - ] - \ No newline at end of file + select --table Blog2 --match_columns title||message --query groonga + # [ + # [ + # 0, + # 1336468403.31753, + # 0.000391006469726562 + # ], + # [ + # [ + # [ + # 3 + # ], + # [ + # [ + # "_id", + # "UInt32" + # ], + # [ + # "_key", + # "ShortText" + # ], + # [ + # "message", + # "ShortText" + # ], + # [ + # "title", + # "ShortText" + # ] + # ], + # [ + # 1, + # "grn1", + # "groonga message", + # "groonga test" + # ], + # [ + # 2, + # "grn2", + # "rakutan eggs 4 - 4 groonga moritars", + # "baseball result" + # ], + # [ + # 3, + # "grn3", + # "none", + # "groonga message" + # ] + # ] + # ] + # ] + select --table Blog2 --match_columns title||message --query message + # [ + # [ + # 0, + # 1336468403.51936, + # 0.00037837028503418 + # ], + # [ + # [ + # [ + # 2 + # ], + # [ + # [ + # "_id", + # "UInt32" + # ], + # [ + # "_key", + # "ShortText" + # ], + # [ + # "message", + # "ShortText" + # ], + # [ + # "title", + # "ShortText" + # ] + # ], + # [ + # 1, + # "grn1", + # "groonga message", + # "groonga test" + # ], + # [ + # 3, + # "grn3", + # "none", + # "groonga message" + # ] + # ] + # ] + # ] + select --table Blog2 --match_columns title --query message + # [ + # [ + # 0, + # 1336468403.72081, + # 0.000359535217285156 + # ], + # [ + # [ + # [ + # 1 + # ], + # [ + # [ + # "_id", + # "UInt32" + # ], + # [ + # "_key", + # "ShortText" + # ], + # [ + # "message", + # "ShortText" + # ], + # [ + # "title", + # "ShortText" + # ] + # ], + # [ + # 3, + # "grn3", + # "none", + # "groonga message" + # ] + # ] + # ] + # ] Modified: doc/source/example/tutorial/micro_blog-1.log (+57 -34) =================================================================== --- doc/source/example/tutorial/micro_blog-1.log 2012-05-08 18:18:08 +0900 (84d3b06) +++ doc/source/example/tutorial/micro_blog-1.log 2012-05-08 18:18:28 +0900 (8df8e9e) @@ -1,36 +1,59 @@ Execution example:: - > select --table Users --match_columns name,location_str,description --query 東京 --output_columns _key,name - [ - [ - 0, - 1335519659.99711, - 0.000482797622680664 - ], - [ - [ - [ - 2 - ], - [ - [ - "_key", - "ShortText" - ], - [ - "name", - "ShortText" - ] - ], - [ - "tasukuchan", - "グニャラくん" - ], - [ - "OffGao", - "OffGao" - ] - ] - ] - ] - \ No newline at end of file + select --table Users --match_columns name,location_str,description --query 東京 --output_columns _key,name + # [[0,1336468413.65365,0.000164031982421875],true] + # [[0,1336468413.65387,0.000146865844726562],true] + # [[0,1336468413.65403,0.000139474868774414],true] + # [[0,1336468413.65418,0.000150680541992188],true] + # [[0,1336468413.65435,0.000566482543945312],true] + # [[0,1336468413.65515,0.000523567199707031],true] + # [[0,1336468413.65569,0.000493526458740234],true] + # [[0,1336468413.65619,0.000108957290649414],true] + # [[0,1336468413.65632,0.000498056411743164],true] + # [[0,1336468413.65683,0.00047755241394043],true] + # [[0,1336468413.65732,0.00335407257080078],true] + # [[0,1336468413.6607,0.000487565994262695],true] + # [[0,1336468413.6612,9.20295715332031e-05],true] + # [[0,1336468413.66132,8.46385955810547e-05],true] + # [[0,1336468413.66141,0.000533342361450195],true] + # [[0,1336468413.66215,0.000516414642333984],true] + # [[0,1336468413.66289,9.79900360107422e-05],true] + # [[0,1336468413.66321,8.32080841064453e-05],true] + # [[0,1336468413.66352,0.0038611888885498],true] + # [[0,1336468413.66749,0.00368213653564453],true] + # [[0,1336468413.67146,0.00414204597473145],true] + # [[0,1336468413.6759,0.00406765937805176],true] + # [[0,1336468413.68002,0.00325989723205566],3] + # [[0,1336468413.68367,0.00261378288269043],8] + # [ + # [ + # 0, + # 1336468413.6863, + # 0.000454187393188477 + # ], + # [ + # [ + # [ + # 2 + # ], + # [ + # [ + # "_key", + # "ShortText" + # ], + # [ + # "name", + # "ShortText" + # ] + # ], + # [ + # "tasukuchan", + # "グニャラくん" + # ], + # [ + # "OffGao", + # "OffGao" + # ] + # ] + # ] + # ] Modified: doc/source/example/tutorial/micro_blog-10.log (+96 -97) =================================================================== --- doc/source/example/tutorial/micro_blog-10.log 2012-05-08 18:18:08 +0900 (8defcec) +++ doc/source/example/tutorial/micro_blog-10.log 2012-05-08 18:18:28 +0900 (c96b1e7) @@ -1,99 +1,98 @@ Execution example:: - > select Comments --filter 'last_modified<=1268802000' --output_columns posted_by.name,comment,last_modified --drilldown hash_tags,posted_by - [ - [ - 0, - 1335519661.82081, - 0.000457286834716797 - ], - [ - [ - [ - 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 + select Comments --filter 'last_modified<=1268802000' --output_columns posted_by.name,comment,last_modified --drilldown hash_tags,posted_by + # [ + # [ + # 0, + # 1336468415.50436, + # 0.000488042831420898 + # ], + # [ + # [ + # [ + # 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 + # ] + # ] + # ] + # ] Modified: doc/source/example/tutorial/micro_blog-2.log (+33 -34) =================================================================== --- doc/source/example/tutorial/micro_blog-2.log 2012-05-08 18:18:08 +0900 (67c6815) +++ doc/source/example/tutorial/micro_blog-2.log 2012-05-08 18:18:28 +0900 (7ea3b22) @@ -1,36 +1,35 @@ Execution example:: - > select --table Users --filter 'geo_in_circle(location,"128484216x502919856",5000)' --output_columns _key,name - [ - [ - 0, - 1335519660.19891, - 0.000342607498168945 - ], - [ - [ - [ - 2 - ], - [ - [ - "_key", - "ShortText" - ], - [ - "name", - "ShortText" - ] - ], - [ - "tasukuchan", - "グニャラくん" - ], - [ - "OffGao", - "OffGao" - ] - ] - ] - ] - \ No newline at end of file + select --table Users --filter 'geo_in_circle(location,"128484216x502919856",5000)' --output_columns _key,name + # [ + # [ + # 0, + # 1336468413.88813, + # 0.000306844711303711 + # ], + # [ + # [ + # [ + # 2 + # ], + # [ + # [ + # "_key", + # "ShortText" + # ], + # [ + # "name", + # "ShortText" + # ] + # ], + # [ + # "tasukuchan", + # "グニャラくん" + # ], + # [ + # "OffGao", + # "OffGao" + # ] + # ] + # ] + # ] Modified: doc/source/example/tutorial/micro_blog-3.log (+33 -34) =================================================================== --- doc/source/example/tutorial/micro_blog-3.log 2012-05-08 18:18:08 +0900 (528e6c9) +++ doc/source/example/tutorial/micro_blog-3.log 2012-05-08 18:18:28 +0900 (572fe6c) @@ -1,36 +1,35 @@ Execution example:: - > select --table Users --query follower:@tasukuchan --output_columns _key,name - [ - [ - 0, - 1335519660.40055, - 0.000302791595458984 - ], - [ - [ - [ - 2 - ], - [ - [ - "_key", - "ShortText" - ], - [ - "name", - "ShortText" - ] - ], - [ - "daijiro", - "hsiomaneki" - ], - [ - "OffGao", - "OffGao" - ] - ] - ] - ] - \ No newline at end of file + select --table Users --query follower:@tasukuchan --output_columns _key,name + # [ + # [ + # 0, + # 1336468414.08964, + # 0.000273466110229492 + # ], + # [ + # [ + # [ + # 2 + # ], + # [ + # [ + # "_key", + # "ShortText" + # ], + # [ + # "name", + # "ShortText" + # ] + # ], + # [ + # "daijiro", + # "hsiomaneki" + # ], + # [ + # "OffGao", + # "OffGao" + # ] + # ] + # ] + # ] Modified: doc/source/example/tutorial/micro_blog-4.log (+87 -88) =================================================================== --- doc/source/example/tutorial/micro_blog-4.log 2012-05-08 18:18:08 +0900 (9bccda0) +++ doc/source/example/tutorial/micro_blog-4.log 2012-05-08 18:18:28 +0900 (1192b13) @@ -1,90 +1,89 @@ Execution example:: - > select --table Comments --filter 'geo_in_circle(location,"127975798x502919856",20000)' --output_columns posted_by.name,comment --drilldown hash_tags,posted_by - [ - [ - 0, - 1335519660.60211, - 0.00048828125 - ], - [ - [ - [ - 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 + select --table Comments --filter 'geo_in_circle(location,"127975798x502919856",20000)' --output_columns posted_by.name,comment --drilldown hash_tags,posted_by + # [ + # [ + # 0, + # 1336468414.29108, + # 0.000583171844482422 + # ], + # [ + # [ + # [ + # 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 + # ] + # ] + # ] + # ] Modified: doc/source/example/tutorial/micro_blog-5.log (+33 -34) =================================================================== --- doc/source/example/tutorial/micro_blog-5.log 2012-05-08 18:18:08 +0900 (732cf56) +++ doc/source/example/tutorial/micro_blog-5.log 2012-05-08 18:18:28 +0900 (c33b134) @@ -1,36 +1,35 @@ Execution example:: - > select --table Comments --query comment:@なう --output_columns comment,_score - [ - [ - 0, - 1335519660.80493, - 0.000359296798706055 - ], - [ - [ - [ - 2 - ], - [ - [ - "comment", - "ShortText" - ], - [ - "_score", - "Int32" - ] - ], - [ - "groongaなう #groonga", - 1 - ], - [ - "中野ブロードウェイなうなう", - 2 - ] - ] - ] - ] - \ No newline at end of file + select --table Comments --query comment:@なう --output_columns comment,_score + # [ + # [ + # 0, + # 1336468414.49473, + # 0.000291824340820312 + # ], + # [ + # [ + # [ + # 2 + # ], + # [ + # [ + # "comment", + # "ShortText" + # ], + # [ + # "_score", + # "Int32" + # ] + # ], + # [ + # "groongaなう #groonga", + # 1 + # ], + # [ + # "中野ブロードウェイなうなう", + # 2 + # ] + # ] + # ] + # ] Modified: doc/source/example/tutorial/micro_blog-6.log (+71 -72) =================================================================== --- doc/source/example/tutorial/micro_blog-6.log 2012-05-08 18:18:08 +0900 (23fb055) +++ doc/source/example/tutorial/micro_blog-6.log 2012-05-08 18:18:28 +0900 (e3f0579) @@ -1,74 +1,73 @@ Execution example:: - > select --table Comments --query comment:@羽田 --filter 'geo_in_circle(location,"127975798x502919856",20000)' --output_columns posted_by.name,comment --drilldown hash_tags,posted_by - [ - [ - 0, - 1335519661.00659, - 0.000471353530883789 - ], - [ - [ - [ - 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 + select --table Comments --query comment:@羽田 --filter 'geo_in_circle(location,"127975798x502919856",20000)' --output_columns posted_by.name,comment --drilldown hash_tags,posted_by + # [ + # [ + # 0, + # 1336468414.69623, + # 0.000463008880615234 + # ], + # [ + # [ + # [ + # 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 + # ] + # ] + # ] + # ] Modified: doc/source/example/tutorial/micro_blog-7.log (+52 -53) =================================================================== --- doc/source/example/tutorial/micro_blog-7.log 2012-05-08 18:18:08 +0900 (ddb7270) +++ doc/source/example/tutorial/micro_blog-7.log 2012-05-08 18:18:28 +0900 (c21dfff) @@ -1,55 +1,54 @@ Execution example:: - > select --table Comments --query hash_tags:@groonga --output_columns posted_by.name,comment --drilldown posted_by - [ - [ - 0, - 1335519661.2089, - 0.000585079193115234 - ], - [ - [ - [ - 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 + select --table Comments --query hash_tags:@groonga --output_columns posted_by.name,comment --drilldown posted_by + # [ + # [ + # 0, + # 1336468414.8984, + # 0.00037074089050293 + # ], + # [ + # [ + # [ + # 2 + # ], + # [ + # [ + # "posted_by.name", + # "ShortText" + # ], + # [ + # "comment", + # "ShortText" + # ] + # ], + # [ + # "グニャラくん", + # "groongaなう #groonga" + # ], + # [ + # "グニャラくん", + # "groonga開発合宿のため羽田空港に来ました! #groonga #travel" + # ] + # ], + # [ + # [ + # 1 + # ], + # [ + # [ + # "_key", + # "ShortText" + # ], + # [ + # "_nsubrecs", + # "Int32" + # ] + # ], + # [ + # "tasukuchan", + # 2 + # ] + # ] + # ] + # ] Modified: doc/source/example/tutorial/micro_blog-8.log (+56 -57) =================================================================== --- doc/source/example/tutorial/micro_blog-8.log 2012-05-08 18:18:08 +0900 (9c21e79) +++ doc/source/example/tutorial/micro_blog-8.log 2012-05-08 18:18:28 +0900 (7e1e367) @@ -1,59 +1,58 @@ Execution example:: - > select --table Comments --query posted_by:tasukuchan --output_columns comment --drilldown hash_tags - [ - [ - 0, - 1335519661.41271, - 0.000678777694702148 - ], - [ - [ - [ - 4 - ], - [ - [ - "comment", - "ShortText" - ] - ], - [ - "初の書き込み。テストテスト。" - ], - [ - "@daijiro ありがとう!" - ], - [ - "groongaなう #groonga" - ], - [ - "groonga開発合宿のため羽田空港に来ました! #groonga #travel" - ] - ], - [ - [ - 2 - ], - [ - [ - "_key", - "ShortText" - ], - [ - "_nsubrecs", - "Int32" - ] - ], - [ - "groonga", - 2 - ], - [ - "travel", - 1 - ] - ] - ] - ] - \ No newline at end of file + select --table Comments --query posted_by:tasukuchan --output_columns comment --drilldown hash_tags + # [ + # [ + # 0, + # 1336468415.10035, + # 0.000369787216186523 + # ], + # [ + # [ + # [ + # 4 + # ], + # [ + # [ + # "comment", + # "ShortText" + # ] + # ], + # [ + # "初の書き込み。テストテスト。" + # ], + # [ + # "@daijiro ありがとう!" + # ], + # [ + # "groongaなう #groonga" + # ], + # [ + # "groonga開発合宿のため羽田空港に来ました! #groonga #travel" + # ] + # ], + # [ + # [ + # 2 + # ], + # [ + # [ + # "_key", + # "ShortText" + # ], + # [ + # "_nsubrecs", + # "Int32" + # ] + # ], + # [ + # "groonga", + # 2 + # ], + # [ + # "travel", + # 1 + # ] + # ] + # ] + # ] Modified: doc/source/example/tutorial/micro_blog-9.log (+35 -36) =================================================================== --- doc/source/example/tutorial/micro_blog-9.log 2012-05-08 18:18:08 +0900 (2ed2400) +++ doc/source/example/tutorial/micro_blog-9.log 2012-05-08 18:18:28 +0900 (c66855e) @@ -1,38 +1,37 @@ Execution example:: - > select --table Users --query _key:tasukuchan --output_columns favorites.posted_by,favorites.comment - [ - [ - 0, - 1335519661.61696, - 0.000443696975708008 - ], - [ - [ - [ - 1 - ], - [ - [ - "favorites.posted_by", - "Users" - ], - [ - "favorites.comment", - "ShortText" - ] - ], - [ - [ - "daijiro", - "OffGao" - ], - [ - "マイクロブログ作ってみました(甘栗むいちゃいました的な感じで)。", - "@daijiro @tasukuchan 登録してみましたよー!" - ] - ] - ] - ] - ] - \ No newline at end of file + select --table Users --query _key:tasukuchan --output_columns favorites.posted_by,favorites.comment + # [ + # [ + # 0, + # 1336468415.3025, + # 0.000294923782348633 + # ], + # [ + # [ + # [ + # 1 + # ], + # [ + # [ + # "favorites.posted_by", + # "Users" + # ], + # [ + # "favorites.comment", + # "ShortText" + # ] + # ], + # [ + # [ + # "daijiro", + # "OffGao" + # ], + # [ + # "マイクロブログ作ってみました(甘栗むいちゃいました的な感じで)。", + # "@daijiro @tasukuchan 登録してみましたよー!" + # ] + # ] + # ] + # ] + # ] Modified: doc/source/example/tutorial/network-1.log (+21 -21) =================================================================== --- doc/source/example/tutorial/network-1.log 2012-05-08 18:18:08 +0900 (e6875fc) +++ doc/source/example/tutorial/network-1.log 2012-05-08 18:18:28 +0900 (03c1f6b) @@ -1,25 +1,25 @@ Execution example:: - % groonga -c - > status - [ - [ - 0, - 1335519662.04579, - 5.79357147216797e-05 - ], - { - "uptime": 0, - "max_command_version": 2, - "n_queries": 0, - "cache_hit_rate": 0.0, - "version": "2.0.1-283-g3f815e2", - "alloc_count": 130, - "command_version": 1, - "starttime": 1335519662, - "default_command_version": 1 - } - ] - > ctrl-d +% groonga -c + status + # [ + # [ + # 0, + # 1336468415.72543, + # 6.19888305664062e-05 + # ], + # { + # "uptime": 0, + # "max_command_version": 2, + # "n_queries": 0, + # "cache_hit_rate": 0.0, + # "version": "2.0.2-28-g74fc93a", + # "alloc_count": 130, + # "command_version": 1, + # "starttime": 1336468415, + # "default_command_version": 1 + # } + # ] +> ctrl-d % \ No newline at end of file Modified: doc/source/example/tutorial/network-2.log (+1 -1) =================================================================== --- doc/source/example/tutorial/network-2.log 2012-05-08 18:18:08 +0900 (d60fd97) +++ doc/source/example/tutorial/network-2.log 2012-05-08 18:18:28 +0900 (186f941) @@ -1,6 +1,6 @@ Execution example:: - % groonga -c +% groonga -c > shutdown % \ No newline at end of file Modified: doc/source/example/tutorial/network-3.log (+84 -85) =================================================================== --- doc/source/example/tutorial/network-3.log 2012-05-08 18:18:08 +0900 (5854972) +++ doc/source/example/tutorial/network-3.log 2012-05-08 18:18:28 +0900 (bf81133) @@ -1,90 +1,89 @@ Execution example:: - http://HOST_NAME_OR_IP_ADDRESS[:PORT_NUMBER]/d/status +http://HOST_NAME_OR_IP_ADDRESS[:PORT_NUMBER]/d/status Executed command: - > status - [ - [ - 0, - 1335519662.24808, - 9.918212890625e-05 - ], - { - "uptime": 0, - "max_command_version": 2, - "n_queries": 0, - "cache_hit_rate": 0.0, - "version": "2.0.1-283-g3f815e2", - "alloc_count": 131, - "command_version": 1, - "starttime": 1335519662, - "default_command_version": 1 - } - ] - + status + # [ + # [ + # 0, + # 1336468415.92706, + # 6.43730163574219e-05 + # ], + # { + # "uptime": 0, + # "max_command_version": 2, + # "n_queries": 0, + # "cache_hit_rate": 0.0, + # "version": "2.0.2-28-g74fc93a", + # "alloc_count": 131, + # "command_version": 1, + # "starttime": 1336468415, + # "default_command_version": 1 + # } + # ] + http://HOST_NAME_OR_IP_ADDRESS[:PORT_NUMBER]/d/select?table=Site&query=title:@this Executed command: - > select --table Site --query title:@this - [ - [ - 0, - 1335519662.45038, - 0.00197672843933105 - ], - [ - [ - [ - 1 - ], - [ - [ - "_id", - "UInt32" - ], - [ - "_key", - "ShortText" - ], - [ - "country", - "SiteCountry" - ], - [ - "domain", - "SiteDomain" - ], - [ - "link", - "Site" - ], - [ - "links", - "Site" - ], - [ - "location", - "WGS84GeoPoint" - ], - [ - "title", - "ShortText" - ] - ], - [ - 1, - "http://example.org/", - "japan", - ".org", - "http://example.net/", - [ - "http://example.net/", - "http://example.org/", - "http://example.com/" - ], - "128452975x503157902", - "This is test record 1!" - ] - ] - ] - ] - \ No newline at end of file + select --table Site --query title:@this + # [ + # [ + # 0, + # 1336468416.12826, + # 0.00135111808776855 + # ], + # [ + # [ + # [ + # 1 + # ], + # [ + # [ + # "_id", + # "UInt32" + # ], + # [ + # "_key", + # "ShortText" + # ], + # [ + # "country", + # "SiteCountry" + # ], + # [ + # "domain", + # "SiteDomain" + # ], + # [ + # "link", + # "Site" + # ], + # [ + # "links", + # "Site" + # ], + # [ + # "location", + # "WGS84GeoPoint" + # ], + # [ + # "title", + # "ShortText" + # ] + # ], + # [ + # 1, + # "http://example.org/", + # "japan", + # ".org", + # "http://example.net/", + # [ + # "http://example.net/", + # "http://example.org/", + # "http://example.com/" + # ], + # "128452975x503157902", + # "This is test record 1!" + # ] + # ] + # ] + # ] Modified: doc/source/example/tutorial/patricia_trie-1.log (+40 -41) =================================================================== --- doc/source/example/tutorial/patricia_trie-1.log 2012-05-08 18:18:08 +0900 (9640058) +++ doc/source/example/tutorial/patricia_trie-1.log 2012-05-08 18:18:28 +0900 (e1b17c6) @@ -1,45 +1,44 @@ Execution example:: - > table_create --name PatPrefix --flags TABLE_PAT_KEY --key_type ShortText - [[0,1335519594.52747,0.000475168228149414],true] - > load --table PatPrefix - > [ - > {"_key":"ひろゆき"}, - > {"_key":"まろゆき"}, - > {"_key":"ひろあき"} - > ] - [[0,1335519594.72892,1.00176382064819],3] - > select --table PatPrefix --query _key:@ひろ + table_create --name PatPrefix --flags TABLE_PAT_KEY --key_type ShortText + # [[0,1336468387.77833,0.000189781188964844],true] + load --table PatPrefix [ - [ - 0, - 1335519595.93126, - 0.00059962272644043 - ], - [ - [ - [ - 2 - ], - [ - [ - "_id", - "UInt32" - ], - [ - "_key", - "ShortText" - ] - ], - [ - 3, - "ひろあき" - ], - [ - 1, - "ひろゆき" - ] - ] - ] + {"_key":"ひろゆき"}, + {"_key":"まろゆき"}, + {"_key":"ひろあき"} ] - \ No newline at end of file + # [[0,1336468387.97908,0.200587749481201],3] + select --table PatPrefix --query _key:@ひろ + # [ + # [ + # 0, + # 1336468388.38016, + # 0.000479698181152344 + # ], + # [ + # [ + # [ + # 2 + # ], + # [ + # [ + # "_id", + # "UInt32" + # ], + # [ + # "_key", + # "ShortText" + # ] + # ], + # [ + # 3, + # "ひろあき" + # ], + # [ + # 1, + # "ひろゆき" + # ] + # ] + # ] + # ] Modified: doc/source/example/tutorial/patricia_trie-2.log (+97 -98) =================================================================== --- doc/source/example/tutorial/patricia_trie-2.log 2012-05-08 18:18:08 +0900 (6ffdaa6) +++ doc/source/example/tutorial/patricia_trie-2.log 2012-05-08 18:18:28 +0900 (790fc11) @@ -1,102 +1,101 @@ Execution example:: - > table_create --name PatSuffix --flags TABLE_PAT_KEY|KEY_WITH_SIS --key_type ShortText - [[0,1335519596.13342,0.000287294387817383],true] - > column_create --table PatSuffix --name original --type Bool - [[0,1335519596.33446,0.000329494476318359],true] - > load --table PatSuffix - > [ - > {"_key":"ひろゆき","original":true}, - > {"_key":"まろゆき","original":true}, - > {"_key":"ひろあき","original":true} - > ] - [[0,1335519596.53576,1.00176548957825],3] - > select --table PatSuffix --query _key:@ゆき + table_create --name PatSuffix --flags TABLE_PAT_KEY|KEY_WITH_SIS --key_type ShortText + # [[0,1336468388.5819,0.000212192535400391],true] + column_create --table PatSuffix --name original --type Bool + # [[0,1336468388.78261,0.000191450119018555],true] + load --table PatSuffix [ - [ - 0, - 1335519597.73837, - 0.000630855560302734 - ], - [ - [ - [ - 4 - ], - [ - [ - "_id", - "UInt32" - ], - [ - "_key", - "ShortText" - ], - [ - "original", - "Bool" - ] - ], - [ - 1, - "ひろゆき", - true - ], - [ - 5, - "まろゆき", - true - ], - [ - 3, - "ゆき", - false - ], - [ - 2, - "ろゆき", - false - ] - ] - ] + {"_key":"ひろゆき","original":true}, + {"_key":"まろゆき","original":true}, + {"_key":"ひろあき","original":true} ] - > select --table PatSuffix --query "_key:@ゆき original:true" - [ - [ - 0, - 1335519597.94114, - 0.000690460205078125 - ], - [ - [ - [ - 2 - ], - [ - [ - "_id", - "UInt32" - ], - [ - "_key", - "ShortText" - ], - [ - "original", - "Bool" - ] - ], - [ - 1, - "ひろゆき", - true - ], - [ - 5, - "まろゆき", - true - ] - ] - ] - ] - \ No newline at end of file + # [[0,1336468388.9833,0.200592756271362],3] + select --table PatSuffix --query _key:@ゆき + # [ + # [ + # 0, + # 1336468389.38437, + # 0.000394582748413086 + # ], + # [ + # [ + # [ + # 4 + # ], + # [ + # [ + # "_id", + # "UInt32" + # ], + # [ + # "_key", + # "ShortText" + # ], + # [ + # "original", + # "Bool" + # ] + # ], + # [ + # 1, + # "ひろゆき", + # true + # ], + # [ + # 5, + # "まろゆき", + # true + # ], + # [ + # 3, + # "ゆき", + # false + # ], + # [ + # 2, + # "ろゆき", + # false + # ] + # ] + # ] + # ] + select --table PatSuffix --query "_key:@ゆき original:true" + # [ + # [ + # 0, + # 1336468389.58586, + # 0.000368118286132812 + # ], + # [ + # [ + # [ + # 2 + # ], + # [ + # [ + # "_id", + # "UInt32" + # ], + # [ + # "_key", + # "ShortText" + # ], + # [ + # "original", + # "Bool" + # ] + # ], + # [ + # 1, + # "ひろゆき", + # true + # ], + # [ + # 5, + # "まろゆき", + # true + # ] + # ] + # ] + # ] Modified: doc/source/example/tutorial/query_expansion-1.log (+24 -25) =================================================================== --- doc/source/example/tutorial/query_expansion-1.log 2012-05-08 18:18:08 +0900 (b7c00f5) +++ doc/source/example/tutorial/query_expansion-1.log 2012-05-08 18:18:28 +0900 (90cae0c) @@ -1,27 +1,26 @@ Execution example:: - > table_create Doc TABLE_PAT_KEY ShortText - [[0,1335519662.68773,0.000400543212890625],true] - > column_create Doc body COLUMN_SCALAR ShortText - [[0,1335519662.88919,0.000899314880371094],true] - > table_create Term TABLE_PAT_KEY|KEY_NORMALIZE ShortText --default_tokenizer TokenBigram - [[0,1335519663.09089,0.000370979309082031],true] - > column_create Term Doc_body COLUMN_INDEX|WITH_POSITION Doc body - [[0,1335519663.29217,0.00676441192626953],true] - > table_create Synonym TABLE_PAT_KEY ShortText - [[0,1335519663.4998,0.000351667404174805],true] - > column_create Synonym body COLUMN_SCALAR ShortText - [[0,1335519663.70094,0.000846624374389648],true] - > load --table Doc - > [ - > {"_key": "001", "body": "すっぱいブドウと甘いシークァーサー"}, - > {"_key": "002", "body": "シークヮーサージュースとゴーヤチャンプル"}, - > ] - [[0,1335519663.90262,0.801640033721924],2] - > load --table Synonym - > [ - > {"_key": "シークァーサー", "body": "(シークァーサー OR シークヮーサー)"}, - > {"_key": "シークヮーサー", "body": "(シークァーサー OR シークヮーサー)"}, - > ] - [[0,1335519664.905,0.801484823226929],2] - \ No newline at end of file + table_create Doc TABLE_PAT_KEY ShortText + # [[0,1336468416.35389,0.000249862670898438],true] + column_create Doc body COLUMN_SCALAR ShortText + # [[0,1336468416.5548,0.000641345977783203],true] + table_create Term TABLE_PAT_KEY|KEY_NORMALIZE ShortText --default_tokenizer TokenBigram + # [[0,1336468416.75607,0.000226736068725586],true] + column_create Term Doc_body COLUMN_INDEX|WITH_POSITION Doc body + # [[0,1336468416.95674,0.00353670120239258],true] + table_create Synonym TABLE_PAT_KEY ShortText + # [[0,1336468417.16076,0.000248432159423828],true] + column_create Synonym body COLUMN_SCALAR ShortText + # [[0,1336468417.36158,0.000540494918823242],true] + load --table Doc + [ + {"_key": "001", "body": "すっぱいブドウと甘いシークァーサー"}, + {"_key": "002", "body": "シークヮーサージュースとゴーヤチャンプル"}, + ] + # [[0,1336468417.56262,0.201695919036865],2] + load --table Synonym + [ + {"_key": "シークァーサー", "body": "(シークァーサー OR シークヮーサー)"}, + {"_key": "シークヮーサー", "body": "(シークァーサー OR シークヮーサー)"}, + ] + # [[0,1336468417.96483,0.200520038604736],2] Modified: doc/source/example/tutorial/query_expansion-2.log (+68 -69) =================================================================== --- doc/source/example/tutorial/query_expansion-2.log 2012-05-08 18:18:08 +0900 (349168d) +++ doc/source/example/tutorial/query_expansion-2.log 2012-05-08 18:18:28 +0900 (c08b35e) @@ -1,71 +1,70 @@ Execution example:: - > select Doc --match_columns body --query "シークァーサー" - [ - [ - 0, - 1335519665.90753, - 0.000537633895874023 - ], - [ - [ - [ - 1 - ], - [ - [ - "_id", - "UInt32" - ], - [ - "_key", - "ShortText" - ], - [ - "body", - "ShortText" - ] - ], - [ - 1, - "001", - "すっぱいブドウと甘いシークァーサー" - ] - ] - ] - ] - > select Doc --match_columns body --query "シークヮーサー" - [ - [ - 0, - 1335519666.10912, - 0.000688791275024414 - ], - [ - [ - [ - 1 - ], - [ - [ - "_id", - "UInt32" - ], - [ - "_key", - "ShortText" - ], - [ - "body", - "ShortText" - ] - ], - [ - 2, - "002", - "シークヮーサージュースとゴーヤチャンプル" - ] - ] - ] - ] - \ No newline at end of file + select Doc --match_columns body --query "シークァーサー" + # [ + # [ + # 0, + # 1336468418.36617, + # 0.000488758087158203 + # ], + # [ + # [ + # [ + # 1 + # ], + # [ + # [ + # "_id", + # "UInt32" + # ], + # [ + # "_key", + # "ShortText" + # ], + # [ + # "body", + # "ShortText" + # ] + # ], + # [ + # 1, + # "001", + # "すっぱいブドウと甘いシークァーサー" + # ] + # ] + # ] + # ] + select Doc --match_columns body --query "シークヮーサー" + # [ + # [ + # 0, + # 1336468418.56768, + # 0.000367879867553711 + # ], + # [ + # [ + # [ + # 1 + # ], + # [ + # [ + # "_id", + # "UInt32" + # ], + # [ + # "_key", + # "ShortText" + # ], + # [ + # "body", + # "ShortText" + # ] + # ], + # [ + # 2, + # "002", + # "シークヮーサージュースとゴーヤチャンプル" + # ] + # ] + # ] + # ] Modified: doc/source/example/tutorial/query_expansion-3.log (+78 -79) =================================================================== --- doc/source/example/tutorial/query_expansion-3.log 2012-05-08 18:18:08 +0900 (44be323) +++ doc/source/example/tutorial/query_expansion-3.log 2012-05-08 18:18:28 +0900 (06ea084) @@ -1,81 +1,80 @@ Execution example:: - > select Doc --match_columns body --query "シークァーサー" --query_expansion Synonym.body - [ - [ - 0, - 1335519666.31137, - 0.000792741775512695 - ], - [ - [ - [ - 2 - ], - [ - [ - "_id", - "UInt32" - ], - [ - "_key", - "ShortText" - ], - [ - "body", - "ShortText" - ] - ], - [ - 1, - "001", - "すっぱいブドウと甘いシークァーサー" - ], - [ - 2, - "002", - "シークヮーサージュースとゴーヤチャンプル" - ] - ] - ] - ] - > select Doc --match_columns body --query "シークヮーサー" --query_expansion Synonym.body - [ - [ - 0, - 1335519666.51486, - 0.000669717788696289 - ], - [ - [ - [ - 2 - ], - [ - [ - "_id", - "UInt32" - ], - [ - "_key", - "ShortText" - ], - [ - "body", - "ShortText" - ] - ], - [ - 1, - "001", - "すっぱいブドウと甘いシークァーサー" - ], - [ - 2, - "002", - "シークヮーサージュースとゴーヤチャンプル" - ] - ] - ] - ] - \ No newline at end of file + select Doc --match_columns body --query "シークァーサー" --query_expansion Synonym.body + # [ + # [ + # 0, + # 1336468418.76931, + # 0.000395298004150391 + # ], + # [ + # [ + # [ + # 2 + # ], + # [ + # [ + # "_id", + # "UInt32" + # ], + # [ + # "_key", + # "ShortText" + # ], + # [ + # "body", + # "ShortText" + # ] + # ], + # [ + # 1, + # "001", + # "すっぱいブドウと甘いシークァーサー" + # ], + # [ + # 2, + # "002", + # "シークヮーサージュースとゴーヤチャンプル" + # ] + # ] + # ] + # ] + select Doc --match_columns body --query "シークヮーサー" --query_expansion Synonym.body + # [ + # [ + # 0, + # 1336468418.97085, + # 0.000394105911254883 + # ], + # [ + # [ + # [ + # 2 + # ], + # [ + # [ + # "_id", + # "UInt32" + # ], + # [ + # "_key", + # "ShortText" + # ], + # [ + # "body", + # "ShortText" + # ] + # ], + # [ + # 1, + # "001", + # "すっぱいブドウと甘いシークァーサー" + # ], + # [ + # 2, + # "002", + # "シークヮーサージュースとゴーヤチャンプル" + # ] + # ] + # ] + # ]