<!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">Kentaro Hayashi <hayas****@clear*****></dd> <dt style="clear: both; float: left; font-weight: bold; width: 8em">Date</dt> <dd style="margin-left: 8.5em">2017-04-24 15:06:47 +0900 (Mon, 24 Apr 2017)</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/commit/8dd45cc7d76b984ecf309873556610d5186bba9a">8dd45cc7d76b984ecf309873556610d5186bba9a</a></dd> <dt style="clear: both; float: left; font-weight: bold; width: 8em">Merge</dt> <dd style="margin-left: 8.5em"> <ul> <li>Merged <a href="https://github.com/groonga/groonga/commit/57b9b40">57b9b40</a>: Merge pull request <a href="https://github.com/groonga/groonga/issues/675">#675</a> from kenhys/test-cache-drilldowns-columns-window-group-keys</li> </ul> </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">test: add drilldowns[LABEL].columns[NAME].window.group_keys test case without cache When the value of --drilldowns[LABEL].columns[NAME].window.group_keys parameter is changed, Groonga returns result without using cache.</pre></dd> <dt style="clear: both; float: left; font-weight: bold; width: 8em">Added files</dt> <dd style="margin-left: 8.5em"> <ul> <li><a href="https://github.com/groonga/groonga/commit/8dd45cc7d76b984ecf309873556610d5186bba9a#diff-c79d8253e7368db00093198469d621b2">test/command/suite/sharding/logical_select/cache/drilldowns/columns/window/group_keys.expected</a></li> <li><a href="https://github.com/groonga/groonga/commit/8dd45cc7d76b984ecf309873556610d5186bba9a#diff-0174ddd9e61dd756783a1058efae0dc6">test/command/suite/sharding/logical_select/cache/drilldowns/columns/window/group_keys.test</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"> Added: test/command/suite/sharding/logical_select/cache/drilldowns/columns/window/group_keys.expected (+151 -0) 100644 =================================================================== </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"><a href="https://github.com/groonga/groonga/commit/8dd45cc7d76b984ecf309873556610d5186bba9a#diff-c79d8253e7368db00093198469d621b2">...</a>                                                                                                                                                                                                                                                                                                               </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"><a href="https://github.com/groonga/groonga/commit/8dd45cc7d76b984ecf309873556610d5186bba9a#diff-c79d8253e7368db00093198469d621b2">...</a> <a href="https://github.com/groonga/groonga/commit/8dd45cc7d76b984ecf309873556610d5186bba9a#diff-c79d8253e7368db00093198469d621b2R1">1</a> <a href="https://github.com/groonga/groonga/commit/8dd45cc7d76b984ecf309873556610d5186bba9a#diff-c79d8253e7368db00093198469d621b2R2">2</a> <a href="https://github.com/groonga/groonga/commit/8dd45cc7d76b984ecf309873556610d5186bba9a#diff-c79d8253e7368db00093198469d621b2R3">3</a> <a href="https://github.com/groonga/groonga/commit/8dd45cc7d76b984ecf309873556610d5186bba9a#diff-c79d8253e7368db00093198469d621b2R4">4</a> <a href="https://github.com/groonga/groonga/commit/8dd45cc7d76b984ecf309873556610d5186bba9a#diff-c79d8253e7368db00093198469d621b2R5">5</a> <a href="https://github.com/groonga/groonga/commit/8dd45cc7d76b984ecf309873556610d5186bba9a#diff-c79d8253e7368db00093198469d621b2R6">6</a> <a href="https://github.com/groonga/groonga/commit/8dd45cc7d76b984ecf309873556610d5186bba9a#diff-c79d8253e7368db00093198469d621b2R7">7</a> <a href="https://github.com/groonga/groonga/commit/8dd45cc7d76b984ecf309873556610d5186bba9a#diff-c79d8253e7368db00093198469d621b2R8">8</a> <a href="https://github.com/groonga/groonga/commit/8dd45cc7d76b984ecf309873556610d5186bba9a#diff-c79d8253e7368db00093198469d621b2R9">9</a> <a href="https://github.com/groonga/groonga/commit/8dd45cc7d76b984ecf309873556610d5186bba9a#diff-c79d8253e7368db00093198469d621b2R10">10</a> <a href="https://github.com/groonga/groonga/commit/8dd45cc7d76b984ecf309873556610d5186bba9a#diff-c79d8253e7368db00093198469d621b2R11">11</a> <a href="https://github.com/groonga/groonga/commit/8dd45cc7d76b984ecf309873556610d5186bba9a#diff-c79d8253e7368db00093198469d621b2R12">12</a> <a href="https://github.com/groonga/groonga/commit/8dd45cc7d76b984ecf309873556610d5186bba9a#diff-c79d8253e7368db00093198469d621b2R13">13</a> <a href="https://github.com/groonga/groonga/commit/8dd45cc7d76b984ecf309873556610d5186bba9a#diff-c79d8253e7368db00093198469d621b2R14">14</a> <a href="https://github.com/groonga/groonga/commit/8dd45cc7d76b984ecf309873556610d5186bba9a#diff-c79d8253e7368db00093198469d621b2R15">15</a> <a href="https://github.com/groonga/groonga/commit/8dd45cc7d76b984ecf309873556610d5186bba9a#diff-c79d8253e7368db00093198469d621b2R16">16</a> <a href="https://github.com/groonga/groonga/commit/8dd45cc7d76b984ecf309873556610d5186bba9a#diff-c79d8253e7368db00093198469d621b2R17">17</a> <a href="https://github.com/groonga/groonga/commit/8dd45cc7d76b984ecf309873556610d5186bba9a#diff-c79d8253e7368db00093198469d621b2R18">18</a> <a href="https://github.com/groonga/groonga/commit/8dd45cc7d76b984ecf309873556610d5186bba9a#diff-c79d8253e7368db00093198469d621b2R19">19</a> <a href="https://github.com/groonga/groonga/commit/8dd45cc7d76b984ecf309873556610d5186bba9a#diff-c79d8253e7368db00093198469d621b2R20">20</a> <a href="https://github.com/groonga/groonga/commit/8dd45cc7d76b984ecf309873556610d5186bba9a#diff-c79d8253e7368db00093198469d621b2R21">21</a> <a href="https://github.com/groonga/groonga/commit/8dd45cc7d76b984ecf309873556610d5186bba9a#diff-c79d8253e7368db00093198469d621b2R22">22</a> <a href="https://github.com/groonga/groonga/commit/8dd45cc7d76b984ecf309873556610d5186bba9a#diff-c79d8253e7368db00093198469d621b2R23">23</a> <a href="https://github.com/groonga/groonga/commit/8dd45cc7d76b984ecf309873556610d5186bba9a#diff-c79d8253e7368db00093198469d621b2R24">24</a> <a href="https://github.com/groonga/groonga/commit/8dd45cc7d76b984ecf309873556610d5186bba9a#diff-c79d8253e7368db00093198469d621b2R25">25</a> <a href="https://github.com/groonga/groonga/commit/8dd45cc7d76b984ecf309873556610d5186bba9a#diff-c79d8253e7368db00093198469d621b2R26">26</a> <a href="https://github.com/groonga/groonga/commit/8dd45cc7d76b984ecf309873556610d5186bba9a#diff-c79d8253e7368db00093198469d621b2R27">27</a> <a href="https://github.com/groonga/groonga/commit/8dd45cc7d76b984ecf309873556610d5186bba9a#diff-c79d8253e7368db00093198469d621b2R28">28</a> <a href="https://github.com/groonga/groonga/commit/8dd45cc7d76b984ecf309873556610d5186bba9a#diff-c79d8253e7368db00093198469d621b2R29">29</a> <a href="https://github.com/groonga/groonga/commit/8dd45cc7d76b984ecf309873556610d5186bba9a#diff-c79d8253e7368db00093198469d621b2R30">30</a> <a href="https://github.com/groonga/groonga/commit/8dd45cc7d76b984ecf309873556610d5186bba9a#diff-c79d8253e7368db00093198469d621b2R31">31</a> <a href="https://github.com/groonga/groonga/commit/8dd45cc7d76b984ecf309873556610d5186bba9a#diff-c79d8253e7368db00093198469d621b2R32">32</a> <a href="https://github.com/groonga/groonga/commit/8dd45cc7d76b984ecf309873556610d5186bba9a#diff-c79d8253e7368db00093198469d621b2R33">33</a> <a href="https://github.com/groonga/groonga/commit/8dd45cc7d76b984ecf309873556610d5186bba9a#diff-c79d8253e7368db00093198469d621b2R34">34</a> <a href="https://github.com/groonga/groonga/commit/8dd45cc7d76b984ecf309873556610d5186bba9a#diff-c79d8253e7368db00093198469d621b2R35">35</a> <a href="https://github.com/groonga/groonga/commit/8dd45cc7d76b984ecf309873556610d5186bba9a#diff-c79d8253e7368db00093198469d621b2R36">36</a> <a href="https://github.com/groonga/groonga/commit/8dd45cc7d76b984ecf309873556610d5186bba9a#diff-c79d8253e7368db00093198469d621b2R37">37</a> <a href="https://github.com/groonga/groonga/commit/8dd45cc7d76b984ecf309873556610d5186bba9a#diff-c79d8253e7368db00093198469d621b2R38">38</a> <a href="https://github.com/groonga/groonga/commit/8dd45cc7d76b984ecf309873556610d5186bba9a#diff-c79d8253e7368db00093198469d621b2R39">39</a> <a href="https://github.com/groonga/groonga/commit/8dd45cc7d76b984ecf309873556610d5186bba9a#diff-c79d8253e7368db00093198469d621b2R40">40</a> <a href="https://github.com/groonga/groonga/commit/8dd45cc7d76b984ecf309873556610d5186bba9a#diff-c79d8253e7368db00093198469d621b2R41">41</a> <a href="https://github.com/groonga/groonga/commit/8dd45cc7d76b984ecf309873556610d5186bba9a#diff-c79d8253e7368db00093198469d621b2R42">42</a> <a href="https://github.com/groonga/groonga/commit/8dd45cc7d76b984ecf309873556610d5186bba9a#diff-c79d8253e7368db00093198469d621b2R43">43</a> <a href="https://github.com/groonga/groonga/commit/8dd45cc7d76b984ecf309873556610d5186bba9a#diff-c79d8253e7368db00093198469d621b2R44">44</a> <a href="https://github.com/groonga/groonga/commit/8dd45cc7d76b984ecf309873556610d5186bba9a#diff-c79d8253e7368db00093198469d621b2R45">45</a> <a href="https://github.com/groonga/groonga/commit/8dd45cc7d76b984ecf309873556610d5186bba9a#diff-c79d8253e7368db00093198469d621b2R46">46</a> <a href="https://github.com/groonga/groonga/commit/8dd45cc7d76b984ecf309873556610d5186bba9a#diff-c79d8253e7368db00093198469d621b2R47">47</a> <a href="https://github.com/groonga/groonga/commit/8dd45cc7d76b984ecf309873556610d5186bba9a#diff-c79d8253e7368db00093198469d621b2R48">48</a> <a href="https://github.com/groonga/groonga/commit/8dd45cc7d76b984ecf309873556610d5186bba9a#diff-c79d8253e7368db00093198469d621b2R49">49</a> <a href="https://github.com/groonga/groonga/commit/8dd45cc7d76b984ecf309873556610d5186bba9a#diff-c79d8253e7368db00093198469d621b2R50">50</a> <a href="https://github.com/groonga/groonga/commit/8dd45cc7d76b984ecf309873556610d5186bba9a#diff-c79d8253e7368db00093198469d621b2R51">51</a> <a href="https://github.com/groonga/groonga/commit/8dd45cc7d76b984ecf309873556610d5186bba9a#diff-c79d8253e7368db00093198469d621b2R52">52</a> <a href="https://github.com/groonga/groonga/commit/8dd45cc7d76b984ecf309873556610d5186bba9a#diff-c79d8253e7368db00093198469d621b2R53">53</a> <a href="https://github.com/groonga/groonga/commit/8dd45cc7d76b984ecf309873556610d5186bba9a#diff-c79d8253e7368db00093198469d621b2R54">54</a> <a href="https://github.com/groonga/groonga/commit/8dd45cc7d76b984ecf309873556610d5186bba9a#diff-c79d8253e7368db00093198469d621b2R55">55</a> <a href="https://github.com/groonga/groonga/commit/8dd45cc7d76b984ecf309873556610d5186bba9a#diff-c79d8253e7368db00093198469d621b2R56">56</a> <a href="https://github.com/groonga/groonga/commit/8dd45cc7d76b984ecf309873556610d5186bba9a#diff-c79d8253e7368db00093198469d621b2R57">57</a> <a href="https://github.com/groonga/groonga/commit/8dd45cc7d76b984ecf309873556610d5186bba9a#diff-c79d8253e7368db00093198469d621b2R58">58</a> <a href="https://github.com/groonga/groonga/commit/8dd45cc7d76b984ecf309873556610d5186bba9a#diff-c79d8253e7368db00093198469d621b2R59">59</a> <a href="https://github.com/groonga/groonga/commit/8dd45cc7d76b984ecf309873556610d5186bba9a#diff-c79d8253e7368db00093198469d621b2R60">60</a> <a href="https://github.com/groonga/groonga/commit/8dd45cc7d76b984ecf309873556610d5186bba9a#diff-c79d8253e7368db00093198469d621b2R61">61</a> <a href="https://github.com/groonga/groonga/commit/8dd45cc7d76b984ecf309873556610d5186bba9a#diff-c79d8253e7368db00093198469d621b2R62">62</a> <a href="https://github.com/groonga/groonga/commit/8dd45cc7d76b984ecf309873556610d5186bba9a#diff-c79d8253e7368db00093198469d621b2R63">63</a> <a href="https://github.com/groonga/groonga/commit/8dd45cc7d76b984ecf309873556610d5186bba9a#diff-c79d8253e7368db00093198469d621b2R64">64</a> <a href="https://github.com/groonga/groonga/commit/8dd45cc7d76b984ecf309873556610d5186bba9a#diff-c79d8253e7368db00093198469d621b2R65">65</a> <a href="https://github.com/groonga/groonga/commit/8dd45cc7d76b984ecf309873556610d5186bba9a#diff-c79d8253e7368db00093198469d621b2R66">66</a> <a href="https://github.com/groonga/groonga/commit/8dd45cc7d76b984ecf309873556610d5186bba9a#diff-c79d8253e7368db00093198469d621b2R67">67</a> <a href="https://github.com/groonga/groonga/commit/8dd45cc7d76b984ecf309873556610d5186bba9a#diff-c79d8253e7368db00093198469d621b2R68">68</a> <a href="https://github.com/groonga/groonga/commit/8dd45cc7d76b984ecf309873556610d5186bba9a#diff-c79d8253e7368db00093198469d621b2R69">69</a> <a href="https://github.com/groonga/groonga/commit/8dd45cc7d76b984ecf309873556610d5186bba9a#diff-c79d8253e7368db00093198469d621b2R70">70</a> <a href="https://github.com/groonga/groonga/commit/8dd45cc7d76b984ecf309873556610d5186bba9a#diff-c79d8253e7368db00093198469d621b2R71">71</a> <a href="https://github.com/groonga/groonga/commit/8dd45cc7d76b984ecf309873556610d5186bba9a#diff-c79d8253e7368db00093198469d621b2R72">72</a> <a href="https://github.com/groonga/groonga/commit/8dd45cc7d76b984ecf309873556610d5186bba9a#diff-c79d8253e7368db00093198469d621b2R73">73</a> <a href="https://github.com/groonga/groonga/commit/8dd45cc7d76b984ecf309873556610d5186bba9a#diff-c79d8253e7368db00093198469d621b2R74">74</a> <a href="https://github.com/groonga/groonga/commit/8dd45cc7d76b984ecf309873556610d5186bba9a#diff-c79d8253e7368db00093198469d621b2R75">75</a> <a href="https://github.com/groonga/groonga/commit/8dd45cc7d76b984ecf309873556610d5186bba9a#diff-c79d8253e7368db00093198469d621b2R76">76</a> <a href="https://github.com/groonga/groonga/commit/8dd45cc7d76b984ecf309873556610d5186bba9a#diff-c79d8253e7368db00093198469d621b2R77">77</a> <a href="https://github.com/groonga/groonga/commit/8dd45cc7d76b984ecf309873556610d5186bba9a#diff-c79d8253e7368db00093198469d621b2R78">78</a> <a href="https://github.com/groonga/groonga/commit/8dd45cc7d76b984ecf309873556610d5186bba9a#diff-c79d8253e7368db00093198469d621b2R79">79</a> <a href="https://github.com/groonga/groonga/commit/8dd45cc7d76b984ecf309873556610d5186bba9a#diff-c79d8253e7368db00093198469d621b2R80">80</a> <a href="https://github.com/groonga/groonga/commit/8dd45cc7d76b984ecf309873556610d5186bba9a#diff-c79d8253e7368db00093198469d621b2R81">81</a> <a href="https://github.com/groonga/groonga/commit/8dd45cc7d76b984ecf309873556610d5186bba9a#diff-c79d8253e7368db00093198469d621b2R82">82</a> <a href="https://github.com/groonga/groonga/commit/8dd45cc7d76b984ecf309873556610d5186bba9a#diff-c79d8253e7368db00093198469d621b2R83">83</a> <a href="https://github.com/groonga/groonga/commit/8dd45cc7d76b984ecf309873556610d5186bba9a#diff-c79d8253e7368db00093198469d621b2R84">84</a> <a href="https://github.com/groonga/groonga/commit/8dd45cc7d76b984ecf309873556610d5186bba9a#diff-c79d8253e7368db00093198469d621b2R85">85</a> <a href="https://github.com/groonga/groonga/commit/8dd45cc7d76b984ecf309873556610d5186bba9a#diff-c79d8253e7368db00093198469d621b2R86">86</a> <a href="https://github.com/groonga/groonga/commit/8dd45cc7d76b984ecf309873556610d5186bba9a#diff-c79d8253e7368db00093198469d621b2R87">87</a> <a href="https://github.com/groonga/groonga/commit/8dd45cc7d76b984ecf309873556610d5186bba9a#diff-c79d8253e7368db00093198469d621b2R88">88</a> <a href="https://github.com/groonga/groonga/commit/8dd45cc7d76b984ecf309873556610d5186bba9a#diff-c79d8253e7368db00093198469d621b2R89">89</a> <a href="https://github.com/groonga/groonga/commit/8dd45cc7d76b984ecf309873556610d5186bba9a#diff-c79d8253e7368db00093198469d621b2R90">90</a> <a href="https://github.com/groonga/groonga/commit/8dd45cc7d76b984ecf309873556610d5186bba9a#diff-c79d8253e7368db00093198469d621b2R91">91</a> <a href="https://github.com/groonga/groonga/commit/8dd45cc7d76b984ecf309873556610d5186bba9a#diff-c79d8253e7368db00093198469d621b2R92">92</a> <a href="https://github.com/groonga/groonga/commit/8dd45cc7d76b984ecf309873556610d5186bba9a#diff-c79d8253e7368db00093198469d621b2R93">93</a> <a href="https://github.com/groonga/groonga/commit/8dd45cc7d76b984ecf309873556610d5186bba9a#diff-c79d8253e7368db00093198469d621b2R94">94</a> <a href="https://github.com/groonga/groonga/commit/8dd45cc7d76b984ecf309873556610d5186bba9a#diff-c79d8253e7368db00093198469d621b2R95">95</a> <a href="https://github.com/groonga/groonga/commit/8dd45cc7d76b984ecf309873556610d5186bba9a#diff-c79d8253e7368db00093198469d621b2R96">96</a> <a href="https://github.com/groonga/groonga/commit/8dd45cc7d76b984ecf309873556610d5186bba9a#diff-c79d8253e7368db00093198469d621b2R97">97</a> <a href="https://github.com/groonga/groonga/commit/8dd45cc7d76b984ecf309873556610d5186bba9a#diff-c79d8253e7368db00093198469d621b2R98">98</a> <a href="https://github.com/groonga/groonga/commit/8dd45cc7d76b984ecf309873556610d5186bba9a#diff-c79d8253e7368db00093198469d621b2R99">99</a> <a href="https://github.com/groonga/groonga/commit/8dd45cc7d76b984ecf309873556610d5186bba9a#diff-c79d8253e7368db00093198469d621b2R100">100</a> <a href="https://github.com/groonga/groonga/commit/8dd45cc7d76b984ecf309873556610d5186bba9a#diff-c79d8253e7368db00093198469d621b2R101">101</a> <a href="https://github.com/groonga/groonga/commit/8dd45cc7d76b984ecf309873556610d5186bba9a#diff-c79d8253e7368db00093198469d621b2R102">102</a> <a href="https://github.com/groonga/groonga/commit/8dd45cc7d76b984ecf309873556610d5186bba9a#diff-c79d8253e7368db00093198469d621b2R103">103</a> <a href="https://github.com/groonga/groonga/commit/8dd45cc7d76b984ecf309873556610d5186bba9a#diff-c79d8253e7368db00093198469d621b2R104">104</a> <a href="https://github.com/groonga/groonga/commit/8dd45cc7d76b984ecf309873556610d5186bba9a#diff-c79d8253e7368db00093198469d621b2R105">105</a> <a href="https://github.com/groonga/groonga/commit/8dd45cc7d76b984ecf309873556610d5186bba9a#diff-c79d8253e7368db00093198469d621b2R106">106</a> <a href="https://github.com/groonga/groonga/commit/8dd45cc7d76b984ecf309873556610d5186bba9a#diff-c79d8253e7368db00093198469d621b2R107">107</a> <a href="https://github.com/groonga/groonga/commit/8dd45cc7d76b984ecf309873556610d5186bba9a#diff-c79d8253e7368db00093198469d621b2R108">108</a> <a href="https://github.com/groonga/groonga/commit/8dd45cc7d76b984ecf309873556610d5186bba9a#diff-c79d8253e7368db00093198469d621b2R109">109</a> <a href="https://github.com/groonga/groonga/commit/8dd45cc7d76b984ecf309873556610d5186bba9a#diff-c79d8253e7368db00093198469d621b2R110">110</a> <a href="https://github.com/groonga/groonga/commit/8dd45cc7d76b984ecf309873556610d5186bba9a#diff-c79d8253e7368db00093198469d621b2R111">111</a> <a href="https://github.com/groonga/groonga/commit/8dd45cc7d76b984ecf309873556610d5186bba9a#diff-c79d8253e7368db00093198469d621b2R112">112</a> <a href="https://github.com/groonga/groonga/commit/8dd45cc7d76b984ecf309873556610d5186bba9a#diff-c79d8253e7368db00093198469d621b2R113">113</a> <a href="https://github.com/groonga/groonga/commit/8dd45cc7d76b984ecf309873556610d5186bba9a#diff-c79d8253e7368db00093198469d621b2R114">114</a> <a href="https://github.com/groonga/groonga/commit/8dd45cc7d76b984ecf309873556610d5186bba9a#diff-c79d8253e7368db00093198469d621b2R115">115</a> <a href="https://github.com/groonga/groonga/commit/8dd45cc7d76b984ecf309873556610d5186bba9a#diff-c79d8253e7368db00093198469d621b2R116">116</a> <a href="https://github.com/groonga/groonga/commit/8dd45cc7d76b984ecf309873556610d5186bba9a#diff-c79d8253e7368db00093198469d621b2R117">117</a> <a href="https://github.com/groonga/groonga/commit/8dd45cc7d76b984ecf309873556610d5186bba9a#diff-c79d8253e7368db00093198469d621b2R118">118</a> <a href="https://github.com/groonga/groonga/commit/8dd45cc7d76b984ecf309873556610d5186bba9a#diff-c79d8253e7368db00093198469d621b2R119">119</a> <a href="https://github.com/groonga/groonga/commit/8dd45cc7d76b984ecf309873556610d5186bba9a#diff-c79d8253e7368db00093198469d621b2R120">120</a> <a href="https://github.com/groonga/groonga/commit/8dd45cc7d76b984ecf309873556610d5186bba9a#diff-c79d8253e7368db00093198469d621b2R121">121</a> <a href="https://github.com/groonga/groonga/commit/8dd45cc7d76b984ecf309873556610d5186bba9a#diff-c79d8253e7368db00093198469d621b2R122">122</a> <a href="https://github.com/groonga/groonga/commit/8dd45cc7d76b984ecf309873556610d5186bba9a#diff-c79d8253e7368db00093198469d621b2R123">123</a> <a href="https://github.com/groonga/groonga/commit/8dd45cc7d76b984ecf309873556610d5186bba9a#diff-c79d8253e7368db00093198469d621b2R124">124</a> <a href="https://github.com/groonga/groonga/commit/8dd45cc7d76b984ecf309873556610d5186bba9a#diff-c79d8253e7368db00093198469d621b2R125">125</a> <a href="https://github.com/groonga/groonga/commit/8dd45cc7d76b984ecf309873556610d5186bba9a#diff-c79d8253e7368db00093198469d621b2R126">126</a> <a href="https://github.com/groonga/groonga/commit/8dd45cc7d76b984ecf309873556610d5186bba9a#diff-c79d8253e7368db00093198469d621b2R127">127</a> <a href="https://github.com/groonga/groonga/commit/8dd45cc7d76b984ecf309873556610d5186bba9a#diff-c79d8253e7368db00093198469d621b2R128">128</a> <a href="https://github.com/groonga/groonga/commit/8dd45cc7d76b984ecf309873556610d5186bba9a#diff-c79d8253e7368db00093198469d621b2R129">129</a> <a href="https://github.com/groonga/groonga/commit/8dd45cc7d76b984ecf309873556610d5186bba9a#diff-c79d8253e7368db00093198469d621b2R130">130</a> <a href="https://github.com/groonga/groonga/commit/8dd45cc7d76b984ecf309873556610d5186bba9a#diff-c79d8253e7368db00093198469d621b2R131">131</a> <a href="https://github.com/groonga/groonga/commit/8dd45cc7d76b984ecf309873556610d5186bba9a#diff-c79d8253e7368db00093198469d621b2R132">132</a> <a href="https://github.com/groonga/groonga/commit/8dd45cc7d76b984ecf309873556610d5186bba9a#diff-c79d8253e7368db00093198469d621b2R133">133</a> <a href="https://github.com/groonga/groonga/commit/8dd45cc7d76b984ecf309873556610d5186bba9a#diff-c79d8253e7368db00093198469d621b2R134">134</a> <a href="https://github.com/groonga/groonga/commit/8dd45cc7d76b984ecf309873556610d5186bba9a#diff-c79d8253e7368db00093198469d621b2R135">135</a> <a href="https://github.com/groonga/groonga/commit/8dd45cc7d76b984ecf309873556610d5186bba9a#diff-c79d8253e7368db00093198469d621b2R136">136</a> <a href="https://github.com/groonga/groonga/commit/8dd45cc7d76b984ecf309873556610d5186bba9a#diff-c79d8253e7368db00093198469d621b2R137">137</a> <a href="https://github.com/groonga/groonga/commit/8dd45cc7d76b984ecf309873556610d5186bba9a#diff-c79d8253e7368db00093198469d621b2R138">138</a> <a href="https://github.com/groonga/groonga/commit/8dd45cc7d76b984ecf309873556610d5186bba9a#diff-c79d8253e7368db00093198469d621b2R139">139</a> <a href="https://github.com/groonga/groonga/commit/8dd45cc7d76b984ecf309873556610d5186bba9a#diff-c79d8253e7368db00093198469d621b2R140">140</a> <a href="https://github.com/groonga/groonga/commit/8dd45cc7d76b984ecf309873556610d5186bba9a#diff-c79d8253e7368db00093198469d621b2R141">141</a> <a href="https://github.com/groonga/groonga/commit/8dd45cc7d76b984ecf309873556610d5186bba9a#diff-c79d8253e7368db00093198469d621b2R142">142</a> <a href="https://github.com/groonga/groonga/commit/8dd45cc7d76b984ecf309873556610d5186bba9a#diff-c79d8253e7368db00093198469d621b2R143">143</a> <a href="https://github.com/groonga/groonga/commit/8dd45cc7d76b984ecf309873556610d5186bba9a#diff-c79d8253e7368db00093198469d621b2R144">144</a> <a href="https://github.com/groonga/groonga/commit/8dd45cc7d76b984ecf309873556610d5186bba9a#diff-c79d8253e7368db00093198469d621b2R145">145</a> <a href="https://github.com/groonga/groonga/commit/8dd45cc7d76b984ecf309873556610d5186bba9a#diff-c79d8253e7368db00093198469d621b2R146">146</a> <a href="https://github.com/groonga/groonga/commit/8dd45cc7d76b984ecf309873556610d5186bba9a#diff-c79d8253e7368db00093198469d621b2R147">147</a> <a href="https://github.com/groonga/groonga/commit/8dd45cc7d76b984ecf309873556610d5186bba9a#diff-c79d8253e7368db00093198469d621b2R148">148</a> <a href="https://github.com/groonga/groonga/commit/8dd45cc7d76b984ecf309873556610d5186bba9a#diff-c79d8253e7368db00093198469d621b2R149">149</a> <a href="https://github.com/groonga/groonga/commit/8dd45cc7d76b984ecf309873556610d5186bba9a#diff-c79d8253e7368db00093198469d621b2R150">150</a> <a href="https://github.com/groonga/groonga/commit/8dd45cc7d76b984ecf309873556610d5186bba9a#diff-c79d8253e7368db00093198469d621b2R151">151</a> </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">@@ -0,0 +1,151 @@ +plugin_register sharding +[[0,0.0,0.0],true] +table_create Items TABLE_HASH_KEY ShortText +[[0,0.0,0.0],true] +column_create Items price COLUMN_SCALAR UInt32 +[[0,0.0,0.0],true] +table_create Logs_20170415 TABLE_NO_KEY +[[0,0.0,0.0],true] +column_create Logs_20170415 timestamp COLUMN_SCALAR Time +[[0,0.0,0.0],true] +column_create Logs_20170415 item COLUMN_SCALAR Items +[[0,0.0,0.0],true] +column_create Logs_20170415 category COLUMN_SCALAR ShortText +[[0,0.0,0.0],true] +table_create Logs_20170416 TABLE_NO_KEY +[[0,0.0,0.0],true] +column_create Logs_20170416 timestamp COLUMN_SCALAR Time +[[0,0.0,0.0],true] +column_create Logs_20170416 item COLUMN_SCALAR Items +[[0,0.0,0.0],true] +column_create Logs_20170416 category COLUMN_SCALAR ShortText +[[0,0.0,0.0],true] +load --table Items +[ +{"_key": "item1", "price": 200}, +{"_key": "item2", "price": 100} +] +[[0,0.0,0.0],2] +load --table Logs_20170415 +[ +{"timestamp": "2017/04/15 00:00:00", "item": "item1", "category": "Book"}, +{"timestamp": "2017/04/15 01:00:00", "item": "item2", "category": "Pen"}, +{"timestamp": "2017/04/15 02:00:00", "item": "item1", "cateogry": "Pen"} +] +[[0,0.0,0.0],3] +#|e| invalid column('cateogry') +load --table Logs_20170416 +[ +{"timestamp": "2017/04/16 10:00:00", "item": "item2", "category": "Pen"}, +{"timestamp": "2017/04/16 11:00:00", "item": "item1", "category": "Pen"}, +{"timestamp": "2017/04/16 12:00:00", "item": "item1", "category": "Book"} +] +[[0,0.0,0.0],3] +logical_select Logs --shard_key timestamp --limit 0 --output_columns _id --drilldowns[group].keys item,category --drilldowns[group].columns[nth].stage initial --drilldowns[group].columns[nth].type UInt32 --drilldowns[group].columns[nth].flags COLUMN_SCALAR --drilldowns[group].columns[nth].value 'window_record_number()' --drilldowns[group].columns[nth].window.group_keys _value.item --drilldowns[group].output_columns _value.item,nth +[ + [ + 0, + 0.0, + 0.0 + ], + [ + [ + [ + 6 + ], + [ + [ + "_id", + "UInt32" + ] + ] + ], + { + "group": [ + [ + 4 + ], + [ + [ + "item", + "Items" + ], + [ + "nth", + "UInt32" + ] + ], + [ + "item1", + 1 + ], + [ + "item2", + 2 + ], + [ + "item1", + 2 + ], + [ + "item1", + 1 + ] + ] + } + ] +] +logical_select Logs --shard_key timestamp --limit 0 --output_columns _id --drilldowns[group].keys item,category --drilldowns[group].columns[nth].stage initial --drilldowns[group].columns[nth].type UInt32 --drilldowns[group].columns[nth].flags COLUMN_SCALAR --drilldowns[group].columns[nth].value 'window_record_number()' --drilldowns[group].columns[nth].window.group_keys _value.category --drilldowns[group].output_columns _value.item,nth +[ + [ + 0, + 0.0, + 0.0 + ], + [ + [ + [ + 6 + ], + [ + [ + "_id", + "UInt32" + ] + ] + ], + { + "group": [ + [ + 4 + ], + [ + [ + "item", + "Items" + ], + [ + "nth", + "UInt32" + ] + ], + [ + "item1", + 1 + ], + [ + "item2", + 2 + ], + [ + "item1", + 1 + ], + [ + "item1", + 1 + ] + ] + } + ] +] </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"> Added: test/command/suite/sharding/logical_select/cache/drilldowns/columns/window/group_keys.test (+61 -0) 100644 =================================================================== </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"><a href="https://github.com/groonga/groonga/commit/8dd45cc7d76b984ecf309873556610d5186bba9a#diff-0174ddd9e61dd756783a1058efae0dc6">...</a>                                                                                                                           </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"><a href="https://github.com/groonga/groonga/commit/8dd45cc7d76b984ecf309873556610d5186bba9a#diff-0174ddd9e61dd756783a1058efae0dc6">...</a> <a href="https://github.com/groonga/groonga/commit/8dd45cc7d76b984ecf309873556610d5186bba9a#diff-0174ddd9e61dd756783a1058efae0dc6R1">1</a> <a href="https://github.com/groonga/groonga/commit/8dd45cc7d76b984ecf309873556610d5186bba9a#diff-0174ddd9e61dd756783a1058efae0dc6R2">2</a> <a href="https://github.com/groonga/groonga/commit/8dd45cc7d76b984ecf309873556610d5186bba9a#diff-0174ddd9e61dd756783a1058efae0dc6R3">3</a> <a href="https://github.com/groonga/groonga/commit/8dd45cc7d76b984ecf309873556610d5186bba9a#diff-0174ddd9e61dd756783a1058efae0dc6R4">4</a> <a href="https://github.com/groonga/groonga/commit/8dd45cc7d76b984ecf309873556610d5186bba9a#diff-0174ddd9e61dd756783a1058efae0dc6R5">5</a> <a href="https://github.com/groonga/groonga/commit/8dd45cc7d76b984ecf309873556610d5186bba9a#diff-0174ddd9e61dd756783a1058efae0dc6R6">6</a> <a href="https://github.com/groonga/groonga/commit/8dd45cc7d76b984ecf309873556610d5186bba9a#diff-0174ddd9e61dd756783a1058efae0dc6R7">7</a> <a href="https://github.com/groonga/groonga/commit/8dd45cc7d76b984ecf309873556610d5186bba9a#diff-0174ddd9e61dd756783a1058efae0dc6R8">8</a> <a href="https://github.com/groonga/groonga/commit/8dd45cc7d76b984ecf309873556610d5186bba9a#diff-0174ddd9e61dd756783a1058efae0dc6R9">9</a> <a href="https://github.com/groonga/groonga/commit/8dd45cc7d76b984ecf309873556610d5186bba9a#diff-0174ddd9e61dd756783a1058efae0dc6R10">10</a> <a href="https://github.com/groonga/groonga/commit/8dd45cc7d76b984ecf309873556610d5186bba9a#diff-0174ddd9e61dd756783a1058efae0dc6R11">11</a> <a href="https://github.com/groonga/groonga/commit/8dd45cc7d76b984ecf309873556610d5186bba9a#diff-0174ddd9e61dd756783a1058efae0dc6R12">12</a> <a href="https://github.com/groonga/groonga/commit/8dd45cc7d76b984ecf309873556610d5186bba9a#diff-0174ddd9e61dd756783a1058efae0dc6R13">13</a> <a href="https://github.com/groonga/groonga/commit/8dd45cc7d76b984ecf309873556610d5186bba9a#diff-0174ddd9e61dd756783a1058efae0dc6R14">14</a> <a href="https://github.com/groonga/groonga/commit/8dd45cc7d76b984ecf309873556610d5186bba9a#diff-0174ddd9e61dd756783a1058efae0dc6R15">15</a> <a href="https://github.com/groonga/groonga/commit/8dd45cc7d76b984ecf309873556610d5186bba9a#diff-0174ddd9e61dd756783a1058efae0dc6R16">16</a> <a href="https://github.com/groonga/groonga/commit/8dd45cc7d76b984ecf309873556610d5186bba9a#diff-0174ddd9e61dd756783a1058efae0dc6R17">17</a> <a href="https://github.com/groonga/groonga/commit/8dd45cc7d76b984ecf309873556610d5186bba9a#diff-0174ddd9e61dd756783a1058efae0dc6R18">18</a> <a href="https://github.com/groonga/groonga/commit/8dd45cc7d76b984ecf309873556610d5186bba9a#diff-0174ddd9e61dd756783a1058efae0dc6R19">19</a> <a href="https://github.com/groonga/groonga/commit/8dd45cc7d76b984ecf309873556610d5186bba9a#diff-0174ddd9e61dd756783a1058efae0dc6R20">20</a> <a href="https://github.com/groonga/groonga/commit/8dd45cc7d76b984ecf309873556610d5186bba9a#diff-0174ddd9e61dd756783a1058efae0dc6R21">21</a> <a href="https://github.com/groonga/groonga/commit/8dd45cc7d76b984ecf309873556610d5186bba9a#diff-0174ddd9e61dd756783a1058efae0dc6R22">22</a> <a href="https://github.com/groonga/groonga/commit/8dd45cc7d76b984ecf309873556610d5186bba9a#diff-0174ddd9e61dd756783a1058efae0dc6R23">23</a> <a href="https://github.com/groonga/groonga/commit/8dd45cc7d76b984ecf309873556610d5186bba9a#diff-0174ddd9e61dd756783a1058efae0dc6R24">24</a> <a href="https://github.com/groonga/groonga/commit/8dd45cc7d76b984ecf309873556610d5186bba9a#diff-0174ddd9e61dd756783a1058efae0dc6R25">25</a> <a href="https://github.com/groonga/groonga/commit/8dd45cc7d76b984ecf309873556610d5186bba9a#diff-0174ddd9e61dd756783a1058efae0dc6R26">26</a> <a href="https://github.com/groonga/groonga/commit/8dd45cc7d76b984ecf309873556610d5186bba9a#diff-0174ddd9e61dd756783a1058efae0dc6R27">27</a> <a href="https://github.com/groonga/groonga/commit/8dd45cc7d76b984ecf309873556610d5186bba9a#diff-0174ddd9e61dd756783a1058efae0dc6R28">28</a> <a href="https://github.com/groonga/groonga/commit/8dd45cc7d76b984ecf309873556610d5186bba9a#diff-0174ddd9e61dd756783a1058efae0dc6R29">29</a> <a href="https://github.com/groonga/groonga/commit/8dd45cc7d76b984ecf309873556610d5186bba9a#diff-0174ddd9e61dd756783a1058efae0dc6R30">30</a> <a href="https://github.com/groonga/groonga/commit/8dd45cc7d76b984ecf309873556610d5186bba9a#diff-0174ddd9e61dd756783a1058efae0dc6R31">31</a> <a href="https://github.com/groonga/groonga/commit/8dd45cc7d76b984ecf309873556610d5186bba9a#diff-0174ddd9e61dd756783a1058efae0dc6R32">32</a> <a href="https://github.com/groonga/groonga/commit/8dd45cc7d76b984ecf309873556610d5186bba9a#diff-0174ddd9e61dd756783a1058efae0dc6R33">33</a> <a href="https://github.com/groonga/groonga/commit/8dd45cc7d76b984ecf309873556610d5186bba9a#diff-0174ddd9e61dd756783a1058efae0dc6R34">34</a> <a href="https://github.com/groonga/groonga/commit/8dd45cc7d76b984ecf309873556610d5186bba9a#diff-0174ddd9e61dd756783a1058efae0dc6R35">35</a> <a href="https://github.com/groonga/groonga/commit/8dd45cc7d76b984ecf309873556610d5186bba9a#diff-0174ddd9e61dd756783a1058efae0dc6R36">36</a> <a href="https://github.com/groonga/groonga/commit/8dd45cc7d76b984ecf309873556610d5186bba9a#diff-0174ddd9e61dd756783a1058efae0dc6R37">37</a> <a href="https://github.com/groonga/groonga/commit/8dd45cc7d76b984ecf309873556610d5186bba9a#diff-0174ddd9e61dd756783a1058efae0dc6R38">38</a> <a href="https://github.com/groonga/groonga/commit/8dd45cc7d76b984ecf309873556610d5186bba9a#diff-0174ddd9e61dd756783a1058efae0dc6R39">39</a> <a href="https://github.com/groonga/groonga/commit/8dd45cc7d76b984ecf309873556610d5186bba9a#diff-0174ddd9e61dd756783a1058efae0dc6R40">40</a> <a href="https://github.com/groonga/groonga/commit/8dd45cc7d76b984ecf309873556610d5186bba9a#diff-0174ddd9e61dd756783a1058efae0dc6R41">41</a> <a href="https://github.com/groonga/groonga/commit/8dd45cc7d76b984ecf309873556610d5186bba9a#diff-0174ddd9e61dd756783a1058efae0dc6R42">42</a> <a href="https://github.com/groonga/groonga/commit/8dd45cc7d76b984ecf309873556610d5186bba9a#diff-0174ddd9e61dd756783a1058efae0dc6R43">43</a> <a href="https://github.com/groonga/groonga/commit/8dd45cc7d76b984ecf309873556610d5186bba9a#diff-0174ddd9e61dd756783a1058efae0dc6R44">44</a> <a href="https://github.com/groonga/groonga/commit/8dd45cc7d76b984ecf309873556610d5186bba9a#diff-0174ddd9e61dd756783a1058efae0dc6R45">45</a> <a href="https://github.com/groonga/groonga/commit/8dd45cc7d76b984ecf309873556610d5186bba9a#diff-0174ddd9e61dd756783a1058efae0dc6R46">46</a> <a href="https://github.com/groonga/groonga/commit/8dd45cc7d76b984ecf309873556610d5186bba9a#diff-0174ddd9e61dd756783a1058efae0dc6R47">47</a> <a href="https://github.com/groonga/groonga/commit/8dd45cc7d76b984ecf309873556610d5186bba9a#diff-0174ddd9e61dd756783a1058efae0dc6R48">48</a> <a href="https://github.com/groonga/groonga/commit/8dd45cc7d76b984ecf309873556610d5186bba9a#diff-0174ddd9e61dd756783a1058efae0dc6R49">49</a> <a href="https://github.com/groonga/groonga/commit/8dd45cc7d76b984ecf309873556610d5186bba9a#diff-0174ddd9e61dd756783a1058efae0dc6R50">50</a> <a href="https://github.com/groonga/groonga/commit/8dd45cc7d76b984ecf309873556610d5186bba9a#diff-0174ddd9e61dd756783a1058efae0dc6R51">51</a> <a href="https://github.com/groonga/groonga/commit/8dd45cc7d76b984ecf309873556610d5186bba9a#diff-0174ddd9e61dd756783a1058efae0dc6R52">52</a> <a href="https://github.com/groonga/groonga/commit/8dd45cc7d76b984ecf309873556610d5186bba9a#diff-0174ddd9e61dd756783a1058efae0dc6R53">53</a> <a href="https://github.com/groonga/groonga/commit/8dd45cc7d76b984ecf309873556610d5186bba9a#diff-0174ddd9e61dd756783a1058efae0dc6R54">54</a> <a href="https://github.com/groonga/groonga/commit/8dd45cc7d76b984ecf309873556610d5186bba9a#diff-0174ddd9e61dd756783a1058efae0dc6R55">55</a> <a href="https://github.com/groonga/groonga/commit/8dd45cc7d76b984ecf309873556610d5186bba9a#diff-0174ddd9e61dd756783a1058efae0dc6R56">56</a> <a href="https://github.com/groonga/groonga/commit/8dd45cc7d76b984ecf309873556610d5186bba9a#diff-0174ddd9e61dd756783a1058efae0dc6R57">57</a> <a href="https://github.com/groonga/groonga/commit/8dd45cc7d76b984ecf309873556610d5186bba9a#diff-0174ddd9e61dd756783a1058efae0dc6R58">58</a> <a href="https://github.com/groonga/groonga/commit/8dd45cc7d76b984ecf309873556610d5186bba9a#diff-0174ddd9e61dd756783a1058efae0dc6R59">59</a> <a href="https://github.com/groonga/groonga/commit/8dd45cc7d76b984ecf309873556610d5186bba9a#diff-0174ddd9e61dd756783a1058efae0dc6R60">60</a> <a href="https://github.com/groonga/groonga/commit/8dd45cc7d76b984ecf309873556610d5186bba9a#diff-0174ddd9e61dd756783a1058efae0dc6R61">61</a> </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">@@ -0,0 +1,61 @@ +#@on-error omit +plugin_register sharding +#@on-error default + +table_create Items TABLE_HASH_KEY ShortText +column_create Items price COLUMN_SCALAR UInt32 + +table_create Logs_20170415 TABLE_NO_KEY +column_create Logs_20170415 timestamp COLUMN_SCALAR Time +column_create Logs_20170415 item COLUMN_SCALAR Items +column_create Logs_20170415 category COLUMN_SCALAR ShortText + +table_create Logs_20170416 TABLE_NO_KEY +column_create Logs_20170416 timestamp COLUMN_SCALAR Time +column_create Logs_20170416 item COLUMN_SCALAR Items +column_create Logs_20170416 category COLUMN_SCALAR ShortText + +load --table Items +[ +{"_key": "item1", "price": 200}, +{"_key": "item2", "price": 100} +] + +load --table Logs_20170415 +[ +{"timestamp": "2017/04/15 00:00:00", "item": "item1", "category": "Book"}, +{"timestamp": "2017/04/15 01:00:00", "item": "item2", "category": "Pen"}, +{"timestamp": "2017/04/15 02:00:00", "item": "item1", "cateogry": "Pen"} +] + +load --table Logs_20170416 +[ +{"timestamp": "2017/04/16 10:00:00", "item": "item2", "category": "Pen"}, +{"timestamp": "2017/04/16 11:00:00", "item": "item1", "category": "Pen"}, +{"timestamp": "2017/04/16 12:00:00", "item": "item1", "category": "Book"} +] + + +logical_select Logs \ + --shard_key timestamp \ + --limit 0 \ + --output_columns _id \ + --drilldowns[group].keys item,category \ + --drilldowns[group].columns[nth].stage initial \ + --drilldowns[group].columns[nth].type UInt32 \ + --drilldowns[group].columns[nth].flags COLUMN_SCALAR \ + --drilldowns[group].columns[nth].value 'window_record_number()' \ + --drilldowns[group].columns[nth].window.group_keys _value.item \ + --drilldowns[group].output_columns _value.item,nth + +logical_select Logs \ + --shard_key timestamp \ + --limit 0 \ + --output_columns _id \ + --drilldowns[group].keys item,category \ + --drilldowns[group].columns[nth].stage initial \ + --drilldowns[group].columns[nth].type UInt32 \ + --drilldowns[group].columns[nth].flags COLUMN_SCALAR \ + --drilldowns[group].columns[nth].value 'window_record_number()' \ + --drilldowns[group].columns[nth].window.group_keys _value.category \ + --drilldowns[group].output_columns _value.item,nth </pre> </td> </tr> </tbody> </table> </div> </body> </html>