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
|
table_create Values TABLE_NO_KEY
[[0,0.0,0.0],true]
column_create Values time_value COLUMN_SCALAR Time
[[0,0.0,0.0],true]
column_create Values output COLUMN_SCALAR Time
[[0,0.0,0.0],true]
load --table Values
[
{"time_value":-1348322135.12666}
]
[[0,0.0,0.0],1]
select Values --filter true --output_columns '_id,output' --scorer 'output = min(-29, time_value, 29.29)'
[
[
0,
0.0,
0.0
],
[
[
[
1
],
[
[
"_id",
"UInt32"
],
[
"output",
"Time"
]
],
[
1,
-1348322135.12666
]
]
]
]
|