HBOS序列异常检测 (HbosOutlier4GroupedDataStreamOp)

Java 类名：com.alibaba.alink.operator.stream.outlier.HbosOutlier4GroupedDataStreamOp

Python 类名：HbosOutlier4GroupedDataStreamOp

功能介绍

Histogram-based Outlier Score 使用直方图统计结果，描述异常值，算法较为简单，上手方便。

文献或出处

HBOS

参数说明

名称	中文名称	描述	类型	是否必须？	取值范围	默认值
inputMTableCol	输入列名	输入序列的列名	String	✓
outputMTableCol	输出列名	输出序列的列名	String	✓
predictionCol	预测结果列名	预测结果列名	String	✓
featureCols	特征列名数组	特征列名数组，默认全选	String[]		所选列类型为 [BIGDECIMAL, BIGINTEGER, BYTE, DOUBLE, FLOAT, INTEGER, LONG, SHORT]	null
k	K	直方图 bin 的数量	Integer		x >= 1	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