Java 类名:com.alibaba.alink.operator.stream.outlier.HbosOutlier4GroupedDataStreamOp
Python 类名:HbosOutlier4GroupedDataStreamOp
功能介绍
Histogram-based Outlier Score 使用直方图统计结果,描述异常值,算法较为简单,上手方便。
文献或出处
- HBOS
参数说明
| 名称 | 中文名称 | 描述 | 类型 | 是否必须? | 取值范围 | 默认值 | | —- | —- | —- | —- | —- | —- | —- |
| inputMTableCol | Not available! | Not available! | String | ✓ | | |
| outputMTableCol | Not available! | Not available! | String | ✓ | | |
| predictionCol | 预测结果列名 | 预测结果列名 | String | ✓ | | |
| featureCols | 特征列名数组 | 特征列名数组,默认全选 | String[] | | 所选列类型为 [BIGDECIMAL, BIGINTEGER, BYTE, DOUBLE, FLOAT, INTEGER, LONG, SHORT] | null |
| k | Not available! | Not available! | Integer | | [1, +inf) | 10 |
| maxOutlierNumPerGroup | 每组最大异常点数目 | 每组最大异常点数目 | Integer | | | |
| maxOutlierRatio | 最大异常点比例 | 算法检测异常点的最大比例 | Double | | | |
| outlierThreshold | 异常评分阈值 | 只有评分大于该阈值才会被认为是异常点 | Double | | | |
| predictionDetailCol | 预测详细信息列名 | 预测详细信息列名 | String | | | |
| tensorCol | tensor列 | tensor列 | String | | 所选列类型为 [BOOL_TENSOR, BYTE_TENSOR, DOUBLE_TENSOR, FLOAT_TENSOR, INT_TENSOR, LONG_TENSOR, STRING, STRING_TENSOR, TENSOR, UBYTE_TENSOR] | null |
| vectorCol | 向量列名 | 向量列对应的列名,默认值是null | String | | 所选列类型为 [DENSE_VECTOR, SPARSE_VECTOR, STRING, VECTOR] | null |
| numThreads | 组件多线程线程个数 | 组件多线程线程个数 | Integer | | | 1 |
代码示例
Python 代码
import time
import datetime
import numpy as np
import pandas as pd
data = pd.DataFrame([
[1, datetime.datetime.fromtimestamp(1), 10.0, 0],
[1, datetime.datetime.fromtimestamp(2), 11.0, 0],
[1, datetime.datetime.fromtimestamp(3), 12.0, 0],
[1, datetime.datetime.fromtimestamp(4), 13.0, 0],
[1, datetime.datetime.fromtimestamp(5), 14.0, 0],
[1, datetime.datetime.fromtimestamp(6), 15.0, 0],
[1, datetime.datetime.fromtimestamp(7), 16.0, 0],
[1, datetime.datetime.fromtimestamp(8), 17.0, 0],
[1, datetime.datetime.fromtimestamp(9), 18.0, 0],
[1, datetime.datetime.fromtimestamp(10), 19.0, 0]
])
dataOp = dataframeToOperator(
data, schemaStr='id int, ts timestamp, val double, label int', op_type='stream')
dataOp.link(
OverCountWindowStreamOp()
.setGroupCols(["id"])
.setTimeCol("ts")
.setPrecedingRows(5)
.setClause("MTABLE_AGG_PRECEDING(ts, val) as series_data")
.setReservedCols(["id", "label"])
).link(
HbosOutlier4GroupedDataStreamOp()
.setInputMTableCol("series_data")
.setFeatureCols(["val"])
.setOutputMTableCol("output_series")
.setPredictionCol("pred")
).link(
FlattenMTableStreamOp()
.setSelectedCol("output_series")
.setSchemaStr("ts TIMESTAMP, val DOUBLE, pred BOOLEAN")
).print()
StreamOperator.execute()
Java 代码
import org.apache.flink.types.Row;
import com.alibaba.alink.operator.stream.StreamOperator;
import com.alibaba.alink.operator.stream.dataproc.FlattenMTableStreamOp;
import com.alibaba.alink.operator.stream.feature.OverCountWindowStreamOp;
import com.alibaba.alink.operator.stream.outlier.HbosOutlier4GroupedDataStreamOp;
import com.alibaba.alink.operator.stream.source.MemSourceStreamOp;
import org.junit.Test;
import java.sql.Timestamp;
import java.util.Arrays;
import java.util.List;
public class HbosOutlier4GroupedDataStreamOpTest {
@Test
public void test() throws Exception {
List <Row> mTableData = Arrays.asList(
Row.of(1, new Timestamp(1), 10.0, 0),
Row.of(1, new Timestamp(2), 11.0, 0),
Row.of(1, new Timestamp(3), 12.0, 0),
Row.of(1, new Timestamp(4), 13.0, 0),
Row.of(1, new Timestamp(5), 14.0, 0),
Row.of(1, new Timestamp(6), 15.0, 0),
Row.of(1, new Timestamp(7), 16.0, 0),
Row.of(1, new Timestamp(8), 17.0, 0),
Row.of(1, new Timestamp(9), 18.0, 0),
Row.of(1, new Timestamp(10), 19.0, 0)
);
MemSourceStreamOp dataOp = new MemSourceStreamOp(mTableData,
new String[] {"id", "ts", "val", "label"});
dataOp.link(
new OverCountWindowStreamOp()
.setGroupCols("id")
.setTimeCol("ts")
.setPrecedingRows(5)
.setClause("MTABLE_AGG_PRECEDING(ts, val) as series_data")
.setReservedCols("id", "label")
).link(
new HbosOutlier4GroupedDataStreamOp()
.setInputMTableCol("series_data")
.setFeatureCols("val")
.setOutputMTableCol("output_series")
.setPredictionCol("pred")
).link(
new FlattenMTableStreamOp()
.setSelectedCol("output_series")
.setSchemaStr("ts TIMESTAMP, val DOUBLE, pred BOOLEAN")
).print();
StreamOperator.execute();
}
}
运行结果
| id | label | series_data | output_series | ts | val | pred | | —- | —- | —- | —- | —- | —- | —- |
| 1 | 0 | MTable(1,2)(ts,val) | MTable(1,3)(ts,val,pred) | 1970-01-01 08:00:00.001 | 10.0000 | false |
| 1970-01-01 08:00:00.001 | 10.0000 | 1970-01-01 08:00:00.001 | 10.0000 | false | | |
| 1 | 0 | MTable(2,2)(ts,val) | MTable(2,3)(ts,val,pred) | 1970-01-01 08:00:00.001 | 10.0000 | false |
| 1970-01-01 08:00:00.001 | 10.0000 | 1970-01-01 08:00:00.001 | 10.0000 | false | | |
| 1970-01-01 08:00:00.002 | 11.0000 | 1970-01-01 08:00:00.002 | 11.0000 | false | | |
| 1 | 0 | MTable(2,2)(ts,val) | MTable(2,3)(ts,val,pred) | 1970-01-01 08:00:00.002 | 11.0000 | false |
| 1970-01-01 08:00:00.001 | 10.0000 | 1970-01-01 08:00:00.001 | 10.0000 | false | | |
| 1970-01-01 08:00:00.002 | 11.0000 | 1970-01-01 08:00:00.002 | 11.0000 | false | | |
| 1 | 0 | MTable(3,2)(ts,val) | MTable(3,3)(ts,val,pred) | 1970-01-01 08:00:00.001 | 10.0000 | false |
| 1970-01-01 08:00:00.001 | 10.0000 | 1970-01-01 08:00:00.001 | 10.0000 | false | | |
| 1970-01-01 08:00:00.002 | 11.0000 | 1970-01-01 08:00:00.002 | 11.0000 | false | | |
| 1970-01-01 08:00:00.003 | 12.0000 | 1970-01-01 08:00:00.003 | 12.0000 | false | | |
| 1 | 0 | MTable(3,2)(ts,val) | MTable(3,3)(ts,val,pred) | 1970-01-01 08:00:00.002 | 11.0000 | false |
| 1970-01-01 08:00:00.001 | 10.0000 | 1970-01-01 08:00:00.001 | 10.0000 | false | | |
| 1970-01-01 08:00:00.002 | 11.0000 | 1970-01-01 08:00:00.002 | 11.0000 | false | | |
| 1970-01-01 08:00:00.003 | 12.0000 | 1970-01-01 08:00:00.003 | 12.0000 | false | | |
| 1 | 0 | MTable(3,2)(ts,val) | MTable(3,3)(ts,val,pred) | 1970-01-01 08:00:00.003 | 12.0000 | false |
| 1970-01-01 08:00:00.001 | 10.0000 | 1970-01-01 08:00:00.001 | 10.0000 | false | | |
| 1970-01-01 08:00:00.002 | 11.0000 | 1970-01-01 08:00:00.002 | 11.0000 | false | | |
| 1970-01-01 08:00:00.003 | 12.0000 | 1970-01-01 08:00:00.003 | 12.0000 | false | | |
| 1 | 0 | MTable(4,2)(ts,val) | MTable(4,3)(ts,val,pred) | 1970-01-01 08:00:00.001 | 10.0000 | false |
| 1970-01-01 08:00:00.001 | 10.0000 | 1970-01-01 08:00:00.001 | 10.0000 | false | | |
| 1970-01-01 08:00:00.002 | 11.0000 | 1970-01-01 08:00:00.002 | 11.0000 | false | | |
| 1970-01-01 08:00:00.003 | 12.0000 | 1970-01-01 08:00:00.003 | 12.0000 | false | | |
| 1970-01-01 08:00:00.004 | 13.0000 | 1970-01-01 08:00:00.004 | 13.0000 | false | | |
| 1 | 0 | MTable(4,2)(ts,val) | MTable(4,3)(ts,val,pred) | 1970-01-01 08:00:00.002 | 11.0000 | false |
| 1970-01-01 08:00:00.001 | 10.0000 | 1970-01-01 08:00:00.001 | 10.0000 | false | | |
| 1970-01-01 08:00:00.002 | 11.0000 | 1970-01-01 08:00:00.002 | 11.0000 | false | | |
| 1970-01-01 08:00:00.003 | 12.0000 | 1970-01-01 08:00:00.003 | 12.0000 | false | | |
| 1970-01-01 08:00:00.004 | 13.0000 | 1970-01-01 08:00:00.004 | 13.0000 | false | | |
| 1 | 0 | MTable(4,2)(ts,val) | MTable(4,3)(ts,val,pred) | 1970-01-01 08:00:00.003 | 12.0000 | false |
| 1970-01-01 08:00:00.001 | 10.0000 | 1970-01-01 08:00:00.001 | 10.0000 | false | | |
| 1970-01-01 08:00:00.002 | 11.0000 | 1970-01-01 08:00:00.002 | 11.0000 | false | | |
| 1970-01-01 08:00:00.003 | 12.0000 | 1970-01-01 08:00:00.003 | 12.0000 | false | | |
| 1970-01-01 08:00:00.004 | 13.0000 | 1970-01-01 08:00:00.004 | 13.0000 | false | | |
| 1 | 0 | MTable(4,2)(ts,val) | MTable(4,3)(ts,val,pred) | 1970-01-01 08:00:00.004 | 13.0000 | false |
| 1970-01-01 08:00:00.001 | 10.0000 | 1970-01-01 08:00:00.001 | 10.0000 | false | | |
| 1970-01-01 08:00:00.002 | 11.0000 | 1970-01-01 08:00:00.002 | 11.0000 | false | | |
| 1970-01-01 08:00:00.003 | 12.0000 | 1970-01-01 08:00:00.003 | 12.0000 | false | | |
| 1970-01-01 08:00:00.004 | 13.0000 | 1970-01-01 08:00:00.004 | 13.0000 | false | | |
| 1 | 0 | MTable(5,2)(ts,val) | MTable(5,3)(ts,val,pred) | 1970-01-01 08:00:00.001 | 10.0000 | false |
| 1970-01-01 08:00:00.001 | 10.0000 | 1970-01-01 08:00:00.001 | 10.0000 | false | | |
| 1970-01-01 08:00:00.002 | 11.0000 | 1970-01-01 08:00:00.002 | 11.0000 | false | | |
| 1970-01-01 08:00:00.003 | 12.0000 | 1970-01-01 08:00:00.003 | 12.0000 | false | | |
| 1970-01-01 08:00:00.004 | 13.0000 | 1970-01-01 08:00:00.004 | 13.0000 | false | | |
| 1970-01-01 08:00:00.005 | 14.0000 | 1970-01-01 08:00:00.005 | 14.0000 | false | | |
| 1 | 0 | MTable(5,2)(ts,val) | MTable(5,3)(ts,val,pred) | 1970-01-01 08:00:00.002 | 11.0000 | false |
| 1970-01-01 08:00:00.001 | 10.0000 | 1970-01-01 08:00:00.001 | 10.0000 | false | | |
| 1970-01-01 08:00:00.002 | 11.0000 | 1970-01-01 08:00:00.002 | 11.0000 | false | | |
| 1970-01-01 08:00:00.003 | 12.0000 | 1970-01-01 08:00:00.003 | 12.0000 | false | | |
| 1970-01-01 08:00:00.004 | 13.0000 | 1970-01-01 08:00:00.004 | 13.0000 | false | | |
| 1970-01-01 08:00:00.005 | 14.0000 | 1970-01-01 08:00:00.005 | 14.0000 | false | | |
| 1 | 0 | MTable(5,2)(ts,val) | MTable(5,3)(ts,val,pred) | 1970-01-01 08:00:00.003 | 12.0000 | false |
| 1970-01-01 08:00:00.001 | 10.0000 | 1970-01-01 08:00:00.001 | 10.0000 | false | | |
| 1970-01-01 08:00:00.002 | 11.0000 | 1970-01-01 08:00:00.002 | 11.0000 | false | | |
| 1970-01-01 08:00:00.003 | 12.0000 | 1970-01-01 08:00:00.003 | 12.0000 | false | | |
| 1970-01-01 08:00:00.004 | 13.0000 | 1970-01-01 08:00:00.004 | 13.0000 | false | | |
| 1970-01-01 08:00:00.005 | 14.0000 | 1970-01-01 08:00:00.005 | 14.0000 | false | | |
| 1 | 0 | MTable(5,2)(ts,val) | MTable(5,3)(ts,val,pred) | 1970-01-01 08:00:00.004 | 13.0000 | false |
| 1970-01-01 08:00:00.001 | 10.0000 | 1970-01-01 08:00:00.001 | 10.0000 | false | | |
| 1970-01-01 08:00:00.002 | 11.0000 | 1970-01-01 08:00:00.002 | 11.0000 | false | | |
| 1970-01-01 08:00:00.003 | 12.0000 | 1970-01-01 08:00:00.003 | 12.0000 | false | | |
| 1970-01-01 08:00:00.004 | 13.0000 | 1970-01-01 08:00:00.004 | 13.0000 | false | | |
| 1970-01-01 08:00:00.005 | 14.0000 | 1970-01-01 08:00:00.005 | 14.0000 | false | | |
| 1 | 0 | MTable(5,2)(ts,val) | MTable(5,3)(ts,val,pred) | 1970-01-01 08:00:00.005 | 14.0000 | false |
| 1970-01-01 08:00:00.001 | 10.0000 | 1970-01-01 08:00:00.001 | 10.0000 | false | | |
| 1970-01-01 08:00:00.002 | 11.0000 | 1970-01-01 08:00:00.002 | 11.0000 | false | | |
| 1970-01-01 08:00:00.003 | 12.0000 | 1970-01-01 08:00:00.003 | 12.0000 | false | | |
| 1970-01-01 08:00:00.004 | 13.0000 | 1970-01-01 08:00:00.004 | 13.0000 | false | | |
| 1970-01-01 08:00:00.005 | 14.0000 | 1970-01-01 08:00:00.005 | 14.0000 | false | | |
| 1 | 0 | MTable(5,2)(ts,val) | MTable(5,3)(ts,val,pred) | 1970-01-01 08:00:00.002 | 11.0000 | false |
| 1970-01-01 08:00:00.002 | 11.0000 | 1970-01-01 08:00:00.002 | 11.0000 | false | | |
| 1970-01-01 08:00:00.003 | 12.0000 | 1970-01-01 08:00:00.003 | 12.0000 | false | | |
| 1970-01-01 08:00:00.004 | 13.0000 | 1970-01-01 08:00:00.004 | 13.0000 | false | | |
| 1970-01-01 08:00:00.005 | 14.0000 | 1970-01-01 08:00:00.005 | 14.0000 | false | | |
| 1970-01-01 08:00:00.006 | 15.0000 | 1970-01-01 08:00:00.006 | 15.0000 | false | | |
| 1 | 0 | MTable(5,2)(ts,val) | MTable(5,3)(ts,val,pred) | 1970-01-01 08:00:00.003 | 12.0000 | false |
| 1970-01-01 08:00:00.002 | 11.0000 | 1970-01-01 08:00:00.002 | 11.0000 | false | | |
| 1970-01-01 08:00:00.003 | 12.0000 | 1970-01-01 08:00:00.003 | 12.0000 | false | | |
| 1970-01-01 08:00:00.004 | 13.0000 | 1970-01-01 08:00:00.004 | 13.0000 | false | | |
| 1970-01-01 08:00:00.005 | 14.0000 | 1970-01-01 08:00:00.005 | 14.0000 | false | | |
| 1970-01-01 08:00:00.006 | 15.0000 | 1970-01-01 08:00:00.006 | 15.0000 | false | | |
| 1 | 0 | MTable(5,2)(ts,val) | MTable(5,3)(ts,val,pred) | 1970-01-01 08:00:00.004 | 13.0000 | false |
| 1970-01-01 08:00:00.002 | 11.0000 | 1970-01-01 08:00:00.002 | 11.0000 | false | | |
| 1970-01-01 08:00:00.003 | 12.0000 | 1970-01-01 08:00:00.003 | 12.0000 | false | | |
| 1970-01-01 08:00:00.004 | 13.0000 | 1970-01-01 08:00:00.004 | 13.0000 | false | | |
| 1970-01-01 08:00:00.005 | 14.0000 | 1970-01-01 08:00:00.005 | 14.0000 | false | | |
| 1970-01-01 08:00:00.006 | 15.0000 | 1970-01-01 08:00:00.006 | 15.0000 | false | | |
| 1 | 0 | MTable(5,2)(ts,val) | MTable(5,3)(ts,val,pred) | 1970-01-01 08:00:00.005 | 14.0000 | false |
| 1970-01-01 08:00:00.002 | 11.0000 | 1970-01-01 08:00:00.002 | 11.0000 | false | | |
| 1970-01-01 08:00:00.003 | 12.0000 | 1970-01-01 08:00:00.003 | 12.0000 | false | | |
| 1970-01-01 08:00:00.004 | 13.0000 | 1970-01-01 08:00:00.004 | 13.0000 | false | | |
| 1970-01-01 08:00:00.005 | 14.0000 | 1970-01-01 08:00:00.005 | 14.0000 | false | | |
| 1970-01-01 08:00:00.006 | 15.0000 | 1970-01-01 08:00:00.006 | 15.0000 | false | | |
| 1 | 0 | MTable(5,2)(ts,val) | MTable(5,3)(ts,val,pred) | 1970-01-01 08:00:00.006 | 15.0000 | false |
| 1970-01-01 08:00:00.002 | 11.0000 | 1970-01-01 08:00:00.002 | 11.0000 | false | | |
| 1970-01-01 08:00:00.003 | 12.0000 | 1970-01-01 08:00:00.003 | 12.0000 | false | | |
| 1970-01-01 08:00:00.004 | 13.0000 | 1970-01-01 08:00:00.004 | 13.0000 | false | | |
| 1970-01-01 08:00:00.005 | 14.0000 | 1970-01-01 08:00:00.005 | 14.0000 | false | | |
| 1970-01-01 08:00:00.006 | 15.0000 | 1970-01-01 08:00:00.006 | 15.0000 | false | | |
| 1 | 0 | MTable(5,2)(ts,val) | MTable(5,3)(ts,val,pred) | 1970-01-01 08:00:00.003 | 12.0000 | false |
| 1970-01-01 08:00:00.003 | 12.0000 | 1970-01-01 08:00:00.003 | 12.0000 | false | | |
| 1970-01-01 08:00:00.004 | 13.0000 | 1970-01-01 08:00:00.004 | 13.0000 | false | | |
| 1970-01-01 08:00:00.005 | 14.0000 | 1970-01-01 08:00:00.005 | 14.0000 | false | | |
| 1970-01-01 08:00:00.006 | 15.0000 | 1970-01-01 08:00:00.006 | 15.0000 | false | | |
| 1970-01-01 08:00:00.007 | 16.0000 | 1970-01-01 08:00:00.007 | 16.0000 | false | | |
| 1 | 0 | MTable(5,2)(ts,val) | MTable(5,3)(ts,val,pred) | 1970-01-01 08:00:00.004 | 13.0000 | false |
| 1970-01-01 08:00:00.003 | 12.0000 | 1970-01-01 08:00:00.003 | 12.0000 | false | | |
| 1970-01-01 08:00:00.004 | 13.0000 | 1970-01-01 08:00:00.004 | 13.0000 | false | | |
| 1970-01-01 08:00:00.005 | 14.0000 | 1970-01-01 08:00:00.005 | 14.0000 | false | | |
| 1970-01-01 08:00:00.006 | 15.0000 | 1970-01-01 08:00:00.006 | 15.0000 | false | | |
| 1970-01-01 08:00:00.007 | 16.0000 | 1970-01-01 08:00:00.007 | 16.0000 | false | | |
| 1 | 0 | MTable(5,2)(ts,val) | MTable(5,3)(ts,val,pred) | 1970-01-01 08:00:00.005 | 14.0000 | false |
| 1970-01-01 08:00:00.003 | 12.0000 | 1970-01-01 08:00:00.003 | 12.0000 | false | | |
| 1970-01-01 08:00:00.004 | 13.0000 | 1970-01-01 08:00:00.004 | 13.0000 | false | | |
| 1970-01-01 08:00:00.005 | 14.0000 | 1970-01-01 08:00:00.005 | 14.0000 | false | | |
| 1970-01-01 08:00:00.006 | 15.0000 | 1970-01-01 08:00:00.006 | 15.0000 | false | | |
| 1970-01-01 08:00:00.007 | 16.0000 | 1970-01-01 08:00:00.007 | 16.0000 | false | | |
| 1 | 0 | MTable(5,2)(ts,val) | MTable(5,3)(ts,val,pred) | 1970-01-01 08:00:00.006 | 15.0000 | false |
| 1970-01-01 08:00:00.003 | 12.0000 | 1970-01-01 08:00:00.003 | 12.0000 | false | | |
| 1970-01-01 08:00:00.004 | 13.0000 | 1970-01-01 08:00:00.004 | 13.0000 | false | | |
| 1970-01-01 08:00:00.005 | 14.0000 | 1970-01-01 08:00:00.005 | 14.0000 | false | | |
| 1970-01-01 08:00:00.006 | 15.0000 | 1970-01-01 08:00:00.006 | 15.0000 | false | | |
| 1970-01-01 08:00:00.007 | 16.0000 | 1970-01-01 08:00:00.007 | 16.0000 | false | | |
| 1 | 0 | MTable(5,2)(ts,val) | MTable(5,3)(ts,val,pred) | 1970-01-01 08:00:00.007 | 16.0000 | false |
| 1970-01-01 08:00:00.003 | 12.0000 | 1970-01-01 08:00:00.003 | 12.0000 | false | | |
| 1970-01-01 08:00:00.004 | 13.0000 | 1970-01-01 08:00:00.004 | 13.0000 | false | | |
| 1970-01-01 08:00:00.005 | 14.0000 | 1970-01-01 08:00:00.005 | 14.0000 | false | | |
| 1970-01-01 08:00:00.006 | 15.0000 | 1970-01-01 08:00:00.006 | 15.0000 | false | | |
| 1970-01-01 08:00:00.007 | 16.0000 | 1970-01-01 08:00:00.007 | 16.0000 | false | | |
| 1 | 0 | MTable(5,2)(ts,val) | MTable(5,3)(ts,val,pred) | 1970-01-01 08:00:00.004 | 13.0000 | false |
| 1970-01-01 08:00:00.004 | 13.0000 | 1970-01-01 08:00:00.004 | 13.0000 | false | | |
| 1970-01-01 08:00:00.005 | 14.0000 | 1970-01-01 08:00:00.005 | 14.0000 | false | | |
| 1970-01-01 08:00:00.006 | 15.0000 | 1970-01-01 08:00:00.006 | 15.0000 | false | | |
| 1970-01-01 08:00:00.007 | 16.0000 | 1970-01-01 08:00:00.007 | 16.0000 | false | | |
| 1970-01-01 08:00:00.008 | 17.0000 | 1970-01-01 08:00:00.008 | 17.0000 | false | | |
| 1 | 0 | MTable(5,2)(ts,val) | MTable(5,3)(ts,val,pred) | 1970-01-01 08:00:00.005 | 14.0000 | false |
| 1970-01-01 08:00:00.004 | 13.0000 | 1970-01-01 08:00:00.004 | 13.0000 | false | | |
| 1970-01-01 08:00:00.005 | 14.0000 | 1970-01-01 08:00:00.005 | 14.0000 | false | | |
| 1970-01-01 08:00:00.006 | 15.0000 | 1970-01-01 08:00:00.006 | 15.0000 | false | | |
| 1970-01-01 08:00:00.007 | 16.0000 | 1970-01-01 08:00:00.007 | 16.0000 | false | | |
| 1970-01-01 08:00:00.008 | 17.0000 | 1970-01-01 08:00:00.008 | 17.0000 | false | | |
| 1 | 0 | MTable(5,2)(ts,val) | MTable(5,3)(ts,val,pred) | 1970-01-01 08:00:00.006 | 15.0000 | false |
| 1970-01-01 08:00:00.004 | 13.0000 | 1970-01-01 08:00:00.004 | 13.0000 | false | | |
| 1970-01-01 08:00:00.005 | 14.0000 | 1970-01-01 08:00:00.005 | 14.0000 | false | | |
| 1970-01-01 08:00:00.006 | 15.0000 | 1970-01-01 08:00:00.006 | 15.0000 | false | | |
| 1970-01-01 08:00:00.007 | 16.0000 | 1970-01-01 08:00:00.007 | 16.0000 | false | | |
| 1970-01-01 08:00:00.008 | 17.0000 | 1970-01-01 08:00:00.008 | 17.0000 | false | | |
| 1 | 0 | MTable(5,2)(ts,val) | MTable(5,3)(ts,val,pred) | 1970-01-01 08:00:00.007 | 16.0000 | false |
| 1970-01-01 08:00:00.004 | 13.0000 | 1970-01-01 08:00:00.004 | 13.0000 | false | | |
| 1970-01-01 08:00:00.005 | 14.0000 | 1970-01-01 08:00:00.005 | 14.0000 | false | | |
| 1970-01-01 08:00:00.006 | 15.0000 | 1970-01-01 08:00:00.006 | 15.0000 | false | | |
| 1970-01-01 08:00:00.007 | 16.0000 | 1970-01-01 08:00:00.007 | 16.0000 | false | | |
| 1970-01-01 08:00:00.008 | 17.0000 | 1970-01-01 08:00:00.008 | 17.0000 | false | | |
| 1 | 0 | MTable(5,2)(ts,val) | MTable(5,3)(ts,val,pred) | 1970-01-01 08:00:00.008 | 17.0000 | false |
| 1970-01-01 08:00:00.004 | 13.0000 | 1970-01-01 08:00:00.004 | 13.0000 | false | | |
| 1970-01-01 08:00:00.005 | 14.0000 | 1970-01-01 08:00:00.005 | 14.0000 | false | | |
| 1970-01-01 08:00:00.006 | 15.0000 | 1970-01-01 08:00:00.006 | 15.0000 | false | | |
| 1970-01-01 08:00:00.007 | 16.0000 | 1970-01-01 08:00:00.007 | 16.0000 | false | | |
| 1970-01-01 08:00:00.008 | 17.0000 | 1970-01-01 08:00:00.008 | 17.0000 | false | | |
| 1 | 0 | MTable(5,2)(ts,val) | MTable(5,3)(ts,val,pred) | 1970-01-01 08:00:00.005 | 14.0000 | false |
| 1970-01-01 08:00:00.005 | 14.0000 | 1970-01-01 08:00:00.005 | 14.0000 | false | | |
| 1970-01-01 08:00:00.006 | 15.0000 | 1970-01-01 08:00:00.006 | 15.0000 | false | | |
| 1970-01-01 08:00:00.007 | 16.0000 | 1970-01-01 08:00:00.007 | 16.0000 | false | | |
| 1970-01-01 08:00:00.008 | 17.0000 | 1970-01-01 08:00:00.008 | 17.0000 | false | | |
| 1970-01-01 08:00:00.009 | 18.0000 | 1970-01-01 08:00:00.009 | 18.0000 | false | | |
| 1 | 0 | MTable(5,2)(ts,val) | MTable(5,3)(ts,val,pred) | 1970-01-01 08:00:00.006 | 15.0000 | false |
| 1970-01-01 08:00:00.005 | 14.0000 | 1970-01-01 08:00:00.005 | 14.0000 | false | | |
| 1970-01-01 08:00:00.006 | 15.0000 | 1970-01-01 08:00:00.006 | 15.0000 | false | | |
| 1970-01-01 08:00:00.007 | 16.0000 | 1970-01-01 08:00:00.007 | 16.0000 | false | | |
| 1970-01-01 08:00:00.008 | 17.0000 | 1970-01-01 08:00:00.008 | 17.0000 | false | | |
| 1970-01-01 08:00:00.009 | 18.0000 | 1970-01-01 08:00:00.009 | 18.0000 | false | | |
| 1 | 0 | MTable(5,2)(ts,val) | MTable(5,3)(ts,val,pred) | 1970-01-01 08:00:00.007 | 16.0000 | false |
| 1970-01-01 08:00:00.005 | 14.0000 | 1970-01-01 08:00:00.005 | 14.0000 | false | | |
| 1970-01-01 08:00:00.006 | 15.0000 | 1970-01-01 08:00:00.006 | 15.0000 | false | | |
| 1970-01-01 08:00:00.007 | 16.0000 | 1970-01-01 08:00:00.007 | 16.0000 | false | | |
| 1970-01-01 08:00:00.008 | 17.0000 | 1970-01-01 08:00:00.008 | 17.0000 | false | | |
| 1970-01-01 08:00:00.009 | 18.0000 | 1970-01-01 08:00:00.009 | 18.0000 | false | | |
| 1 | 0 | MTable(5,2)(ts,val) | MTable(5,3)(ts,val,pred) | 1970-01-01 08:00:00.008 | 17.0000 | false |
| 1970-01-01 08:00:00.005 | 14.0000 | 1970-01-01 08:00:00.005 | 14.0000 | false | | |
| 1970-01-01 08:00:00.006 | 15.0000 | 1970-01-01 08:00:00.006 | 15.0000 | false | | |
| 1970-01-01 08:00:00.007 | 16.0000 | 1970-01-01 08:00:00.007 | 16.0000 | false | | |
| 1970-01-01 08:00:00.008 | 17.0000 | 1970-01-01 08:00:00.008 | 17.0000 | false | | |
| 1970-01-01 08:00:00.009 | 18.0000 | 1970-01-01 08:00:00.009 | 18.0000 | false | | |
| 1 | 0 | MTable(5,2)(ts,val) | MTable(5,3)(ts,val,pred) | 1970-01-01 08:00:00.009 | 18.0000 | false |
| 1970-01-01 08:00:00.005 | 14.0000 | 1970-01-01 08:00:00.005 | 14.0000 | false | | |
| 1970-01-01 08:00:00.006 | 15.0000 | 1970-01-01 08:00:00.006 | 15.0000 | false | | |
| 1970-01-01 08:00:00.007 | 16.0000 | 1970-01-01 08:00:00.007 | 16.0000 | false | | |
| 1970-01-01 08:00:00.008 | 17.0000 | 1970-01-01 08:00:00.008 | 17.0000 | false | | |
| 1970-01-01 08:00:00.009 | 18.0000 | 1970-01-01 08:00:00.009 | 18.0000 | false | | |