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
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
|
table_create Memos TABLE_HASH_KEY ShortText
[[0,0.0,0.0],true]
column_create Memos timestamp COLUMN_SCALAR Time
[[0,0.0,0.0],true]
table_create Times TABLE_PAT_KEY Time
[[0,0.0,0.0],true]
column_create Times memos_timestamp COLUMN_INDEX Memos timestamp
[[0,0.0,0.0],true]
load --table Memos
[
{"_key": "001", "timestamp": "2014-11-10 07:25:23"},
{"_key": "002", "timestamp": "2014-11-10 07:25:24"},
{"_key": "003", "timestamp": "2014-11-10 07:25:25"},
{"_key": "004", "timestamp": "2014-11-10 07:25:26"},
{"_key": "005", "timestamp": "2014-11-10 07:25:27"},
{"_key": "006", "timestamp": "2014-11-10 07:25:28"},
{"_key": "007", "timestamp": "2014-11-10 07:25:29"},
{"_key": "008", "timestamp": "2014-11-10 07:25:30"},
{"_key": "009", "timestamp": "2014-11-10 07:25:31"},
{"_key": "010", "timestamp": "2014-11-10 07:25:32"},
{"_key": "011", "timestamp": "2014-11-10 07:25:33"},
{"_key": "012", "timestamp": "2014-11-10 07:25:34"},
{"_key": "013", "timestamp": "2014-11-10 07:25:35"},
{"_key": "014", "timestamp": "2014-11-10 07:25:36"},
{"_key": "015", "timestamp": "2014-11-10 07:25:37"},
{"_key": "016", "timestamp": "2014-11-10 07:25:38"},
{"_key": "017", "timestamp": "2014-11-10 07:25:39"},
{"_key": "018", "timestamp": "2014-11-10 07:25:40"},
{"_key": "019", "timestamp": "2014-11-10 07:25:41"},
{"_key": "020", "timestamp": "2014-11-10 07:25:42"},
{"_key": "021", "timestamp": "2014-11-10 07:25:43"},
{"_key": "022", "timestamp": "2014-11-10 07:25:44"},
{"_key": "023", "timestamp": "2014-11-10 07:25:45"},
{"_key": "024", "timestamp": "2014-11-10 07:25:46"},
{"_key": "025", "timestamp": "2014-11-10 07:25:47"},
{"_key": "026", "timestamp": "2014-11-10 07:25:48"},
{"_key": "027", "timestamp": "2014-11-10 07:25:49"},
{"_key": "028", "timestamp": "2014-11-10 07:25:50"},
{"_key": "029", "timestamp": "2014-11-10 07:25:51"},
{"_key": "030", "timestamp": "2014-11-10 07:25:52"},
{"_key": "031", "timestamp": "2014-11-10 07:25:53"},
{"_key": "032", "timestamp": "2014-11-10 07:25:54"},
{"_key": "033", "timestamp": "2014-11-10 07:25:55"},
{"_key": "034", "timestamp": "2014-11-10 07:25:56"},
{"_key": "035", "timestamp": "2014-11-10 07:25:57"},
{"_key": "036", "timestamp": "2014-11-10 07:25:58"},
{"_key": "037", "timestamp": "2014-11-10 07:25:59"},
{"_key": "038", "timestamp": "2014-11-10 07:26:00"},
{"_key": "039", "timestamp": "2014-11-10 07:26:01"},
{"_key": "040", "timestamp": "2014-11-10 07:26:02"},
{"_key": "041", "timestamp": "2014-11-10 07:26:03"},
{"_key": "042", "timestamp": "2014-11-10 07:26:04"},
{"_key": "043", "timestamp": "2014-11-10 07:26:05"},
{"_key": "044", "timestamp": "2014-11-10 07:26:06"},
{"_key": "045", "timestamp": "2014-11-10 07:26:07"},
{"_key": "046", "timestamp": "2014-11-10 07:26:08"},
{"_key": "047", "timestamp": "2014-11-10 07:26:09"},
{"_key": "048", "timestamp": "2014-11-10 07:26:10"},
{"_key": "049", "timestamp": "2014-11-10 07:26:11"},
{"_key": "050", "timestamp": "2014-11-10 07:26:12"},
{"_key": "051", "timestamp": "2014-11-10 07:26:13"},
{"_key": "052", "timestamp": "2014-11-10 07:26:14"},
{"_key": "053", "timestamp": "2014-11-10 07:26:15"},
{"_key": "054", "timestamp": "2014-11-10 07:26:16"},
{"_key": "055", "timestamp": "2014-11-10 07:26:17"},
{"_key": "056", "timestamp": "2014-11-10 07:26:18"},
{"_key": "057", "timestamp": "2014-11-10 07:26:19"},
{"_key": "058", "timestamp": "2014-11-10 07:26:20"},
{"_key": "059", "timestamp": "2014-11-10 07:26:21"},
{"_key": "060", "timestamp": "2014-11-10 07:26:22"},
{"_key": "061", "timestamp": "2014-11-10 07:26:23"},
{"_key": "062", "timestamp": "2014-11-10 07:26:24"},
{"_key": "063", "timestamp": "2014-11-10 07:26:25"},
{"_key": "064", "timestamp": "2014-11-10 07:26:26"},
{"_key": "065", "timestamp": "2014-11-10 07:26:27"},
{"_key": "066", "timestamp": "2014-11-10 07:26:28"},
{"_key": "067", "timestamp": "2014-11-10 07:26:29"},
{"_key": "068", "timestamp": "2014-11-10 07:26:30"},
{"_key": "069", "timestamp": "2014-11-10 07:26:31"},
{"_key": "070", "timestamp": "2014-11-10 07:26:32"},
{"_key": "071", "timestamp": "2014-11-10 07:26:33"},
{"_key": "072", "timestamp": "2014-11-10 07:26:34"},
{"_key": "073", "timestamp": "2014-11-10 07:26:35"},
{"_key": "074", "timestamp": "2014-11-10 07:26:36"},
{"_key": "075", "timestamp": "2014-11-10 07:26:37"},
{"_key": "076", "timestamp": "2014-11-10 07:26:38"},
{"_key": "077", "timestamp": "2014-11-10 07:26:39"},
{"_key": "078", "timestamp": "2014-11-10 07:26:40"},
{"_key": "079", "timestamp": "2014-11-10 07:26:41"},
{"_key": "080", "timestamp": "2014-11-10 07:26:42"},
{"_key": "081", "timestamp": "2014-11-10 07:26:43"},
{"_key": "082", "timestamp": "2014-11-10 07:26:44"},
{"_key": "083", "timestamp": "2014-11-10 07:26:45"},
{"_key": "084", "timestamp": "2014-11-10 07:26:46"},
{"_key": "085", "timestamp": "2014-11-10 07:26:47"},
{"_key": "086", "timestamp": "2014-11-10 07:26:48"},
{"_key": "087", "timestamp": "2014-11-10 07:26:49"},
{"_key": "088", "timestamp": "2014-11-10 07:26:50"},
{"_key": "089", "timestamp": "2014-11-10 07:26:51"},
{"_key": "090", "timestamp": "2014-11-10 07:26:52"},
{"_key": "091", "timestamp": "2014-11-10 07:26:53"},
{"_key": "092", "timestamp": "2014-11-10 07:26:54"},
{"_key": "093", "timestamp": "2014-11-10 07:26:55"},
{"_key": "094", "timestamp": "2014-11-10 07:26:56"},
{"_key": "095", "timestamp": "2014-11-10 07:26:57"},
{"_key": "096", "timestamp": "2014-11-10 07:26:58"},
{"_key": "097", "timestamp": "2014-11-10 07:26:59"},
{"_key": "098", "timestamp": "2014-11-10 07:27:00"},
{"_key": "099", "timestamp": "2014-11-10 07:27:01"},
{"_key": "100", "timestamp": "2014-11-10 07:27:02"},
{"_key": "101", "timestamp": "2014-11-10 07:27:03"},
{"_key": "102", "timestamp": "2014-11-10 07:27:04"},
{"_key": "103", "timestamp": "2014-11-10 07:27:05"},
{"_key": "104", "timestamp": "2014-11-10 07:27:06"},
{"_key": "105", "timestamp": "2014-11-10 07:27:07"},
{"_key": "106", "timestamp": "2014-11-10 07:27:08"},
{"_key": "107", "timestamp": "2014-11-10 07:27:09"},
{"_key": "108", "timestamp": "2014-11-10 07:27:10"},
{"_key": "109", "timestamp": "2014-11-10 07:27:11"},
{"_key": "110", "timestamp": "2014-11-10 07:27:12"},
{"_key": "111", "timestamp": "2014-11-10 07:27:13"},
{"_key": "112", "timestamp": "2014-11-10 07:27:14"},
{"_key": "113", "timestamp": "2014-11-10 07:27:15"},
{"_key": "114", "timestamp": "2014-11-10 07:27:16"},
{"_key": "115", "timestamp": "2014-11-10 07:27:17"},
{"_key": "116", "timestamp": "2014-11-10 07:27:18"},
{"_key": "117", "timestamp": "2014-11-10 07:27:19"},
{"_key": "118", "timestamp": "2014-11-10 07:27:20"},
{"_key": "119", "timestamp": "2014-11-10 07:27:21"},
{"_key": "120", "timestamp": "2014-11-10 07:27:22"},
{"_key": "121", "timestamp": "2014-11-10 07:27:23"},
{"_key": "122", "timestamp": "2014-11-10 07:27:24"},
{"_key": "123", "timestamp": "2014-11-10 07:27:25"},
{"_key": "124", "timestamp": "2014-11-10 07:27:26"},
{"_key": "125", "timestamp": "2014-11-10 07:27:27"},
{"_key": "126", "timestamp": "2014-11-10 07:27:28"},
{"_key": "127", "timestamp": "2014-11-10 07:27:29"},
{"_key": "128", "timestamp": "2014-11-10 07:27:30"},
{"_key": "129", "timestamp": "2014-11-10 07:27:31"},
{"_key": "130", "timestamp": "2014-11-10 07:27:32"},
{"_key": "131", "timestamp": "2014-11-10 07:27:33"},
{"_key": "132", "timestamp": "2014-11-10 07:27:34"},
{"_key": "133", "timestamp": "2014-11-10 07:27:35"},
{"_key": "134", "timestamp": "2014-11-10 07:27:36"},
{"_key": "135", "timestamp": "2014-11-10 07:27:37"},
{"_key": "136", "timestamp": "2014-11-10 07:27:38"},
{"_key": "137", "timestamp": "2014-11-10 07:27:39"},
{"_key": "138", "timestamp": "2014-11-10 07:27:40"},
{"_key": "139", "timestamp": "2014-11-10 07:27:41"},
{"_key": "140", "timestamp": "2014-11-10 07:27:42"},
{"_key": "141", "timestamp": "2014-11-10 07:27:43"},
{"_key": "142", "timestamp": "2014-11-10 07:27:44"},
{"_key": "143", "timestamp": "2014-11-10 07:27:45"},
{"_key": "144", "timestamp": "2014-11-10 07:27:46"},
{"_key": "145", "timestamp": "2014-11-10 07:27:47"},
{"_key": "146", "timestamp": "2014-11-10 07:27:48"},
{"_key": "147", "timestamp": "2014-11-10 07:27:49"},
{"_key": "148", "timestamp": "2014-11-10 07:27:50"},
{"_key": "149", "timestamp": "2014-11-10 07:27:51"},
{"_key": "150", "timestamp": "2014-11-10 07:27:52"},
{"_key": "151", "timestamp": "2014-11-10 07:27:53"},
{"_key": "152", "timestamp": "2014-11-10 07:27:54"},
{"_key": "153", "timestamp": "2014-11-10 07:27:55"},
{"_key": "154", "timestamp": "2014-11-10 07:27:56"},
{"_key": "155", "timestamp": "2014-11-10 07:27:57"},
{"_key": "156", "timestamp": "2014-11-10 07:27:58"},
{"_key": "157", "timestamp": "2014-11-10 07:27:59"},
{"_key": "158", "timestamp": "2014-11-10 07:28:00"},
{"_key": "159", "timestamp": "2014-11-10 07:28:01"},
{"_key": "160", "timestamp": "2014-11-10 07:28:02"},
{"_key": "161", "timestamp": "2014-11-10 07:28:03"},
{"_key": "162", "timestamp": "2014-11-10 07:28:04"},
{"_key": "163", "timestamp": "2014-11-10 07:28:05"},
{"_key": "164", "timestamp": "2014-11-10 07:28:06"},
{"_key": "165", "timestamp": "2014-11-10 07:28:07"},
{"_key": "166", "timestamp": "2014-11-10 07:28:08"},
{"_key": "167", "timestamp": "2014-11-10 07:28:09"},
{"_key": "168", "timestamp": "2014-11-10 07:28:10"},
{"_key": "169", "timestamp": "2014-11-10 07:28:11"},
{"_key": "170", "timestamp": "2014-11-10 07:28:12"},
{"_key": "171", "timestamp": "2014-11-10 07:28:13"},
{"_key": "172", "timestamp": "2014-11-10 07:28:14"},
{"_key": "173", "timestamp": "2014-11-10 07:28:15"},
{"_key": "174", "timestamp": "2014-11-10 07:28:16"},
{"_key": "175", "timestamp": "2014-11-10 07:28:17"},
{"_key": "176", "timestamp": "2014-11-10 07:28:18"},
{"_key": "177", "timestamp": "2014-11-10 07:28:19"},
{"_key": "178", "timestamp": "2014-11-10 07:28:20"},
{"_key": "179", "timestamp": "2014-11-10 07:28:21"},
{"_key": "180", "timestamp": "2014-11-10 07:28:22"},
{"_key": "181", "timestamp": "2014-11-10 07:28:23"},
{"_key": "182", "timestamp": "2014-11-10 07:28:24"},
{"_key": "183", "timestamp": "2014-11-10 07:28:25"},
{"_key": "184", "timestamp": "2014-11-10 07:28:26"},
{"_key": "185", "timestamp": "2014-11-10 07:28:27"},
{"_key": "186", "timestamp": "2014-11-10 07:28:28"},
{"_key": "187", "timestamp": "2014-11-10 07:28:29"},
{"_key": "188", "timestamp": "2014-11-10 07:28:30"},
{"_key": "189", "timestamp": "2014-11-10 07:28:31"},
{"_key": "190", "timestamp": "2014-11-10 07:28:32"},
{"_key": "191", "timestamp": "2014-11-10 07:28:33"},
{"_key": "192", "timestamp": "2014-11-10 07:28:34"},
{"_key": "193", "timestamp": "2014-11-10 07:28:35"},
{"_key": "194", "timestamp": "2014-11-10 07:28:36"},
{"_key": "195", "timestamp": "2014-11-10 07:28:37"},
{"_key": "196", "timestamp": "2014-11-10 07:28:38"},
{"_key": "197", "timestamp": "2014-11-10 07:28:39"},
{"_key": "198", "timestamp": "2014-11-10 07:28:40"},
{"_key": "199", "timestamp": "2014-11-10 07:28:41"},
{"_key": "200", "timestamp": "2014-11-10 07:28:42"}
]
[[0,0.0,0.0],200]
log_level --level info
[[0,0.0,0.0],true]
select Memos --filter '_key == "003" && between(timestamp, "2014-11-10 07:25:24", "include", "2014-11-10 07:27:26", "exclude")'
[
[
0,
0.0,
0.0
],
[
[
[
1
],
[
[
"_id",
"UInt32"
],
[
"_key",
"ShortText"
],
[
"timestamp",
"Time"
]
],
[
3,
"003",
1415571925.0
]
]
]
]
#|i| [object][search][index][table][equal] <Memos>
#|i| [table-selector][select][index][selector][between] <Times.memos_timestamp>
#|i| [between][index-not-used] <Times.memos_timestamp>: too many index match: 1 < 1.220000 (122 * 0.010000)
#>select --filter "_key == \"003\" && between(timestamp, \"2014-11-10 07:25:24\", \"include\", \"2014-11-10 07:27:26\", \"exclude\")" --table "Memos"
#:000000000000000 filter(1): #<accessor _key(Memos)> equal "003"
#:000000000000000 filter(1): between(Memos.timestamp, "2014-11-10 07:25:24", "include", "2014-11-10 07:27:26", "exclude")
#:000000000000000 select(1)
#:000000000000000 output(1)
#:000000000000000 send(0)
#<000000000000000 rc=0
log_level --level notice
[[0,0.0,0.0],true]
|
