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
|
table_create Purchases TABLE_HASH_KEY ShortText
[[0,0.0,0.0],true]
column_create Purchases item COLUMN_SCALAR ShortText
[[0,0.0,0.0],true]
column_create Purchases price COLUMN_SCALAR UInt32
[[0,0.0,0.0],true]
table_create Settlements TABLE_HASH_KEY ShortText
[[0,0.0,0.0],true]
column_create Settlements purchases COLUMN_VECTOR Purchases
[[0,0.0,0.0],true]
column_create Purchases settlements_purchases COLUMN_INDEX Settlements purchases
[[0,0.0,0.0],true]
load --table Settlements
[
{
"_key": "super market",
"purchases": [
{"_key": "super market-1", "item": "apple", "price": 100},
{"_key": "super market-2", "item": "milk", "price": 200}
]
},
{
"_key": "shoes shop",
"purchases": [
{"_key": "shoes shop-1", "item": "sneakers", "price": 3000}
]
}
]
[[0,0.0,0.0],2]
dump --dump_plugins no --dump_schema no
load --table Purchases
[
["_key","item","price"],
["super market-1","apple",100],
["super market-2","milk",200],
["shoes shop-1","sneakers",3000]
]
load --table Settlements
[
["_key","purchases"],
["super market",["super market-1","super market-2"]],
["shoes shop",["shoes shop-1"]]
]
column_create Purchases settlements_purchases COLUMN_INDEX Settlements purchases
|
