[Groonga-commit] groonga/groonga at 48704ae [master] logical_select: fix a bug that labeled drilldown reports the number of hits

Back to archive index

Kouhei Sutou null+****@clear*****
Tue Jul 7 16:26:58 JST 2015


Kouhei Sutou	2015-07-07 16:26:58 +0900 (Tue, 07 Jul 2015)

  New Revision: 48704ae09432fcf4742162e39920f38051c71463
  https://github.com/groonga/groonga/commit/48704ae09432fcf4742162e39920f38051c71463

  Message:
    logical_select: fix a bug that labeled drilldown reports the number of hits

  Copied files:
    test/command/suite/sharding/logical_select/drilldown/labeled/sortby/ascending.expected
      (from test/command/suite/sharding/logical_select/drilldown/labeled/limit/positive.expected)
    test/command/suite/sharding/logical_select/drilldown/labeled/sortby/ascending.test
      (from test/command/suite/sharding/logical_select/drilldown/labeled/limit/positive.expected)
    test/command/suite/sharding/logical_select/drilldown/labeled/sortby/descending.expected
      (from test/command/suite/sharding/logical_select/drilldown/labeled/limit/positive.expected)
    test/command/suite/sharding/logical_select/drilldown/labeled/sortby/descending.test
      (from test/command/suite/sharding/logical_select/drilldown/labeled/limit/positive.expected)
    test/command/suite/sharding/logical_select/drilldown/labeled/sortby/limit.expected
      (from test/command/suite/sharding/logical_select/drilldown/labeled/limit/positive.expected)
    test/command/suite/sharding/logical_select/drilldown/labeled/sortby/limit.test
      (from test/command/suite/sharding/logical_select/drilldown/labeled/limit/positive.expected)
    test/command/suite/sharding/logical_select/drilldown/labeled/sortby/offset.expected
      (from test/command/suite/sharding/logical_select/drilldown/labeled/limit/positive.expected)
    test/command/suite/sharding/logical_select/drilldown/labeled/sortby/offset.test
      (from test/command/suite/sharding/logical_select/drilldown/labeled/limit/positive.expected)
  Modified files:
    plugins/sharding/logical_select.rb
    test/command/suite/sharding/logical_select/drilldown/labeled/limit/positive.expected

  Modified: plugins/sharding/logical_select.rb (+2 -14)
===================================================================
--- plugins/sharding/logical_select.rb    2015-07-07 16:12:57 +0900 (101138f)
+++ plugins/sharding/logical_select.rb    2015-07-07 16:26:58 +0900 (53b0255)
@@ -135,7 +135,7 @@ module Groonga
             n_elements += result_set.size
             output_columns = drilldown.output_columns
             options = {
-              :offset => drilldown.output_offset,
+              :offset => drilldown.offset,
               :limit  => drilldown.limit,
             }
 
@@ -308,7 +308,6 @@ module Groonga
         attr_reader :limit
         attr_reader :sort_keys
         attr_reader :output_columns
-        attr_reader :output_offset
         attr_reader :calc_target_name
         attr_reader :calc_types
         attr_accessor :result_set
@@ -324,12 +323,6 @@ module Groonga
           @calc_target_name = parameters["calc_target"]
           @calc_types = parse_calc_types(parameters["calc_types"])
 
-          if @sort_keys.empty?
-            @output_offset = @offset
-          else
-            @output_offset = 0
-          end
-
           @result_set = nil
           @unsorted_result_set = nil
         end
@@ -465,10 +458,6 @@ module Groonga
           drilldowns.each do |drilldown|
             group_result = TableGroupResult.new
             keys = drilldown.keys
-            sort_options = {
-              :offset => drilldown.offset,
-              :limit  => drilldown.limit,
-            }
             begin
               group_result.key_begin = 0
               group_result.key_end = keys.size - 1
@@ -485,8 +474,7 @@ module Groonga
               if drilldown.sort_keys.empty?
                 drilldown.result_set = result_set
               else
-                drilldown.result_set = result_set.sort(drilldown.sort_keys,
-                                                       sort_options)
+                drilldown.result_set = result_set.sort(drilldown.sort_keys)
                 drilldown.unsorted_result_set = result_set
               end
               group_result.table = nil

  Modified: test/command/suite/sharding/logical_select/drilldown/labeled/limit/positive.expected (+1 -21)
===================================================================
--- test/command/suite/sharding/logical_select/drilldown/labeled/limit/positive.expected    2015-07-07 16:12:57 +0900 (db8061b)
+++ test/command/suite/sharding/logical_select/drilldown/labeled/limit/positive.expected    2015-07-07 16:26:58 +0900 (b17a055)
@@ -96,7 +96,7 @@ load --table Logs_20150205
 }
 ]
 [[0,0.0,0.0],4]
-logical_select Logs timestamp   --limit 0   --drilldown[action_date].keys action,date   --drilldown[action_date].output_columns _value.action,_value.date,_nsubrecs   --drilldown[action_date].limit -1
+logical_select Logs timestamp   --limit 0   --drilldown[action_date].keys action,date   --drilldown[action_date].output_columns _value.action,_value.date,_nsubrecs   --drilldown[action_date].limit 1
 [
   [
     0,
@@ -150,26 +150,6 @@ logical_select Logs timestamp   --limit 0   --drilldown[action_date].keys action
           "Start",
           "2015-02-03",
           1
-        ],
-        [
-          "Shutdown",
-          "2015-02-03",
-          1
-        ],
-        [
-          "Start",
-          "2015-02-04",
-          1
-        ],
-        [
-          "Restart",
-          "2015-02-04",
-          2
-        ],
-        [
-          "Restart",
-          "2015-02-05",
-          4
         ]
       ]
     }

  Copied: test/command/suite/sharding/logical_select/drilldown/labeled/sortby/ascending.expected (+1 -1) 97%
===================================================================
--- test/command/suite/sharding/logical_select/drilldown/labeled/limit/positive.expected    2015-07-07 16:12:57 +0900 (db8061b)
+++ test/command/suite/sharding/logical_select/drilldown/labeled/sortby/ascending.expected    2015-07-07 16:26:58 +0900 (f93ccdd)
@@ -96,7 +96,7 @@ load --table Logs_20150205
 }
 ]
 [[0,0.0,0.0],4]
-logical_select Logs timestamp   --limit 0   --drilldown[action_date].keys action,date   --drilldown[action_date].output_columns _value.action,_value.date,_nsubrecs   --drilldown[action_date].limit -1
+logical_select Logs timestamp   --limit 0   --drilldown[action_date].keys action,date   --drilldown[action_date].output_columns _value.action,_value.date,_nsubrecs   --drilldown[action_date].sortby _nsubrecs
 [
   [
     0,

  Copied: test/command/suite/sharding/logical_select/drilldown/labeled/sortby/ascending.test (+14 -98) 57%
===================================================================
--- test/command/suite/sharding/logical_select/drilldown/labeled/limit/positive.expected    2015-07-07 16:12:57 +0900 (db8061b)
+++ test/command/suite/sharding/logical_select/drilldown/labeled/sortby/ascending.test    2015-07-07 16:26:58 +0900 (abfbf2d)
@@ -1,35 +1,25 @@
+#@on-error omit
 register sharding
-[[0,0.0,0.0],true]
+#@on-error default
+
 table_create Logs_20150203 TABLE_NO_KEY
-[[0,0.0,0.0],true]
 column_create Logs_20150203 timestamp COLUMN_SCALAR Time
-[[0,0.0,0.0],true]
 column_create Logs_20150203 memo COLUMN_SCALAR ShortText
-[[0,0.0,0.0],true]
 column_create Logs_20150203 date COLUMN_SCALAR ShortText
-[[0,0.0,0.0],true]
 column_create Logs_20150203 action COLUMN_SCALAR ShortText
-[[0,0.0,0.0],true]
+
 table_create Logs_20150204 TABLE_NO_KEY
-[[0,0.0,0.0],true]
 column_create Logs_20150204 timestamp COLUMN_SCALAR Time
-[[0,0.0,0.0],true]
 column_create Logs_20150204 memo COLUMN_SCALAR ShortText
-[[0,0.0,0.0],true]
 column_create Logs_20150204 date COLUMN_SCALAR ShortText
-[[0,0.0,0.0],true]
 column_create Logs_20150204 action COLUMN_SCALAR ShortText
-[[0,0.0,0.0],true]
+
 table_create Logs_20150205 TABLE_NO_KEY
-[[0,0.0,0.0],true]
 column_create Logs_20150205 timestamp COLUMN_SCALAR Time
-[[0,0.0,0.0],true]
 column_create Logs_20150205 memo COLUMN_SCALAR ShortText
-[[0,0.0,0.0],true]
 column_create Logs_20150205 date COLUMN_SCALAR ShortText
-[[0,0.0,0.0],true]
 column_create Logs_20150205 action COLUMN_SCALAR ShortText
-[[0,0.0,0.0],true]
+
 load --table Logs_20150203
 [
 {
@@ -45,7 +35,7 @@ load --table Logs_20150203
   "action":    "Shutdown"
 }
 ]
-[[0,0.0,0.0],2]
+
 load --table Logs_20150204
 [
 {
@@ -67,7 +57,7 @@ load --table Logs_20150204
   "action":    "Restart"
 }
 ]
-[[0,0.0,0.0],3]
+
 load --table Logs_20150205
 [
 {
@@ -95,83 +85,9 @@ load --table Logs_20150205
   "action":    "Restart"
 }
 ]
-[[0,0.0,0.0],4]
-logical_select Logs timestamp   --limit 0   --drilldown[action_date].keys action,date   --drilldown[action_date].output_columns _value.action,_value.date,_nsubrecs   --drilldown[action_date].limit -1
-[
-  [
-    0,
-    0.0,
-    0.0
-  ],
-  [
-    [
-      [
-        9
-      ],
-      [
-        [
-          "action",
-          "ShortText"
-        ],
-        [
-          "date",
-          "ShortText"
-        ],
-        [
-          "memo",
-          "ShortText"
-        ],
-        [
-          "timestamp",
-          "Time"
-        ]
-      ]
-    ],
-    {
-      "action_date": [
-        [
-          5
-        ],
-        [
-          [
-            "action",
-            "ShortText"
-          ],
-          [
-            "date",
-            "ShortText"
-          ],
-          [
-            "_nsubrecs",
-            "Int32"
-          ]
-        ],
-        [
-          "Start",
-          "2015-02-03",
-          1
-        ],
-        [
-          "Shutdown",
-          "2015-02-03",
-          1
-        ],
-        [
-          "Start",
-          "2015-02-04",
-          1
-        ],
-        [
-          "Restart",
-          "2015-02-04",
-          2
-        ],
-        [
-          "Restart",
-          "2015-02-05",
-          4
-        ]
-      ]
-    }
-  ]
-]
+
+logical_select Logs timestamp \
+  --limit 0 \
+  --drilldown[action_date].keys action,date \
+  --drilldown[action_date].output_columns _value.action,_value.date,_nsubrecs \
+  --drilldown[action_date].sortby _nsubrecs

  Copied: test/command/suite/sharding/logical_select/drilldown/labeled/sortby/descending.expected (+13 -13) 97%
===================================================================
--- test/command/suite/sharding/logical_select/drilldown/labeled/limit/positive.expected    2015-07-07 16:12:57 +0900 (db8061b)
+++ test/command/suite/sharding/logical_select/drilldown/labeled/sortby/descending.expected    2015-07-07 16:26:58 +0900 (54368f1)
@@ -96,7 +96,7 @@ load --table Logs_20150205
 }
 ]
 [[0,0.0,0.0],4]
-logical_select Logs timestamp   --limit 0   --drilldown[action_date].keys action,date   --drilldown[action_date].output_columns _value.action,_value.date,_nsubrecs   --drilldown[action_date].limit -1
+logical_select Logs timestamp   --limit 0   --drilldown[action_date].keys action,date   --drilldown[action_date].output_columns _value.action,_value.date,_nsubrecs   --drilldown[action_date].sortby -_nsubrecs
 [
   [
     0,
@@ -147,29 +147,29 @@ logical_select Logs timestamp   --limit 0   --drilldown[action_date].keys action
           ]
         ],
         [
-          "Start",
-          "2015-02-03",
-          1
+          "Restart",
+          "2015-02-05",
+          4
         ],
         [
-          "Shutdown",
-          "2015-02-03",
-          1
+          "Restart",
+          "2015-02-04",
+          2
         ],
         [
           "Start",
-          "2015-02-04",
+          "2015-02-03",
           1
         ],
         [
-          "Restart",
+          "Start",
           "2015-02-04",
-          2
+          1
         ],
         [
-          "Restart",
-          "2015-02-05",
-          4
+          "Shutdown",
+          "2015-02-03",
+          1
         ]
       ]
     }

  Copied: test/command/suite/sharding/logical_select/drilldown/labeled/sortby/descending.test (+14 -98) 57%
===================================================================
--- test/command/suite/sharding/logical_select/drilldown/labeled/limit/positive.expected    2015-07-07 16:12:57 +0900 (db8061b)
+++ test/command/suite/sharding/logical_select/drilldown/labeled/sortby/descending.test    2015-07-07 16:26:58 +0900 (0772190)
@@ -1,35 +1,25 @@
+#@on-error omit
 register sharding
-[[0,0.0,0.0],true]
+#@on-error default
+
 table_create Logs_20150203 TABLE_NO_KEY
-[[0,0.0,0.0],true]
 column_create Logs_20150203 timestamp COLUMN_SCALAR Time
-[[0,0.0,0.0],true]
 column_create Logs_20150203 memo COLUMN_SCALAR ShortText
-[[0,0.0,0.0],true]
 column_create Logs_20150203 date COLUMN_SCALAR ShortText
-[[0,0.0,0.0],true]
 column_create Logs_20150203 action COLUMN_SCALAR ShortText
-[[0,0.0,0.0],true]
+
 table_create Logs_20150204 TABLE_NO_KEY
-[[0,0.0,0.0],true]
 column_create Logs_20150204 timestamp COLUMN_SCALAR Time
-[[0,0.0,0.0],true]
 column_create Logs_20150204 memo COLUMN_SCALAR ShortText
-[[0,0.0,0.0],true]
 column_create Logs_20150204 date COLUMN_SCALAR ShortText
-[[0,0.0,0.0],true]
 column_create Logs_20150204 action COLUMN_SCALAR ShortText
-[[0,0.0,0.0],true]
+
 table_create Logs_20150205 TABLE_NO_KEY
-[[0,0.0,0.0],true]
 column_create Logs_20150205 timestamp COLUMN_SCALAR Time
-[[0,0.0,0.0],true]
 column_create Logs_20150205 memo COLUMN_SCALAR ShortText
-[[0,0.0,0.0],true]
 column_create Logs_20150205 date COLUMN_SCALAR ShortText
-[[0,0.0,0.0],true]
 column_create Logs_20150205 action COLUMN_SCALAR ShortText
-[[0,0.0,0.0],true]
+
 load --table Logs_20150203
 [
 {
@@ -45,7 +35,7 @@ load --table Logs_20150203
   "action":    "Shutdown"
 }
 ]
-[[0,0.0,0.0],2]
+
 load --table Logs_20150204
 [
 {
@@ -67,7 +57,7 @@ load --table Logs_20150204
   "action":    "Restart"
 }
 ]
-[[0,0.0,0.0],3]
+
 load --table Logs_20150205
 [
 {
@@ -95,83 +85,9 @@ load --table Logs_20150205
   "action":    "Restart"
 }
 ]
-[[0,0.0,0.0],4]
-logical_select Logs timestamp   --limit 0   --drilldown[action_date].keys action,date   --drilldown[action_date].output_columns _value.action,_value.date,_nsubrecs   --drilldown[action_date].limit -1
-[
-  [
-    0,
-    0.0,
-    0.0
-  ],
-  [
-    [
-      [
-        9
-      ],
-      [
-        [
-          "action",
-          "ShortText"
-        ],
-        [
-          "date",
-          "ShortText"
-        ],
-        [
-          "memo",
-          "ShortText"
-        ],
-        [
-          "timestamp",
-          "Time"
-        ]
-      ]
-    ],
-    {
-      "action_date": [
-        [
-          5
-        ],
-        [
-          [
-            "action",
-            "ShortText"
-          ],
-          [
-            "date",
-            "ShortText"
-          ],
-          [
-            "_nsubrecs",
-            "Int32"
-          ]
-        ],
-        [
-          "Start",
-          "2015-02-03",
-          1
-        ],
-        [
-          "Shutdown",
-          "2015-02-03",
-          1
-        ],
-        [
-          "Start",
-          "2015-02-04",
-          1
-        ],
-        [
-          "Restart",
-          "2015-02-04",
-          2
-        ],
-        [
-          "Restart",
-          "2015-02-05",
-          4
-        ]
-      ]
-    }
-  ]
-]
+
+logical_select Logs timestamp \
+  --limit 0 \
+  --drilldown[action_date].keys action,date \
+  --drilldown[action_date].output_columns _value.action,_value.date,_nsubrecs \
+  --drilldown[action_date].sortby -_nsubrecs

  Copied: test/command/suite/sharding/logical_select/drilldown/labeled/sortby/limit.expected (+1 -21) 89%
===================================================================
--- test/command/suite/sharding/logical_select/drilldown/labeled/limit/positive.expected    2015-07-07 16:12:57 +0900 (db8061b)
+++ test/command/suite/sharding/logical_select/drilldown/labeled/sortby/limit.expected    2015-07-07 16:26:58 +0900 (0e1fa2e)
@@ -96,7 +96,7 @@ load --table Logs_20150205
 }
 ]
 [[0,0.0,0.0],4]
-logical_select Logs timestamp   --limit 0   --drilldown[action_date].keys action,date   --drilldown[action_date].output_columns _value.action,_value.date,_nsubrecs   --drilldown[action_date].limit -1
+logical_select Logs timestamp   --limit 0   --drilldown[action_date].keys action,date   --drilldown[action_date].output_columns _value.action,_value.date,_nsubrecs   --drilldown[action_date].sortby _nsubrecs   --drilldown[action_date].limit 1
 [
   [
     0,
@@ -150,26 +150,6 @@ logical_select Logs timestamp   --limit 0   --drilldown[action_date].keys action
           "Start",
           "2015-02-03",
           1
-        ],
-        [
-          "Shutdown",
-          "2015-02-03",
-          1
-        ],
-        [
-          "Start",
-          "2015-02-04",
-          1
-        ],
-        [
-          "Restart",
-          "2015-02-04",
-          2
-        ],
-        [
-          "Restart",
-          "2015-02-05",
-          4
         ]
       ]
     }

  Copied: test/command/suite/sharding/logical_select/drilldown/labeled/sortby/limit.test (+15 -98) 57%
===================================================================
--- test/command/suite/sharding/logical_select/drilldown/labeled/limit/positive.expected    2015-07-07 16:12:57 +0900 (db8061b)
+++ test/command/suite/sharding/logical_select/drilldown/labeled/sortby/limit.test    2015-07-07 16:26:58 +0900 (8ab6aff)
@@ -1,35 +1,25 @@
+#@on-error omit
 register sharding
-[[0,0.0,0.0],true]
+#@on-error default
+
 table_create Logs_20150203 TABLE_NO_KEY
-[[0,0.0,0.0],true]
 column_create Logs_20150203 timestamp COLUMN_SCALAR Time
-[[0,0.0,0.0],true]
 column_create Logs_20150203 memo COLUMN_SCALAR ShortText
-[[0,0.0,0.0],true]
 column_create Logs_20150203 date COLUMN_SCALAR ShortText
-[[0,0.0,0.0],true]
 column_create Logs_20150203 action COLUMN_SCALAR ShortText
-[[0,0.0,0.0],true]
+
 table_create Logs_20150204 TABLE_NO_KEY
-[[0,0.0,0.0],true]
 column_create Logs_20150204 timestamp COLUMN_SCALAR Time
-[[0,0.0,0.0],true]
 column_create Logs_20150204 memo COLUMN_SCALAR ShortText
-[[0,0.0,0.0],true]
 column_create Logs_20150204 date COLUMN_SCALAR ShortText
-[[0,0.0,0.0],true]
 column_create Logs_20150204 action COLUMN_SCALAR ShortText
-[[0,0.0,0.0],true]
+
 table_create Logs_20150205 TABLE_NO_KEY
-[[0,0.0,0.0],true]
 column_create Logs_20150205 timestamp COLUMN_SCALAR Time
-[[0,0.0,0.0],true]
 column_create Logs_20150205 memo COLUMN_SCALAR ShortText
-[[0,0.0,0.0],true]
 column_create Logs_20150205 date COLUMN_SCALAR ShortText
-[[0,0.0,0.0],true]
 column_create Logs_20150205 action COLUMN_SCALAR ShortText
-[[0,0.0,0.0],true]
+
 load --table Logs_20150203
 [
 {
@@ -45,7 +35,7 @@ load --table Logs_20150203
   "action":    "Shutdown"
 }
 ]
-[[0,0.0,0.0],2]
+
 load --table Logs_20150204
 [
 {
@@ -67,7 +57,7 @@ load --table Logs_20150204
   "action":    "Restart"
 }
 ]
-[[0,0.0,0.0],3]
+
 load --table Logs_20150205
 [
 {
@@ -95,83 +85,10 @@ load --table Logs_20150205
   "action":    "Restart"
 }
 ]
-[[0,0.0,0.0],4]
-logical_select Logs timestamp   --limit 0   --drilldown[action_date].keys action,date   --drilldown[action_date].output_columns _value.action,_value.date,_nsubrecs   --drilldown[action_date].limit -1
-[
-  [
-    0,
-    0.0,
-    0.0
-  ],
-  [
-    [
-      [
-        9
-      ],
-      [
-        [
-          "action",
-          "ShortText"
-        ],
-        [
-          "date",
-          "ShortText"
-        ],
-        [
-          "memo",
-          "ShortText"
-        ],
-        [
-          "timestamp",
-          "Time"
-        ]
-      ]
-    ],
-    {
-      "action_date": [
-        [
-          5
-        ],
-        [
-          [
-            "action",
-            "ShortText"
-          ],
-          [
-            "date",
-            "ShortText"
-          ],
-          [
-            "_nsubrecs",
-            "Int32"
-          ]
-        ],
-        [
-          "Start",
-          "2015-02-03",
-          1
-        ],
-        [
-          "Shutdown",
-          "2015-02-03",
-          1
-        ],
-        [
-          "Start",
-          "2015-02-04",
-          1
-        ],
-        [
-          "Restart",
-          "2015-02-04",
-          2
-        ],
-        [
-          "Restart",
-          "2015-02-05",
-          4
-        ]
-      ]
-    }
-  ]
-]
+
+logical_select Logs timestamp \
+  --limit 0 \
+  --drilldown[action_date].keys action,date \
+  --drilldown[action_date].output_columns _value.action,_value.date,_nsubrecs \
+  --drilldown[action_date].sortby _nsubrecs \
+  --drilldown[action_date].limit 1

  Copied: test/command/suite/sharding/logical_select/drilldown/labeled/sortby/offset.expected (+1 -6) 96%
===================================================================
--- test/command/suite/sharding/logical_select/drilldown/labeled/limit/positive.expected    2015-07-07 16:12:57 +0900 (db8061b)
+++ test/command/suite/sharding/logical_select/drilldown/labeled/sortby/offset.expected    2015-07-07 16:26:58 +0900 (29f278e)
@@ -96,7 +96,7 @@ load --table Logs_20150205
 }
 ]
 [[0,0.0,0.0],4]
-logical_select Logs timestamp   --limit 0   --drilldown[action_date].keys action,date   --drilldown[action_date].output_columns _value.action,_value.date,_nsubrecs   --drilldown[action_date].limit -1
+logical_select Logs timestamp   --limit 0   --drilldown[action_date].keys action,date   --drilldown[action_date].output_columns _value.action,_value.date,_nsubrecs   --drilldown[action_date].sortby _nsubrecs   --drilldown[action_date].offset 1
 [
   [
     0,
@@ -147,11 +147,6 @@ logical_select Logs timestamp   --limit 0   --drilldown[action_date].keys action
           ]
         ],
         [
-          "Start",
-          "2015-02-03",
-          1
-        ],
-        [
           "Shutdown",
           "2015-02-03",
           1

  Copied: test/command/suite/sharding/logical_select/drilldown/labeled/sortby/offset.test (+15 -98) 57%
===================================================================
--- test/command/suite/sharding/logical_select/drilldown/labeled/limit/positive.expected    2015-07-07 16:12:57 +0900 (db8061b)
+++ test/command/suite/sharding/logical_select/drilldown/labeled/sortby/offset.test    2015-07-07 16:26:58 +0900 (2a6b74e)
@@ -1,35 +1,25 @@
+#@on-error omit
 register sharding
-[[0,0.0,0.0],true]
+#@on-error default
+
 table_create Logs_20150203 TABLE_NO_KEY
-[[0,0.0,0.0],true]
 column_create Logs_20150203 timestamp COLUMN_SCALAR Time
-[[0,0.0,0.0],true]
 column_create Logs_20150203 memo COLUMN_SCALAR ShortText
-[[0,0.0,0.0],true]
 column_create Logs_20150203 date COLUMN_SCALAR ShortText
-[[0,0.0,0.0],true]
 column_create Logs_20150203 action COLUMN_SCALAR ShortText
-[[0,0.0,0.0],true]
+
 table_create Logs_20150204 TABLE_NO_KEY
-[[0,0.0,0.0],true]
 column_create Logs_20150204 timestamp COLUMN_SCALAR Time
-[[0,0.0,0.0],true]
 column_create Logs_20150204 memo COLUMN_SCALAR ShortText
-[[0,0.0,0.0],true]
 column_create Logs_20150204 date COLUMN_SCALAR ShortText
-[[0,0.0,0.0],true]
 column_create Logs_20150204 action COLUMN_SCALAR ShortText
-[[0,0.0,0.0],true]
+
 table_create Logs_20150205 TABLE_NO_KEY
-[[0,0.0,0.0],true]
 column_create Logs_20150205 timestamp COLUMN_SCALAR Time
-[[0,0.0,0.0],true]
 column_create Logs_20150205 memo COLUMN_SCALAR ShortText
-[[0,0.0,0.0],true]
 column_create Logs_20150205 date COLUMN_SCALAR ShortText
-[[0,0.0,0.0],true]
 column_create Logs_20150205 action COLUMN_SCALAR ShortText
-[[0,0.0,0.0],true]
+
 load --table Logs_20150203
 [
 {
@@ -45,7 +35,7 @@ load --table Logs_20150203
   "action":    "Shutdown"
 }
 ]
-[[0,0.0,0.0],2]
+
 load --table Logs_20150204
 [
 {
@@ -67,7 +57,7 @@ load --table Logs_20150204
   "action":    "Restart"
 }
 ]
-[[0,0.0,0.0],3]
+
 load --table Logs_20150205
 [
 {
@@ -95,83 +85,10 @@ load --table Logs_20150205
   "action":    "Restart"
 }
 ]
-[[0,0.0,0.0],4]
-logical_select Logs timestamp   --limit 0   --drilldown[action_date].keys action,date   --drilldown[action_date].output_columns _value.action,_value.date,_nsubrecs   --drilldown[action_date].limit -1
-[
-  [
-    0,
-    0.0,
-    0.0
-  ],
-  [
-    [
-      [
-        9
-      ],
-      [
-        [
-          "action",
-          "ShortText"
-        ],
-        [
-          "date",
-          "ShortText"
-        ],
-        [
-          "memo",
-          "ShortText"
-        ],
-        [
-          "timestamp",
-          "Time"
-        ]
-      ]
-    ],
-    {
-      "action_date": [
-        [
-          5
-        ],
-        [
-          [
-            "action",
-            "ShortText"
-          ],
-          [
-            "date",
-            "ShortText"
-          ],
-          [
-            "_nsubrecs",
-            "Int32"
-          ]
-        ],
-        [
-          "Start",
-          "2015-02-03",
-          1
-        ],
-        [
-          "Shutdown",
-          "2015-02-03",
-          1
-        ],
-        [
-          "Start",
-          "2015-02-04",
-          1
-        ],
-        [
-          "Restart",
-          "2015-02-04",
-          2
-        ],
-        [
-          "Restart",
-          "2015-02-05",
-          4
-        ]
-      ]
-    }
-  ]
-]
+
+logical_select Logs timestamp \
+  --limit 0 \
+  --drilldown[action_date].keys action,date \
+  --drilldown[action_date].output_columns _value.action,_value.date,_nsubrecs \
+  --drilldown[action_date].sortby _nsubrecs \
+  --drilldown[action_date].offset 1
-------------- next part --------------
HTML����������������������������...
Download 



More information about the Groonga-commit mailing list
Back to archive index