<!DOCTYPE html>
<html>
<head>
</head>
<body>
<dl style="line-height: 1.5; margin-left: 2em">
<dt style="clear: both; float: left; font-weight: bold; width: 8em">Author</dt>
<dd style="margin-left: 8.5em">Kouhei Sutou <kou****@clear*****></dd>
<dt style="clear: both; float: left; font-weight: bold; width: 8em">Date</dt>
<dd style="margin-left: 8.5em">2015-01-29 22:23:18 +0900 (Thu, 29 Jan 2015)</dd>
<dt style="clear: both; float: left; font-weight: bold; width: 8em">New Revision</dt>
<dd style="margin-left: 8.5em"><a href="https://github.com/groonga/groonga.org/commit/c68fa1bddbdd616644878b4bf10d3f5f7aca0c25">c68fa1bddbdd616644878b4bf10d3f5f7aca0c25</a></dd>
<dt style="clear: both; float: left; font-weight: bold; width: 8em">Message</dt>
<dd style="margin-left: 8.5em"><pre style="border: 1px solid #aaa; font-family: Consolas, Menlo, "Liberation Mono", Courier, monospace; line-height: 1.2; padding: 0.5em; width: auto">Remove trailing spaces</pre></dd>
<dt style="clear: both; float: left; font-weight: bold; width: 8em">Modified files</dt>
<dd style="margin-left: 8.5em">
<ul>
<li><a href="https://github.com/groonga/groonga.org/commit/c68fa1bddbdd616644878b4bf10d3f5f7aca0c25#diff-0">en/_posts/2015-01-29-release.md</a></li>
<li><a href="https://github.com/groonga/groonga.org/commit/c68fa1bddbdd616644878b4bf10d3f5f7aca0c25#diff-1">ja/_posts/2015-01-29-release.md</a></li>
</ul>
</dd>
</dl>
<div class="diff-section" style="clear: both">
<table style="border-collapse: collapse; border: 1px solid #aaa">
<thead>
<tr class="diff-header" style="border: 1px solid #aaa">
<td colspan="3">
<pre style="border: 0; font-family: Consolas, Menlo, "Liberation Mono", Courier, monospace; line-height: 1.2; margin: 0; padding: 0.5em; white-space: normal; width: auto"><span class="diff-header" style="background-color: #eaf2f5; color: #999999; display: block; white-space: pre"> Modified: en/_posts/2015-01-29-release.md (+5 -5)</span>
<span class="diff-header-mark" style="background-color: #eaf2f5; color: #999999; display: block; white-space: pre">===================================================================</span>
</pre>
</td>
</tr>
</thead>
<tbody>
<tr>
<th class="diff-line-number" style="border: 1px solid #aaa">
<pre style="border: 0; font-family: Consolas, Menlo, "Liberation Mono", Courier, monospace; line-height: 1.2; margin: 0; padding: 0.5em; white-space: normal; width: auto"><span class="diff-line-number-hunk-header" style="display: block; white-space: pre"><a href="https://github.com/groonga/groonga.org/commit/c68fa1bddbdd616644878b4bf10d3f5f7aca0c25#L0L34">...</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/groonga/groonga.org/commit/c68fa1bddbdd616644878b4bf10d3f5f7aca0c25#L0L35">35</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/groonga/groonga.org/commit/c68fa1bddbdd616644878b4bf10d3f5f7aca0c25#L0L36">36</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/groonga/groonga.org/commit/c68fa1bddbdd616644878b4bf10d3f5f7aca0c25#L0L37">37</a></span>
<span class="diff-line-number-deleted" style="background-color: #ffaaaa; color: #000000; display: block; white-space: pre"><a href="https://github.com/groonga/groonga.org/commit/c68fa1bddbdd616644878b4bf10d3f5f7aca0c25#L0L38">38</a></span>
<span class="diff-line-number-nothing" style="display: block; white-space: pre"> </span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/groonga/groonga.org/commit/c68fa1bddbdd616644878b4bf10d3f5f7aca0c25#L0L39">39</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/groonga/groonga.org/commit/c68fa1bddbdd616644878b4bf10d3f5f7aca0c25#L0L40">40</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/groonga/groonga.org/commit/c68fa1bddbdd616644878b4bf10d3f5f7aca0c25#L0L41">41</a></span>
<span class="diff-line-number-deleted" style="background-color: #ffaaaa; color: #000000; display: block; white-space: pre"><a href="https://github.com/groonga/groonga.org/commit/c68fa1bddbdd616644878b4bf10d3f5f7aca0c25#L0L42">42</a></span>
<span class="diff-line-number-nothing" style="display: block; white-space: pre"> </span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/groonga/groonga.org/commit/c68fa1bddbdd616644878b4bf10d3f5f7aca0c25#L0L43">43</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/groonga/groonga.org/commit/c68fa1bddbdd616644878b4bf10d3f5f7aca0c25#L0L44">44</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/groonga/groonga.org/commit/c68fa1bddbdd616644878b4bf10d3f5f7aca0c25#L0L45">45</a></span>
<span class="diff-line-number-hunk-header" style="display: block; white-space: pre"><a href="https://github.com/groonga/groonga.org/commit/c68fa1bddbdd616644878b4bf10d3f5f7aca0c25#L0L51">...</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/groonga/groonga.org/commit/c68fa1bddbdd616644878b4bf10d3f5f7aca0c25#L0L52">52</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/groonga/groonga.org/commit/c68fa1bddbdd616644878b4bf10d3f5f7aca0c25#L0L53">53</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/groonga/groonga.org/commit/c68fa1bddbdd616644878b4bf10d3f5f7aca0c25#L0L54">54</a></span>
<span class="diff-line-number-deleted" style="background-color: #ffaaaa; color: #000000; display: block; white-space: pre"><a href="https://github.com/groonga/groonga.org/commit/c68fa1bddbdd616644878b4bf10d3f5f7aca0c25#L0L55">55</a></span>
<span class="diff-line-number-nothing" style="display: block; white-space: pre"> </span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/groonga/groonga.org/commit/c68fa1bddbdd616644878b4bf10d3f5f7aca0c25#L0L56">56</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/groonga/groonga.org/commit/c68fa1bddbdd616644878b4bf10d3f5f7aca0c25#L0L57">57</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/groonga/groonga.org/commit/c68fa1bddbdd616644878b4bf10d3f5f7aca0c25#L0L58">58</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/groonga/groonga.org/commit/c68fa1bddbdd616644878b4bf10d3f5f7aca0c25#L0L59">59</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/groonga/groonga.org/commit/c68fa1bddbdd616644878b4bf10d3f5f7aca0c25#L0L60">60</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/groonga/groonga.org/commit/c68fa1bddbdd616644878b4bf10d3f5f7aca0c25#L0L61">61</a></span>
<span class="diff-line-number-deleted" style="background-color: #ffaaaa; color: #000000; display: block; white-space: pre"><a href="https://github.com/groonga/groonga.org/commit/c68fa1bddbdd616644878b4bf10d3f5f7aca0c25#L0L62">62</a></span>
<span class="diff-line-number-nothing" style="display: block; white-space: pre"> </span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/groonga/groonga.org/commit/c68fa1bddbdd616644878b4bf10d3f5f7aca0c25#L0L63">63</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/groonga/groonga.org/commit/c68fa1bddbdd616644878b4bf10d3f5f7aca0c25#L0L64">64</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/groonga/groonga.org/commit/c68fa1bddbdd616644878b4bf10d3f5f7aca0c25#L0L65">65</a></span>
<span class="diff-line-number-hunk-header" style="display: block; white-space: pre"><a href="https://github.com/groonga/groonga.org/commit/c68fa1bddbdd616644878b4bf10d3f5f7aca0c25#L0L96">...</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/groonga/groonga.org/commit/c68fa1bddbdd616644878b4bf10d3f5f7aca0c25#L0L97">97</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/groonga/groonga.org/commit/c68fa1bddbdd616644878b4bf10d3f5f7aca0c25#L0L98">98</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/groonga/groonga.org/commit/c68fa1bddbdd616644878b4bf10d3f5f7aca0c25#L0L99">99</a></span>
<span class="diff-line-number-deleted" style="background-color: #ffaaaa; color: #000000; display: block; white-space: pre"><a href="https://github.com/groonga/groonga.org/commit/c68fa1bddbdd616644878b4bf10d3f5f7aca0c25#L0L100">100</a></span>
<span class="diff-line-number-nothing" style="display: block; white-space: pre"> </span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/groonga/groonga.org/commit/c68fa1bddbdd616644878b4bf10d3f5f7aca0c25#L0L101">101</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/groonga/groonga.org/commit/c68fa1bddbdd616644878b4bf10d3f5f7aca0c25#L0L102">102</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/groonga/groonga.org/commit/c68fa1bddbdd616644878b4bf10d3f5f7aca0c25#L0L103">103</a></span>
</pre>
</th>
<th class="diff-line-number" style="border: 1px solid #aaa">
<pre style="border: 0; font-family: Consolas, Menlo, "Liberation Mono", Courier, monospace; line-height: 1.2; margin: 0; padding: 0.5em; white-space: normal; width: auto"><span class="diff-line-number-hunk-header" style="display: block; white-space: pre"><a href="https://github.com/groonga/groonga.org/commit/c68fa1bddbdd616644878b4bf10d3f5f7aca0c25#L0R34">...</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/groonga/groonga.org/commit/c68fa1bddbdd616644878b4bf10d3f5f7aca0c25#L0R35">35</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/groonga/groonga.org/commit/c68fa1bddbdd616644878b4bf10d3f5f7aca0c25#L0R36">36</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/groonga/groonga.org/commit/c68fa1bddbdd616644878b4bf10d3f5f7aca0c25#L0R37">37</a></span>
<span class="diff-line-number-nothing" style="display: block; white-space: pre"> </span>
<span class="diff-line-number-added" style="background-color: #aaffaa; color: #000000; display: block; white-space: pre"><a href="https://github.com/groonga/groonga.org/commit/c68fa1bddbdd616644878b4bf10d3f5f7aca0c25#L0R38">38</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/groonga/groonga.org/commit/c68fa1bddbdd616644878b4bf10d3f5f7aca0c25#L0R39">39</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/groonga/groonga.org/commit/c68fa1bddbdd616644878b4bf10d3f5f7aca0c25#L0R40">40</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/groonga/groonga.org/commit/c68fa1bddbdd616644878b4bf10d3f5f7aca0c25#L0R41">41</a></span>
<span class="diff-line-number-nothing" style="display: block; white-space: pre"> </span>
<span class="diff-line-number-added" style="background-color: #aaffaa; color: #000000; display: block; white-space: pre"><a href="https://github.com/groonga/groonga.org/commit/c68fa1bddbdd616644878b4bf10d3f5f7aca0c25#L0R42">42</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/groonga/groonga.org/commit/c68fa1bddbdd616644878b4bf10d3f5f7aca0c25#L0R43">43</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/groonga/groonga.org/commit/c68fa1bddbdd616644878b4bf10d3f5f7aca0c25#L0R44">44</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/groonga/groonga.org/commit/c68fa1bddbdd616644878b4bf10d3f5f7aca0c25#L0R45">45</a></span>
<span class="diff-line-number-hunk-header" style="display: block; white-space: pre"><a href="https://github.com/groonga/groonga.org/commit/c68fa1bddbdd616644878b4bf10d3f5f7aca0c25#L0R51">...</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/groonga/groonga.org/commit/c68fa1bddbdd616644878b4bf10d3f5f7aca0c25#L0R52">52</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/groonga/groonga.org/commit/c68fa1bddbdd616644878b4bf10d3f5f7aca0c25#L0R53">53</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/groonga/groonga.org/commit/c68fa1bddbdd616644878b4bf10d3f5f7aca0c25#L0R54">54</a></span>
<span class="diff-line-number-nothing" style="display: block; white-space: pre"> </span>
<span class="diff-line-number-added" style="background-color: #aaffaa; color: #000000; display: block; white-space: pre"><a href="https://github.com/groonga/groonga.org/commit/c68fa1bddbdd616644878b4bf10d3f5f7aca0c25#L0R55">55</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/groonga/groonga.org/commit/c68fa1bddbdd616644878b4bf10d3f5f7aca0c25#L0R56">56</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/groonga/groonga.org/commit/c68fa1bddbdd616644878b4bf10d3f5f7aca0c25#L0R57">57</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/groonga/groonga.org/commit/c68fa1bddbdd616644878b4bf10d3f5f7aca0c25#L0R58">58</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/groonga/groonga.org/commit/c68fa1bddbdd616644878b4bf10d3f5f7aca0c25#L0R59">59</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/groonga/groonga.org/commit/c68fa1bddbdd616644878b4bf10d3f5f7aca0c25#L0R60">60</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/groonga/groonga.org/commit/c68fa1bddbdd616644878b4bf10d3f5f7aca0c25#L0R61">61</a></span>
<span class="diff-line-number-nothing" style="display: block; white-space: pre"> </span>
<span class="diff-line-number-added" style="background-color: #aaffaa; color: #000000; display: block; white-space: pre"><a href="https://github.com/groonga/groonga.org/commit/c68fa1bddbdd616644878b4bf10d3f5f7aca0c25#L0R62">62</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/groonga/groonga.org/commit/c68fa1bddbdd616644878b4bf10d3f5f7aca0c25#L0R63">63</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/groonga/groonga.org/commit/c68fa1bddbdd616644878b4bf10d3f5f7aca0c25#L0R64">64</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/groonga/groonga.org/commit/c68fa1bddbdd616644878b4bf10d3f5f7aca0c25#L0R65">65</a></span>
<span class="diff-line-number-hunk-header" style="display: block; white-space: pre"><a href="https://github.com/groonga/groonga.org/commit/c68fa1bddbdd616644878b4bf10d3f5f7aca0c25#L0R96">...</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/groonga/groonga.org/commit/c68fa1bddbdd616644878b4bf10d3f5f7aca0c25#L0R97">97</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/groonga/groonga.org/commit/c68fa1bddbdd616644878b4bf10d3f5f7aca0c25#L0R98">98</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/groonga/groonga.org/commit/c68fa1bddbdd616644878b4bf10d3f5f7aca0c25#L0R99">99</a></span>
<span class="diff-line-number-nothing" style="display: block; white-space: pre"> </span>
<span class="diff-line-number-added" style="background-color: #aaffaa; color: #000000; display: block; white-space: pre"><a href="https://github.com/groonga/groonga.org/commit/c68fa1bddbdd616644878b4bf10d3f5f7aca0c25#L0R100">100</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/groonga/groonga.org/commit/c68fa1bddbdd616644878b4bf10d3f5f7aca0c25#L0R101">101</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/groonga/groonga.org/commit/c68fa1bddbdd616644878b4bf10d3f5f7aca0c25#L0R102">102</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/groonga/groonga.org/commit/c68fa1bddbdd616644878b4bf10d3f5f7aca0c25#L0R103">103</a></span>
</pre>
</th>
<td class="diff-content" style="border: 1px solid #aaa">
<pre style="border: 0; font-family: Consolas, Menlo, "Liberation Mono", Courier, monospace; line-height: 1.2; margin: 0; padding: 0.5em; white-space: normal; width: auto"><span class="diff-hunk-header" style="background-color: #eaf2f5; color: #999999; display: block; white-space: pre">@@ -35,11 +35,11 @@ <span class="diff-context" style="background-color: #ffffaa; color: #000000">Try to pass following parameter to select command:</span></span>
<span class="diff-not-changed" style="display: block; white-space: pre"> Here is the simple example which use MAX.</span>
<span class="diff-not-changed" style="display: block; white-space: pre"> </span>
<span class="diff-not-changed" style="display: block; white-space: pre"> table_create Tags TABLE_PAT_KEY ShortText</span>
<span class="diff-deleted" style="background-color: #ffaaaa; color: #000000; display: block; white-space: pre">- </span>
<span class="diff-added" style="background-color: #aaffaa; color: #000000; display: block; white-space: pre">+</span>
<span class="diff-not-changed" style="display: block; white-space: pre"> table_create Memos TABLE_HASH_KEY ShortText</span>
<span class="diff-not-changed" style="display: block; white-space: pre"> column_create Memos tag COLUMN_SCALAR Tags</span>
<span class="diff-not-changed" style="display: block; white-space: pre"> column_create Memos priority COLUMN_SCALAR Int64</span>
<span class="diff-deleted" style="background-color: #ffaaaa; color: #000000; display: block; white-space: pre">- </span>
<span class="diff-added" style="background-color: #aaffaa; color: #000000; display: block; white-space: pre">+</span>
<span class="diff-not-changed" style="display: block; white-space: pre"> load --table Memos</span>
<span class="diff-not-changed" style="display: block; white-space: pre"> [</span>
<span class="diff-not-changed" style="display: block; white-space: pre"> {"_key": "Groonga1", "tag": "Groonga", "priority": 10},</span>
<span class="diff-hunk-header" style="background-color: #eaf2f5; color: #999999; display: block; white-space: pre">@@ -52,14 +52,14 @@ <span class="diff-context" style="background-color: #ffffaa; color: #000000">Here is the simple example which use MAX.</span></span>
<span class="diff-not-changed" style="display: block; white-space: pre"> {"_key": "Rroonga2", "tag": "Rroonga", "priority": -25},</span>
<span class="diff-not-changed" style="display: block; white-space: pre"> {"_key": "Rroonga3", "tag": "Rroonga", "priority": 0}</span>
<span class="diff-not-changed" style="display: block; white-space: pre"> ]</span>
<span class="diff-deleted" style="background-color: #ffaaaa; color: #000000; display: block; white-space: pre">- </span>
<span class="diff-added" style="background-color: #aaffaa; color: #000000; display: block; white-space: pre">+</span>
<span class="diff-not-changed" style="display: block; white-space: pre"> select Memos \</span>
<span class="diff-not-changed" style="display: block; white-space: pre"> --limit 0 \</span>
<span class="diff-not-changed" style="display: block; white-space: pre"> --drilldown[tag].keys tag \</span>
<span class="diff-not-changed" style="display: block; white-space: pre"> --drilldown[tag].calc_types MAX \</span>
<span class="diff-not-changed" style="display: block; white-space: pre"> --drilldown[tag].calc_target priority \</span>
<span class="diff-not-changed" style="display: block; white-space: pre"> --drilldown[tag].output_columns _key,_max</span>
<span class="diff-deleted" style="background-color: #ffaaaa; color: #000000; display: block; white-space: pre">- </span>
<span class="diff-added" style="background-color: #aaffaa; color: #000000; display: block; white-space: pre">+</span>
<span class="diff-not-changed" style="display: block; white-space: pre"> Here is the drilldown results.</span>
<span class="diff-not-changed" style="display: block; white-space: pre"> </span>
<span class="diff-not-changed" style="display: block; white-space: pre"> {</span>
<span class="diff-hunk-header" style="background-color: #eaf2f5; color: #999999; display: block; white-space: pre">@@ -97,7 +97,7 @@ <span class="diff-context" style="background-color: #ffffaa; color: #000000">The data is grouped by tag, there are three groups - "Groonga", "Mroonga" and "R</span></span>
<span class="diff-not-changed" style="display: block; white-space: pre"> If you want to get not only max value, but also min value, specify multiple types for calc_types.</span>
<span class="diff-not-changed" style="display: block; white-space: pre"> Here is the example which gets max value and min value:</span>
<span class="diff-not-changed" style="display: block; white-space: pre"> </span>
<span class="diff-deleted" style="background-color: #ffaaaa; color: #000000; display: block; white-space: pre">- --drilldown[tag].calc_types MAX,MIN </span>
<span class="diff-added" style="background-color: #aaffaa; color: #000000; display: block; white-space: pre">+ --drilldown[tag].calc_types MAX,MIN</span>
<span class="diff-not-changed" style="display: block; white-space: pre"> </span>
<span class="diff-not-changed" style="display: block; white-space: pre"> Don't forget to specify pseudo column name "_min".</span>
<span class="diff-not-changed" style="display: block; white-space: pre"> </span>
</pre>
</td>
</tr>
</tbody>
</table>
<table style="border-collapse: collapse; border: 1px solid #aaa">
<thead>
<tr class="diff-header" style="border: 1px solid #aaa">
<td colspan="3">
<pre style="border: 0; font-family: Consolas, Menlo, "Liberation Mono", Courier, monospace; line-height: 1.2; margin: 0; padding: 0.5em; white-space: normal; width: auto"><span class="diff-header" style="background-color: #eaf2f5; color: #999999; display: block; white-space: pre"> Modified: ja/_posts/2015-01-29-release.md (+5 -5)</span>
<span class="diff-header-mark" style="background-color: #eaf2f5; color: #999999; display: block; white-space: pre">===================================================================</span>
</pre>
</td>
</tr>
</thead>
<tbody>
<tr>
<th class="diff-line-number" style="border: 1px solid #aaa">
<pre style="border: 0; font-family: Consolas, Menlo, "Liberation Mono", Courier, monospace; line-height: 1.2; margin: 0; padding: 0.5em; white-space: normal; width: auto"><span class="diff-line-number-hunk-header" style="display: block; white-space: pre"><a href="https://github.com/groonga/groonga.org/commit/c68fa1bddbdd616644878b4bf10d3f5f7aca0c25#L1L43">...</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/groonga/groonga.org/commit/c68fa1bddbdd616644878b4bf10d3f5f7aca0c25#L1L44">44</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/groonga/groonga.org/commit/c68fa1bddbdd616644878b4bf10d3f5f7aca0c25#L1L45">45</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/groonga/groonga.org/commit/c68fa1bddbdd616644878b4bf10d3f5f7aca0c25#L1L46">46</a></span>
<span class="diff-line-number-deleted" style="background-color: #ffaaaa; color: #000000; display: block; white-space: pre"><a href="https://github.com/groonga/groonga.org/commit/c68fa1bddbdd616644878b4bf10d3f5f7aca0c25#L1L47">47</a></span>
<span class="diff-line-number-nothing" style="display: block; white-space: pre"> </span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/groonga/groonga.org/commit/c68fa1bddbdd616644878b4bf10d3f5f7aca0c25#L1L48">48</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/groonga/groonga.org/commit/c68fa1bddbdd616644878b4bf10d3f5f7aca0c25#L1L49">49</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/groonga/groonga.org/commit/c68fa1bddbdd616644878b4bf10d3f5f7aca0c25#L1L50">50</a></span>
<span class="diff-line-number-deleted" style="background-color: #ffaaaa; color: #000000; display: block; white-space: pre"><a href="https://github.com/groonga/groonga.org/commit/c68fa1bddbdd616644878b4bf10d3f5f7aca0c25#L1L51">51</a></span>
<span class="diff-line-number-nothing" style="display: block; white-space: pre"> </span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/groonga/groonga.org/commit/c68fa1bddbdd616644878b4bf10d3f5f7aca0c25#L1L52">52</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/groonga/groonga.org/commit/c68fa1bddbdd616644878b4bf10d3f5f7aca0c25#L1L53">53</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/groonga/groonga.org/commit/c68fa1bddbdd616644878b4bf10d3f5f7aca0c25#L1L54">54</a></span>
<span class="diff-line-number-hunk-header" style="display: block; white-space: pre"><a href="https://github.com/groonga/groonga.org/commit/c68fa1bddbdd616644878b4bf10d3f5f7aca0c25#L1L60">...</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/groonga/groonga.org/commit/c68fa1bddbdd616644878b4bf10d3f5f7aca0c25#L1L61">61</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/groonga/groonga.org/commit/c68fa1bddbdd616644878b4bf10d3f5f7aca0c25#L1L62">62</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/groonga/groonga.org/commit/c68fa1bddbdd616644878b4bf10d3f5f7aca0c25#L1L63">63</a></span>
<span class="diff-line-number-deleted" style="background-color: #ffaaaa; color: #000000; display: block; white-space: pre"><a href="https://github.com/groonga/groonga.org/commit/c68fa1bddbdd616644878b4bf10d3f5f7aca0c25#L1L64">64</a></span>
<span class="diff-line-number-nothing" style="display: block; white-space: pre"> </span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/groonga/groonga.org/commit/c68fa1bddbdd616644878b4bf10d3f5f7aca0c25#L1L65">65</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/groonga/groonga.org/commit/c68fa1bddbdd616644878b4bf10d3f5f7aca0c25#L1L66">66</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/groonga/groonga.org/commit/c68fa1bddbdd616644878b4bf10d3f5f7aca0c25#L1L67">67</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/groonga/groonga.org/commit/c68fa1bddbdd616644878b4bf10d3f5f7aca0c25#L1L68">68</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/groonga/groonga.org/commit/c68fa1bddbdd616644878b4bf10d3f5f7aca0c25#L1L69">69</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/groonga/groonga.org/commit/c68fa1bddbdd616644878b4bf10d3f5f7aca0c25#L1L70">70</a></span>
<span class="diff-line-number-deleted" style="background-color: #ffaaaa; color: #000000; display: block; white-space: pre"><a href="https://github.com/groonga/groonga.org/commit/c68fa1bddbdd616644878b4bf10d3f5f7aca0c25#L1L71">71</a></span>
<span class="diff-line-number-nothing" style="display: block; white-space: pre"> </span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/groonga/groonga.org/commit/c68fa1bddbdd616644878b4bf10d3f5f7aca0c25#L1L72">72</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/groonga/groonga.org/commit/c68fa1bddbdd616644878b4bf10d3f5f7aca0c25#L1L73">73</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/groonga/groonga.org/commit/c68fa1bddbdd616644878b4bf10d3f5f7aca0c25#L1L74">74</a></span>
<span class="diff-line-number-hunk-header" style="display: block; white-space: pre"><a href="https://github.com/groonga/groonga.org/commit/c68fa1bddbdd616644878b4bf10d3f5f7aca0c25#L1L103">...</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/groonga/groonga.org/commit/c68fa1bddbdd616644878b4bf10d3f5f7aca0c25#L1L104">104</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/groonga/groonga.org/commit/c68fa1bddbdd616644878b4bf10d3f5f7aca0c25#L1L105">105</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/groonga/groonga.org/commit/c68fa1bddbdd616644878b4bf10d3f5f7aca0c25#L1L106">106</a></span>
<span class="diff-line-number-deleted" style="background-color: #ffaaaa; color: #000000; display: block; white-space: pre"><a href="https://github.com/groonga/groonga.org/commit/c68fa1bddbdd616644878b4bf10d3f5f7aca0c25#L1L107">107</a></span>
<span class="diff-line-number-nothing" style="display: block; white-space: pre"> </span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/groonga/groonga.org/commit/c68fa1bddbdd616644878b4bf10d3f5f7aca0c25#L1L108">108</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/groonga/groonga.org/commit/c68fa1bddbdd616644878b4bf10d3f5f7aca0c25#L1L109">109</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/groonga/groonga.org/commit/c68fa1bddbdd616644878b4bf10d3f5f7aca0c25#L1L110">110</a></span>
</pre>
</th>
<th class="diff-line-number" style="border: 1px solid #aaa">
<pre style="border: 0; font-family: Consolas, Menlo, "Liberation Mono", Courier, monospace; line-height: 1.2; margin: 0; padding: 0.5em; white-space: normal; width: auto"><span class="diff-line-number-hunk-header" style="display: block; white-space: pre"><a href="https://github.com/groonga/groonga.org/commit/c68fa1bddbdd616644878b4bf10d3f5f7aca0c25#L1R43">...</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/groonga/groonga.org/commit/c68fa1bddbdd616644878b4bf10d3f5f7aca0c25#L1R44">44</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/groonga/groonga.org/commit/c68fa1bddbdd616644878b4bf10d3f5f7aca0c25#L1R45">45</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/groonga/groonga.org/commit/c68fa1bddbdd616644878b4bf10d3f5f7aca0c25#L1R46">46</a></span>
<span class="diff-line-number-nothing" style="display: block; white-space: pre"> </span>
<span class="diff-line-number-added" style="background-color: #aaffaa; color: #000000; display: block; white-space: pre"><a href="https://github.com/groonga/groonga.org/commit/c68fa1bddbdd616644878b4bf10d3f5f7aca0c25#L1R47">47</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/groonga/groonga.org/commit/c68fa1bddbdd616644878b4bf10d3f5f7aca0c25#L1R48">48</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/groonga/groonga.org/commit/c68fa1bddbdd616644878b4bf10d3f5f7aca0c25#L1R49">49</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/groonga/groonga.org/commit/c68fa1bddbdd616644878b4bf10d3f5f7aca0c25#L1R50">50</a></span>
<span class="diff-line-number-nothing" style="display: block; white-space: pre"> </span>
<span class="diff-line-number-added" style="background-color: #aaffaa; color: #000000; display: block; white-space: pre"><a href="https://github.com/groonga/groonga.org/commit/c68fa1bddbdd616644878b4bf10d3f5f7aca0c25#L1R51">51</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/groonga/groonga.org/commit/c68fa1bddbdd616644878b4bf10d3f5f7aca0c25#L1R52">52</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/groonga/groonga.org/commit/c68fa1bddbdd616644878b4bf10d3f5f7aca0c25#L1R53">53</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/groonga/groonga.org/commit/c68fa1bddbdd616644878b4bf10d3f5f7aca0c25#L1R54">54</a></span>
<span class="diff-line-number-hunk-header" style="display: block; white-space: pre"><a href="https://github.com/groonga/groonga.org/commit/c68fa1bddbdd616644878b4bf10d3f5f7aca0c25#L1R60">...</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/groonga/groonga.org/commit/c68fa1bddbdd616644878b4bf10d3f5f7aca0c25#L1R61">61</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/groonga/groonga.org/commit/c68fa1bddbdd616644878b4bf10d3f5f7aca0c25#L1R62">62</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/groonga/groonga.org/commit/c68fa1bddbdd616644878b4bf10d3f5f7aca0c25#L1R63">63</a></span>
<span class="diff-line-number-nothing" style="display: block; white-space: pre"> </span>
<span class="diff-line-number-added" style="background-color: #aaffaa; color: #000000; display: block; white-space: pre"><a href="https://github.com/groonga/groonga.org/commit/c68fa1bddbdd616644878b4bf10d3f5f7aca0c25#L1R64">64</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/groonga/groonga.org/commit/c68fa1bddbdd616644878b4bf10d3f5f7aca0c25#L1R65">65</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/groonga/groonga.org/commit/c68fa1bddbdd616644878b4bf10d3f5f7aca0c25#L1R66">66</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/groonga/groonga.org/commit/c68fa1bddbdd616644878b4bf10d3f5f7aca0c25#L1R67">67</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/groonga/groonga.org/commit/c68fa1bddbdd616644878b4bf10d3f5f7aca0c25#L1R68">68</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/groonga/groonga.org/commit/c68fa1bddbdd616644878b4bf10d3f5f7aca0c25#L1R69">69</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/groonga/groonga.org/commit/c68fa1bddbdd616644878b4bf10d3f5f7aca0c25#L1R70">70</a></span>
<span class="diff-line-number-nothing" style="display: block; white-space: pre"> </span>
<span class="diff-line-number-added" style="background-color: #aaffaa; color: #000000; display: block; white-space: pre"><a href="https://github.com/groonga/groonga.org/commit/c68fa1bddbdd616644878b4bf10d3f5f7aca0c25#L1R71">71</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/groonga/groonga.org/commit/c68fa1bddbdd616644878b4bf10d3f5f7aca0c25#L1R72">72</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/groonga/groonga.org/commit/c68fa1bddbdd616644878b4bf10d3f5f7aca0c25#L1R73">73</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/groonga/groonga.org/commit/c68fa1bddbdd616644878b4bf10d3f5f7aca0c25#L1R74">74</a></span>
<span class="diff-line-number-hunk-header" style="display: block; white-space: pre"><a href="https://github.com/groonga/groonga.org/commit/c68fa1bddbdd616644878b4bf10d3f5f7aca0c25#L1R103">...</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/groonga/groonga.org/commit/c68fa1bddbdd616644878b4bf10d3f5f7aca0c25#L1R104">104</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/groonga/groonga.org/commit/c68fa1bddbdd616644878b4bf10d3f5f7aca0c25#L1R105">105</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/groonga/groonga.org/commit/c68fa1bddbdd616644878b4bf10d3f5f7aca0c25#L1R106">106</a></span>
<span class="diff-line-number-nothing" style="display: block; white-space: pre"> </span>
<span class="diff-line-number-added" style="background-color: #aaffaa; color: #000000; display: block; white-space: pre"><a href="https://github.com/groonga/groonga.org/commit/c68fa1bddbdd616644878b4bf10d3f5f7aca0c25#L1R107">107</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/groonga/groonga.org/commit/c68fa1bddbdd616644878b4bf10d3f5f7aca0c25#L1R108">108</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/groonga/groonga.org/commit/c68fa1bddbdd616644878b4bf10d3f5f7aca0c25#L1R109">109</a></span>
<span class="diff-line-number-not-changed" style="display: block; white-space: pre"><a href="https://github.com/groonga/groonga.org/commit/c68fa1bddbdd616644878b4bf10d3f5f7aca0c25#L1R110">110</a></span>
</pre>
</th>
<td class="diff-content" style="border: 1px solid #aaa">
<pre style="border: 0; font-family: Consolas, Menlo, "Liberation Mono", Courier, monospace; line-height: 1.2; margin: 0; padding: 0.5em; white-space: normal; width: auto"><span class="diff-hunk-header" style="background-color: #eaf2f5; color: #999999; display: block; white-space: pre">@@ -44,11 +44,11 @@ <span class="diff-context" style="background-color: #ffffaa; color: #000000">drilldownした結果をグループごとにSUM (合計)、 MIN (最小値)、</span></span>
<span class="diff-not-changed" style="display: block; white-space: pre"> 具体的な例をみてみましょう。MAXを使ってグループごとの最大値を取得する例です。</span>
<span class="diff-not-changed" style="display: block; white-space: pre"> </span>
<span class="diff-not-changed" style="display: block; white-space: pre"> table_create Tags TABLE_PAT_KEY ShortText</span>
<span class="diff-deleted" style="background-color: #ffaaaa; color: #000000; display: block; white-space: pre">- </span>
<span class="diff-added" style="background-color: #aaffaa; color: #000000; display: block; white-space: pre">+</span>
<span class="diff-not-changed" style="display: block; white-space: pre"> table_create Memos TABLE_HASH_KEY ShortText</span>
<span class="diff-not-changed" style="display: block; white-space: pre"> column_create Memos tag COLUMN_SCALAR Tags</span>
<span class="diff-not-changed" style="display: block; white-space: pre"> column_create Memos priority COLUMN_SCALAR Int64</span>
<span class="diff-deleted" style="background-color: #ffaaaa; color: #000000; display: block; white-space: pre">- </span>
<span class="diff-added" style="background-color: #aaffaa; color: #000000; display: block; white-space: pre">+</span>
<span class="diff-not-changed" style="display: block; white-space: pre"> load --table Memos</span>
<span class="diff-not-changed" style="display: block; white-space: pre"> [</span>
<span class="diff-not-changed" style="display: block; white-space: pre"> {"_key": "Groonga1", "tag": "Groonga", "priority": 10},</span>
<span class="diff-hunk-header" style="background-color: #eaf2f5; color: #999999; display: block; white-space: pre">@@ -61,14 +61,14 @@ <span class="diff-context" style="background-color: #ffffaa; color: #000000">drilldownした結果をグループごとにSUM (合計)、 MIN (最小値)、</span></span>
<span class="diff-not-changed" style="display: block; white-space: pre"> {"_key": "Rroonga2", "tag": "Rroonga", "priority": -25},</span>
<span class="diff-not-changed" style="display: block; white-space: pre"> {"_key": "Rroonga3", "tag": "Rroonga", "priority": 0}</span>
<span class="diff-not-changed" style="display: block; white-space: pre"> ]</span>
<span class="diff-deleted" style="background-color: #ffaaaa; color: #000000; display: block; white-space: pre">- </span>
<span class="diff-added" style="background-color: #aaffaa; color: #000000; display: block; white-space: pre">+</span>
<span class="diff-not-changed" style="display: block; white-space: pre"> select Memos \</span>
<span class="diff-not-changed" style="display: block; white-space: pre"> --limit 0 \</span>
<span class="diff-not-changed" style="display: block; white-space: pre"> --drilldown[tag].keys tag \</span>
<span class="diff-not-changed" style="display: block; white-space: pre"> --drilldown[tag].calc_types MAX \</span>
<span class="diff-not-changed" style="display: block; white-space: pre"> --drilldown[tag].calc_target priority \</span>
<span class="diff-not-changed" style="display: block; white-space: pre"> --drilldown[tag].output_columns _key,_max</span>
<span class="diff-deleted" style="background-color: #ffaaaa; color: #000000; display: block; white-space: pre">- </span>
<span class="diff-added" style="background-color: #aaffaa; color: #000000; display: block; white-space: pre">+</span>
<span class="diff-not-changed" style="display: block; white-space: pre"> 結果は次のようになります。</span>
<span class="diff-not-changed" style="display: block; white-space: pre"> </span>
<span class="diff-not-changed" style="display: block; white-space: pre"> {</span>
<span class="diff-hunk-header" style="background-color: #eaf2f5; color: #999999; display: block; white-space: pre">@@ -104,7 +104,7 @@ <span class="diff-context" style="background-color: #ffffaa; color: #000000">drilldownした結果をグループごとにSUM (合計)、 MIN (最小値)、</span></span>
<span class="diff-not-changed" style="display: block; white-space: pre"> 3つにグループ化され、タグとグループごとの最大値が返ってくるのがわかります。</span>
<span class="diff-not-changed" style="display: block; white-space: pre"> 最大値だけでなく最小値も取得したいなら、`calc_types`に複数カンマ区切りで指定します。</span>
<span class="diff-not-changed" style="display: block; white-space: pre"> </span>
<span class="diff-deleted" style="background-color: #ffaaaa; color: #000000; display: block; white-space: pre">- --drilldown[tag].calc_types MAX,MIN </span>
<span class="diff-added" style="background-color: #aaffaa; color: #000000; display: block; white-space: pre">+ --drilldown[tag].calc_types MAX,MIN</span>
<span class="diff-not-changed" style="display: block; white-space: pre"> </span>
<span class="diff-not-changed" style="display: block; white-space: pre"> `output_columns` に `_min` 疑似カラムの指定も忘れないようにしましょう。</span>
<span class="diff-not-changed" style="display: block; white-space: pre"> </span>
</pre>
</td>
</tr>
</tbody>
</table>
</div>
</body>
</html>