Yasuhiro Horimoto 2018-12-28 00:33:47 +0900 (Fri, 28 Dec 2018) Revision: 55df31d4bf8ed052ef7e78fa567cde7484c04f4c https://github.com/groonga/groonga.org/commit/55df31d4bf8ed052ef7e78fa567cde7484c04f4c Message: blog: add release announce for 8.1.0 Added files: en/_posts/2018-12-29-groonga-8.1.0.md ja/_posts/2018-12-29-groonga-8.1.0.md Added: en/_posts/2018-12-29-groonga-8.1.0.md (+151 -0) 100644 =================================================================== --- /dev/null +++ en/_posts/2018-12-29-groonga-8.1.0.md 2018-12-28 00:33:47 +0900 (c2997d710) @@ -0,0 +1,151 @@ +--- +layout: post.en +title: Groonga 8.1.0 has been released +description: Groonga 8.1.0 has been released! +published: false +--- + +## Groonga 8.1.0 has been released + +[Groonga 8.1.0](/docs/news.html#release-8-1-0) has been released! + +How to install: [Install](/docs/install.html) + +### Changes + +Here are important changes in this release: + +* The [logical_select](/docs/reference/commands/logical_select) Added new options `load_table` and `load_columns`, `load_values`. + +#### The [logical_select](/docs/reference/commands/logical_select) Added new options `load_table` and `load_columns`, `load_values`. + +New options `load_table` , `load_columns` and `load_values` are now available for `logical_select`. +You can store a result of `logical_select` into a table that specifying `load_table` as below. + +``` +plugin_register sharding +[[0,0.0,0.0],true] +table_create Logs_20150203 TABLE_NO_KEY +[[0,0.0,0.0],true] +column_create Logs_20150203 timestamp COLUMN_SCALAR Time +[[0,0.0,0.0],true] +table_create Logs_20150204 TABLE_NO_KEY +[[0,0.0,0.0],true] +column_create Logs_20150204 timestamp COLUMN_SCALAR Time +[[0,0.0,0.0],true] +table_create Logs TABLE_NO_KEY +[[0,0.0,0.0],true] +column_create Logs original_id COLUMN_SCALAR UInt32 +[[0,0.0,0.0],true] +column_create Logs timestamp_text COLUMN_SCALAR ShortText +[[0,0.0,0.0],true] +load --table Logs_20150203 +[ +{ + "timestamp": "2015-02-03 10:49:00" +}, +{ + "timestamp": "2015-02-03 12:49:00" +} +] +[[0,0.0,0.0],2] +load --table Logs_20150204 +[ +{ + "timestamp": "2015-02-04 00:00:00" +} +] +[[0,0.0,0.0],1] +logical_select \ + --logical_table Logs \ + --shard_key timestamp \ + --load_table Logs \ + --load_columns "original_id, timestamp_text" \ + --load_values "_id, timestamp" +[ + [ + 0, + 0.0, + 0.0 + ], + [ + [ + [ + 3 + ], + [ + [ + "_id", + "UInt32" + ], + [ + "timestamp", + "Time" + ] + ], + [ + 1, + 1422928140.0 + ], + [ + 2, + 1422935340.0 + ], + [ + 1, + 1422975600.0 + ] + ] + ] +] +select --table Logs +[ + [ + 0, + 0.0, + 0.0 + ], + [ + [ + [ + 3 + ], + [ + [ + "_id", + "UInt32" + ], + [ + "original_id", + "UInt32" + ], + [ + "timestamp_text", + "ShortText" + ] + ], + [ + 1, + 1, + "1422928140000000" + ], + [ + 2, + 2, + "1422935340000000" + ], + [ + 3, + 1, + "1422975600000000" + ] + ] + ] +] +``` + +### Conclusion + +See [Release 8.1.0 2018-12-29](/docs/news.html#release-8-1-0) about detailed changes since 8.0.9 + +Let's search by Groonga! Added: ja/_posts/2018-12-29-groonga-8.1.0.md (+151 -0) 100644 =================================================================== --- /dev/null +++ ja/_posts/2018-12-29-groonga-8.1.0.md 2018-12-28 00:33:47 +0900 (e2074bf29) @@ -0,0 +1,151 @@ +--- +layout: post.ja +title: Groonga 8.1.0リリース +description: Groonga 8.1.0をリリースしました！ +published: false +--- + +## Groonga 8.1.0リリース + +[Groonga 8.1.0](/ja/docs/news.html#release-8-1-0)をリリースしました！ + +それぞれの環境毎のインストール方法: [インストール](/ja/docs/install.html) + +### 変更内容 + +主な変更点は以下の通りです。 + +* [logical_select](ja/docs/reference/commands/logical_select) に新しいオプション `load_table` 、 `load_columns` 、 `load_values` を追加しました。 + +#### [logical_select](ja/docs/reference/commands/logical_select) に新しいオプション `load_table` 、 `load_columns` 、 `load_values` を追加しました。 + +`logical_select` で新たなオプション `load_table` 、 `load_columns` 、 `load_values` が使用できます。 +以下のように、`load_table` で指定したテーブルに `logical_select` の結果を格納できます。 + +``` +plugin_register sharding +[[0,0.0,0.0],true] +table_create Logs_20150203 TABLE_NO_KEY +[[0,0.0,0.0],true] +column_create Logs_20150203 timestamp COLUMN_SCALAR Time +[[0,0.0,0.0],true] +table_create Logs_20150204 TABLE_NO_KEY +[[0,0.0,0.0],true] +column_create Logs_20150204 timestamp COLUMN_SCALAR Time +[[0,0.0,0.0],true] +table_create Logs TABLE_NO_KEY +[[0,0.0,0.0],true] +column_create Logs original_id COLUMN_SCALAR UInt32 +[[0,0.0,0.0],true] +column_create Logs timestamp_text COLUMN_SCALAR ShortText +[[0,0.0,0.0],true] +load --table Logs_20150203 +[ +{ + "timestamp": "2015-02-03 10:49:00" +}, +{ + "timestamp": "2015-02-03 12:49:00" +} +] +[[0,0.0,0.0],2] +load --table Logs_20150204 +[ +{ + "timestamp": "2015-02-04 00:00:00" +} +] +[[0,0.0,0.0],1] +logical_select \ + --logical_table Logs \ + --shard_key timestamp \ + --load_table Logs \ + --load_columns "original_id, timestamp_text" \ + --load_values "_id, timestamp" +[ + [ + 0, + 0.0, + 0.0 + ], + [ + [ + [ + 3 + ], + [ + [ + "_id", + "UInt32" + ], + [ + "timestamp", + "Time" + ] + ], + [ + 1, + 1422928140.0 + ], + [ + 2, + 1422935340.0 + ], + [ + 1, + 1422975600.0 + ] + ] + ] +] +select --table Logs +[ + [ + 0, + 0.0, + 0.0 + ], + [ + [ + [ + 3 + ], + [ + [ + "_id", + "UInt32" + ], + [ + "original_id", + "UInt32" + ], + [ + "timestamp_text", + "ShortText" + ] + ], + [ + 1, + 1, + "1422928140000000" + ], + [ + 2, + 2, + "1422935340000000" + ], + [ + 3, + 1, + "1422975600000000" + ] + ] + ] +] +``` + +### さいごに + +8.0.9からの詳細な変更点は[8.1.0リリース 2018-12-29](/ja/docs/news.html#release-8-1-0)を確認してください。 + +それでは、Groongaでガンガン検索してください！ -------------- next part -------------- An HTML attachment was scrubbed... URL: <https://lists.osdn.me/mailman/archives/groonga-commit/attachments/20181228/5c2cdf00/attachment-0001.html>
