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
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
|
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 tag COLUMN_SCALAR Tags
[[0,0.0,0.0],true]
load --table Memos
[
{"_key": "Groonga is fast!", "tag": "Groonga"},
{"_key": "Mroonga is fast!", "tag": "Mroonga"},
{"_key": "Groonga sticker!", "tag": "Groonga"},
{"_key": "Rroonga is fast!", "tag": "Rroonga"}
]
[[0,0.0,0.0],4]
log_level --level debug
[[0,0.0,0.0],true]
select Memos --slices[no_rroonga].filter '_id < 4' --slices[no_rroonga].drilldowns[tag].keys tag
[
[
0,
0.0,
0.0
],
[
[
[
4
],
[
[
"_id",
"UInt32"
],
[
"_key",
"ShortText"
],
[
"tag",
"Tags"
]
],
[
1,
"Groonga is fast!",
"Groonga"
],
[
2,
"Mroonga is fast!",
"Mroonga"
],
[
3,
"Groonga sticker!",
"Groonga"
],
[
4,
"Rroonga is fast!",
"Rroonga"
]
],
{
"no_rroonga": [
[
3
],
[
[
"_id",
"UInt32"
],
[
"_key",
"ShortText"
],
[
"tag",
"Tags"
]
],
[
1,
"Groonga is fast!",
"Groonga"
],
[
2,
"Mroonga is fast!",
"Mroonga"
],
[
3,
"Groonga sticker!",
"Groonga"
],
{
"tag": [
[
2
],
[
[
"_key",
"ShortText"
],
[
"_nsubrecs",
"Int32"
]
],
[
"Groonga",
2
],
[
"Mroonga",
1
]
]
}
]
}
]
]
#>select --slices[no_rroonga].drilldowns[tag].keys "tag" --slices[no_rroonga].filter "_id < 4" --table "Memos"
#:000000000000000 select(4)
#:000000000000000 slices[no_rroonga].filter(3): #<accessor _id(Memos)> less 4
#:000000000000000 slices[no_rroonga](3)
#:000000000000000 slices[no_rroonga].drilldowns[tag](2): tag
#:000000000000000 output(4)
#:000000000000000 slices[no_rroonga].output.drilldowns[tag](2)
#:000000000000000 slices[no_rroonga].output(3)
#:000000000000000 send(0)
#<000000000000000 rc=0
log_level --level notice
[[0,0.0,0.0],true]
|
