HAYASHI Kentaro
null+****@clear*****
Wed Jan 28 14:06:54 JST 2015
HAYASHI Kentaro 2015-01-28 14:06:54 +0900 (Wed, 28 Jan 2015) New Revision: 53c7a2257487ab9998ec4c21e595be4251f4def2 https://github.com/groonga/groonga/commit/53c7a2257487ab9998ec4c21e595be4251f4def2 Message: doc: update po Modified files: doc/locale/en/LC_MESSAGES/install.po doc/locale/en/LC_MESSAGES/news.po doc/locale/en/LC_MESSAGES/reference.po Modified: doc/locale/en/LC_MESSAGES/install.po (+10 -13) =================================================================== --- doc/locale/en/LC_MESSAGES/install.po 2015-01-28 13:19:51 +0900 (a2bcb32) +++ doc/locale/en/LC_MESSAGES/install.po 2015-01-28 14:06:54 +0900 (4469f19) @@ -8,7 +8,7 @@ msgid "" msgstr "" "Project-Id-Version: Groonga 4.0.3\n" "Report-Msgid-Bugs-To: \n" -"PO-Revision-Date: 2015-01-21 15:13+0900\n" +"PO-Revision-Date: 2015-01-28 13:21+0900\n" "Last-Translator: Kouhei Sutou <kou �� clear-code.com>\n" "Language-Team: English\n" "Language: en\n" @@ -165,8 +165,8 @@ msgid "/etc/apt/sources.list.d/groonga.list::" msgstr "/etc/apt/sources.list.d/groonga.list::" msgid "" -"If you want to use TokenFilterStem as a token filter, install groonga-token-" -"filter-stem package." +"If you want to use ``TokenFilterStem`` as a token filter, install groonga-" +"token-filter-stem package." msgstr "" msgid "Install groonga-token-filter-stem package::" @@ -231,12 +231,9 @@ msgstr "Mac OS X" msgid "" "This section describes how to install Groonga on Mac OS X. You can install " -"Groonga by `MacPorts <http://www.macports.org/>`_ or `Homebrew <http://mxcl." -"github.com/homebrew/>`_." +"Groonga by `MacPorts <http://www.macports.org/>`__ or `Homebrew <http://mxcl." +"github.com/homebrew/>`__." msgstr "" -"This section describes how to install Groonga on Mac OS X. You can install " -"Groonga by `MacPorts <http://www.macports.org/>`_ or `Homebrew <http://mxcl." -"github.com/homebrew/>`_." msgid "MacPorts" msgstr "MacPorts" @@ -749,7 +746,7 @@ msgstr "" "For 32-bit environment, download x86 executable binary from packages.groonga." "org:" -msgid "http://packages.groonga.org/windows/groonga/groonga-4.1.0-x86.exe" +msgid "http://packages.groonga.org/windows/groonga/groonga-4.1.1-x86.exe" msgstr "" msgid "Then run it." @@ -762,7 +759,7 @@ msgstr "" "For 64-bit environment, download x64 executable binary from packages.goronga." "org:" -msgid "http://packages.groonga.org/windows/groonga/groonga-4.1.0-x64.exe" +msgid "http://packages.groonga.org/windows/groonga/groonga-4.1.1-x64.exe" msgstr "" msgid "" @@ -780,7 +777,7 @@ msgid "" msgstr "" "For 32-bit environment, download x86 zip archive from packages.groonga.org:" -msgid "http://packages.groonga.org/windows/groonga/groonga-4.1.0-x86.zip" +msgid "http://packages.groonga.org/windows/groonga/groonga-4.1.1-x86.zip" msgstr "" msgid "Then extract it." @@ -791,7 +788,7 @@ msgid "" msgstr "" "For 64-bit environment, download x64 zip archive from packages.groonga.org:" -msgid "http://packages.groonga.org/windows/groonga/groonga-4.1.0-x64.zip" +msgid "http://packages.groonga.org/windows/groonga/groonga-4.1.1-x64.zip" msgstr "" msgid "You can find :doc:`/reference/executables/groonga` in ``bin`` folder." @@ -817,7 +814,7 @@ msgstr "`CMake <http://www.cmake.org/>`_" msgid "Download zipped source from packages.groonga.org:" msgstr "Download zipped source from packages.groonga.org:" -msgid "http://packages.groonga.org/source/groonga/groonga-4.1.0.zip" +msgid "http://packages.groonga.org/source/groonga/groonga-4.1.1.zip" msgstr "" msgid "Move to the Groonga's source folder::" Modified: doc/locale/en/LC_MESSAGES/news.po (+112 -30) =================================================================== --- doc/locale/en/LC_MESSAGES/news.po 2015-01-28 13:19:51 +0900 (a08a9ee) +++ doc/locale/en/LC_MESSAGES/news.po 2015-01-28 14:06:54 +0900 (f5d73ac) @@ -8,7 +8,7 @@ msgid "" msgstr "" "Project-Id-Version: Groonga 4.0.1\n" "Report-Msgid-Bugs-To: \n" -"PO-Revision-Date: 2015-01-21 15:14+0900\n" +"PO-Revision-Date: 2015-01-28 13:25+0900\n" "Last-Translator: Kouhei Sutou <kou �� clear-code.com>\n" "Language-Team: English\n" "Language: en\n" @@ -20,6 +20,96 @@ msgstr "" msgid "News" msgstr "News" +msgid "Release 4.1.1 - 2015-01-29" +msgstr "" + +msgid "Improvements" +msgstr "Improvements" + +msgid "" +"[windows] Improved to show error message instead of error code. It's easy to " +"understand." +msgstr "" + +msgid "" +"[windows] Supported small start file size for database file. In previous " +"versions, Groonga consumed larger initial file size on windows in contrast " +"to UNIX like environment. To enable this feature, use ``GRN_IO_VERSION=1`` " +"environment variable." +msgstr "" + +msgid "" +"Supported sum feature for drilldown. Here is the syntax how to use it. " +"``select --drilldown[label].calc_type SUM --drilldown[label].calc_target " +"target_column`` It returns drilldown result with max value in group." +msgstr "" + +msgid "" +"Supported ``MIN``, ``MAX``, ``AVG`` feature for drilldown. The syntax is " +"same as sum feature. You can specify multiple 'calc_types' at the same time." +msgstr "" + +msgid "" +"Added ``--with-jemalloc`` option to use ``jemalloc`` for ``malloc()/" +"free()``. It'll improve performance on multi-threading usage." +msgstr "" + +msgid "" +"groonga-httpd: Supported long error message over ``NGX_MAX_ERROR_STR``. By " +"this change, long error message (>=2048) is not truncated." +msgstr "" + +msgid "" +"[doc] Added documents about :ref:`select-drilldown-limit`, :ref:`select-" +"drilldown-calc-types`, :ref:`select-drilldown-calc-target` and more." +msgstr "" + +msgid "Fixes" +msgstr "Fixes" + +msgid "" +"Fixed mismatch between error code and error message when ``strerror()`` is " +"failed. There was a case that Groonga shows incorrect error code as syscall " +"error." +msgstr "" + +msgid "Fixed to show errno in error message when unknow error is occurred." +msgstr "" + +msgid "[windows] Fixed to return proper error code." +msgstr "" + +msgid "" +"Fixed a bug that there is only 'index[0]' for :ref:`select-match_columns`, " +"it doesn't return correct search results. For example, it occurs when index " +"'memo_index' is created against multiple column - 'title,content' then " +"'memo_index[0]' is specified." +msgstr "" + +msgid "http: Fixed a bug that two or more request don't have body." +msgstr "" + +msgid "" +"mecab: Added workaround for ``mecab_strerror(NULL)`` on MeCab 0.993. Without " +"this workaround, Groonga aborts if there is no MeCab dictionary. [Reported " +"by Shuhei Tanuma]" +msgstr "" + +msgid "groonga-httpd: Fixed a bug that custom log file is ignored." +msgstr "" + +msgid "groonga-httpd: Fixed a bug that empty dump doesn't return." +msgstr "" + +msgid "http: Fixed a bug that body isn't returned for POST requests." +msgstr "" + +msgid "Thanks" +msgstr "Thanks" + +msgid "Shuhei Tanuma" +msgstr "" + msgid "Release 4.1.0 - 2015-01-09" msgstr "" @@ -48,9 +138,6 @@ msgid "" "re-create your indexes." msgstr "" -msgid "Fixes" -msgstr "Fixes" - # eec36f7644d24a0e8bae40f427308c29 msgid "" "Fixed a bug that index may be broken. But the following bug fixed in Groonga " @@ -69,9 +156,6 @@ msgid "" "Use 4.1.0 instead of 4.0.9. 4.0.9 has a serious bug that may break index." msgstr "" -msgid "Improvements" -msgstr "Improvements" - # 1a9a4ae1ae5847a8be98c96d9b7df541 msgid "[:doc:`/reference/executables/groonga-httpd`] Marked as stable." msgstr "" @@ -191,9 +275,6 @@ msgid "" "\"Piro\" Hiroshi]" msgstr "" -msgid "Thanks" -msgstr "Thanks" - msgid "Hiroshi Hatake" msgstr "" @@ -273,9 +354,9 @@ msgid "" msgstr "" msgid "" -"[experimental] Supported multiple drilldowns for :doc:``/reference/command/" -"select`` command. The syntax is extended to support this feature. The new " -"one is ``--drilldown[LABEL1].keys COLUMN1,COLUMN2`` for keys, ``--" +"[experimental] Supported multiple drilldowns for :doc:`/reference/commands/" +"select` command. The syntax is extended to support this feature. The new one " +"is ``--drilldown[LABEL1].keys COLUMN1,COLUMN2`` for keys, ``--" "drilldown[LABEL1].output_columns _value.COLUMN1,_value.COLUMN2,_nsubrecs`` " "for output columns. In the previous versions, a client application must " "implement by oneself for drilldown by multiple keys. Use ``_key[N]`` for ``--" @@ -287,11 +368,11 @@ msgstr "" msgid "" "[experimental] Added :doc:`/reference/commands/range_filter` command. It is " -"faster than select command to fetch specific range of records in most cases, " -"because it doesn't returns the number of matched records. There are " -"limitations which doesn't support drilldown and so on. Thus, " -"``range_filter`` is suitable for extracting first ``N`` records in specific " -"range for ranking or something else." +"faster than :doc:`/reference/commands/select` command to fetch specific " +"range of records in most cases, because it doesn't returns the number of " +"matched records. There are limitations which doesn't support drilldown and " +"so on. Thus, ``range_filter`` is suitable for extracting first ``N`` " +"records in specific range for ranking or something else." msgstr "" msgid "[httpd] Supported ``groonga-httpd`` on windows." @@ -330,9 +411,10 @@ msgid "" msgstr "" msgid "" -"Fixed a bug that select command reports invalid value type (table) as index " -"column value type. It was fixed to ``UInt32``. Note that it affects only the " -"value of response header. The search results is not changed at all." +"Fixed a bug that :doc:`/reference/commands/select` command reports invalid " +"value type (table) as index column value type. It was fixed to ``UInt32``. " +"Note that it affects only the value of response header. The search results " +"is not changed at all." msgstr "" msgid "" @@ -2854,14 +2936,10 @@ msgstr "" msgid "" "Fixed a bug that ``--default-match-escalation-threshold`` doesn't accept " -"negative value to disable functionality. This fix enable you to disable " -"search escalation. see :option:`--default-match-escalation-threshold` about " -"details." +"negative value to disable functionality that is used on :doc:`/spec/" +"search`. This fix enable you to disable search escalation. see :option:`--" +"default-match-escalation-threshold` about details." msgstr "" -"Fixed a bug that ``--default-match-escalation-threshold`` doesn't accept " -"negative value to disable functionality. This fix enable you to disable " -"search escalation. see :option:`--default-match-escalation-threshold` about " -"details." msgid "" "Fixed a bug that ``_score`` after \"*\" is ignored in ``--output_columns``." @@ -4799,8 +4877,9 @@ msgstr "" "Y``, ``X % Y``, ``X >> Y``, ``X << Y``, ``X | Y``, ``X ^ Y``, ``X & Y`` and " "``X >>> Y`` for Int8, UInt8, Int16, UInt16 and UInt64." -msgid "Added english documentation for ``load`` command." -msgstr "Added english documentation for ``load`` command." +msgid "" +"Added English documentation for :doc:`/reference/commands/load` command." +msgstr "" msgid "" "Supported binary assign operations such as ``X += Y``, ``X -= Y``, ``X *= " @@ -5079,3 +5158,6 @@ msgid "" msgstr "" "applied ftb patch for mysql binding from <ko****@yappo*****> 'IN BOOLEAN " "MODE' supported" + +#~ msgid "Added english documentation for ``load`` command." +#~ msgstr "Added english documentation for ``load`` command." Modified: doc/locale/en/LC_MESSAGES/reference.po (+778 -86) =================================================================== --- doc/locale/en/LC_MESSAGES/reference.po 2015-01-28 13:19:51 +0900 (de45621) +++ doc/locale/en/LC_MESSAGES/reference.po 2015-01-28 14:06:54 +0900 (cffeebd) @@ -8,7 +8,7 @@ msgid "" msgstr "" "Project-Id-Version: Groonga 4.0.1\n" "Report-Msgid-Bugs-To: \n" -"PO-Revision-Date: 2015-01-21 15:15+0900\n" +"PO-Revision-Date: 2015-01-28 13:25+0900\n" "Last-Translator: Kouhei Sutou <kou �� clear-code.com>\n" "Language-Team: English\n" "Language: en\n" @@ -621,10 +621,9 @@ msgstr "ctxの管理するメモリを解放し、使用を終了します。" msgid "" "If ``ctx`` is initialized by :c:func:`grn_ctx_open()` not :c:func:" -"`grn_ctx_init()`. You need also to call :c:func:`grn_ctx_close()`." +"`grn_ctx_init()`, you need to use :c:func:`grn_ctx_close()` instead of :c:" +"func:`grn_ctx_fin()`." msgstr "" -"If ``ctx`` is initialized by :c:func:`grn_ctx_open()` not :c:func:" -"`grn_ctx_init()`. You need also to call :c:func:`grn_ctx_close()`." msgid "解放するctx構造体へのポインタを指定します。" msgstr "解放するctx構造体へのポインタを指定します。" @@ -2601,23 +2600,20 @@ msgstr "" msgid "Here are data store columns:" msgstr "Here are data store columns:" -msgid ":doc:`columns/scalar`" -msgstr ":doc:`columns/scalar`" - -msgid ":doc:`columns/vector`" -msgstr ":doc:`columns/vector`" - -msgid ":doc:`columns/pseudo`" -msgstr ":doc:`columns/pseudo`" - msgid "Here is an index column:" msgstr "Here is an index column:" -msgid ":doc:`columns/index`" -msgstr ":doc:`columns/index`" +msgid "Index column" +msgstr "" + +msgid "TODO" +msgstr "TODO" + +msgid "Usage" +msgstr "Usage" -msgid "疑似カラム (pseudo_column)" -msgstr "疑似カラム (pseudo_column)" +msgid "Pseudo column" +msgstr "" msgid "名前" msgstr "名前" @@ -2703,6 +2699,9 @@ msgstr "" "前のテーブルにおいて、グループ化キーの値が同一であったレコードの件数が、グ" "ループ化処理の結果を格納するテーブルの_nsubrecsに記録されます。" +msgid "Scalar column" +msgstr "" + msgid "Vector column" msgstr "Vector column" @@ -2744,9 +2743,6 @@ msgstr "" "is too high when weight is used. You should use full text search with weight " "carefully." -msgid "Usage" -msgstr "Usage" - msgid "There are three vector column types:" msgstr "There are three vector column types:" @@ -2859,9 +2855,6 @@ msgstr "You can also use weight in :ref:`select-match-columns`:" msgid "With :ref:`select-filter`:" msgstr "With :ref:`select-filter`:" -msgid "TODO" -msgstr "TODO" - msgid "" "Reference vector column is space-efficient if there are many same value " "elements. Reference vector column keeps reference record IDs not value " @@ -5623,6 +5616,62 @@ msgstr "" "``select`` has many parameters. The required parameter is only ``table`` and " "others are optional::" +msgid "``select`` has the following named parameters for advanced drilldown:" +msgstr "" + +msgid "``drilldown[${LABEL}].keys=null``" +msgstr "" + +msgid "``drilldown[${LABEL}].sortby=null``" +msgstr "" + +msgid "``drilldown[${LABEL}].output_columns=\"_key, _nsubrecs\"``" +msgstr "" + +msgid "``drilldown[${LABEL}].offset=0``" +msgstr "" + +msgid "``drilldown[${LABEL}].limit=10``" +msgstr "" + +msgid "``drilldown[${LABEL}].calc_types=NONE``" +msgstr "" + +msgid "``drilldown[${LABEL}].calc_target=null``" +msgstr "" + +msgid "" +"You can use one or more alphabets, digits, ``_`` and ``.`` for ``${LABEL}``. " +"For example, ``parent.sub1`` is a valid ``${LABEL}``." +msgstr "" + +msgid "Parameters that have the same ``${LABEL}`` are grouped." +msgstr "" + +msgid "For example, the following parameters specify one drilldown:" +msgstr "" + +msgid "``--drilldown[label].keys column``" +msgstr "" + +msgid "``--drilldown[label].sortby -_nsubrecs``" +msgstr "" + +msgid "The following parameters specify two drilldowns:" +msgstr "" + +msgid "``--drilldown[label1].keys column1``" +msgstr "" + +msgid "``--drilldown[label1].sortby -_nsubrecs``" +msgstr "" + +msgid "``--drilldown[label2].keys column2``" +msgstr "" + +msgid "``--drilldown[label2].sortby _key``" +msgstr "" + msgid "" "Let's learn about ``select`` usage with examples. This section shows many " "popular usages." @@ -5631,15 +5680,12 @@ msgstr "" "popular usages." msgid "" -"There is a table, ``Entries``, for blog entries. An entry has title, content " -"and the number of likes for the entry. Title is key of ``Entries``. Content " -"is value of ``Entries.content`` column. The number of likes is value of " -"``Entries.n_likes`` column." +"There is a table, ``Entries``, for blog entries. An entry has title, " +"content, the number of likes for the entry and tag. Title is key of " +"``Entries``. Content is value of ``Entries.content`` column. The number of " +"likes is value of ``Entries.n_likes`` column. Tag is value of ``Entries." +"tag`` column." msgstr "" -"There is a table, ``Entries``, for blog entries. An entry has title, content " -"and the number of likes for the entry. Title is key of ``Entries``. Content " -"is value of ``Entries.content`` column. The number of likes is value of " -"``Entries.n_likes`` column." msgid "" "``Entries._key`` column and ``Entries.content`` column are indexed using " @@ -5769,12 +5815,9 @@ msgstr "" msgid "" "``filter`` has more operators and syntax like grouping by ``(...)`` its " -"deatils aren't described here. See :doc:`/reference/grn_expr/script_syntax` " +"details aren't described here. See :doc:`/reference/grn_expr/script_syntax` " "for datails." msgstr "" -"``filter`` has more operators and syntax like grouping by ``(...)`` its " -"deatils aren't described here. See :doc:`/reference/grn_expr/script_syntax` " -"for datails." msgid "Paging" msgstr "Paging" @@ -5787,11 +5830,9 @@ msgstr "" "is an example to output only the 2nd record." msgid "" -"``offset`` is zero-origin. ``--offset 1`` means output range is started from " +"``offset`` is zero-based. ``--offset 1`` means output range is started from " "the 2nd record." msgstr "" -"``offset`` is zero-origin. ``--offset 1`` means output range is started from " -"the 2nd record." msgid "" "``limit`` specifies the max number of output records. ``--limit 1`` means " @@ -5819,6 +5860,63 @@ msgstr "" "``--limit 0`` is also useful for retrieving only the number of matched " "records." +msgid "Drilldown" +msgstr "" + +msgid "" +"You can get additional grouped results against the search result in one " +"``select``. You need to use two or more ``SELECT``s in SQL but ``select`` in " +"Groonga can do it in one ``select``." +msgstr "" + +msgid "" +"This feature is called as `drilldown <http://en.wikipedia.org/wiki/" +"Drill_down>`_ in Groonga. It's also called as `faceted search <http://en." +"wikipedia.org/wiki/Faceted_search>`_ in other search engine." +msgstr "" + +msgid "For example, think about the following situation." +msgstr "" + +msgid "You search entries that has ``fast`` word:" +msgstr "" + +msgid "" +"You want to use ``tag`` for additional search condition like ``--filter " +"'content @ \"fast\" && tag == \"???\"``. But you don't know suitable tag " +"until you see the result of ``content @ \"fast\"``." +msgstr "" + +msgid "" +"If you know the number of matched records of each available tag, you can " +"choose suitable tag. You can use drilldown for the case:" +msgstr "" + +msgid "" +"``--drilldown tag`` returns a list of pair of available tag and the number " +"of matched records. You can avoid \"no hit search\" case by choosing a tag " +"from the list. You can also avoid \"too many search results\" case by " +"choosing a tag that the number of matched records is few from the list." +msgstr "" + +msgid "You can create the following UI with the drilldown results:" +msgstr "" + +msgid "" +"Links to narrow search results. (Users don't need to input a search query by " +"their keyboard. They just click a link.)" +msgstr "" + +msgid "Most EC sites use the UI. See side menu at Amazon." +msgstr "" + +msgid "" +"Groonga supports not only counting grouped records but also finding the " +"maximum and/or minimum value from grouped records, summing values in grouped " +"records and so on. See :ref:`select-drilldown-related-parameters` for " +"details." +msgstr "" + msgid "This section describes all parameters. Parameters are categorized." msgstr "This section describes all parameters. Parameters are categorized." @@ -6505,11 +6603,9 @@ msgstr "" "ignored but get a warning in log file." msgid "" -"It specifies offset to determine output records range. Offset is zero-" -"origin. ``--offset 1`` means output range is started from the 2nd record." +"It specifies offset to determine output records range. Offset is zero-based. " +"``--offset 1`` means output range is started from the 2nd record." msgstr "" -"It specifies offset to determine output records range. Offset is zero-" -"origin. ``--offset 1`` means output range is started from the 2nd record." msgid "The ``select`` command outputs from the 4th record." msgstr "The ``select`` command outputs from the 4th record." @@ -6517,11 +6613,9 @@ msgstr "The ``select`` command outputs from the 4th record." msgid "" "You can specify negative value. It means that ``the number of matched " "records + offset``. If you have 3 matched records and specify ``--offset " -"-2``, you get records from the 1st (``3 + -2 = 1``) record to the 3rd record." +"-2``, you get records from the 2nd (``3 + -2 = 1``. ``1`` means 2nd. " +"Remember that offset is zero-based.) record to the 3rd record." msgstr "" -"You can specify negative value. It means that ``the number of matched " -"records + offset``. If you have 3 matched records and specify ``--offset " -"-2``, you get records from the 1st (``3 + -2 = 1``) record to the 3rd record." msgid "" "The ``select`` command outputs from the 4th record because the total number " @@ -6583,57 +6677,580 @@ msgstr "" "て、各レコードのスコアを操作する式を指定しておけば、検索結果のソート順序をカ" "スタマイズできるようになります。" -msgid "Facet related parameters" -msgstr "Facet related parameters" +msgid "Drilldown related parameters" +msgstr "" + +msgid "" +"This section describes basic drilldown related parameters. Advanced " +"drilldown related parameters are described in another section." +msgstr "" + +msgid "It specifies keys for grouping separated by ``,``." +msgstr "" + +msgid "" +"Matched records by specified search conditions are grouped by each key. If " +"you specify no search condition, all records are grouped by each key." +msgstr "" + +msgid "Here is a simple ``drilldown`` example:" +msgstr "" + +msgid "The ``select`` command outputs the following information:" +msgstr "" + +msgid "There is one record that has \"Hello\" tag." +msgstr "" + +msgid "There is two records that has \"Groonga\" tag." +msgstr "" + +msgid "There is two records that has \"Senna\" tag." +msgstr "" + +msgid "Here is a ``drilldown`` with search condition example:" +msgstr "" + +msgid "In records that have 5 or larger as ``n_likes`` value:" +msgstr "" + +msgid "Here is a ``drilldown`` with multiple group keys example:" +msgstr "" + +msgid "About ``tag``:" +msgstr "" + +msgid "About ``n_likes``:" +msgstr "" + +msgid "" +"It specifies sort keys for drilldown outputs separated by ``,``. Each sort " +"key is column name." +msgstr "" + +msgid "" +"You can refer the number of grouped records by ``_nsubrecs`` :doc:`/" +"reference/columns/pseudo`." +msgstr "" + +msgid "Here is a simple ``drilldown_sortby`` example:" +msgstr "" + +msgid "" +"Drilldown result is sorted by the number of grouped records (= " +"``_nsubrecs`` ) in descending order. If there are grouped results that the " +"number of records in the group are the same, these grouped results are " +"sorted by grouped key (= ``_key`` ) in ascending order." +msgstr "" + +msgid "The sort keys are used in all group keys specified in ``drilldown``:" +msgstr "" + +msgid "" +"The same sort keys are used in ``tag`` drilldown and ``n_likes`` drilldown." +msgstr "" + +msgid "" +"If you want to use different sort keys for each drilldown, use :ref:`select-" +"advanced-drilldown-related-parameters`." +msgstr "" + +msgid "It specifies output columns for drilldown separated by ``,``." +msgstr "" + +msgid "Here is a ``drilldown_output_columns`` example:" +msgstr "" + +msgid "The ``select`` command just outputs grouped key." +msgstr "" + +msgid "" +"If grouped key is a referenced type column (= column that its type is a " +"table), you can access column of the table referenced by the referenced type " +"column." +msgstr "" + +msgid "" +"Here are a schema definition and sample data to show drilldown against " +"referenced type column:" +msgstr "" + +msgid "" +"``Tags`` table is a referenced table. ``Items.tag`` is a referenced type " +"column." +msgstr "" + +msgid "" +"You can refer ``Tags.label`` by ``label`` in ``drilldown_output_columns``:" +msgstr "" + +msgid "" +"You can use ``*`` to refer all columns in referenced table (= ``Tags``):" +msgstr "" + +msgid "``*`` is expanded to ``label, priority``." +msgstr "" + +msgid "" +"The default value of ``drilldown_output_columns`` is ``_key, _nsubrecs``. It " +"means that grouped key and the number of records in the group are output." +msgstr "" + +msgid "" +"You can use more :doc:`/reference/columns/pseudo` in " +"``drilldown_output_columns`` such as ``_max``, ``_min``, ``_sum`` and " +"``_avg`` when you use :ref:`select-drilldown-calc-types`. See " +"``drilldown_calc_types`` document for details." +msgstr "" + +msgid "" +"It specifies offset to determine range of drilldown output records. Offset " +"is zero-based. ``--drilldown_offset 1`` means output range is started from " +"the 2nd record." +msgstr "" + +msgid "Here is a ``drilldown_offset`` example:" +msgstr "" + +msgid "The ``select`` command outputs from the 2nd record." +msgstr "" + +msgid "" +"You can specify negative value. It means that ``the number of grouped " +"results + offset``. If you have 3 grouped results and specify ``--" +"drilldown_offset -2``, you get grouped results from the 2st (``3 + -2 = 1``. " +"``1`` means 2nd. Remember that offset is zero-based.) grouped result to the " +"3rd grouped result." +msgstr "" + +msgid "" +"The ``select`` command outputs from the 2nd grouped result because the total " +"number of grouped results is ``3``." +msgstr "" + +msgid "The default value of ``drilldown_offset`` is ``0``." +msgstr "" + +msgid "" +"It specifies the max number of groups in a drilldown. If the number of " +"groups is less than ``drilldown_limit``, all groups are outputted." +msgstr "" + +msgid "Here is a ``drilldown_limit`` example:" +msgstr "" + +msgid "The ``select`` command outputs the 2rd and the 3rd groups." +msgstr "" + +msgid "" +"You can specify negative value. It means that ``the number of groups + " +"drilldown_limit + 1``. For example, ``--drilldown_limit -1`` outputs all " +"groups. It's very useful value to show all groups." +msgstr "" + +msgid "Here is a negative ``drilldown_limit`` value example." +msgstr "" + +msgid "The ``select`` command outputs all groups." +msgstr "" + +msgid "The default value of ``drilldown_limit`` is ``10``." +msgstr "" + +msgid "``drilldown_calc_types``" +msgstr "" + +msgid "" +"It specifies how to calculate (aggregate) values in grouped records by a " +"drilldown. You can specify multiple calculation types separated by \"``,``" +"\". For example, ``MAX,MIN``." +msgstr "" + +msgid "" +"Calculation target values are read from a column of grouped records. The " +"column is specified by :ref:`select-drilldown-calc-target`." +msgstr "" + +msgid "" +"You can read calculated value by :doc:`/reference/columns/pseudo` such as " +"``_max`` and ``_min`` in :ref:`select-drilldown-output-columns`." +msgstr "" + +msgid "You can use the following calculation types:" +msgstr "" + +msgid "Type name" +msgstr "" + +msgid ":doc:`/reference/columns/pseudo` name" +msgstr "" + +msgid "Need :ref:`select-drilldown-calc-target`" +msgstr "" + +msgid "Nothing." +msgstr "" + +msgid "Not needs." +msgstr "" + +msgid "``COUNT``" +msgstr "" + +msgid "Counting grouped records. It's always enabled. So you don't specify it." +msgstr "" + +msgid "``MAX``" +msgstr "" + +msgid "``_max``" +msgstr "" + +msgid "Needs." +msgstr "" + +msgid "" +"Finding the maximum integer value from integer values in grouped records." +msgstr "" + +msgid "``MIN``" +msgstr "" + +msgid "``_min``" +msgstr "" + +msgid "" +"Finding the minimum integer value from integer values in grouped records." +msgstr "" + +msgid "``SUM``" +msgstr "" + +msgid "``_sum``" +msgstr "" + +msgid "Summing integer values in grouped records." +msgstr "" + +msgid "``AVG``" +msgstr "" + +msgid "``_avg``" +msgstr "" + +msgid "Averaging integer/float values in grouped records." +msgstr "" + +msgid "Here is a ``MAX`` example:" +msgstr "" + +msgid "" +"The ``select`` command groups all records by ``tag`` column value, finding " +"the maximum ``n_likes`` column value for each group and outputs pairs of " +"grouped key and the maximum ``n_likes`` column value for the group. It uses " +"``_max`` :doc:`/reference/columns/pseudo` to read the maximum ``n_likes`` " +"column value." +msgstr "" + +msgid "Here is a ``MIN`` example:" +msgstr "" + +msgid "" +"The ``select`` command groups all records by ``tag`` column value, finding " +"the minimum ``n_likes`` column value for each group and outputs pairs of " +"grouped key and the minimum ``n_likes`` column value for the group. It uses " +"``_min`` :doc:`/reference/columns/pseudo` to read the minimum ``n_likes`` " +"column value." +msgstr "" + +msgid "Here is a ``SUM`` example:" +msgstr "" + +msgid "" +"The ``select`` command groups all records by ``tag`` column value, sums all " +"``n_likes`` column values for each group and outputs pairs of grouped key " +"and the summed ``n_likes`` column values for the group. It uses ``_sum`` :" +"doc:`/reference/columns/pseudo` to read the summed ``n_likes`` column values." +msgstr "" + +msgid "Here is a ``AVG`` example:" +msgstr "" + +msgid "" +"The ``select`` command groups all records by ``tag`` column value, averages " +"all ``n_likes`` column values for each group and outputs pairs of grouped " +"key and the averaged ``n_likes`` column values for the group. It uses " +"``_avg`` :doc:`/reference/columns/pseudo` to read the averaged ``n_likes`` " +"column values." +msgstr "" + +msgid "Here is an example that uses all calculation types:" +msgstr "" + +msgid "" +"The ``select`` command specifies multiple calculation types separated by " +"\"``,``\" like ``MAX,MIN,SUM,AVG``. You can use ``_nsubrecs`` :doc:`/" +"reference/columns/pseudo` in :ref:`select-drilldown-output-columns` without " +"specifying ``COUNT`` in ``drilldown_calc_types``. Because ``COUNT`` is " +"always enabled." +msgstr "" + +msgid "" +"The default value of ``drilldown_calc_types`` is ``NONE``. It means that " +"only ``COUNT`` is enabled. Because ``NONE`` is just ignored and ``COUNT`` is " +"always enabled." +msgstr "" + +msgid "``drilldown_calc_target``" +msgstr "" + +msgid "It specifies the target column for :ref:`select-drilldown-calc-types`." +msgstr "" + +msgid "" +"If you specify a calculation type that needs a target column such as ``MAX`` " +"in :ref:`select-drilldown-calc-types` but you omit " +"``drilldown_calc_target``, the calculation result is always ``0``." +msgstr "" + +msgid "" +"You can specify only one column name like ``--drilldown_calc_target " +"n_likes``. You can't specify multiple column name like ``--" +"drilldown_calc_target _key,n_likes``." +msgstr "" + +msgid "" +"You can use referenced value from the target record by combining \"``.``\" " +"like ``--drilldown_calc_target reference_column.nested_reference_column." +"value``." +msgstr "" + +msgid "" +"See :ref:`select-drilldown-calc-types` to know how to use " +"``drilldown_calc_target``." +msgstr "" + +msgid "" +"The default value of ``drilldown_calc_target`` is ``null``. It means that no " +"calculation target column is specified." +msgstr "" + +msgid "Advanced drilldown related parameters" +msgstr "" + +msgid "" +"You can get multiple drilldown results by specifying multiple group keys by :" +"ref:`select-drilldown`. But you need to use the same configuration for all " +"drilldowns. For example, :ref:`select-drilldown-output-columns` is used by " +"all drilldowns." +msgstr "" + +msgid "" +"You can use a configuration for each drilldown by the following parameters:" +msgstr "" + +msgid "``drilldown[${LABEL}].keys``" +msgstr "" + +msgid "``drilldown[${LABEL}].sortby``" +msgstr "" + +msgid "``drilldown[${LABEL}].output_columns``" +msgstr "" + +msgid "``drilldown[${LABEL}].offset``" +msgstr "" + +msgid "``drilldown[${LABEL}].limit``" +msgstr "" + +msgid "``drilldown[${LABEL}].calc_types``" +msgstr "" + +msgid "``drilldown[${LABEL}].calc_target``" +msgstr "" + +msgid "" +"``${LABEL}`` is a variable. You can use the following characters for ``" +"${LABEL}``:" +msgstr "" + +msgid "Alphabets" +msgstr "" + +msgid "Digits" +msgstr "" + +msgid "``.``" +msgstr "" + +msgid "``_``" +msgstr "" + +msgid "" +"Parameters that has the same ``${LABEL}`` value are grouped. Grouped " +"parameters are used for one drilldown." +msgstr "" + +msgid "For example, there are 2 groups for the following parameters:" +msgstr "" + +msgid "``--drilldown[label1].keys _key``" +msgstr "" + +msgid "``--drilldown[label1].output_columns _nsubrecs``" +msgstr "" + +msgid "``--drilldown[label2].keys tag``" +msgstr "" + +msgid "``--drilldown[label2].output_columns _key,_nsubrecs``" +msgstr "" + +msgid "" +"``drilldown[label1].keys`` and ``drilldown[label1].output_columns`` are " +"grouped. ``drilldown[label2].keys`` and ``drilldown[label2].output_columns`` " +"are also grouped." +msgstr "" + +msgid "" +"In ``label1`` group, ``_key`` is used for group key and ``_nsubrecs`` is " +"used for output columns." +msgstr "" + +msgid "" +"In ``label2`` group, ``tag`` is used for group key and ``_key,_nsubrecs`` is " +"used for output columns." +msgstr "" + +msgid "" +"See document for corresponding ``drilldown_XXX`` parameter to know how to " +"use it for the following parameters:" +msgstr "" + +msgid "``drilldown[${LABEL}].sortby``: :ref:`select-drilldown-sortby`" +msgstr "" + +msgid "``drilldown[${LABEL}].offset``: :ref:`select-drilldown-offset`" +msgstr "" + +msgid "``drilldown[${LABEL}].limit``: :ref:`select-drilldown-limit`" +msgstr "" + +msgid "``drilldown[${LABEL}].calc_types``: :ref:`select-drilldown-calc-types`" +msgstr "" + +msgid "" +"``drilldown[${LABEL}].calc_target``: :ref:`select-drilldown-calc-target`" +msgstr "" + +msgid "The following parameters are needed more description:" +msgstr "" + +msgid "Output format is different a bit. It's also needed more description." +msgstr "" + +msgid "" +":ref:`select-drilldown` can specify multiple keys for multiple drilldowns. " +"But it can't specify multiple keys for one drilldown." +msgstr "" + +msgid "" +"``drilldown[${LABEL}].keys`` can't specify multiple keys for multiple " +"drilldowns. But it can specify multiple keys for one drilldown." +msgstr "" + +msgid "You can specify multiple keys separated by \"``,``\"." +msgstr "" + +msgid "" +"Here is an example to group by multiple keys, ``tag`` and ``n_likes`` column " +"values:" +msgstr "" + +msgid "" +"``tag.n_likes`` is used as the label for the drilldown parameters group. You " +"can refer grouped keys by ``_value.${KEY_NAME}`` syntax in :ref:`select-" +"drilldown-label-output-columns`. ``${KEY_NAME}`` is a column name to be used " +"by group key. ``tag`` and ``n_likes`` are ``${KEY_NAME}`` in this case." +msgstr "" + +msgid "" +"Note that you can't use ``_value.${KEY_NAME}`` syntax when you just specify " +"one key as ``drilldown[${LABEL}].keys`` like ``--drilldown[tag].keys tag``. " +"You should use ``_key`` for the case. It's the same rule in :ref:`select-" +"drilldown-output-columns`." +msgstr "" + +msgid "" +"It's almost same as :ref:`select-drilldown-output-columns`. The difference " +"between :ref:`select-drilldown-output-columns` and ``drilldown[${LABEL}]." +"output_columns`` is how to refer group keys." +msgstr "" msgid "" -"グループ化のキーとなるカラム名のリストをカンマ(',')区切りで指定します。検索条" -"件にマッチした各レコードを出力したのちに、drilldownに指定されたカラムの値が同" -"一であるレコードをとりまとめて、それぞれについて結果レコードを出力します。" +":ref:`select-drilldown-output-columns` uses ``_key`` :doc:`/reference/" +"columns/pseudo` to refer group key. ``drilldown[${LABEL}].output_columns`` " +"also uses ``_key`` :doc:`/reference/columns/pseudo` to refer group key when " +"you specify only one group key by :ref:`select-drilldown-label-keys`." msgstr "" -"グループ化のキーとなるカラム名のリストをカンマ(',')区切りで指定します。検索条" -"件にマッチした各レコードを出力したのちに、drilldownに指定されたカラムの値が同" -"一であるレコードをとりまとめて、それぞれについて結果レコードを出力します。" msgid "" -"drilldown条件に指定されたカラムの値毎にとりまとめられたレコードについて、ソー" -"トキーとなるカラム名のリストをカンマ(',')区切りで指定します。sortbyパラメータ" -"と同様に昇降順を指定できます。" +"Here is an example to refer single group key by ``_key`` :doc:`/reference/" +"columns/pseudo`:" msgstr "" -"drilldown条件に指定されたカラムの値毎にとりまとめられたレコードについて、ソー" -"トキーとなるカラム名のリストをカンマ(',')区切りで指定します。sortbyパラメータ" -"と同様に昇降順を指定できます。" msgid "" -"drilldown条件に指定されたカラムの値毎にとりまとめられたレコードについて、出力" -"するカラム名のリストをカンマ(',')区切りで指定します。" +"But you can't refer each group key by ``_key`` :doc:`/reference/columns/" +"pseudo` in ``drilldown[${LABEL}].output_columns``. You need to use ``_value." +"${KEY_NAME}`` syntax. ``${KEY_NAME}`` is a column name that is used for " +"group key in :ref:`select-drilldown-label-keys`." msgstr "" -"drilldown条件に指定されたカラムの値毎にとりまとめられたレコードについて、出力" -"するカラム名のリストをカンマ(',')区切りで指定します。" msgid "" -"drilldown条件に指定されたカラムの値毎にとりまとめられたレコードについて、出力" -"対象となる最初のレコードの番号を0ベースで指定します。デフォルト値は0です。" -"drilldown_offsetに負の値を指定した場合は、ヒットした件数 + drilldown_offsetに" -"よって算出される値が指定されたものとみなされます。" +"Here is an example to refer each group key in multiple group keys by " +"``_value.${KEY_NAME}`` syntax:" +msgstr "" + +msgid "Why ``_value.${KEY_NAME}`` syntax?" +msgstr "" + +msgid "It's implementation specific information." msgstr "" -"drilldown条件に指定されたカラムの値毎にとりまとめられたレコードについて、出力" -"対象となる最初のレコードの番号を0ベースで指定します。デフォルト値は0です。" -"drilldown_offsetに負の値を指定した場合は、ヒットした件数 + drilldown_offsetに" -"よって算出される値が指定されたものとみなされます。" msgid "" -"drilldown条件に指定されたカラムの値毎にとりまとめられたレコードについて、出力" -"を行うレコードの件数を指定します。デフォルト値は10です。実際には、" -"drilldown_offset + drilldown_limit がヒットした件数を超えない範囲でレコードが" -"出力されます。drilldown_limitに負の値を指定した場合は、ヒットした件数 + " -"drilldown_limit + 1 によって算出される値が指定されたものとみなされます。" +"``_key`` is a vector value. The vector value is consists of all group keys. " +"You can see byte sequence of the vector value by referring ``_key`` in " +"``drilldown[${LABEL}].output_columns``." +msgstr "" + +msgid "" +"There is one grouped record in ``_value`` to refer each grouped values when " +"you specify multiple group keys to :ref:`select-drilldown-label-keys`. So " +"you can refer each group key by ``_value.${KEY_NAME}`` syntax." +msgstr "" + +msgid "" +"On the other hand, there is no grouped record in ``_value`` when you specify " +"only one group key to :ref:`select-drilldown-label-keys`. So you can't refer " +"group key by ``_value.${KEY_NAME}`` syntax." +msgstr "" + +msgid "Output format for ``drilldown[${LABEL}]`` style" +msgstr "" + +msgid "" +"There is a difference in output format between :ref:`select-drilldown` and :" +"ref:`select-drilldown-label-keys`. :ref:`select-drilldown` uses array to " +"output multiple drilldown results. :ref:`select-drilldown-label-keys` uses " +"pairs of label and drilldown result." +msgstr "" + +msgid ":ref:`select-drilldown` uses the following output format::" +msgstr "" + +msgid ":ref:`select-drilldown-label-keys` uses the following output format::" msgstr "" -"drilldown条件に指定されたカラムの値毎にとりまとめられたレコードについて、出力" -"を行うレコードの件数を指定します。デフォルト値は10です。実際には、" -"drilldown_offset + drilldown_limit がヒットした件数を超えない範囲でレコードが" -"出力されます。drilldown_limitに負の値を指定した場合は、ヒットした件数 + " -"drilldown_limit + 1 によって算出される値が指定されたものとみなされます。" msgid "Cache related parameter" msgstr "Cache related parameter" @@ -10903,11 +11520,9 @@ msgid "``html_untag`` strips HTML tags from HTML and outputs plain text." msgstr "``html_untag`` strips HTML tags from HTML and outputs plain text." msgid "" -"``html_untag`` is used in ``--output_columns`` described at :ref:" -"`output_columns`." +"``html_untag`` is used in ``--output_columns`` described at :ref:`select-" +"output-columns`." msgstr "" -"``html_untag`` is used in ``--output_columns`` described at :ref:" -"`output_columns`." msgid "``html_untag`` requires only one argument. It is ``html``." msgstr "``html_untag`` requires only one argument. It is ``html``." @@ -11526,6 +12141,17 @@ msgstr "" msgid "Sample data" msgstr "Sample data" +msgid "" +"There is a table, ``Entries``, for blog entries. An entry has title, content " +"and the number of likes for the entry. Title is key of ``Entries``. Content " +"is value of ``Entries.content`` column. The number of likes is value of " +"``Entries.n_likes`` column." +msgstr "" +"There is a table, ``Entries``, for blog entries. An entry has title, content " +"and the number of likes for the entry. Title is key of ``Entries``. Content " +"is value of ``Entries.content`` column. The number of likes is value of " +"``Entries.n_likes`` column." + msgid "Escape" msgstr "Escape" @@ -15738,3 +16364,69 @@ msgstr "" msgid "Object型はv1.2でサポートされます。" msgstr "Object型はv1.2でサポートされます。" + +#~ msgid "" +#~ "drilldown条件に指定されたカラムの値毎にとりまとめられたレコードについて、" +#~ "出力を行うレコードの件数を指定します。デフォルト値は10です。実際には、" +#~ "drilldown_offset + drilldown_limit がヒットした件数を超えない範囲でレコー" +#~ "ドが出力されます。drilldown_limitに負の値を指定した場合は、ヒットした件数 " +#~ "+ drilldown_limit + 1 によって算出される値が指定されたものとみなされます。" +#~ msgstr "" +#~ "drilldown条件に指定されたカラムの値毎にとりまとめられたレコードについて、" +#~ "出力を行うレコードの件数を指定します。デフォルト値は10です。実際には、" +#~ "drilldown_offset + drilldown_limit がヒットした件数を超えない範囲でレコー" +#~ "ドが出力されます。drilldown_limitに負の値を指定した場合は、ヒットした件数 " +#~ "+ drilldown_limit + 1 によって算出される値が指定されたものとみなされます。" + +#~ msgid "" +#~ "drilldown条件に指定されたカラムの値毎にとりまとめられたレコードについて、" +#~ "出力対象となる最初のレコードの番号を0ベースで指定します。デフォルト値は0で" +#~ "す。drilldown_offsetに負の値を指定した場合は、ヒットした件数 + " +#~ "drilldown_offsetによって算出される値が指定されたものとみなされます。" +#~ msgstr "" +#~ "drilldown条件に指定されたカラムの値毎にとりまとめられたレコードについて、" +#~ "出力対象となる最初のレコードの番号を0ベースで指定します。デフォルト値は0で" +#~ "す。drilldown_offsetに負の値を指定した場合は、ヒットした件数 + " +#~ "drilldown_offsetによって算出される値が指定されたものとみなされます。" + +#~ msgid "" +#~ "drilldown条件に指定されたカラムの値毎にとりまとめられたレコードについて、" +#~ "出力するカラム名のリストをカンマ(',')区切りで指定します。" +#~ msgstr "" +#~ "drilldown条件に指定されたカラムの値毎にとりまとめられたレコードについて、" +#~ "出力するカラム名のリストをカンマ(',')区切りで指定します。" + +#~ msgid "" +#~ "drilldown条件に指定されたカラムの値毎にとりまとめられたレコードについて、" +#~ "ソートキーとなるカラム名のリストをカンマ(',')区切りで指定します。sortbyパ" +#~ "ラメータと同様に昇降順を指定できます。" +#~ msgstr "" +#~ "drilldown条件に指定されたカラムの値毎にとりまとめられたレコードについて、" +#~ "ソートキーとなるカラム名のリストをカンマ(',')区切りで指定します。sortbyパ" +#~ "ラメータと同様に昇降順を指定できます。" + +#~ msgid "" +#~ "グループ化のキーとなるカラム名のリストをカンマ(',')区切りで指定します。検" +#~ "索条件にマッチした各レコードを出力したのちに、drilldownに指定されたカラム" +#~ "の値が同一であるレコードをとりまとめて、それぞれについて結果レコードを出力" +#~ "します。" +#~ msgstr "" +#~ "グループ化のキーとなるカラム名のリストをカンマ(',')区切りで指定します。検" +#~ "索条件にマッチした各レコードを出力したのちに、drilldownに指定されたカラム" +#~ "の値が同一であるレコードをとりまとめて、それぞれについて結果レコードを出力" +#~ "します。" + +#~ msgid "疑似カラム (pseudo_column)" +#~ msgstr "疑似カラム (pseudo_column)" + +#~ msgid ":doc:`columns/index`" +#~ msgstr ":doc:`columns/index`" + +#~ msgid ":doc:`columns/pseudo`" +#~ msgstr ":doc:`columns/pseudo`" + +#~ msgid ":doc:`columns/vector`" +#~ msgstr ":doc:`columns/vector`" + +#~ msgid ":doc:`columns/scalar`" +#~ msgstr ":doc:`columns/scalar`" -------------- next part -------------- HTML����������������������������...Télécharger