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
|
Execution example::
table_create Logs_20150203 TABLE_HASH_KEY ShortText
# [[0,1337566253.89858,0.000355720520019531],true]
column_create Logs_20150203 timestamp COLUMN_SCALAR Time
# [[0,1337566253.89858,0.000355720520019531],true]
table_create Logs_20150204 TABLE_HASH_KEY ShortText
# [[0,1337566253.89858,0.000355720520019531],true]
column_create Logs_20150204 timestamp COLUMN_SCALAR Time
# [[0,1337566253.89858,0.000355720520019531],true]
table_create Logs TABLE_HASH_KEY ShortText
# [[0,1337566253.89858,0.000355720520019531],true]
column_create Logs original_id COLUMN_SCALAR UInt32
# [[0,1337566253.89858,0.000355720520019531],true]
column_create Logs timestamp_text COLUMN_SCALAR ShortText
# [[0,1337566253.89858,0.000355720520019531],true]
load --table Logs_20150203
[
{
"_key": "2015-02-03:1",
"timestamp": "2015-02-03 10:49:00"
},
{
"_key": "2015-02-03:2",
"timestamp": "2015-02-03 12:49:00"
}
]
# [[0,1337566253.89858,0.000355720520019531],2]
load --table Logs_20150204
[
{
"_key": "2015-02-04:1",
"timestamp": "2015-02-04 00:00:00"
}
]
# [[0,1337566253.89858,0.000355720520019531],1]
logical_select \
--logical_table Logs \
--shard_key timestamp \
--load_table Logs \
--load_columns "_key, original_id, timestamp_text" \
--load_values "_key, _id, timestamp"
# [
# [
# 0,
# 1337566253.89858,
# 0.000355720520019531
# ],
# [
# [
# [
# 3
# ],
# [
# [
# "_id",
# "UInt32"
# ],
# [
# "_key",
# "ShortText"
# ],
# [
# "timestamp",
# "Time"
# ]
# ],
# [
# 1,
# "2015-02-03:1",
# 1422928140.0
# ],
# [
# 2,
# "2015-02-03:2",
# 1422935340.0
# ],
# [
# 1,
# "2015-02-04:1",
# 1422975600.0
# ]
# ]
# ]
# ]
select --table Logs
# [
# [
# 0,
# 1337566253.89858,
# 0.000355720520019531
# ],
# [
# [
# [
# 3
# ],
# [
# [
# "_id",
# "UInt32"
# ],
# [
# "_key",
# "ShortText"
# ],
# [
# "original_id",
# "UInt32"
# ],
# [
# "timestamp_text",
# "ShortText"
# ]
# ],
# [
# 1,
# "2015-02-03:1",
# 1,
# "1422928140000000"
# ],
# [
# 2,
# "2015-02-03:2",
# 2,
# "1422935340000000"
# ],
# [
# 3,
# "2015-02-04:1",
# 1,
# "1422975600000000"
# ]
# ]
# ]
# ]
|
