1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
|
plugin_register functions/time
table_create Tags TABLE_PAT_KEY ShortText
table_create Memos TABLE_HASH_KEY ShortText
column_create Memos date COLUMN_SCALAR Time
column_create Memos tag COLUMN_SCALAR Tags
load --table Memos
[
{"_key": "Groonga is fast!", "date": "2016-05-19 12:00:00", "tag": "Groonga"},
{"_key": "Mroonga is fast!", "date": "2016-05-19 12:00:01", "tag": "Mroonga"},
{"_key": "Groonga sticker!", "date": "2016-05-20 12:00:02", "tag": "Groonga"},
{"_key": "Rroonga is fast!", "date": "2016-05-21 12:00:03", "tag": "Rroonga"}
]
select Memos \
--slices[groonga].filter 'tag == "Groonga"' \
--slices[groonga].sort_keys 'date' \
--slices[groonga].output_columns '_key, date' \
--slices[groonga].columns[date_day].stage filtered \
--slices[groonga].columns[date_day].type Time \
--slices[groonga].columns[date_day].value 'time_classify_day(date)' \
--slices[groonga].drilldowns[day].keys 'date_day' \
--command_version 3
|
