YUKI Hiroshi
null+****@clear*****
Thu May 29 20:26:42 JST 2014
YUKI Hiroshi 2014-05-29 20:26:42 +0900 (Thu, 29 May 2014) New Revision: 768e8b1da0ef97403d66cca7904d5c09d8ff2183 https://github.com/droonga/droonga.org/commit/768e8b1da0ef97403d66cca7904d5c09d8ff2183 Message: Update translations Modified files: _po/ja/tutorial/1.0.3/groonga/index.po _po/ja/tutorial/1.0.4/groonga/index.po ja/tutorial/1.0.3/groonga/index.md ja/tutorial/1.0.4/groonga/index.md Modified: _po/ja/tutorial/1.0.3/groonga/index.po (+111 -127) =================================================================== --- _po/ja/tutorial/1.0.3/groonga/index.po 2014-05-29 20:21:56 +0900 (ae82498) +++ _po/ja/tutorial/1.0.3/groonga/index.po 2014-05-29 20:26:42 +0900 (4f328d7) @@ -250,15 +250,12 @@ msgid "" " --log-file=~/droonga/droonga-engine.log \\\n" " --daemon \\\n" " --pid-file=~/droonga/droonga-engine.pid\n" -" # droonga-http-server --port=10041 \\\n" -" --receive-host-name=$host \\\n" -" --droonga-engine-host-name=$host \\\n" -" --access-log-file=~/droonga/droonga-http-server.acce" -"ss.log \\\n" -" --system-log-file=~/droonga/droonga-http-server.syst" -"em.log \\\n" -" --daemon \\\n" -" --pid-file=~/droonga/droonga-http-server.pid" +" # env NODE_ENV=production \\\n" +" droonga-http-server --port=10041 \\\n" +" --receive-host-name=$host \\\n" +" --droonga-engine-host-name=$host \\\n" +" --daemon \\\n" +" --pid-file=~/droonga/droonga-http-server.pid" msgstr "" msgid "" @@ -296,8 +293,8 @@ msgid "" " # kill $(cat ~/droonga/droonga-http-server.pid)" msgstr "" -msgid "### Create a table" -msgstr "### テーブルの作成" +msgid "### Create a table, columns, and indexes" +msgstr "### テーブル、カラム、インデックスの作成" msgid "Now your Droonga cluster actually works as a Groonga's HTTP server." msgstr "以上の手順で、Groonga HTTPサーバ互換のサービスとして動作するDroongaクラスタができました。" @@ -312,8 +309,9 @@ msgstr "" msgid "" " # endpoint=\"http://192.168.0.10:10041/d\"\n" -" # curl \"${endpoint}/table_create?name=Store&type=Hash&key_type=ShortText\"\n" -" [[0,1398662266.3853862,0.08530688285827637],true]" +" # curl \"${endpoint}/table_create?name=Store&flags=TABLE_PAT_KEY&key_type=S" +"hortText\"\n" +" [[0,1401358896.360356,0.0035653114318847656],true]" msgstr "" msgid "" @@ -328,80 +326,63 @@ msgstr "" "すべてのリクエストは、クラスタ中の適切なノードに配送されます。" msgid "" -"OK, now the table has been created successfully.\n" -"Let's see it by the `table_list` command:" -msgstr "" -"さて、テーブルを正しく作成できました。\n" -"`table_list` コマンドを使って、作成されたテーブルの情報を見てみましょう:" +"Next, create new columns `name` and `location` to the `Store` table by the `co" +"lumn_create` command, like:" +msgstr "次は、`column_create` コマンドを使って `Store` テーブルに `name` と `location` という新しいカラムを作ります:" msgid "" -" # curl \"${endpoint}/table_list\"\n" -" [[0,1398662423.509928,0.003869295120239258],[[[\"id\",\"UInt32\"],[\"name\",\"Sho" -"rtText\"],[\"path\",\"ShortText\"],[\"flags\",\"ShortText\"],[\"domain\",\"ShortText\"],[\"r" -"ange\",\"ShortText\"],[\"default_tokenizer\",\"ShortText\"],[\"normalizer\",\"ShortText\"" -"]],[256,\"Store\",\"/home/username/groonga/droonga-engine/000/db.0000100\",\"TABLE_" -"HASH_KEY|PERSISTENT\",\"ShortText\",null,null,null]]]" +" # curl \"${endpoint}/column_create?table=Store&name=name&flags=COLUMN_SCALA" +"R&type=ShortText\"\n" +" [[0,1401358348.6541538,0.0004096031188964844],true]\n" +" # curl \"${endpoint}/column_create?table=Store&name=location&flags=COLUMN_S" +"CALAR&type=WGS84GeoPoint\"\n" +" [[0,1401358359.084659,0.002511262893676758],true],true]" msgstr "" -msgid "Because it is a cluster, another endpoint returns same result." -msgstr "Droongaはクラスタで動作するので、他のエンドポイントも同じ結果を返します。" +msgid "Create indexes also." +msgstr "インデックスも作成しましょう。" msgid "" -" # curl \"http://192.168.0.11:10041/d/table_list\"\n" -" [[0,1398662423.509928,0.003869295120239258],[[[\"id\",\"UInt32\"],[\"name\",\"Sho" -"rtText\"],[\"path\",\"ShortText\"],[\"flags\",\"ShortText\"],[\"domain\",\"ShortText\"],[\"r" -"ange\",\"ShortText\"],[\"default_tokenizer\",\"ShortText\"],[\"normalizer\",\"ShortText\"" -"]],[256,\"Store\",\"/home/username/groonga/droonga-engine/000/db.0000100\",\"TABLE_" -"HASH_KEY|PERSISTENT\",\"ShortText\",null,null,null]]]" +" # curl \"${endpoint}/table_create?name=Term&flags=TABLE_PAT_KEY&key_type=Sh" +"ortText&default_tokenizer=TokenBigram&normalizer=NormalizerAuto\"\n" +" [[0,1401358475.7229664,0.002419710159301758],true]\n" +" # curl \"${endpoint}/column_create?table=Term&name=store_name&flags=COLUMN_" +"INDEX|WITH_POSITION&type=Store&source=name\"\n" +" [[0,1401358494.1656318,0.006799221038818359],true]\n" +" # curl \"${endpoint}/table_create?name=Location&flags=TABLE_PAT_KEY&key_typ" +"e=WGS84GeoPoint\"\n" +" [[0,1401358505.708896,0.0016951560974121094],true]\n" +" # curl \"${endpoint}/column_create?table=Location&name=store&flags=COLUMN_I" +"NDEX&type=Store&source=location\"\n" +" [[0,1401358519.6187897,0.024788379669189453],true]" msgstr "" -msgid "### Create a column" -msgstr "### カラムの作成" - -msgid "" -"Next, create a new column `location` to the `Store` table by the `column_creat" -"e` command, like:" -msgstr "次は、`column_create` コマンドを使って `Store` テーブルに `location` という新しいカラムを作ります:" - msgid "" -" # curl \"${endpoint}/column_create?table=Store&name=location&flags=COLUMN_S" -"CALAR&type=WGS84GeoPoint\"\n" -" [[0,1398664305.8856306,0.00026226043701171875],true]" +"OK, now the table has been created successfully.\n" +"Let's see it by the `table_list` command:" msgstr "" +"さて、テーブルを正しく作成できました。\n" +"`table_list` コマンドを使って、作成されたテーブルの情報を見てみましょう:" msgid "" -"Then verify that the column is correctly created, by the `column_list` command" -":" -msgstr "`column_list` コマンドを使って、カラムが正しく作成された事を確認しましょう:" - -msgid "" -" # curl \"${endpoint}/column_list?table=Store\"\n" -" [[0,1398664345.9680889,0.0011739730834960938],[[[\"id\",\"UInt32\"],[\"name\",\"S" -"hortText\"],[\"path\",\"ShortText\"],[\"type\",\"ShortText\"],[\"flags\",\"ShortText\"],[\"d" -"omain\",\"ShortText\"],[\"range\",\"ShortText\"],[\"source\",\"ShortText\"]],[257,\"locati" -"on\",\"/home/username/groonga/droonga-engine/000/db.0000101\",\"fix\",\"COLUMN_SCALA" -"R\",\"Store\",\"WGS84GeoPoint\",[]]]]" +" # curl \"${endpoint}/table_list\"\n" +" [[0,1401358908.9126804,0.001600027084350586],[[[\"id\",\"UInt32\"],[\"name\",\"Sh" +"ortText\"],[\"path\",\"ShortText\"],[\"flags\",\"ShortText\"],[\"domain\",\"ShortText\"],[\"" +"range\",\"ShortText\"],[\"default_tokenizer\",\"ShortText\"],[\"normalizer\",\"ShortText" +"\"]],[256,\"Store\",\"/home/vagrant/droonga/000/db.0000100\",\"TABLE_PAT_KEY|PERSIST" +"ENT\",\"ShortText\",null,null,null]]]" msgstr "" -msgid "### Create indexes" -msgstr "### インデックスの作成" - -msgid "Create indexes also." -msgstr "インデックスも作成しましょう。" +msgid "Because it is a cluster, another endpoint returns same result." +msgstr "Droongaはクラスタで動作するので、他のエンドポイントも同じ結果を返します。" msgid "" -" # curl \"${endpoint}/table_create?name=Location&type=PatriciaTrie&key_type=" -"WGS84GeoPoint\"\n" -" [[0,1398664401.4927232,0.12011909484863281],true]\n" -" # curl \"${endpoint}/column_create?table=Location&name=store&flags=COLUMN_I" -"NDEX&type=Store&source=location\"\n" -" [[0,1398664429.5348525,0.13435077667236328],true]\n" -" # curl \"${endpoint}/table_create?name=Term&type=PatriciaTrie&key_type=Shor" -"tText&default_tokenizer=TokenBigram&normalizer=NormalizerAuto\"\n" -" [[0,1398664454.446939,0.14734888076782227],true]\n" -" # curl \"${endpoint}/column_create?table=Term&name=store__key&flags=COLUMN_" -"INDEX|WITH_POSITION&type=Store&source=_key\"\n" -" [[0,1398664474.7112074,0.12619781494140625],true]" +" # curl \"http://192.168.0.11:10041/d/table_list\"\n" +" [[0,1401358908.9126804,0.001600027084350586],[[[\"id\",\"UInt32\"],[\"name\",\"Sh" +"ortText\"],[\"path\",\"ShortText\"],[\"flags\",\"ShortText\"],[\"domain\",\"ShortText\"],[\"" +"range\",\"ShortText\"],[\"default_tokenizer\",\"ShortText\"],[\"normalizer\",\"ShortText" +"\"]],[256,\"Store\",\"/home/vagrant/droonga/000/db.0000100\",\"TABLE_PAT_KEY|PERSIST" +"ENT\",\"ShortText\",null,null,null]]]" msgstr "" msgid "### Load data to a table" @@ -420,50 +401,53 @@ msgstr "" msgid "" "~~~\n" "[\n" -"[\"_key\",\"location\"],\n" -"[\"1st Avenue & 75th St. - New York NY (W)\",\"40.770262,-73.954798\"],\n" -"[\"76th & Second - New York NY (W)\",\"40.771056,-73.956757\"],\n" -"[\"2nd Ave. & 9th Street - New York NY\",\"40.729445,-73.987471\"],\n" -"[\"15th & Third - New York NY (W)\",\"40.733946,-73.9867\"],\n" -"[\"41st and Broadway - New York NY (W)\",\"40.755111,-73.986225\"],\n" -"[\"84th & Third Ave - New York NY (W)\",\"40.777485,-73.954979\"],\n" -"[\"150 E. 42nd Street - New York NY (W)\",\"40.750784,-73.975582\"],\n" -"[\"West 43rd and Broadway - New York NY (W)\",\"40.756197,-73.985624\"],\n" -"[\"Macy's 35th Street Balcony - New York NY\",\"40.750703,-73.989787\"],\n" -"[\"Macy's 6th Floor - Herald Square - New York NY (W)\",\"40.750703,-73.989787\"]" -",\n" -"[\"Herald Square- Macy's - New York NY\",\"40.750703,-73.989787\"],\n" -"[\"Macy's 5th Floor - Herald Square - New York NY (W)\",\"40.750703,-73.989787\"]" -",\n" -"[\"80th & York - New York NY (W)\",\"40.772204,-73.949862\"],\n" -"[\"Columbus @ 67th - New York NY (W)\",\"40.774009,-73.981472\"],\n" -"[\"45th & Broadway - New York NY (W)\",\"40.75766,-73.985719\"],\n" -"[\"Marriott Marquis - Lobby - New York NY\",\"40.759123,-73.984927\"],\n" -"[\"Second @ 81st - New York NY (W)\",\"40.77466,-73.954447\"],\n" -"[\"52nd & Seventh - New York NY (W)\",\"40.761829,-73.981141\"],\n" -"[\"1585 Broadway (47th) - New York NY (W)\",\"40.759806,-73.985066\"],\n" -"[\"85th & First - New York NY (W)\",\"40.776101,-73.949971\"],\n" -"[\"92nd & 3rd - New York NY (W)\",\"40.782606,-73.951235\"],\n" -"[\"165 Broadway - 1 Liberty - New York NY (W)\",\"40.709727,-74.011395\"],\n" -"[\"1656 Broadway - New York NY (W)\",\"40.762434,-73.983364\"],\n" -"[\"54th & Broadway - New York NY (W)\",\"40.764275,-73.982361\"],\n" -"[\"Limited Brands-NYC - New York NY\",\"40.765219,-73.982025\"],\n" -"[\"19th & 8th - New York NY (W)\",\"40.743218,-74.000605\"],\n" -"[\"60th & Broadway-II - New York NY (W)\",\"40.769196,-73.982576\"],\n" -"[\"63rd & Broadway - New York NY (W)\",\"40.771376,-73.982709\"],\n" -"[\"195 Broadway - New York NY (W)\",\"40.710703,-74.009485\"],\n" -"[\"2 Broadway - New York NY (W)\",\"40.704538,-74.01324\"],\n" -"[\"2 Columbus Ave. - New York NY (W)\",\"40.769262,-73.984764\"],\n" -"[\"NY Plaza - New York NY (W)\",\"40.702802,-74.012784\"],\n" -"[\"36th and Madison - New York NY (W)\",\"40.748917,-73.982683\"],\n" -"[\"125th St. btwn Adam Clayton & FDB - New York NY\",\"40.808952,-73.948229\"],\n" -"[\"70th & Broadway - New York NY (W)\",\"40.777463,-73.982237\"],\n" -"[\"2138 Broadway - New York NY (W)\",\"40.781078,-73.981167\"],\n" -"[\"118th & Frederick Douglas Blvd. - New York NY (W)\",\"40.806176,-73.954109\"]," +"[\"_key\",\"name\",\"location\"],\n" +"[\"store0\",\"1st Avenue & 75th St. - New York NY (W)\",\"40.770262,-73.954798\"],\n" +"[\"store1\",\"76th & Second - New York NY (W)\",\"40.771056,-73.956757\"],\n" +"[\"store2\",\"2nd Ave. & 9th Street - New York NY\",\"40.729445,-73.987471\"],\n" +"[\"store3\",\"15th & Third - New York NY (W)\",\"40.733946,-73.9867\"],\n" +"[\"store4\",\"41st and Broadway - New York NY (W)\",\"40.755111,-73.986225\"],\n" +"[\"store5\",\"84th & Third Ave - New York NY (W)\",\"40.777485,-73.954979\"],\n" +"[\"store6\",\"150 E. 42nd Street - New York NY (W)\",\"40.750784,-73.975582\"],\n" +"[\"store7\",\"West 43rd and Broadway - New York NY (W)\",\"40.756197,-73.985624\"]," "\n" -"[\"42nd & Second - New York NY (W)\",\"40.750069,-73.973393\"],\n" -"[\"Broadway @ 81st - New York NY (W)\",\"40.784972,-73.978987\"],\n" -"[\"Fashion Inst of Technology - New York NY\",\"40.746948,-73.994557\"]\n" +"[\"store8\",\"Macy's 35th Street Balcony - New York NY\",\"40.750703,-73.989787\"],\n" +"[\"store9\",\"Macy's 6th Floor - Herald Square - New York NY (W)\",\"40.750703,-73" +".989787\"],\n" +"[\"store10\",\"Herald Square- Macy's - New York NY\",\"40.750703,-73.989787\"],\n" +"[\"store11\",\"Macy's 5th Floor - Herald Square - New York NY (W)\",\"40.750703,-7" +"3.989787\"],\n" +"[\"store12\",\"80th & York - New York NY (W)\",\"40.772204,-73.949862\"],\n" +"[\"store13\",\"Columbus @ 67th - New York NY (W)\",\"40.774009,-73.981472\"],\n" +"[\"store14\",\"45th & Broadway - New York NY (W)\",\"40.75766,-73.985719\"],\n" +"[\"store15\",\"Marriott Marquis - Lobby - New York NY\",\"40.759123,-73.984927\"],\n" +"[\"store16\",\"Second @ 81st - New York NY (W)\",\"40.77466,-73.954447\"],\n" +"[\"store17\",\"52nd & Seventh - New York NY (W)\",\"40.761829,-73.981141\"],\n" +"[\"store18\",\"1585 Broadway (47th) - New York NY (W)\",\"40.759806,-73.985066\"],\n" +"[\"store19\",\"85th & First - New York NY (W)\",\"40.776101,-73.949971\"],\n" +"[\"store20\",\"92nd & 3rd - New York NY (W)\",\"40.782606,-73.951235\"],\n" +"[\"store21\",\"165 Broadway - 1 Liberty - New York NY (W)\",\"40.709727,-74.011395" +"\"],\n" +"[\"store22\",\"1656 Broadway - New York NY (W)\",\"40.762434,-73.983364\"],\n" +"[\"store23\",\"54th & Broadway - New York NY (W)\",\"40.764275,-73.982361\"],\n" +"[\"store24\",\"Limited Brands-NYC - New York NY\",\"40.765219,-73.982025\"],\n" +"[\"store25\",\"19th & 8th - New York NY (W)\",\"40.743218,-74.000605\"],\n" +"[\"store26\",\"60th & Broadway-II - New York NY (W)\",\"40.769196,-73.982576\"],\n" +"[\"store27\",\"63rd & Broadway - New York NY (W)\",\"40.771376,-73.982709\"],\n" +"[\"store28\",\"195 Broadway - New York NY (W)\",\"40.710703,-74.009485\"],\n" +"[\"store29\",\"2 Broadway - New York NY (W)\",\"40.704538,-74.01324\"],\n" +"[\"store30\",\"2 Columbus Ave. - New York NY (W)\",\"40.769262,-73.984764\"],\n" +"[\"store31\",\"NY Plaza - New York NY (W)\",\"40.702802,-74.012784\"],\n" +"[\"store32\",\"36th and Madison - New York NY (W)\",\"40.748917,-73.982683\"],\n" +"[\"store33\",\"125th St. btwn Adam Clayton & FDB - New York NY\",\"40.808952,-73.94" +"8229\"],\n" +"[\"store34\",\"70th & Broadway - New York NY (W)\",\"40.777463,-73.982237\"],\n" +"[\"store35\",\"2138 Broadway - New York NY (W)\",\"40.781078,-73.981167\"],\n" +"[\"store36\",\"118th & Frederick Douglas Blvd. - New York NY (W)\",\"40.806176,-73" +".954109\"],\n" +"[\"store37\",\"42nd & Second - New York NY (W)\",\"40.750069,-73.973393\"],\n" +"[\"store38\",\"Broadway @ 81st - New York NY (W)\",\"40.784972,-73.978987\"],\n" +"[\"store39\",\"Fashion Inst of Technology - New York NY\",\"40.746948,-73.994557\"]\n" "]\n" "~~~" msgstr "" @@ -473,7 +457,7 @@ msgstr "データが準備できたら、`load` コマンドのPOSTリクエス msgid "" " # curl --data \"@stores.json\" \"${endpoint}/load?table=Store\"\n" -" [[0,1398666180.023,0.069],[40]]" +" [[0,1401358564.909,0.158],[40]]" msgstr "" msgid "Now all data in the JSON file are successfully loaded." @@ -489,27 +473,27 @@ msgid "As the starter, let's select initial ten records with the `select` comman msgstr "試しに、`select` コマンドを使って最初の10レコードを取り出してみましょう:" msgid "" -" # curl \"${endpoint}/select?table=Store&output_columns=_key&limit=10\"\n" -" [[0,1398666260.887927,0.000017404556274414062],[[[40],[[\"_key\",\"ShortText\"" -"]],[\"1st Avenue & 75th St. - New York NY (W)\"],[\"2nd Ave. & 9th Street - New " -"York NY\"],[\"76th & Second - New York NY (W)\"],[\"15th & Third - New York NY (" -"W)\"],[\"41st and Broadway - New York NY (W)\"],[\"West 43rd and Broadway - New Y" -"ork NY (W)\"],[\"84th & Third Ave - New York NY (W)\"],[\"150 E. 42nd Street - N" -"ew York NY (W)\"],[\"Macy's 35th Street Balcony - New York NY\"],[\"Herald Square" -"- Macy's - New York NY\"]]]]" +" # curl \"${endpoint}/select?table=Store&output_columns=name&limit=10\"\n" +" [[0,1401362059.7437818,0.00004935264587402344],[[[40],[[\"name\",\"ShortText\"" +"]],[\"1st Avenue & 75th St. - New York NY (W)\"],[\"76th & Second - New York NY " +" (W)\"],[\"Herald Square- Macy's - New York NY\"],[\"Macy's 5th Floor - Herald Squ" +"are - New York NY (W)\"],[\"80th & York - New York NY (W)\"],[\"Columbus @ 67th " +"- New York NY (W)\"],[\"45th & Broadway - New York NY (W)\"],[\"Marriott Marquis" +" - Lobby - New York NY\"],[\"Second @ 81st - New York NY (W)\"],[\"52nd & Seventh" +" - New York NY (W)\"]]]]" msgstr "" msgid "Of course you can specify conditions via the `query` option:" msgstr "もちろん、`query` オプションを使って検索条件を指定する事もできます:" msgid "" -" # curl \"${endpoint}/select?table=Store&query=Columbus&match_columns=_key&o" -"utput_columns=_key&limit=10\"\n" +" # curl \"${endpoint}/select?table=Store&query=Columbus&match_columns=name&o" +"utput_columns=name&limit=10\"\n" " [[0,1398670157.661574,0.0012705326080322266],[[[2],[[\"_key\",\"ShortText\"]]," "[\"Columbus @ 67th - New York NY (W)\"],[\"2 Columbus Ave. - New York NY (W)\"]]" "]]\n" -" # curl \"${endpoint}/select?table=Store&filter=_key@'Ave'&output_columns=_k" -"ey&limit=10\"\n" +" # curl \"${endpoint}/select?table=Store&filter=name@'Ave'&output_columns=na" +"me&limit=10\"\n" " [[0,1398670586.193325,0.0003848075866699219],[[[3],[[\"_key\",\"ShortText\"]]," "[\"2nd Ave. & 9th Street - New York NY\"],[\"84th & Third Ave - New York NY (W)\"" "],[\"2 Columbus Ave. - New York NY (W)\"]]]]" Modified: _po/ja/tutorial/1.0.4/groonga/index.po (+111 -127) =================================================================== --- _po/ja/tutorial/1.0.4/groonga/index.po 2014-05-29 20:21:56 +0900 (ae82498) +++ _po/ja/tutorial/1.0.4/groonga/index.po 2014-05-29 20:26:42 +0900 (4f328d7) @@ -250,15 +250,12 @@ msgid "" " --log-file=~/droonga/droonga-engine.log \\\n" " --daemon \\\n" " --pid-file=~/droonga/droonga-engine.pid\n" -" # droonga-http-server --port=10041 \\\n" -" --receive-host-name=$host \\\n" -" --droonga-engine-host-name=$host \\\n" -" --access-log-file=~/droonga/droonga-http-server.acce" -"ss.log \\\n" -" --system-log-file=~/droonga/droonga-http-server.syst" -"em.log \\\n" -" --daemon \\\n" -" --pid-file=~/droonga/droonga-http-server.pid" +" # env NODE_ENV=production \\\n" +" droonga-http-server --port=10041 \\\n" +" --receive-host-name=$host \\\n" +" --droonga-engine-host-name=$host \\\n" +" --daemon \\\n" +" --pid-file=~/droonga/droonga-http-server.pid" msgstr "" msgid "" @@ -296,8 +293,8 @@ msgid "" " # kill $(cat ~/droonga/droonga-http-server.pid)" msgstr "" -msgid "### Create a table" -msgstr "### テーブルの作成" +msgid "### Create a table, columns, and indexes" +msgstr "### テーブル、カラム、インデックスの作成" msgid "Now your Droonga cluster actually works as a Groonga's HTTP server." msgstr "以上の手順で、Groonga HTTPサーバ互換のサービスとして動作するDroongaクラスタができました。" @@ -312,8 +309,9 @@ msgstr "" msgid "" " # endpoint=\"http://192.168.0.10:10041/d\"\n" -" # curl \"${endpoint}/table_create?name=Store&type=Hash&key_type=ShortText\"\n" -" [[0,1398662266.3853862,0.08530688285827637],true]" +" # curl \"${endpoint}/table_create?name=Store&flags=TABLE_PAT_KEY&key_type=S" +"hortText\"\n" +" [[0,1401358896.360356,0.0035653114318847656],true]" msgstr "" msgid "" @@ -328,80 +326,63 @@ msgstr "" "すべてのリクエストは、クラスタ中の適切なノードに配送されます。" msgid "" -"OK, now the table has been created successfully.\n" -"Let's see it by the `table_list` command:" -msgstr "" -"さて、テーブルを正しく作成できました。\n" -"`table_list` コマンドを使って、作成されたテーブルの情報を見てみましょう:" +"Next, create new columns `name` and `location` to the `Store` table by the `co" +"lumn_create` command, like:" +msgstr "次は、`column_create` コマンドを使って `Store` テーブルに `name` と `location` という新しいカラムを作ります:" msgid "" -" # curl \"${endpoint}/table_list\"\n" -" [[0,1398662423.509928,0.003869295120239258],[[[\"id\",\"UInt32\"],[\"name\",\"Sho" -"rtText\"],[\"path\",\"ShortText\"],[\"flags\",\"ShortText\"],[\"domain\",\"ShortText\"],[\"r" -"ange\",\"ShortText\"],[\"default_tokenizer\",\"ShortText\"],[\"normalizer\",\"ShortText\"" -"]],[256,\"Store\",\"/home/username/groonga/droonga-engine/000/db.0000100\",\"TABLE_" -"HASH_KEY|PERSISTENT\",\"ShortText\",null,null,null]]]" +" # curl \"${endpoint}/column_create?table=Store&name=name&flags=COLUMN_SCALA" +"R&type=ShortText\"\n" +" [[0,1401358348.6541538,0.0004096031188964844],true]\n" +" # curl \"${endpoint}/column_create?table=Store&name=location&flags=COLUMN_S" +"CALAR&type=WGS84GeoPoint\"\n" +" [[0,1401358359.084659,0.002511262893676758],true],true]" msgstr "" -msgid "Because it is a cluster, another endpoint returns same result." -msgstr "Droongaはクラスタで動作するので、他のエンドポイントも同じ結果を返します。" +msgid "Create indexes also." +msgstr "インデックスも作成しましょう。" msgid "" -" # curl \"http://192.168.0.11:10041/d/table_list\"\n" -" [[0,1398662423.509928,0.003869295120239258],[[[\"id\",\"UInt32\"],[\"name\",\"Sho" -"rtText\"],[\"path\",\"ShortText\"],[\"flags\",\"ShortText\"],[\"domain\",\"ShortText\"],[\"r" -"ange\",\"ShortText\"],[\"default_tokenizer\",\"ShortText\"],[\"normalizer\",\"ShortText\"" -"]],[256,\"Store\",\"/home/username/groonga/droonga-engine/000/db.0000100\",\"TABLE_" -"HASH_KEY|PERSISTENT\",\"ShortText\",null,null,null]]]" +" # curl \"${endpoint}/table_create?name=Term&flags=TABLE_PAT_KEY&key_type=Sh" +"ortText&default_tokenizer=TokenBigram&normalizer=NormalizerAuto\"\n" +" [[0,1401358475.7229664,0.002419710159301758],true]\n" +" # curl \"${endpoint}/column_create?table=Term&name=store_name&flags=COLUMN_" +"INDEX|WITH_POSITION&type=Store&source=name\"\n" +" [[0,1401358494.1656318,0.006799221038818359],true]\n" +" # curl \"${endpoint}/table_create?name=Location&flags=TABLE_PAT_KEY&key_typ" +"e=WGS84GeoPoint\"\n" +" [[0,1401358505.708896,0.0016951560974121094],true]\n" +" # curl \"${endpoint}/column_create?table=Location&name=store&flags=COLUMN_I" +"NDEX&type=Store&source=location\"\n" +" [[0,1401358519.6187897,0.024788379669189453],true]" msgstr "" -msgid "### Create a column" -msgstr "### カラムの作成" - -msgid "" -"Next, create a new column `location` to the `Store` table by the `column_creat" -"e` command, like:" -msgstr "次は、`column_create` コマンドを使って `Store` テーブルに `location` という新しいカラムを作ります:" - msgid "" -" # curl \"${endpoint}/column_create?table=Store&name=location&flags=COLUMN_S" -"CALAR&type=WGS84GeoPoint\"\n" -" [[0,1398664305.8856306,0.00026226043701171875],true]" +"OK, now the table has been created successfully.\n" +"Let's see it by the `table_list` command:" msgstr "" +"さて、テーブルを正しく作成できました。\n" +"`table_list` コマンドを使って、作成されたテーブルの情報を見てみましょう:" msgid "" -"Then verify that the column is correctly created, by the `column_list` command" -":" -msgstr "`column_list` コマンドを使って、カラムが正しく作成された事を確認しましょう:" - -msgid "" -" # curl \"${endpoint}/column_list?table=Store\"\n" -" [[0,1398664345.9680889,0.0011739730834960938],[[[\"id\",\"UInt32\"],[\"name\",\"S" -"hortText\"],[\"path\",\"ShortText\"],[\"type\",\"ShortText\"],[\"flags\",\"ShortText\"],[\"d" -"omain\",\"ShortText\"],[\"range\",\"ShortText\"],[\"source\",\"ShortText\"]],[257,\"locati" -"on\",\"/home/username/groonga/droonga-engine/000/db.0000101\",\"fix\",\"COLUMN_SCALA" -"R\",\"Store\",\"WGS84GeoPoint\",[]]]]" +" # curl \"${endpoint}/table_list\"\n" +" [[0,1401358908.9126804,0.001600027084350586],[[[\"id\",\"UInt32\"],[\"name\",\"Sh" +"ortText\"],[\"path\",\"ShortText\"],[\"flags\",\"ShortText\"],[\"domain\",\"ShortText\"],[\"" +"range\",\"ShortText\"],[\"default_tokenizer\",\"ShortText\"],[\"normalizer\",\"ShortText" +"\"]],[256,\"Store\",\"/home/vagrant/droonga/000/db.0000100\",\"TABLE_PAT_KEY|PERSIST" +"ENT\",\"ShortText\",null,null,null]]]" msgstr "" -msgid "### Create indexes" -msgstr "### インデックスの作成" - -msgid "Create indexes also." -msgstr "インデックスも作成しましょう。" +msgid "Because it is a cluster, another endpoint returns same result." +msgstr "Droongaはクラスタで動作するので、他のエンドポイントも同じ結果を返します。" msgid "" -" # curl \"${endpoint}/table_create?name=Location&type=PatriciaTrie&key_type=" -"WGS84GeoPoint\"\n" -" [[0,1398664401.4927232,0.12011909484863281],true]\n" -" # curl \"${endpoint}/column_create?table=Location&name=store&flags=COLUMN_I" -"NDEX&type=Store&source=location\"\n" -" [[0,1398664429.5348525,0.13435077667236328],true]\n" -" # curl \"${endpoint}/table_create?name=Term&type=PatriciaTrie&key_type=Shor" -"tText&default_tokenizer=TokenBigram&normalizer=NormalizerAuto\"\n" -" [[0,1398664454.446939,0.14734888076782227],true]\n" -" # curl \"${endpoint}/column_create?table=Term&name=store__key&flags=COLUMN_" -"INDEX|WITH_POSITION&type=Store&source=_key\"\n" -" [[0,1398664474.7112074,0.12619781494140625],true]" +" # curl \"http://192.168.0.11:10041/d/table_list\"\n" +" [[0,1401358908.9126804,0.001600027084350586],[[[\"id\",\"UInt32\"],[\"name\",\"Sh" +"ortText\"],[\"path\",\"ShortText\"],[\"flags\",\"ShortText\"],[\"domain\",\"ShortText\"],[\"" +"range\",\"ShortText\"],[\"default_tokenizer\",\"ShortText\"],[\"normalizer\",\"ShortText" +"\"]],[256,\"Store\",\"/home/vagrant/droonga/000/db.0000100\",\"TABLE_PAT_KEY|PERSIST" +"ENT\",\"ShortText\",null,null,null]]]" msgstr "" msgid "### Load data to a table" @@ -420,50 +401,53 @@ msgstr "" msgid "" "~~~\n" "[\n" -"[\"_key\",\"location\"],\n" -"[\"1st Avenue & 75th St. - New York NY (W)\",\"40.770262,-73.954798\"],\n" -"[\"76th & Second - New York NY (W)\",\"40.771056,-73.956757\"],\n" -"[\"2nd Ave. & 9th Street - New York NY\",\"40.729445,-73.987471\"],\n" -"[\"15th & Third - New York NY (W)\",\"40.733946,-73.9867\"],\n" -"[\"41st and Broadway - New York NY (W)\",\"40.755111,-73.986225\"],\n" -"[\"84th & Third Ave - New York NY (W)\",\"40.777485,-73.954979\"],\n" -"[\"150 E. 42nd Street - New York NY (W)\",\"40.750784,-73.975582\"],\n" -"[\"West 43rd and Broadway - New York NY (W)\",\"40.756197,-73.985624\"],\n" -"[\"Macy's 35th Street Balcony - New York NY\",\"40.750703,-73.989787\"],\n" -"[\"Macy's 6th Floor - Herald Square - New York NY (W)\",\"40.750703,-73.989787\"]" -",\n" -"[\"Herald Square- Macy's - New York NY\",\"40.750703,-73.989787\"],\n" -"[\"Macy's 5th Floor - Herald Square - New York NY (W)\",\"40.750703,-73.989787\"]" -",\n" -"[\"80th & York - New York NY (W)\",\"40.772204,-73.949862\"],\n" -"[\"Columbus @ 67th - New York NY (W)\",\"40.774009,-73.981472\"],\n" -"[\"45th & Broadway - New York NY (W)\",\"40.75766,-73.985719\"],\n" -"[\"Marriott Marquis - Lobby - New York NY\",\"40.759123,-73.984927\"],\n" -"[\"Second @ 81st - New York NY (W)\",\"40.77466,-73.954447\"],\n" -"[\"52nd & Seventh - New York NY (W)\",\"40.761829,-73.981141\"],\n" -"[\"1585 Broadway (47th) - New York NY (W)\",\"40.759806,-73.985066\"],\n" -"[\"85th & First - New York NY (W)\",\"40.776101,-73.949971\"],\n" -"[\"92nd & 3rd - New York NY (W)\",\"40.782606,-73.951235\"],\n" -"[\"165 Broadway - 1 Liberty - New York NY (W)\",\"40.709727,-74.011395\"],\n" -"[\"1656 Broadway - New York NY (W)\",\"40.762434,-73.983364\"],\n" -"[\"54th & Broadway - New York NY (W)\",\"40.764275,-73.982361\"],\n" -"[\"Limited Brands-NYC - New York NY\",\"40.765219,-73.982025\"],\n" -"[\"19th & 8th - New York NY (W)\",\"40.743218,-74.000605\"],\n" -"[\"60th & Broadway-II - New York NY (W)\",\"40.769196,-73.982576\"],\n" -"[\"63rd & Broadway - New York NY (W)\",\"40.771376,-73.982709\"],\n" -"[\"195 Broadway - New York NY (W)\",\"40.710703,-74.009485\"],\n" -"[\"2 Broadway - New York NY (W)\",\"40.704538,-74.01324\"],\n" -"[\"2 Columbus Ave. - New York NY (W)\",\"40.769262,-73.984764\"],\n" -"[\"NY Plaza - New York NY (W)\",\"40.702802,-74.012784\"],\n" -"[\"36th and Madison - New York NY (W)\",\"40.748917,-73.982683\"],\n" -"[\"125th St. btwn Adam Clayton & FDB - New York NY\",\"40.808952,-73.948229\"],\n" -"[\"70th & Broadway - New York NY (W)\",\"40.777463,-73.982237\"],\n" -"[\"2138 Broadway - New York NY (W)\",\"40.781078,-73.981167\"],\n" -"[\"118th & Frederick Douglas Blvd. - New York NY (W)\",\"40.806176,-73.954109\"]," +"[\"_key\",\"name\",\"location\"],\n" +"[\"store0\",\"1st Avenue & 75th St. - New York NY (W)\",\"40.770262,-73.954798\"],\n" +"[\"store1\",\"76th & Second - New York NY (W)\",\"40.771056,-73.956757\"],\n" +"[\"store2\",\"2nd Ave. & 9th Street - New York NY\",\"40.729445,-73.987471\"],\n" +"[\"store3\",\"15th & Third - New York NY (W)\",\"40.733946,-73.9867\"],\n" +"[\"store4\",\"41st and Broadway - New York NY (W)\",\"40.755111,-73.986225\"],\n" +"[\"store5\",\"84th & Third Ave - New York NY (W)\",\"40.777485,-73.954979\"],\n" +"[\"store6\",\"150 E. 42nd Street - New York NY (W)\",\"40.750784,-73.975582\"],\n" +"[\"store7\",\"West 43rd and Broadway - New York NY (W)\",\"40.756197,-73.985624\"]," "\n" -"[\"42nd & Second - New York NY (W)\",\"40.750069,-73.973393\"],\n" -"[\"Broadway @ 81st - New York NY (W)\",\"40.784972,-73.978987\"],\n" -"[\"Fashion Inst of Technology - New York NY\",\"40.746948,-73.994557\"]\n" +"[\"store8\",\"Macy's 35th Street Balcony - New York NY\",\"40.750703,-73.989787\"],\n" +"[\"store9\",\"Macy's 6th Floor - Herald Square - New York NY (W)\",\"40.750703,-73" +".989787\"],\n" +"[\"store10\",\"Herald Square- Macy's - New York NY\",\"40.750703,-73.989787\"],\n" +"[\"store11\",\"Macy's 5th Floor - Herald Square - New York NY (W)\",\"40.750703,-7" +"3.989787\"],\n" +"[\"store12\",\"80th & York - New York NY (W)\",\"40.772204,-73.949862\"],\n" +"[\"store13\",\"Columbus @ 67th - New York NY (W)\",\"40.774009,-73.981472\"],\n" +"[\"store14\",\"45th & Broadway - New York NY (W)\",\"40.75766,-73.985719\"],\n" +"[\"store15\",\"Marriott Marquis - Lobby - New York NY\",\"40.759123,-73.984927\"],\n" +"[\"store16\",\"Second @ 81st - New York NY (W)\",\"40.77466,-73.954447\"],\n" +"[\"store17\",\"52nd & Seventh - New York NY (W)\",\"40.761829,-73.981141\"],\n" +"[\"store18\",\"1585 Broadway (47th) - New York NY (W)\",\"40.759806,-73.985066\"],\n" +"[\"store19\",\"85th & First - New York NY (W)\",\"40.776101,-73.949971\"],\n" +"[\"store20\",\"92nd & 3rd - New York NY (W)\",\"40.782606,-73.951235\"],\n" +"[\"store21\",\"165 Broadway - 1 Liberty - New York NY (W)\",\"40.709727,-74.011395" +"\"],\n" +"[\"store22\",\"1656 Broadway - New York NY (W)\",\"40.762434,-73.983364\"],\n" +"[\"store23\",\"54th & Broadway - New York NY (W)\",\"40.764275,-73.982361\"],\n" +"[\"store24\",\"Limited Brands-NYC - New York NY\",\"40.765219,-73.982025\"],\n" +"[\"store25\",\"19th & 8th - New York NY (W)\",\"40.743218,-74.000605\"],\n" +"[\"store26\",\"60th & Broadway-II - New York NY (W)\",\"40.769196,-73.982576\"],\n" +"[\"store27\",\"63rd & Broadway - New York NY (W)\",\"40.771376,-73.982709\"],\n" +"[\"store28\",\"195 Broadway - New York NY (W)\",\"40.710703,-74.009485\"],\n" +"[\"store29\",\"2 Broadway - New York NY (W)\",\"40.704538,-74.01324\"],\n" +"[\"store30\",\"2 Columbus Ave. - New York NY (W)\",\"40.769262,-73.984764\"],\n" +"[\"store31\",\"NY Plaza - New York NY (W)\",\"40.702802,-74.012784\"],\n" +"[\"store32\",\"36th and Madison - New York NY (W)\",\"40.748917,-73.982683\"],\n" +"[\"store33\",\"125th St. btwn Adam Clayton & FDB - New York NY\",\"40.808952,-73.94" +"8229\"],\n" +"[\"store34\",\"70th & Broadway - New York NY (W)\",\"40.777463,-73.982237\"],\n" +"[\"store35\",\"2138 Broadway - New York NY (W)\",\"40.781078,-73.981167\"],\n" +"[\"store36\",\"118th & Frederick Douglas Blvd. - New York NY (W)\",\"40.806176,-73" +".954109\"],\n" +"[\"store37\",\"42nd & Second - New York NY (W)\",\"40.750069,-73.973393\"],\n" +"[\"store38\",\"Broadway @ 81st - New York NY (W)\",\"40.784972,-73.978987\"],\n" +"[\"store39\",\"Fashion Inst of Technology - New York NY\",\"40.746948,-73.994557\"]\n" "]\n" "~~~" msgstr "" @@ -473,7 +457,7 @@ msgstr "データが準備できたら、`load` コマンドのPOSTリクエス msgid "" " # curl --data \"@stores.json\" \"${endpoint}/load?table=Store\"\n" -" [[0,1398666180.023,0.069],[40]]" +" [[0,1401358564.909,0.158],[40]]" msgstr "" msgid "Now all data in the JSON file are successfully loaded." @@ -489,27 +473,27 @@ msgid "As the starter, let's select initial ten records with the `select` comman msgstr "試しに、`select` コマンドを使って最初の10レコードを取り出してみましょう:" msgid "" -" # curl \"${endpoint}/select?table=Store&output_columns=_key&limit=10\"\n" -" [[0,1398666260.887927,0.000017404556274414062],[[[40],[[\"_key\",\"ShortText\"" -"]],[\"1st Avenue & 75th St. - New York NY (W)\"],[\"2nd Ave. & 9th Street - New " -"York NY\"],[\"76th & Second - New York NY (W)\"],[\"15th & Third - New York NY (" -"W)\"],[\"41st and Broadway - New York NY (W)\"],[\"West 43rd and Broadway - New Y" -"ork NY (W)\"],[\"84th & Third Ave - New York NY (W)\"],[\"150 E. 42nd Street - N" -"ew York NY (W)\"],[\"Macy's 35th Street Balcony - New York NY\"],[\"Herald Square" -"- Macy's - New York NY\"]]]]" +" # curl \"${endpoint}/select?table=Store&output_columns=name&limit=10\"\n" +" [[0,1401362059.7437818,0.00004935264587402344],[[[40],[[\"name\",\"ShortText\"" +"]],[\"1st Avenue & 75th St. - New York NY (W)\"],[\"76th & Second - New York NY " +" (W)\"],[\"Herald Square- Macy's - New York NY\"],[\"Macy's 5th Floor - Herald Squ" +"are - New York NY (W)\"],[\"80th & York - New York NY (W)\"],[\"Columbus @ 67th " +"- New York NY (W)\"],[\"45th & Broadway - New York NY (W)\"],[\"Marriott Marquis" +" - Lobby - New York NY\"],[\"Second @ 81st - New York NY (W)\"],[\"52nd & Seventh" +" - New York NY (W)\"]]]]" msgstr "" msgid "Of course you can specify conditions via the `query` option:" msgstr "もちろん、`query` オプションを使って検索条件を指定する事もできます:" msgid "" -" # curl \"${endpoint}/select?table=Store&query=Columbus&match_columns=_key&o" -"utput_columns=_key&limit=10\"\n" +" # curl \"${endpoint}/select?table=Store&query=Columbus&match_columns=name&o" +"utput_columns=name&limit=10\"\n" " [[0,1398670157.661574,0.0012705326080322266],[[[2],[[\"_key\",\"ShortText\"]]," "[\"Columbus @ 67th - New York NY (W)\"],[\"2 Columbus Ave. - New York NY (W)\"]]" "]]\n" -" # curl \"${endpoint}/select?table=Store&filter=_key@'Ave'&output_columns=_k" -"ey&limit=10\"\n" +" # curl \"${endpoint}/select?table=Store&filter=name@'Ave'&output_columns=na" +"me&limit=10\"\n" " [[0,1398670586.193325,0.0003848075866699219],[[[3],[[\"_key\",\"ShortText\"]]," "[\"2nd Ave. & 9th Street - New York NY\"],[\"84th & Third Ave - New York NY (W)\"" "],[\"2 Columbus Ave. - New York NY (W)\"]]]]" Modified: ja/tutorial/1.0.3/groonga/index.md (+75 -85) =================================================================== --- ja/tutorial/1.0.3/groonga/index.md 2014-05-29 20:21:56 +0900 (b95c298) +++ ja/tutorial/1.0.3/groonga/index.md 2014-05-29 20:26:42 +0900 (be6f4b0) @@ -122,13 +122,12 @@ GroongaをHTTPサーバとして使う場合は、以下のように `-d` オプ --log-file=~/droonga/droonga-engine.log \ --daemon \ --pid-file=~/droonga/droonga-engine.pid - # droonga-http-server --port=10041 \ - --receive-host-name=$host \ - --droonga-engine-host-name=$host \ - --access-log-file=~/droonga/droonga-http-server.access.log \ - --system-log-file=~/droonga/droonga-http-server.system.log \ - --daemon \ - --pid-file=~/droonga/droonga-http-server.pid + # env NODE_ENV=production \ + droonga-http-server --port=10041 \ + --receive-host-name=$host \ + --droonga-engine-host-name=$host \ + --daemon \ + --pid-file=~/droonga/droonga-http-server.pid いくつかのオプションにおいて、そのDroongaノード自身のホスト名を指定する必要がある事に注意して下さい。 この情報は、クラスタ内の他のDroongaノードとの通信のために使われます。 @@ -146,7 +145,7 @@ GroongaをHTTPサーバとして使う場合は、以下のように `-d` オプ # kill $(cat ~/droonga/droonga-engine.pid) # kill $(cat ~/droonga/droonga-http-server.pid) -### テーブルの作成 +### テーブル、カラム、インデックスの作成 以上の手順で、Groonga HTTPサーバ互換のサービスとして動作するDroongaクラスタができました。 @@ -154,49 +153,41 @@ GroongaをHTTPサーバとして使う場合は、以下のように `-d` オプ 新しいテーブル `Store` を作るには、`table_create` コマンドにあたるGETリクエストを送信して下さい: # endpoint="http://192.168.0.10:10041/d" - # curl "${endpoint}/table_create?name=Store&type=Hash&key_type=ShortText" - [[0,1398662266.3853862,0.08530688285827637],true] + # curl "${endpoint}/table_create?name=Store&flags=TABLE_PAT_KEY&key_type=ShortText" + [[0,1401358896.360356,0.0035653114318847656],true] リクエストの送信先として、Droongaノード中でdroonga-http-serverが動作しているDroongaノードのどれか1つを指定する必要がある事に注意して下さい。 言い換えると、接続先（エンドポイント）としてはクラスタ中のどのノードでも好きな物を使う事ができます。 すべてのリクエストは、クラスタ中の適切なノードに配送されます。 -さて、テーブルを正しく作成できました。 -`table_list` コマンドを使って、作成されたテーブルの情報を見てみましょう: - - # curl "${endpoint}/table_list" - [[0,1398662423.509928,0.003869295120239258],[[["id","UInt32"],["name","ShortText"],["path","ShortText"],["flags","ShortText"],["domain","ShortText"],["range","ShortText"],["default_tokenizer","ShortText"],["normalizer","ShortText"]],[256,"Store","/home/username/groonga/droonga-engine/000/db.0000100","TABLE_HASH_KEY|PERSISTENT","ShortText",null,null,null]]] - -Droongaはクラスタで動作するので、他のエンドポイントも同じ結果を返します。 - - # curl "http://192.168.0.11:10041/d/table_list" - [[0,1398662423.509928,0.003869295120239258],[[["id","UInt32"],["name","ShortText"],["path","ShortText"],["flags","ShortText"],["domain","ShortText"],["range","ShortText"],["default_tokenizer","ShortText"],["normalizer","ShortText"]],[256,"Store","/home/username/groonga/droonga-engine/000/db.0000100","TABLE_HASH_KEY|PERSISTENT","ShortText",null,null,null]]] - -### カラムの作成 - -次は、`column_create` コマンドを使って `Store` テーブルに `location` という新しいカラムを作ります: +次は、`column_create` コマンドを使って `Store` テーブルに `name` と `location` という新しいカラムを作ります: + # curl "${endpoint}/column_create?table=Store&name=name&flags=COLUMN_SCALAR&type=ShortText" + [[0,1401358348.6541538,0.0004096031188964844],true] # curl "${endpoint}/column_create?table=Store&name=location&flags=COLUMN_SCALAR&type=WGS84GeoPoint" - [[0,1398664305.8856306,0.00026226043701171875],true] + [[0,1401358359.084659,0.002511262893676758],true],true] -`column_list` コマンドを使って、カラムが正しく作成された事を確認しましょう: +インデックスも作成しましょう。 - # curl "${endpoint}/column_list?table=Store" - [[0,1398664345.9680889,0.0011739730834960938],[[["id","UInt32"],["name","ShortText"],["path","ShortText"],["type","ShortText"],["flags","ShortText"],["domain","ShortText"],["range","ShortText"],["source","ShortText"]],[257,"location","/home/username/groonga/droonga-engine/000/db.0000101","fix","COLUMN_SCALAR","Store","WGS84GeoPoint",[]]]] + # curl "${endpoint}/table_create?name=Term&flags=TABLE_PAT_KEY&key_type=ShortText&default_tokenizer=TokenBigram&normalizer=NormalizerAuto" + [[0,1401358475.7229664,0.002419710159301758],true] + # curl "${endpoint}/column_create?table=Term&name=store_name&flags=COLUMN_INDEX|WITH_POSITION&type=Store&source=name" + [[0,1401358494.1656318,0.006799221038818359],true] + # curl "${endpoint}/table_create?name=Location&flags=TABLE_PAT_KEY&key_type=WGS84GeoPoint" + [[0,1401358505.708896,0.0016951560974121094],true] + # curl "${endpoint}/column_create?table=Location&name=store&flags=COLUMN_INDEX&type=Store&source=location" + [[0,1401358519.6187897,0.024788379669189453],true] -### インデックスの作成 +さて、テーブルを正しく作成できました。 +`table_list` コマンドを使って、作成されたテーブルの情報を見てみましょう: -インデックスも作成しましょう。 + # curl "${endpoint}/table_list" + [[0,1401358908.9126804,0.001600027084350586],[[["id","UInt32"],["name","ShortText"],["path","ShortText"],["flags","ShortText"],["domain","ShortText"],["range","ShortText"],["default_tokenizer","ShortText"],["normalizer","ShortText"]],[256,"Store","/home/vagrant/droonga/000/db.0000100","TABLE_PAT_KEY|PERSISTENT","ShortText",null,null,null]]] - # curl "${endpoint}/table_create?name=Location&type=PatriciaTrie&key_type=WGS84GeoPoint" - [[0,1398664401.4927232,0.12011909484863281],true] - # curl "${endpoint}/column_create?table=Location&name=store&flags=COLUMN_INDEX&type=Store&source=location" - [[0,1398664429.5348525,0.13435077667236328],true] - # curl "${endpoint}/table_create?name=Term&type=PatriciaTrie&key_type=ShortText&default_tokenizer=TokenBigram&normalizer=NormalizerAuto" - [[0,1398664454.446939,0.14734888076782227],true] - # curl "${endpoint}/column_create?table=Term&name=store__key&flags=COLUMN_INDEX|WITH_POSITION&type=Store&source=_key" - [[0,1398664474.7112074,0.12619781494140625],true] +Droongaはクラスタで動作するので、他のエンドポイントも同じ結果を返します。 + # curl "http://192.168.0.11:10041/d/table_list" + [[0,1401358908.9126804,0.001600027084350586],[[["id","UInt32"],["name","ShortText"],["path","ShortText"],["flags","ShortText"],["domain","ShortText"],["range","ShortText"],["default_tokenizer","ShortText"],["normalizer","ShortText"]],[256,"Store","/home/vagrant/droonga/000/db.0000100","TABLE_PAT_KEY|PERSISTENT","ShortText",null,null,null]]] ### テーブルへのデータの読み込み @@ -207,54 +198,54 @@ stores.json: ~~~ [ -["_key","location"], -["1st Avenue & 75th St. - New York NY (W)","40.770262,-73.954798"], -["76th & Second - New York NY (W)","40.771056,-73.956757"], -["2nd Ave. & 9th Street - New York NY","40.729445,-73.987471"], -["15th & Third - New York NY (W)","40.733946,-73.9867"], -["41st and Broadway - New York NY (W)","40.755111,-73.986225"], -["84th & Third Ave - New York NY (W)","40.777485,-73.954979"], -["150 E. 42nd Street - New York NY (W)","40.750784,-73.975582"], -["West 43rd and Broadway - New York NY (W)","40.756197,-73.985624"], -["Macy's 35th Street Balcony - New York NY","40.750703,-73.989787"], -["Macy's 6th Floor - Herald Square - New York NY (W)","40.750703,-73.989787"], -["Herald Square- Macy's - New York NY","40.750703,-73.989787"], -["Macy's 5th Floor - Herald Square - New York NY (W)","40.750703,-73.989787"], -["80th & York - New York NY (W)","40.772204,-73.949862"], -["Columbus @ 67th - New York NY (W)","40.774009,-73.981472"], -["45th & Broadway - New York NY (W)","40.75766,-73.985719"], -["Marriott Marquis - Lobby - New York NY","40.759123,-73.984927"], -["Second @ 81st - New York NY (W)","40.77466,-73.954447"], -["52nd & Seventh - New York NY (W)","40.761829,-73.981141"], -["1585 Broadway (47th) - New York NY (W)","40.759806,-73.985066"], -["85th & First - New York NY (W)","40.776101,-73.949971"], -["92nd & 3rd - New York NY (W)","40.782606,-73.951235"], -["165 Broadway - 1 Liberty - New York NY (W)","40.709727,-74.011395"], -["1656 Broadway - New York NY (W)","40.762434,-73.983364"], -["54th & Broadway - New York NY (W)","40.764275,-73.982361"], -["Limited Brands-NYC - New York NY","40.765219,-73.982025"], -["19th & 8th - New York NY (W)","40.743218,-74.000605"], -["60th & Broadway-II - New York NY (W)","40.769196,-73.982576"], -["63rd & Broadway - New York NY (W)","40.771376,-73.982709"], -["195 Broadway - New York NY (W)","40.710703,-74.009485"], -["2 Broadway - New York NY (W)","40.704538,-74.01324"], -["2 Columbus Ave. - New York NY (W)","40.769262,-73.984764"], -["NY Plaza - New York NY (W)","40.702802,-74.012784"], -["36th and Madison - New York NY (W)","40.748917,-73.982683"], -["125th St. btwn Adam Clayton & FDB - New York NY","40.808952,-73.948229"], -["70th & Broadway - New York NY (W)","40.777463,-73.982237"], -["2138 Broadway - New York NY (W)","40.781078,-73.981167"], -["118th & Frederick Douglas Blvd. - New York NY (W)","40.806176,-73.954109"], -["42nd & Second - New York NY (W)","40.750069,-73.973393"], -["Broadway @ 81st - New York NY (W)","40.784972,-73.978987"], -["Fashion Inst of Technology - New York NY","40.746948,-73.994557"] +["_key","name","location"], +["store0","1st Avenue & 75th St. - New York NY (W)","40.770262,-73.954798"], +["store1","76th & Second - New York NY (W)","40.771056,-73.956757"], +["store2","2nd Ave. & 9th Street - New York NY","40.729445,-73.987471"], +["store3","15th & Third - New York NY (W)","40.733946,-73.9867"], +["store4","41st and Broadway - New York NY (W)","40.755111,-73.986225"], +["store5","84th & Third Ave - New York NY (W)","40.777485,-73.954979"], +["store6","150 E. 42nd Street - New York NY (W)","40.750784,-73.975582"], +["store7","West 43rd and Broadway - New York NY (W)","40.756197,-73.985624"], +["store8","Macy's 35th Street Balcony - New York NY","40.750703,-73.989787"], +["store9","Macy's 6th Floor - Herald Square - New York NY (W)","40.750703,-73.989787"], +["store10","Herald Square- Macy's - New York NY","40.750703,-73.989787"], +["store11","Macy's 5th Floor - Herald Square - New York NY (W)","40.750703,-73.989787"], +["store12","80th & York - New York NY (W)","40.772204,-73.949862"], +["store13","Columbus @ 67th - New York NY (W)","40.774009,-73.981472"], +["store14","45th & Broadway - New York NY (W)","40.75766,-73.985719"], +["store15","Marriott Marquis - Lobby - New York NY","40.759123,-73.984927"], +["store16","Second @ 81st - New York NY (W)","40.77466,-73.954447"], +["store17","52nd & Seventh - New York NY (W)","40.761829,-73.981141"], +["store18","1585 Broadway (47th) - New York NY (W)","40.759806,-73.985066"], +["store19","85th & First - New York NY (W)","40.776101,-73.949971"], +["store20","92nd & 3rd - New York NY (W)","40.782606,-73.951235"], +["store21","165 Broadway - 1 Liberty - New York NY (W)","40.709727,-74.011395"], +["store22","1656 Broadway - New York NY (W)","40.762434,-73.983364"], +["store23","54th & Broadway - New York NY (W)","40.764275,-73.982361"], +["store24","Limited Brands-NYC - New York NY","40.765219,-73.982025"], +["store25","19th & 8th - New York NY (W)","40.743218,-74.000605"], +["store26","60th & Broadway-II - New York NY (W)","40.769196,-73.982576"], +["store27","63rd & Broadway - New York NY (W)","40.771376,-73.982709"], +["store28","195 Broadway - New York NY (W)","40.710703,-74.009485"], +["store29","2 Broadway - New York NY (W)","40.704538,-74.01324"], +["store30","2 Columbus Ave. - New York NY (W)","40.769262,-73.984764"], +["store31","NY Plaza - New York NY (W)","40.702802,-74.012784"], +["store32","36th and Madison - New York NY (W)","40.748917,-73.982683"], +["store33","125th St. btwn Adam Clayton & FDB - New York NY","40.808952,-73.948229"], +["store34","70th & Broadway - New York NY (W)","40.777463,-73.982237"], +["store35","2138 Broadway - New York NY (W)","40.781078,-73.981167"], +["store36","118th & Frederick Douglas Blvd. - New York NY (W)","40.806176,-73.954109"], +["store37","42nd & Second - New York NY (W)","40.750069,-73.973393"], +["store38","Broadway @ 81st - New York NY (W)","40.784972,-73.978987"], +["store39","Fashion Inst of Technology - New York NY","40.746948,-73.994557"] ] ~~~ データが準備できたら、`load` コマンドのPOSTリクエストとして送信します: # curl --data "@stores.json" "${endpoint}/load?table=Store" - [[0,1398666180.023,0.069],[40]] + [[0,1401358564.909,0.158],[40]] これで、JSONファイル中のすべてのデータが正しく読み込まれます。 @@ -264,17 +255,16 @@ stores.json: 試しに、`select` コマンドを使って最初の10レコードを取り出してみましょう: - # curl "${endpoint}/select?table=Store&output_columns=_key&limit=10" - [[0,1398666260.887927,0.000017404556274414062],[[[40],[["_key","ShortText"]],["1st Avenue & 75th St. - New York NY (W)"],["2nd Ave. & 9th Street - New York NY"],["76th & Second - New York NY (W)"],["15th & Third - New York NY (W)"],["41st and Broadway - New York NY (W)"],["West 43rd and Broadway - New York NY (W)"],["84th & Third Ave - New York NY (W)"],["150 E. 42nd Street - New York NY (W)"],["Macy's 35th Street Balcony - New York NY"],["Herald Square- Macy's - New York NY"]]]] + # curl "${endpoint}/select?table=Store&output_columns=name&limit=10" + [[0,1401362059.7437818,0.00004935264587402344],[[[40],[["name","ShortText"]],["1st Avenue & 75th St. - New York NY (W)"],["76th & Second - New York NY (W)"],["Herald Square- Macy's - New York NY"],["Macy's 5th Floor - Herald Square - New York NY (W)"],["80th & York - New York NY (W)"],["Columbus @ 67th - New York NY (W)"],["45th & Broadway - New York NY (W)"],["Marriott Marquis - Lobby - New York NY"],["Second @ 81st - New York NY (W)"],["52nd & Seventh - New York NY (W)"]]]] もちろん、`query` オプションを使って検索条件を指定する事もできます: - # curl "${endpoint}/select?table=Store&query=Columbus&match_columns=_key&output_columns=_key&limit=10" + # curl "${endpoint}/select?table=Store&query=Columbus&match_columns=name&output_columns=name&limit=10" [[0,1398670157.661574,0.0012705326080322266],[[[2],[["_key","ShortText"]],["Columbus @ 67th - New York NY (W)"],["2 Columbus Ave. - New York NY (W)"]]]] - # curl "${endpoint}/select?table=Store&filter=_key@'Ave'&output_columns=_key&limit=10" + # curl "${endpoint}/select?table=Store&filter=name@'Ave'&output_columns=name&limit=10" [[0,1398670586.193325,0.0003848075866699219],[[[3],[["_key","ShortText"]],["2nd Ave. & 9th Street - New York NY"],["84th & Third Ave - New York NY (W)"],["2 Columbus Ave. - New York NY (W)"]]]] - ## まとめ このチュートリアルでは、[Ubuntu Linux][Ubuntu]のコンピュータを使って[Droonga][]クラスタを構築しました。 Modified: ja/tutorial/1.0.4/groonga/index.md (+75 -85) =================================================================== --- ja/tutorial/1.0.4/groonga/index.md 2014-05-29 20:21:56 +0900 (e284700) +++ ja/tutorial/1.0.4/groonga/index.md 2014-05-29 20:26:42 +0900 (2588e74) @@ -122,13 +122,12 @@ GroongaをHTTPサーバとして使う場合は、以下のように `-d` オプ --log-file=~/droonga/droonga-engine.log \ --daemon \ --pid-file=~/droonga/droonga-engine.pid - # droonga-http-server --port=10041 \ - --receive-host-name=$host \ - --droonga-engine-host-name=$host \ - --access-log-file=~/droonga/droonga-http-server.access.log \ - --system-log-file=~/droonga/droonga-http-server.system.log \ - --daemon \ - --pid-file=~/droonga/droonga-http-server.pid + # env NODE_ENV=production \ + droonga-http-server --port=10041 \ + --receive-host-name=$host \ + --droonga-engine-host-name=$host \ + --daemon \ + --pid-file=~/droonga/droonga-http-server.pid いくつかのオプションにおいて、そのDroongaノード自身のホスト名を指定する必要がある事に注意して下さい。 この情報は、クラスタ内の他のDroongaノードとの通信のために使われます。 @@ -146,7 +145,7 @@ GroongaをHTTPサーバとして使う場合は、以下のように `-d` オプ # kill $(cat ~/droonga/droonga-engine.pid) # kill $(cat ~/droonga/droonga-http-server.pid) -### テーブルの作成 +### テーブル、カラム、インデックスの作成 以上の手順で、Groonga HTTPサーバ互換のサービスとして動作するDroongaクラスタができました。 @@ -154,49 +153,41 @@ GroongaをHTTPサーバとして使う場合は、以下のように `-d` オプ 新しいテーブル `Store` を作るには、`table_create` コマンドにあたるGETリクエストを送信して下さい: # endpoint="http://192.168.0.10:10041/d" - # curl "${endpoint}/table_create?name=Store&type=Hash&key_type=ShortText" - [[0,1398662266.3853862,0.08530688285827637],true] + # curl "${endpoint}/table_create?name=Store&flags=TABLE_PAT_KEY&key_type=ShortText" + [[0,1401358896.360356,0.0035653114318847656],true] リクエストの送信先として、Droongaノード中でdroonga-http-serverが動作しているDroongaノードのどれか1つを指定する必要がある事に注意して下さい。 言い換えると、接続先（エンドポイント）としてはクラスタ中のどのノードでも好きな物を使う事ができます。 すべてのリクエストは、クラスタ中の適切なノードに配送されます。 -さて、テーブルを正しく作成できました。 -`table_list` コマンドを使って、作成されたテーブルの情報を見てみましょう: - - # curl "${endpoint}/table_list" - [[0,1398662423.509928,0.003869295120239258],[[["id","UInt32"],["name","ShortText"],["path","ShortText"],["flags","ShortText"],["domain","ShortText"],["range","ShortText"],["default_tokenizer","ShortText"],["normalizer","ShortText"]],[256,"Store","/home/username/groonga/droonga-engine/000/db.0000100","TABLE_HASH_KEY|PERSISTENT","ShortText",null,null,null]]] - -Droongaはクラスタで動作するので、他のエンドポイントも同じ結果を返します。 - - # curl "http://192.168.0.11:10041/d/table_list" - [[0,1398662423.509928,0.003869295120239258],[[["id","UInt32"],["name","ShortText"],["path","ShortText"],["flags","ShortText"],["domain","ShortText"],["range","ShortText"],["default_tokenizer","ShortText"],["normalizer","ShortText"]],[256,"Store","/home/username/groonga/droonga-engine/000/db.0000100","TABLE_HASH_KEY|PERSISTENT","ShortText",null,null,null]]] - -### カラムの作成 - -次は、`column_create` コマンドを使って `Store` テーブルに `location` という新しいカラムを作ります: +次は、`column_create` コマンドを使って `Store` テーブルに `name` と `location` という新しいカラムを作ります: + # curl "${endpoint}/column_create?table=Store&name=name&flags=COLUMN_SCALAR&type=ShortText" + [[0,1401358348.6541538,0.0004096031188964844],true] # curl "${endpoint}/column_create?table=Store&name=location&flags=COLUMN_SCALAR&type=WGS84GeoPoint" - [[0,1398664305.8856306,0.00026226043701171875],true] + [[0,1401358359.084659,0.002511262893676758],true],true] -`column_list` コマンドを使って、カラムが正しく作成された事を確認しましょう: +インデックスも作成しましょう。 - # curl "${endpoint}/column_list?table=Store" - [[0,1398664345.9680889,0.0011739730834960938],[[["id","UInt32"],["name","ShortText"],["path","ShortText"],["type","ShortText"],["flags","ShortText"],["domain","ShortText"],["range","ShortText"],["source","ShortText"]],[257,"location","/home/username/groonga/droonga-engine/000/db.0000101","fix","COLUMN_SCALAR","Store","WGS84GeoPoint",[]]]] + # curl "${endpoint}/table_create?name=Term&flags=TABLE_PAT_KEY&key_type=ShortText&default_tokenizer=TokenBigram&normalizer=NormalizerAuto" + [[0,1401358475.7229664,0.002419710159301758],true] + # curl "${endpoint}/column_create?table=Term&name=store_name&flags=COLUMN_INDEX|WITH_POSITION&type=Store&source=name" + [[0,1401358494.1656318,0.006799221038818359],true] + # curl "${endpoint}/table_create?name=Location&flags=TABLE_PAT_KEY&key_type=WGS84GeoPoint" + [[0,1401358505.708896,0.0016951560974121094],true] + # curl "${endpoint}/column_create?table=Location&name=store&flags=COLUMN_INDEX&type=Store&source=location" + [[0,1401358519.6187897,0.024788379669189453],true] -### インデックスの作成 +さて、テーブルを正しく作成できました。 +`table_list` コマンドを使って、作成されたテーブルの情報を見てみましょう: -インデックスも作成しましょう。 + # curl "${endpoint}/table_list" + [[0,1401358908.9126804,0.001600027084350586],[[["id","UInt32"],["name","ShortText"],["path","ShortText"],["flags","ShortText"],["domain","ShortText"],["range","ShortText"],["default_tokenizer","ShortText"],["normalizer","ShortText"]],[256,"Store","/home/vagrant/droonga/000/db.0000100","TABLE_PAT_KEY|PERSISTENT","ShortText",null,null,null]]] - # curl "${endpoint}/table_create?name=Location&type=PatriciaTrie&key_type=WGS84GeoPoint" - [[0,1398664401.4927232,0.12011909484863281],true] - # curl "${endpoint}/column_create?table=Location&name=store&flags=COLUMN_INDEX&type=Store&source=location" - [[0,1398664429.5348525,0.13435077667236328],true] - # curl "${endpoint}/table_create?name=Term&type=PatriciaTrie&key_type=ShortText&default_tokenizer=TokenBigram&normalizer=NormalizerAuto" - [[0,1398664454.446939,0.14734888076782227],true] - # curl "${endpoint}/column_create?table=Term&name=store__key&flags=COLUMN_INDEX|WITH_POSITION&type=Store&source=_key" - [[0,1398664474.7112074,0.12619781494140625],true] +Droongaはクラスタで動作するので、他のエンドポイントも同じ結果を返します。 + # curl "http://192.168.0.11:10041/d/table_list" + [[0,1401358908.9126804,0.001600027084350586],[[["id","UInt32"],["name","ShortText"],["path","ShortText"],["flags","ShortText"],["domain","ShortText"],["range","ShortText"],["default_tokenizer","ShortText"],["normalizer","ShortText"]],[256,"Store","/home/vagrant/droonga/000/db.0000100","TABLE_PAT_KEY|PERSISTENT","ShortText",null,null,null]]] ### テーブルへのデータの読み込み @@ -207,54 +198,54 @@ stores.json: ~~~ [ -["_key","location"], -["1st Avenue & 75th St. - New York NY (W)","40.770262,-73.954798"], -["76th & Second - New York NY (W)","40.771056,-73.956757"], -["2nd Ave. & 9th Street - New York NY","40.729445,-73.987471"], -["15th & Third - New York NY (W)","40.733946,-73.9867"], -["41st and Broadway - New York NY (W)","40.755111,-73.986225"], -["84th & Third Ave - New York NY (W)","40.777485,-73.954979"], -["150 E. 42nd Street - New York NY (W)","40.750784,-73.975582"], -["West 43rd and Broadway - New York NY (W)","40.756197,-73.985624"], -["Macy's 35th Street Balcony - New York NY","40.750703,-73.989787"], -["Macy's 6th Floor - Herald Square - New York NY (W)","40.750703,-73.989787"], -["Herald Square- Macy's - New York NY","40.750703,-73.989787"], -["Macy's 5th Floor - Herald Square - New York NY (W)","40.750703,-73.989787"], -["80th & York - New York NY (W)","40.772204,-73.949862"], -["Columbus @ 67th - New York NY (W)","40.774009,-73.981472"], -["45th & Broadway - New York NY (W)","40.75766,-73.985719"], -["Marriott Marquis - Lobby - New York NY","40.759123,-73.984927"], -["Second @ 81st - New York NY (W)","40.77466,-73.954447"], -["52nd & Seventh - New York NY (W)","40.761829,-73.981141"], -["1585 Broadway (47th) - New York NY (W)","40.759806,-73.985066"], -["85th & First - New York NY (W)","40.776101,-73.949971"], -["92nd & 3rd - New York NY (W)","40.782606,-73.951235"], -["165 Broadway - 1 Liberty - New York NY (W)","40.709727,-74.011395"], -["1656 Broadway - New York NY (W)","40.762434,-73.983364"], -["54th & Broadway - New York NY (W)","40.764275,-73.982361"], -["Limited Brands-NYC - New York NY","40.765219,-73.982025"], -["19th & 8th - New York NY (W)","40.743218,-74.000605"], -["60th & Broadway-II - New York NY (W)","40.769196,-73.982576"], -["63rd & Broadway - New York NY (W)","40.771376,-73.982709"], -["195 Broadway - New York NY (W)","40.710703,-74.009485"], -["2 Broadway - New York NY (W)","40.704538,-74.01324"], -["2 Columbus Ave. - New York NY (W)","40.769262,-73.984764"], -["NY Plaza - New York NY (W)","40.702802,-74.012784"], -["36th and Madison - New York NY (W)","40.748917,-73.982683"], -["125th St. btwn Adam Clayton & FDB - New York NY","40.808952,-73.948229"], -["70th & Broadway - New York NY (W)","40.777463,-73.982237"], -["2138 Broadway - New York NY (W)","40.781078,-73.981167"], -["118th & Frederick Douglas Blvd. - New York NY (W)","40.806176,-73.954109"], -["42nd & Second - New York NY (W)","40.750069,-73.973393"], -["Broadway @ 81st - New York NY (W)","40.784972,-73.978987"], -["Fashion Inst of Technology - New York NY","40.746948,-73.994557"] +["_key","name","location"], +["store0","1st Avenue & 75th St. - New York NY (W)","40.770262,-73.954798"], +["store1","76th & Second - New York NY (W)","40.771056,-73.956757"], +["store2","2nd Ave. & 9th Street - New York NY","40.729445,-73.987471"], +["store3","15th & Third - New York NY (W)","40.733946,-73.9867"], +["store4","41st and Broadway - New York NY (W)","40.755111,-73.986225"], +["store5","84th & Third Ave - New York NY (W)","40.777485,-73.954979"], +["store6","150 E. 42nd Street - New York NY (W)","40.750784,-73.975582"], +["store7","West 43rd and Broadway - New York NY (W)","40.756197,-73.985624"], +["store8","Macy's 35th Street Balcony - New York NY","40.750703,-73.989787"], +["store9","Macy's 6th Floor - Herald Square - New York NY (W)","40.750703,-73.989787"], +["store10","Herald Square- Macy's - New York NY","40.750703,-73.989787"], +["store11","Macy's 5th Floor - Herald Square - New York NY (W)","40.750703,-73.989787"], +["store12","80th & York - New York NY (W)","40.772204,-73.949862"], +["store13","Columbus @ 67th - New York NY (W)","40.774009,-73.981472"], +["store14","45th & Broadway - New York NY (W)","40.75766,-73.985719"], +["store15","Marriott Marquis - Lobby - New York NY","40.759123,-73.984927"], +["store16","Second @ 81st - New York NY (W)","40.77466,-73.954447"], +["store17","52nd & Seventh - New York NY (W)","40.761829,-73.981141"], +["store18","1585 Broadway (47th) - New York NY (W)","40.759806,-73.985066"], +["store19","85th & First - New York NY (W)","40.776101,-73.949971"], +["store20","92nd & 3rd - New York NY (W)","40.782606,-73.951235"], +["store21","165 Broadway - 1 Liberty - New York NY (W)","40.709727,-74.011395"], +["store22","1656 Broadway - New York NY (W)","40.762434,-73.983364"], +["store23","54th & Broadway - New York NY (W)","40.764275,-73.982361"], +["store24","Limited Brands-NYC - New York NY","40.765219,-73.982025"], +["store25","19th & 8th - New York NY (W)","40.743218,-74.000605"], +["store26","60th & Broadway-II - New York NY (W)","40.769196,-73.982576"], +["store27","63rd & Broadway - New York NY (W)","40.771376,-73.982709"], +["store28","195 Broadway - New York NY (W)","40.710703,-74.009485"], +["store29","2 Broadway - New York NY (W)","40.704538,-74.01324"], +["store30","2 Columbus Ave. - New York NY (W)","40.769262,-73.984764"], +["store31","NY Plaza - New York NY (W)","40.702802,-74.012784"], +["store32","36th and Madison - New York NY (W)","40.748917,-73.982683"], +["store33","125th St. btwn Adam Clayton & FDB - New York NY","40.808952,-73.948229"], +["store34","70th & Broadway - New York NY (W)","40.777463,-73.982237"], +["store35","2138 Broadway - New York NY (W)","40.781078,-73.981167"], +["store36","118th & Frederick Douglas Blvd. - New York NY (W)","40.806176,-73.954109"], +["store37","42nd & Second - New York NY (W)","40.750069,-73.973393"], +["store38","Broadway @ 81st - New York NY (W)","40.784972,-73.978987"], +["store39","Fashion Inst of Technology - New York NY","40.746948,-73.994557"] ] ~~~ データが準備できたら、`load` コマンドのPOSTリクエストとして送信します: # curl --data "@stores.json" "${endpoint}/load?table=Store" - [[0,1398666180.023,0.069],[40]] + [[0,1401358564.909,0.158],[40]] これで、JSONファイル中のすべてのデータが正しく読み込まれます。 @@ -264,17 +255,16 @@ stores.json: 試しに、`select` コマンドを使って最初の10レコードを取り出してみましょう: - # curl "${endpoint}/select?table=Store&output_columns=_key&limit=10" - [[0,1398666260.887927,0.000017404556274414062],[[[40],[["_key","ShortText"]],["1st Avenue & 75th St. - New York NY (W)"],["2nd Ave. & 9th Street - New York NY"],["76th & Second - New York NY (W)"],["15th & Third - New York NY (W)"],["41st and Broadway - New York NY (W)"],["West 43rd and Broadway - New York NY (W)"],["84th & Third Ave - New York NY (W)"],["150 E. 42nd Street - New York NY (W)"],["Macy's 35th Street Balcony - New York NY"],["Herald Square- Macy's - New York NY"]]]] + # curl "${endpoint}/select?table=Store&output_columns=name&limit=10" + [[0,1401362059.7437818,0.00004935264587402344],[[[40],[["name","ShortText"]],["1st Avenue & 75th St. - New York NY (W)"],["76th & Second - New York NY (W)"],["Herald Square- Macy's - New York NY"],["Macy's 5th Floor - Herald Square - New York NY (W)"],["80th & York - New York NY (W)"],["Columbus @ 67th - New York NY (W)"],["45th & Broadway - New York NY (W)"],["Marriott Marquis - Lobby - New York NY"],["Second @ 81st - New York NY (W)"],["52nd & Seventh - New York NY (W)"]]]] もちろん、`query` オプションを使って検索条件を指定する事もできます: - # curl "${endpoint}/select?table=Store&query=Columbus&match_columns=_key&output_columns=_key&limit=10" + # curl "${endpoint}/select?table=Store&query=Columbus&match_columns=name&output_columns=name&limit=10" [[0,1398670157.661574,0.0012705326080322266],[[[2],[["_key","ShortText"]],["Columbus @ 67th - New York NY (W)"],["2 Columbus Ave. - New York NY (W)"]]]] - # curl "${endpoint}/select?table=Store&filter=_key@'Ave'&output_columns=_key&limit=10" + # curl "${endpoint}/select?table=Store&filter=name@'Ave'&output_columns=name&limit=10" [[0,1398670586.193325,0.0003848075866699219],[[[3],[["_key","ShortText"]],["2nd Ave. & 9th Street - New York NY"],["84th & Third Ave - New York NY (W)"],["2 Columbus Ave. - New York NY (W)"]]]] - ## まとめ このチュートリアルでは、[Ubuntu Linux][Ubuntu]のコンピュータを使って[Droonga][]クラスタを構築しました。 -------------- next part -------------- HTML����������������������������...ダウンロード
