1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
|
table_create Users TABLE_PAT_KEY ShortText
[[0,0.0,0.0],true]
column_create Users age COLUMN_SCALAR UInt8
[[0,0.0,0.0],true]
table_create Logs TABLE_NO_KEY
[[0,0.0,0.0],true]
column_create Logs users COLUMN_VECTOR Users
[[0,0.0,0.0],true]
load --table Users
[
{"_key": "alice", "age": 12},
{"_key": "bob", "age": 29},
{"_key": "chris", "age": 3}
]
[[0,0.0,0.0],3]
load --table Logs
[
{"users": ["bob", "chris", "alice"]}
]
[[0,0.0,0.0],1]
select Logs --output_columns '_id, min(users.age)'
[[0,0.0,0.0],[[[1],[["_id","UInt32"],["min",null]],[1,3]]]]
|
