IForest序列异常检测 (IForestOutlier4GroupedDataStreamOp)

Java 类名:com.alibaba.alink.operator.stream.outlier.IForestOutlier4GroupedDataStreamOp

Python 类名:IForestOutlier4GroupedDataStreamOp

功能介绍

iForest 可以识别数据中异常点,在异常检测领域有比较好的效果。算法使用 sub-sampling 方法,降低了算法的计算复杂度。

文献或出处

  1. Isolation Forest

参数说明

名称 中文名称 描述 类型 是否必须? 取值范围 默认值
inputMTableCol 输入列名 输入序列的列名 String
outputMTableCol 输出列名 输出序列的列名 String
predictionCol 预测结果列名 预测结果列名 String
featureCols 特征列名数组 特征列名数组,默认全选 String[] 所选列类型为 [BIGDECIMAL, BIGINTEGER, BYTE, DOUBLE, FLOAT, INTEGER, LONG, SHORT] null
maxOutlierNumPerGroup 每组最大异常点数目 每组最大异常点数目 Integer
maxOutlierRatio 最大异常点比例 算法检测异常点的最大比例 Double
numTrees 模型中树的棵数 模型中树的棵数 Integer 100
outlierThreshold 异常评分阈值 只有评分大于该阈值才会被认为是异常点 Double
predictionDetailCol 预测详细信息列名 预测详细信息列名 String
subsamplingSize 每棵树的样本采样行数 每棵树的样本采样行数,默认 256 ,最小 2 ,最大 100000 . Integer 1 <= x <= 100000 256
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(ts, val) as series_data")
    .setReservedCols(["id", "label"])
).link(
    IForestOutlier4GroupedDataStreamOp()
    .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.IForestOutlier4GroupedDataStreamOp;
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 IForestOutlier4GroupedDataStreamOpTest {
	@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(10)
				.setClause("MTABLE_AGG(ts, val) as series_data")
				.setReservedCols("id", "label")
		).link(
			new IForestOutlier4GroupedDataStreamOp()
				.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(6,2)(ts,val) MTable(6,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(6,2)(ts,val) MTable(6,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(6,2)(ts,val) MTable(6,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(6,2)(ts,val) MTable(6,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(6,2)(ts,val) MTable(6,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(6,2)(ts,val) MTable(6,3)(ts,val,pred) 1970-01-01 08:00:00.006 15.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(7,2)(ts,val) MTable(7,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(7,2)(ts,val) MTable(7,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(7,2)(ts,val) MTable(7,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(7,2)(ts,val) MTable(7,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(7,2)(ts,val) MTable(7,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(7,2)(ts,val) MTable(7,3)(ts,val,pred) 1970-01-01 08:00:00.006 15.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(7,2)(ts,val) MTable(7,3)(ts,val,pred) 1970-01-01 08:00:00.007 16.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(8,2)(ts,val) MTable(8,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(8,2)(ts,val) MTable(8,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(8,2)(ts,val) MTable(8,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(8,2)(ts,val) MTable(8,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(8,2)(ts,val) MTable(8,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(8,2)(ts,val) MTable(8,3)(ts,val,pred) 1970-01-01 08:00:00.006 15.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(8,2)(ts,val) MTable(8,3)(ts,val,pred) 1970-01-01 08:00:00.007 16.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(8,2)(ts,val) MTable(8,3)(ts,val,pred) 1970-01-01 08:00:00.008 17.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(9,2)(ts,val) MTable(9,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(9,2)(ts,val) MTable(9,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(9,2)(ts,val) MTable(9,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(9,2)(ts,val) MTable(9,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(9,2)(ts,val) MTable(9,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(9,2)(ts,val) MTable(9,3)(ts,val,pred) 1970-01-01 08:00:00.006 15.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(9,2)(ts,val) MTable(9,3)(ts,val,pred) 1970-01-01 08:00:00.007 16.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(9,2)(ts,val) MTable(9,3)(ts,val,pred) 1970-01-01 08:00:00.008 17.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(9,2)(ts,val) MTable(9,3)(ts,val,pred) 1970-01-01 08:00:00.009 18.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(10,2)(ts,val) MTable(10,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(10,2)(ts,val) MTable(10,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(10,2)(ts,val) MTable(10,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(10,2)(ts,val) MTable(10,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(10,2)(ts,val) MTable(10,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(10,2)(ts,val) MTable(10,3)(ts,val,pred) 1970-01-01 08:00:00.006 15.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(10,2)(ts,val) MTable(10,3)(ts,val,pred) 1970-01-01 08:00:00.007 16.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(10,2)(ts,val) MTable(10,3)(ts,val,pred) 1970-01-01 08:00:00.008 17.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(10,2)(ts,val) MTable(10,3)(ts,val,pred) 1970-01-01 08:00:00.009 18.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(10,2)(ts,val) MTable(10,3)(ts,val,pred) 1970-01-01 08:00:00.01 19.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