[Groonga-commit] groonga/groonga at 78f99bf [master] doc: add execution results

Back to archive index

Kouhei Sutou null+****@clear*****
Tue Jan 27 19:07:19 JST 2015


Kouhei Sutou	2015-01-27 19:07:19 +0900 (Tue, 27 Jan 2015)

  New Revision: 78f99bf28877466793fbd7f2e8315d829466c97a
  https://github.com/groonga/groonga/commit/78f99bf28877466793fbd7f2e8315d829466c97a

  Message:
    doc: add execution results

  Added files:
    doc/source/example/reference/commands/select/drilldown_calc_types_all.log
    doc/source/example/reference/commands/select/drilldown_calc_types_avg.log
    doc/source/example/reference/commands/select/drilldown_calc_types_max.log
    doc/source/example/reference/commands/select/drilldown_calc_types_min.log
    doc/source/example/reference/commands/select/drilldown_calc_types_sum.log
    doc/source/example/reference/commands/select/drilldown_filter.log
    doc/source/example/reference/commands/select/drilldown_label_keys_multiple.log
    doc/source/example/reference/commands/select/drilldown_label_output_columns_single_group_key.log
    doc/source/example/reference/commands/select/drilldown_limit_negative.log
    doc/source/example/reference/commands/select/drilldown_limit_simple.log
    doc/source/example/reference/commands/select/drilldown_multiple.log
    doc/source/example/reference/commands/select/drilldown_offset_negative.log
    doc/source/example/reference/commands/select/drilldown_offset_simple.log
    doc/source/example/reference/commands/select/drilldown_output_columns_referenced_type_column_asterisk.log
    doc/source/example/reference/commands/select/drilldown_output_columns_referenced_type_column_definition.log
    doc/source/example/reference/commands/select/drilldown_output_columns_referenced_type_column_label.log
    doc/source/example/reference/commands/select/drilldown_output_columns_simple.log
    doc/source/example/reference/commands/select/drilldown_simple.log
    doc/source/example/reference/commands/select/drilldown_sortby_simple.log
    doc/source/example/reference/commands/select/usage_drilldown.log
    doc/source/example/reference/commands/select/usage_drilldown_only_query.log

  Added: doc/source/example/reference/commands/select/drilldown_calc_types_all.log (+25 -0) 100644
===================================================================
--- /dev/null
+++ doc/source/example/reference/commands/select/drilldown_calc_types_all.log    2015-01-27 19:07:19 +0900 (5a19b4e)
@@ -0,0 +1,25 @@
+Execution example::
+
+  select Entries \
+    --limit -1 \
+    --output_column _id,n_likes \
+    --drilldown tag \
+    --drilldown_calc_types MAX|MIN|SUM|AVG \
+    --drilldown_calc_target n_likes \
+    --drilldown_output_columns _key,_nsubrecs,_max,_min,_sum,_avg
+  # [
+  #   [
+  #     -22, 
+  #     1337566253.89858, 
+  #     0.000355720520019531, 
+  #     "invalid table group calc type: <|MIN|SUM|AVG>", 
+  #     [
+  #       [
+  #         "grn_parse_table_group_calc_types", 
+  #         "proc.c", 
+  #         625
+  #       ]
+  #     ]
+  #   ], 
+  #   []
+  # ]

  Added: doc/source/example/reference/commands/select/drilldown_calc_types_avg.log (+107 -0) 100644
===================================================================
--- /dev/null
+++ doc/source/example/reference/commands/select/drilldown_calc_types_avg.log    2015-01-27 19:07:19 +0900 (50acb62)
@@ -0,0 +1,107 @@
+Execution example::
+
+  select Entries \
+    --limit -1 \
+    --output_column _id,n_likes \
+    --drilldown tag \
+    --drilldown_calc_types AVG \
+    --drilldown_calc_target n_likes \
+    --drilldown_output_columns _key,_avg
+  # [
+  #   [
+  #     0, 
+  #     1337566253.89858, 
+  #     0.000355720520019531
+  #   ], 
+  #   [
+  #     [
+  #       [
+  #         5
+  #       ], 
+  #       [
+  #         [
+  #           "_id", 
+  #           "UInt32"
+  #         ], 
+  #         [
+  #           "_key", 
+  #           "ShortText"
+  #         ], 
+  #         [
+  #           "content", 
+  #           "Text"
+  #         ], 
+  #         [
+  #           "n_likes", 
+  #           "UInt32"
+  #         ], 
+  #         [
+  #           "tag", 
+  #           "ShortText"
+  #         ]
+  #       ], 
+  #       [
+  #         1, 
+  #         "The first post!", 
+  #         "Welcome! This is my first post!", 
+  #         5, 
+  #         "Hello"
+  #       ], 
+  #       [
+  #         2, 
+  #         "Groonga", 
+  #         "I started to use Groonga. It's very fast!", 
+  #         10, 
+  #         "Groonga"
+  #       ], 
+  #       [
+  #         3, 
+  #         "Mroonga", 
+  #         "I also started to use Mroonga. It's also very fast! Really fast!", 
+  #         15, 
+  #         "Groonga"
+  #       ], 
+  #       [
+  #         4, 
+  #         "Good-bye Senna", 
+  #         "I migrated all Senna system!", 
+  #         3, 
+  #         "Senna"
+  #       ], 
+  #       [
+  #         5, 
+  #         "Good-bye Tritonn", 
+  #         "I also migrated all Tritonn system!", 
+  #         3, 
+  #         "Senna"
+  #       ]
+  #     ], 
+  #     [
+  #       [
+  #         3
+  #       ], 
+  #       [
+  #         [
+  #           "_key", 
+  #           "ShortText"
+  #         ], 
+  #         [
+  #           "_avg", 
+  #           "Float"
+  #         ]
+  #       ], 
+  #       [
+  #         "Hello", 
+  #         5.0
+  #       ], 
+  #       [
+  #         "Groonga", 
+  #         12.5
+  #       ], 
+  #       [
+  #         "Senna", 
+  #         3.0
+  #       ]
+  #     ]
+  #   ]
+  # ]

  Added: doc/source/example/reference/commands/select/drilldown_calc_types_max.log (+107 -0) 100644
===================================================================
--- /dev/null
+++ doc/source/example/reference/commands/select/drilldown_calc_types_max.log    2015-01-27 19:07:19 +0900 (05d0795)
@@ -0,0 +1,107 @@
+Execution example::
+
+  select Entries \
+    --limit -1 \
+    --output_column _id,n_likes \
+    --drilldown tag \
+    --drilldown_calc_types MAX \
+    --drilldown_calc_target n_likes \
+    --drilldown_output_columns _key,_max
+  # [
+  #   [
+  #     0, 
+  #     1337566253.89858, 
+  #     0.000355720520019531
+  #   ], 
+  #   [
+  #     [
+  #       [
+  #         5
+  #       ], 
+  #       [
+  #         [
+  #           "_id", 
+  #           "UInt32"
+  #         ], 
+  #         [
+  #           "_key", 
+  #           "ShortText"
+  #         ], 
+  #         [
+  #           "content", 
+  #           "Text"
+  #         ], 
+  #         [
+  #           "n_likes", 
+  #           "UInt32"
+  #         ], 
+  #         [
+  #           "tag", 
+  #           "ShortText"
+  #         ]
+  #       ], 
+  #       [
+  #         1, 
+  #         "The first post!", 
+  #         "Welcome! This is my first post!", 
+  #         5, 
+  #         "Hello"
+  #       ], 
+  #       [
+  #         2, 
+  #         "Groonga", 
+  #         "I started to use Groonga. It's very fast!", 
+  #         10, 
+  #         "Groonga"
+  #       ], 
+  #       [
+  #         3, 
+  #         "Mroonga", 
+  #         "I also started to use Mroonga. It's also very fast! Really fast!", 
+  #         15, 
+  #         "Groonga"
+  #       ], 
+  #       [
+  #         4, 
+  #         "Good-bye Senna", 
+  #         "I migrated all Senna system!", 
+  #         3, 
+  #         "Senna"
+  #       ], 
+  #       [
+  #         5, 
+  #         "Good-bye Tritonn", 
+  #         "I also migrated all Tritonn system!", 
+  #         3, 
+  #         "Senna"
+  #       ]
+  #     ], 
+  #     [
+  #       [
+  #         3
+  #       ], 
+  #       [
+  #         [
+  #           "_key", 
+  #           "ShortText"
+  #         ], 
+  #         [
+  #           "_max", 
+  #           "Int64"
+  #         ]
+  #       ], 
+  #       [
+  #         "Hello", 
+  #         5
+  #       ], 
+  #       [
+  #         "Groonga", 
+  #         15
+  #       ], 
+  #       [
+  #         "Senna", 
+  #         3
+  #       ]
+  #     ]
+  #   ]
+  # ]

  Added: doc/source/example/reference/commands/select/drilldown_calc_types_min.log (+107 -0) 100644
===================================================================
--- /dev/null
+++ doc/source/example/reference/commands/select/drilldown_calc_types_min.log    2015-01-27 19:07:19 +0900 (2f18111)
@@ -0,0 +1,107 @@
+Execution example::
+
+  select Entries \
+    --limit -1 \
+    --output_column _id,n_likes \
+    --drilldown tag \
+    --drilldown_calc_types MIN \
+    --drilldown_calc_target n_likes \
+    --drilldown_output_columns _key,_min
+  # [
+  #   [
+  #     0, 
+  #     1337566253.89858, 
+  #     0.000355720520019531
+  #   ], 
+  #   [
+  #     [
+  #       [
+  #         5
+  #       ], 
+  #       [
+  #         [
+  #           "_id", 
+  #           "UInt32"
+  #         ], 
+  #         [
+  #           "_key", 
+  #           "ShortText"
+  #         ], 
+  #         [
+  #           "content", 
+  #           "Text"
+  #         ], 
+  #         [
+  #           "n_likes", 
+  #           "UInt32"
+  #         ], 
+  #         [
+  #           "tag", 
+  #           "ShortText"
+  #         ]
+  #       ], 
+  #       [
+  #         1, 
+  #         "The first post!", 
+  #         "Welcome! This is my first post!", 
+  #         5, 
+  #         "Hello"
+  #       ], 
+  #       [
+  #         2, 
+  #         "Groonga", 
+  #         "I started to use Groonga. It's very fast!", 
+  #         10, 
+  #         "Groonga"
+  #       ], 
+  #       [
+  #         3, 
+  #         "Mroonga", 
+  #         "I also started to use Mroonga. It's also very fast! Really fast!", 
+  #         15, 
+  #         "Groonga"
+  #       ], 
+  #       [
+  #         4, 
+  #         "Good-bye Senna", 
+  #         "I migrated all Senna system!", 
+  #         3, 
+  #         "Senna"
+  #       ], 
+  #       [
+  #         5, 
+  #         "Good-bye Tritonn", 
+  #         "I also migrated all Tritonn system!", 
+  #         3, 
+  #         "Senna"
+  #       ]
+  #     ], 
+  #     [
+  #       [
+  #         3
+  #       ], 
+  #       [
+  #         [
+  #           "_key", 
+  #           "ShortText"
+  #         ], 
+  #         [
+  #           "_min", 
+  #           "Int64"
+  #         ]
+  #       ], 
+  #       [
+  #         "Hello", 
+  #         5
+  #       ], 
+  #       [
+  #         "Groonga", 
+  #         10
+  #       ], 
+  #       [
+  #         "Senna", 
+  #         3
+  #       ]
+  #     ]
+  #   ]
+  # ]

  Added: doc/source/example/reference/commands/select/drilldown_calc_types_sum.log (+107 -0) 100644
===================================================================
--- /dev/null
+++ doc/source/example/reference/commands/select/drilldown_calc_types_sum.log    2015-01-27 19:07:19 +0900 (0b7358f)
@@ -0,0 +1,107 @@
+Execution example::
+
+  select Entries \
+    --limit -1 \
+    --output_column _id,n_likes \
+    --drilldown tag \
+    --drilldown_calc_types SUM \
+    --drilldown_calc_target n_likes \
+    --drilldown_output_columns _key,_sum
+  # [
+  #   [
+  #     0, 
+  #     1337566253.89858, 
+  #     0.000355720520019531
+  #   ], 
+  #   [
+  #     [
+  #       [
+  #         5
+  #       ], 
+  #       [
+  #         [
+  #           "_id", 
+  #           "UInt32"
+  #         ], 
+  #         [
+  #           "_key", 
+  #           "ShortText"
+  #         ], 
+  #         [
+  #           "content", 
+  #           "Text"
+  #         ], 
+  #         [
+  #           "n_likes", 
+  #           "UInt32"
+  #         ], 
+  #         [
+  #           "tag", 
+  #           "ShortText"
+  #         ]
+  #       ], 
+  #       [
+  #         1, 
+  #         "The first post!", 
+  #         "Welcome! This is my first post!", 
+  #         5, 
+  #         "Hello"
+  #       ], 
+  #       [
+  #         2, 
+  #         "Groonga", 
+  #         "I started to use Groonga. It's very fast!", 
+  #         10, 
+  #         "Groonga"
+  #       ], 
+  #       [
+  #         3, 
+  #         "Mroonga", 
+  #         "I also started to use Mroonga. It's also very fast! Really fast!", 
+  #         15, 
+  #         "Groonga"
+  #       ], 
+  #       [
+  #         4, 
+  #         "Good-bye Senna", 
+  #         "I migrated all Senna system!", 
+  #         3, 
+  #         "Senna"
+  #       ], 
+  #       [
+  #         5, 
+  #         "Good-bye Tritonn", 
+  #         "I also migrated all Tritonn system!", 
+  #         3, 
+  #         "Senna"
+  #       ]
+  #     ], 
+  #     [
+  #       [
+  #         3
+  #       ], 
+  #       [
+  #         [
+  #           "_key", 
+  #           "ShortText"
+  #         ], 
+  #         [
+  #           "_sum", 
+  #           "Int64"
+  #         ]
+  #       ], 
+  #       [
+  #         "Hello", 
+  #         5
+  #       ], 
+  #       [
+  #         "Groonga", 
+  #         25
+  #       ], 
+  #       [
+  #         "Senna", 
+  #         6
+  #       ]
+  #     ]
+  #   ]
+  # ]

  Added: doc/source/example/reference/commands/select/drilldown_filter.log (+65 -0) 100644
===================================================================
--- /dev/null
+++ doc/source/example/reference/commands/select/drilldown_filter.log    2015-01-27 19:07:19 +0900 (9d3a8a6)
@@ -0,0 +1,65 @@
+Execution example::
+
+  select Entries \
+    --output_columns _key,tag \
+    --filter 'n_likes >= 5' \
+    --drilldown tag
+  # [
+  #   [
+  #     0, 
+  #     1337566253.89858, 
+  #     0.000355720520019531
+  #   ], 
+  #   [
+  #     [
+  #       [
+  #         3
+  #       ], 
+  #       [
+  #         [
+  #           "_key", 
+  #           "ShortText"
+  #         ], 
+  #         [
+  #           "tag", 
+  #           "ShortText"
+  #         ]
+  #       ], 
+  #       [
+  #         "The first post!", 
+  #         "Hello"
+  #       ], 
+  #       [
+  #         "Groonga", 
+  #         "Groonga"
+  #       ], 
+  #       [
+  #         "Mroonga", 
+  #         "Groonga"
+  #       ]
+  #     ], 
+  #     [
+  #       [
+  #         2
+  #       ], 
+  #       [
+  #         [
+  #           "_key", 
+  #           "ShortText"
+  #         ], 
+  #         [
+  #           "_nsubrecs", 
+  #           "Int32"
+  #         ]
+  #       ], 
+  #       [
+  #         "Hello", 
+  #         1
+  #       ], 
+  #       [
+  #         "Groonga", 
+  #         2
+  #       ]
+  #     ]
+  #   ]
+  # ]

  Added: doc/source/example/reference/commands/select/drilldown_label_keys_multiple.log (+119 -0) 100644
===================================================================
--- /dev/null
+++ doc/source/example/reference/commands/select/drilldown_label_keys_multiple.log    2015-01-27 19:07:19 +0900 (74a1c59)
@@ -0,0 +1,119 @@
+Execution example::
+
+  select Entries \
+    --limit -1 \
+    --output_column tag,n_likes \
+    --drilldown[tag.n_likes].keys tag,n_likes \
+    --drilldown[tag.n_likes].output_columns _value.tag,_value.n_likes,_nsubrecs
+  # [
+  #   [
+  #     0, 
+  #     1337566253.89858, 
+  #     0.000355720520019531
+  #   ], 
+  #   [
+  #     [
+  #       [
+  #         5
+  #       ], 
+  #       [
+  #         [
+  #           "_id", 
+  #           "UInt32"
+  #         ], 
+  #         [
+  #           "_key", 
+  #           "ShortText"
+  #         ], 
+  #         [
+  #           "content", 
+  #           "Text"
+  #         ], 
+  #         [
+  #           "n_likes", 
+  #           "UInt32"
+  #         ], 
+  #         [
+  #           "tag", 
+  #           "ShortText"
+  #         ]
+  #       ], 
+  #       [
+  #         1, 
+  #         "The first post!", 
+  #         "Welcome! This is my first post!", 
+  #         5, 
+  #         "Hello"
+  #       ], 
+  #       [
+  #         2, 
+  #         "Groonga", 
+  #         "I started to use Groonga. It's very fast!", 
+  #         10, 
+  #         "Groonga"
+  #       ], 
+  #       [
+  #         3, 
+  #         "Mroonga", 
+  #         "I also started to use Mroonga. It's also very fast! Really fast!", 
+  #         15, 
+  #         "Groonga"
+  #       ], 
+  #       [
+  #         4, 
+  #         "Good-bye Senna", 
+  #         "I migrated all Senna system!", 
+  #         3, 
+  #         "Senna"
+  #       ], 
+  #       [
+  #         5, 
+  #         "Good-bye Tritonn", 
+  #         "I also migrated all Tritonn system!", 
+  #         3, 
+  #         "Senna"
+  #       ]
+  #     ], 
+  #     {
+  #       "tag.n_likes": [
+  #         [
+  #           4
+  #         ], 
+  #         [
+  #           [
+  #             "tag", 
+  #             "ShortText"
+  #           ], 
+  #           [
+  #             "n_likes", 
+  #             "UInt32"
+  #           ], 
+  #           [
+  #             "_nsubrecs", 
+  #             "Int32"
+  #           ]
+  #         ], 
+  #         [
+  #           "Hello", 
+  #           5, 
+  #           1
+  #         ], 
+  #         [
+  #           "Groonga", 
+  #           10, 
+  #           1
+  #         ], 
+  #         [
+  #           "Groonga", 
+  #           15, 
+  #           1
+  #         ], 
+  #         [
+  #           "Senna", 
+  #           3, 
+  #           2
+  #         ]
+  #       ]
+  #     }
+  #   ]
+  # ]

  Added: doc/source/example/reference/commands/select/drilldown_label_output_columns_single_group_key.log (+76 -0) 100644
===================================================================
--- /dev/null
+++ doc/source/example/reference/commands/select/drilldown_label_output_columns_single_group_key.log    2015-01-27 19:07:19 +0900 (e1772cc)
@@ -0,0 +1,76 @@
+Execution example::
+
+  select Entries \
+    --limit 0 \
+    --output_column _id \
+    --drilldown[tag.n_likes].keys tag,n_likes \
+    --drilldown[tag.n_likes].output_columns _value.tag,_value.n_likes
+  # [
+  #   [
+  #     0, 
+  #     1337566253.89858, 
+  #     0.000355720520019531
+  #   ], 
+  #   [
+  #     [
+  #       [
+  #         5
+  #       ], 
+  #       [
+  #         [
+  #           "_id", 
+  #           "UInt32"
+  #         ], 
+  #         [
+  #           "_key", 
+  #           "ShortText"
+  #         ], 
+  #         [
+  #           "content", 
+  #           "Text"
+  #         ], 
+  #         [
+  #           "n_likes", 
+  #           "UInt32"
+  #         ], 
+  #         [
+  #           "tag", 
+  #           "ShortText"
+  #         ]
+  #       ]
+  #     ], 
+  #     {
+  #       "tag.n_likes": [
+  #         [
+  #           4
+  #         ], 
+  #         [
+  #           [
+  #             "tag", 
+  #             "ShortText"
+  #           ], 
+  #           [
+  #             "n_likes", 
+  #             "UInt32"
+  #           ]
+  #         ], 
+  #         [
+  #           "Hello", 
+  #           5
+  #         ], 
+  #         [
+  #           "Groonga", 
+  #           10
+  #         ], 
+  #         [
+  #           "Groonga", 
+  #           15
+  #         ], 
+  #         [
+  #           "Senna", 
+  #           3
+  #         ]
+  #       ]
+  #     }
+  #   ]
+  # ]

  Added: doc/source/example/reference/commands/select/drilldown_limit_negative.log (+71 -0) 100644
===================================================================
--- /dev/null
+++ doc/source/example/reference/commands/select/drilldown_limit_negative.log    2015-01-27 19:07:19 +0900 (80ef1ac)
@@ -0,0 +1,71 @@
+Execution example::
+
+  select Entries \
+    --limit 0 \
+    --output_column _id \
+    --drilldown tag \
+    --drilldown_sortby _key \
+    --drilldown_limit -1
+  # [
+  #   [
+  #     0, 
+  #     1337566253.89858, 
+  #     0.000355720520019531
+  #   ], 
+  #   [
+  #     [
+  #       [
+  #         5
+  #       ], 
+  #       [
+  #         [
+  #           "_id", 
+  #           "UInt32"
+  #         ], 
+  #         [
+  #           "_key", 
+  #           "ShortText"
+  #         ], 
+  #         [
+  #           "content", 
+  #           "Text"
+  #         ], 
+  #         [
+  #           "n_likes", 
+  #           "UInt32"
+  #         ], 
+  #         [
+  #           "tag", 
+  #           "ShortText"
+  #         ]
+  #       ]
+  #     ], 
+  #     [
+  #       [
+  #         3
+  #       ], 
+  #       [
+  #         [
+  #           "_key", 
+  #           "ShortText"
+  #         ], 
+  #         [
+  #           "_nsubrecs", 
+  #           "Int32"
+  #         ]
+  #       ], 
+  #       [
+  #         "Groonga", 
+  #         2
+  #       ], 
+  #       [
+  #         "Hello", 
+  #         1
+  #       ], 
+  #       [
+  #         "Senna", 
+  #         2
+  #       ]
+  #     ]
+  #   ]
+  # ]

  Added: doc/source/example/reference/commands/select/drilldown_limit_simple.log (+68 -0) 100644
===================================================================
--- /dev/null
+++ doc/source/example/reference/commands/select/drilldown_limit_simple.log    2015-01-27 19:07:19 +0900 (2a57fe0)
@@ -0,0 +1,68 @@
+Execution example::
+
+  select Entries \
+    --limit 0 \
+    --output_column _id \
+    --drilldown tag \
+    --drilldown_sortby _key \
+    --drilldown_offset 1 \
+    --drilldown_limit 2
+  # [
+  #   [
+  #     0, 
+  #     1337566253.89858, 
+  #     0.000355720520019531
+  #   ], 
+  #   [
+  #     [
+  #       [
+  #         5
+  #       ], 
+  #       [
+  #         [
+  #           "_id", 
+  #           "UInt32"
+  #         ], 
+  #         [
+  #           "_key", 
+  #           "ShortText"
+  #         ], 
+  #         [
+  #           "content", 
+  #           "Text"
+  #         ], 
+  #         [
+  #           "n_likes", 
+  #           "UInt32"
+  #         ], 
+  #         [
+  #           "tag", 
+  #           "ShortText"
+  #         ]
+  #       ]
+  #     ], 
+  #     [
+  #       [
+  #         3
+  #       ], 
+  #       [
+  #         [
+  #           "_key", 
+  #           "ShortText"
+  #         ], 
+  #         [
+  #           "_nsubrecs", 
+  #           "Int32"
+  #         ]
+  #       ], 
+  #       [
+  #         "Hello", 
+  #         1
+  #       ], 
+  #       [
+  #         "Senna", 
+  #         2
+  #       ]
+  #     ]
+  #   ]
+  # ]

  Added: doc/source/example/reference/commands/select/drilldown_multiple.log (+100 -0) 100644
===================================================================
--- /dev/null
+++ doc/source/example/reference/commands/select/drilldown_multiple.log    2015-01-27 19:07:19 +0900 (33ae594)
@@ -0,0 +1,100 @@
+Execution example::
+
+  select Entries \
+    --limit 0 \
+    --output_column _id \
+    --drilldown tag,n_likes
+  # [
+  #   [
+  #     0, 
+  #     1337566253.89858, 
+  #     0.000355720520019531
+  #   ], 
+  #   [
+  #     [
+  #       [
+  #         5
+  #       ], 
+  #       [
+  #         [
+  #           "_id", 
+  #           "UInt32"
+  #         ], 
+  #         [
+  #           "_key", 
+  #           "ShortText"
+  #         ], 
+  #         [
+  #           "content", 
+  #           "Text"
+  #         ], 
+  #         [
+  #           "n_likes", 
+  #           "UInt32"
+  #         ], 
+  #         [
+  #           "tag", 
+  #           "ShortText"
+  #         ]
+  #       ]
+  #     ], 
+  #     [
+  #       [
+  #         3
+  #       ], 
+  #       [
+  #         [
+  #           "_key", 
+  #           "ShortText"
+  #         ], 
+  #         [
+  #           "_nsubrecs", 
+  #           "Int32"
+  #         ]
+  #       ], 
+  #       [
+  #         "Hello", 
+  #         1
+  #       ], 
+  #       [
+  #         "Groonga", 
+  #         2
+  #       ], 
+  #       [
+  #         "Senna", 
+  #         2
+  #       ]
+  #     ], 
+  #     [
+  #       [
+  #         4
+  #       ], 
+  #       [
+  #         [
+  #           "_key", 
+  #           "UInt32"
+  #         ], 
+  #         [
+  #           "_nsubrecs", 
+  #           "Int32"
+  #         ]
+  #       ], 
+  #       [
+  #         5, 
+  #         1
+  #       ], 
+  #       [
+  #         10, 
+  #         1
+  #       ], 
+  #       [
+  #         15, 
+  #         1
+  #       ], 
+  #       [
+  #         3, 
+  #         2
+  #       ]
+  #     ]
+  #   ]
+  # ]

  Added: doc/source/example/reference/commands/select/drilldown_offset_negative.log (+67 -0) 100644
===================================================================
--- /dev/null
+++ doc/source/example/reference/commands/select/drilldown_offset_negative.log    2015-01-27 19:07:19 +0900 (f05231c)
@@ -0,0 +1,67 @@
+Execution example::
+
+  select Entries \
+    --limit 0 \
+    --output_column _id \
+    --drilldown tag \
+    --drilldown_sortby _key \
+    --drilldown_offset -2
+  # [
+  #   [
+  #     0, 
+  #     1337566253.89858, 
+  #     0.000355720520019531
+  #   ], 
+  #   [
+  #     [
+  #       [
+  #         5
+  #       ], 
+  #       [
+  #         [
+  #           "_id", 
+  #           "UInt32"
+  #         ], 
+  #         [
+  #           "_key", 
+  #           "ShortText"
+  #         ], 
+  #         [
+  #           "content", 
+  #           "Text"
+  #         ], 
+  #         [
+  #           "n_likes", 
+  #           "UInt32"
+  #         ], 
+  #         [
+  #           "tag", 
+  #           "ShortText"
+  #         ]
+  #       ]
+  #     ], 
+  #     [
+  #       [
+  #         3
+  #       ], 
+  #       [
+  #         [
+  #           "_key", 
+  #           "ShortText"
+  #         ], 
+  #         [
+  #           "_nsubrecs", 
+  #           "Int32"
+  #         ]
+  #       ], 
+  #       [
+  #         "Hello", 
+  #         1
+  #       ], 
+  #       [
+  #         "Senna", 
+  #         2
+  #       ]
+  #     ]
+  #   ]
+  # ]

  Added: doc/source/example/reference/commands/select/drilldown_offset_simple.log (+67 -0) 100644
===================================================================
--- /dev/null
+++ doc/source/example/reference/commands/select/drilldown_offset_simple.log    2015-01-27 19:07:19 +0900 (bcb04f7)
@@ -0,0 +1,67 @@
+Execution example::
+
+  select Entries \
+    --limit 0 \
+    --output_column _id \
+    --drilldown tag \
+    --drilldown_sortby _key \
+    --drilldown_offset 1
+  # [
+  #   [
+  #     0, 
+  #     1337566253.89858, 
+  #     0.000355720520019531
+  #   ], 
+  #   [
+  #     [
+  #       [
+  #         5
+  #       ], 
+  #       [
+  #         [
+  #           "_id", 
+  #           "UInt32"
+  #         ], 
+  #         [
+  #           "_key", 
+  #           "ShortText"
+  #         ], 
+  #         [
+  #           "content", 
+  #           "Text"
+  #         ], 
+  #         [
+  #           "n_likes", 
+  #           "UInt32"
+  #         ], 
+  #         [
+  #           "tag", 
+  #           "ShortText"
+  #         ]
+  #       ]
+  #     ], 
+  #     [
+  #       [
+  #         3
+  #       ], 
+  #       [
+  #         [
+  #           "_key", 
+  #           "ShortText"
+  #         ], 
+  #         [
+  #           "_nsubrecs", 
+  #           "Int32"
+  #         ]
+  #       ], 
+  #       [
+  #         "Hello", 
+  #         1
+  #       ], 
+  #       [
+  #         "Senna", 
+  #         2
+  #       ]
+  #     ]
+  #   ]
+  # ]

  Added: doc/source/example/reference/commands/select/drilldown_output_columns_referenced_type_column_asterisk.log (+64 -0) 100644
===================================================================
--- /dev/null
+++ doc/source/example/reference/commands/select/drilldown_output_columns_referenced_type_column_asterisk.log    2015-01-27 19:07:19 +0900 (0e2cbae)
@@ -0,0 +1,64 @@
+Execution example::
+
+  select Items \
+    --limit 0 \
+    --output_column _id \
+    --drilldown tag \
+    --drilldown_output_columns '_key, *'
+  # [
+  #   [
+  #     0, 
+  #     1337566253.89858, 
+  #     0.000355720520019531
+  #   ], 
+  #   [
+  #     [
+  #       [
+  #         3
+  #       ], 
+  #       [
+  #         [
+  #           "_id", 
+  #           "UInt32"
+  #         ], 
+  #         [
+  #           "_key", 
+  #           "ShortText"
+  #         ], 
+  #         [
+  #           "tag", 
+  #           "Tags"
+  #         ]
+  #       ]
+  #     ], 
+  #     [
+  #       [
+  #         2
+  #       ], 
+  #       [
+  #         [
+  #           "_key", 
+  #           "ShortText"
+  #         ], 
+  #         [
+  #           "label", 
+  #           "ShortText"
+  #         ], 
+  #         [
+  #           "priority", 
+  #           "Int32"
+  #         ]
+  #       ], 
+  #       [
+  #         "groonga", 
+  #         "Groonga", 
+  #         10
+  #       ], 
+  #       [
+  #         "mroonga", 
+  #         "Mroonga", 
+  #         5
+  #       ]
+  #     ]
+  #   ]
+  # ]

  Added: doc/source/example/reference/commands/select/drilldown_output_columns_referenced_type_column_definition.log (+25 -0) 100644
===================================================================
--- /dev/null
+++ doc/source/example/reference/commands/select/drilldown_output_columns_referenced_type_column_definition.log    2015-01-27 19:07:19 +0900 (5f50db8)
@@ -0,0 +1,25 @@
+Execution example::
+
+  table_create Tags TABLE_HASH_KEY ShortText --normalizer NormalizerAuto
+  # [[0, 1337566253.89858, 0.000355720520019531], true]
+  column_create Tags label COLUMN_SCALAR ShortText
+  # [[0, 1337566253.89858, 0.000355720520019531], true]
+  column_create Tags priority COLUMN_SCALAR Int32
+  # [[0, 1337566253.89858, 0.000355720520019531], true]
+  table_create Items TABLE_HASH_KEY ShortText
+  # [[0, 1337566253.89858, 0.000355720520019531], true]
+  column_create Items tag COLUMN_SCALAR Tags
+  # [[0, 1337566253.89858, 0.000355720520019531], true]
+  load --table Tags
+  [
+  {"_key": "groonga", label: "Groonga", priority: 10},
+  {"_key": "mroonga", label: "Mroonga", priority: 5}
+  ]
+  # [[0, 1337566253.89858, 0.000355720520019531], 2]
+  load --table Items
+  [
+  {"_key": "A", "tag": "groonga"},
+  {"_key": "B", "tag": "groonga"},
+  {"_key": "C", "tag": "mroonga"}
+  ]
+  # [[0, 1337566253.89858, 0.000355720520019531], 3]

  Added: doc/source/example/reference/commands/select/drilldown_output_columns_referenced_type_column_label.log (+58 -0) 100644
===================================================================
--- /dev/null
+++ doc/source/example/reference/commands/select/drilldown_output_columns_referenced_type_column_label.log    2015-01-27 19:07:19 +0900 (c598286)
@@ -0,0 +1,58 @@
+Execution example::
+
+  select Items \
+    --limit 0 \
+    --output_column _id \
+    --drilldown tag \
+    --drilldown_output_columns '_key, label'
+  # [
+  #   [
+  #     0, 
+  #     1337566253.89858, 
+  #     0.000355720520019531
+  #   ], 
+  #   [
+  #     [
+  #       [
+  #         3
+  #       ], 
+  #       [
+  #         [
+  #           "_id", 
+  #           "UInt32"
+  #         ], 
+  #         [
+  #           "_key", 
+  #           "ShortText"
+  #         ], 
+  #         [
+  #           "tag", 
+  #           "Tags"
+  #         ]
+  #       ]
+  #     ], 
+  #     [
+  #       [
+  #         2
+  #       ], 
+  #       [
+  #         [
+  #           "_key", 
+  #           "ShortText"
+  #         ], 
+  #         [
+  #           "label", 
+  #           "ShortText"
+  #         ]
+  #       ], 
+  #       [
+  #         "groonga", 
+  #         "Groonga"
+  #       ], 
+  #       [
+  #         "mroonga", 
+  #         "Mroonga"
+  #       ]
+  #     ]
+  #   ]
+  # ]

  Added: doc/source/example/reference/commands/select/drilldown_output_columns_simple.log (+63 -0) 100644
===================================================================
--- /dev/null
+++ doc/source/example/reference/commands/select/drilldown_output_columns_simple.log    2015-01-27 19:07:19 +0900 (7022a7d)
@@ -0,0 +1,63 @@
+Execution example::
+
+  select Entries \
+    --limit 0 \
+    --output_column _id \
+    --drilldown tag \
+    --drilldown_output_columns _key
+  # [
+  #   [
+  #     0, 
+  #     1337566253.89858, 
+  #     0.000355720520019531
+  #   ], 
+  #   [
+  #     [
+  #       [
+  #         5
+  #       ], 
+  #       [
+  #         [
+  #           "_id", 
+  #           "UInt32"
+  #         ], 
+  #         [
+  #           "_key", 
+  #           "ShortText"
+  #         ], 
+  #         [
+  #           "content", 
+  #           "Text"
+  #         ], 
+  #         [
+  #           "n_likes", 
+  #           "UInt32"
+  #         ], 
+  #         [
+  #           "tag", 
+  #           "ShortText"
+  #         ]
+  #       ]
+  #     ], 
+  #     [
+  #       [
+  #         3
+  #       ], 
+  #       [
+  #         [
+  #           "_key", 
+  #           "ShortText"
+  #         ]
+  #       ], 
+  #       [
+  #         "Hello"
+  #       ], 
+  #       [
+  #         "Groonga"
+  #       ], 
+  #       [
+  #         "Senna"
+  #       ]
+  #     ]
+  #   ]
+  # ]

  Added: doc/source/example/reference/commands/select/drilldown_simple.log (+76 -0) 100644
===================================================================
--- /dev/null
+++ doc/source/example/reference/commands/select/drilldown_simple.log    2015-01-27 19:07:19 +0900 (bfd268e)
@@ -0,0 +1,76 @@
+Execution example::
+
+  select Entries \
+    --output_columns _key,tag \
+    --drilldown tag
+  # [
+  #   [
+  #     0, 
+  #     1337566253.89858, 
+  #     0.000355720520019531
+  #   ], 
+  #   [
+  #     [
+  #       [
+  #         5
+  #       ], 
+  #       [
+  #         [
+  #           "_key", 
+  #           "ShortText"
+  #         ], 
+  #         [
+  #           "tag", 
+  #           "ShortText"
+  #         ]
+  #       ], 
+  #       [
+  #         "The first post!", 
+  #         "Hello"
+  #       ], 
+  #       [
+  #         "Groonga", 
+  #         "Groonga"
+  #       ], 
+  #       [
+  #         "Mroonga", 
+  #         "Groonga"
+  #       ], 
+  #       [
+  #         "Good-bye Senna", 
+  #         "Senna"
+  #       ], 
+  #       [
+  #         "Good-bye Tritonn", 
+  #         "Senna"
+  #       ]
+  #     ], 
+  #     [
+  #       [
+  #         3
+  #       ], 
+  #       [
+  #         [
+  #           "_key", 
+  #           "ShortText"
+  #         ], 
+  #         [
+  #           "_nsubrecs", 
+  #           "Int32"
+  #         ]
+  #       ], 
+  #       [
+  #         "Hello", 
+  #         1
+  #       ], 
+  #       [
+  #         "Groonga", 
+  #         2
+  #       ], 
+  #       [
+  #         "Senna", 
+  #         2
+  #       ]
+  #     ]
+  #   ]
+  # ]

  Added: doc/source/example/reference/commands/select/drilldown_sortby_simple.log (+101 -0) 100644
===================================================================
--- /dev/null
+++ doc/source/example/reference/commands/select/drilldown_sortby_simple.log    2015-01-27 19:07:19 +0900 (bd91417)
@@ -0,0 +1,101 @@
+Execution example::
+
+  select Entries \
+    --limit 0 \
+    --output_column _id \
+    --drilldown 'tag, n_likes' \
+    --drilldown_sortby '-_nsubrecs, _key'
+  # [
+  #   [
+  #     0, 
+  #     1337566253.89858, 
+  #     0.000355720520019531
+  #   ], 
+  #   [
+  #     [
+  #       [
+  #         5
+  #       ], 
+  #       [
+  #         [
+  #           "_id", 
+  #           "UInt32"
+  #         ], 
+  #         [
+  #           "_key", 
+  #           "ShortText"
+  #         ], 
+  #         [
+  #           "content", 
+  #           "Text"
+  #         ], 
+  #         [
+  #           "n_likes", 
+  #           "UInt32"
+  #         ], 
+  #         [
+  #           "tag", 
+  #           "ShortText"
+  #         ]
+  #       ]
+  #     ], 
+  #     [
+  #       [
+  #         3
+  #       ], 
+  #       [
+  #         [
+  #           "_key", 
+  #           "ShortText"
+  #         ], 
+  #         [
+  #           "_nsubrecs", 
+  #           "Int32"
+  #         ]
+  #       ], 
+  #       [
+  #         "Groonga", 
+  #         2
+  #       ], 
+  #       [
+  #         "Senna", 
+  #         2
+  #       ], 
+  #       [
+  #         "Hello", 
+  #         1
+  #       ]
+  #     ], 
+  #     [
+  #       [
+  #         4
+  #       ], 
+  #       [
+  #         [
+  #           "_key", 
+  #           "UInt32"
+  #         ], 
+  #         [
+  #           "_nsubrecs", 
+  #           "Int32"
+  #         ]
+  #       ], 
+  #       [
+  #         3, 
+  #         2
+  #       ], 
+  #       [
+  #         5, 
+  #         1
+  #       ], 
+  #       [
+  #         10, 
+  #         1
+  #       ], 
+  #       [
+  #         15, 
+  #         1
+  #       ]
+  #     ]
+  #   ]
+  # ]

  Added: doc/source/example/reference/commands/select/usage_drilldown.log (+72 -0) 100644
===================================================================
--- /dev/null
+++ doc/source/example/reference/commands/select/usage_drilldown.log    2015-01-27 19:07:19 +0900 (746a61d)
@@ -0,0 +1,72 @@
+Execution example::
+
+  select Entries --filter 'content @ "fast"' --drilldown tag
+  # [
+  #   [
+  #     0, 
+  #     1337566253.89858, 
+  #     0.000355720520019531
+  #   ], 
+  #   [
+  #     [
+  #       [
+  #         2
+  #       ], 
+  #       [
+  #         [
+  #           "_id", 
+  #           "UInt32"
+  #         ], 
+  #         [
+  #           "_key", 
+  #           "ShortText"
+  #         ], 
+  #         [
+  #           "content", 
+  #           "Text"
+  #         ], 
+  #         [
+  #           "n_likes", 
+  #           "UInt32"
+  #         ], 
+  #         [
+  #           "tag", 
+  #           "ShortText"
+  #         ]
+  #       ], 
+  #       [
+  #         2, 
+  #         "Groonga", 
+  #         "I started to use Groonga. It's very fast!", 
+  #         10, 
+  #         "Groonga"
+  #       ], 
+  #       [
+  #         3, 
+  #         "Mroonga", 
+  #         "I also started to use Mroonga. It's also very fast! Really fast!", 
+  #         15, 
+  #         "Groonga"
+  #       ]
+  #     ], 
+  #     [
+  #       [
+  #         1
+  #       ], 
+  #       [
+  #         [
+  #           "_key", 
+  #           "ShortText"
+  #         ], 
+  #         [
+  #           "_nsubrecs", 
+  #           "Int32"
+  #         ]
+  #       ], 
+  #       [
+  #         "Groonga", 
+  #         2
+  #       ]
+  #     ]
+  #   ]
+  # ]

  Added: doc/source/example/reference/commands/select/usage_drilldown_only_query.log (+53 -0) 100644
===================================================================
--- /dev/null
+++ doc/source/example/reference/commands/select/usage_drilldown_only_query.log    2015-01-27 19:07:19 +0900 (d25a881)
@@ -0,0 +1,53 @@
+Execution example::
+
+  select Entries --filter 'content @ "fast"'
+  # [
+  #   [
+  #     0, 
+  #     1337566253.89858, 
+  #     0.000355720520019531
+  #   ], 
+  #   [
+  #     [
+  #       [
+  #         2
+  #       ], 
+  #       [
+  #         [
+  #           "_id", 
+  #           "UInt32"
+  #         ], 
+  #         [
+  #           "_key", 
+  #           "ShortText"
+  #         ], 
+  #         [
+  #           "content", 
+  #           "Text"
+  #         ], 
+  #         [
+  #           "n_likes", 
+  #           "UInt32"
+  #         ], 
+  #         [
+  #           "tag", 
+  #           "ShortText"
+  #         ]
+  #       ], 
+  #       [
+  #         2, 
+  #         "Groonga", 
+  #         "I started to use Groonga. It's very fast!", 
+  #         10, 
+  #         "Groonga"
+  #       ], 
+  #       [
+  #         3, 
+  #         "Mroonga", 
+  #         "I also started to use Mroonga. It's also very fast! Really fast!", 
+  #         15, 
+  #         "Groonga"
+  #       ]
+  #     ]
+  #   ]
+  # ]
-------------- next part --------------
HTML����������������������������...
Download 



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