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
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
|
plugin_register functions/time
[[0,0.0,0.0],true]
table_create Tags TABLE_PAT_KEY ShortText
[[0,0.0,0.0],true]
table_create Memos TABLE_HASH_KEY ShortText
[[0,0.0,0.0],true]
column_create Memos date COLUMN_SCALAR Time
[[0,0.0,0.0],true]
column_create Memos tag COLUMN_SCALAR Tags
[[0,0.0,0.0],true]
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"}
]
[[0,0.0,0.0],4]
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
{
"header": {
"return_code": 0,
"start_time": 0.0,
"elapsed_time": 0.0
},
"body": {
"n_hits": 4,
"columns": [
{
"name": "_id",
"type": "UInt32"
},
{
"name": "_key",
"type": "ShortText"
},
{
"name": "date",
"type": "Time"
},
{
"name": "tag",
"type": "Tags"
}
],
"records": [
[
1,
"Groonga is fast!",
1463626800.0,
"Groonga"
],
[
2,
"Mroonga is fast!",
1463626801.0,
"Mroonga"
],
[
3,
"Groonga sticker!",
1463713202.0,
"Groonga"
],
[
4,
"Rroonga is fast!",
1463799603.0,
"Rroonga"
]
],
"slices": {
"groonga": {
"n_hits": 2,
"columns": [
{
"name": "_key",
"type": "ShortText"
},
{
"name": "date",
"type": "Time"
}
],
"records": [
[
"Groonga is fast!",
1463626800.0
],
[
"Groonga sticker!",
1463713202.0
]
],
"drilldowns": {
"day": {
"n_hits": 2,
"columns": [
{
"name": "_key",
"type": "Time"
},
{
"name": "_nsubrecs",
"type": "Int32"
}
],
"records": [
[
1463583600.0,
1
],
[
1463670000.0,
1
]
]
}
}
}
}
}
}
|
