大数据3.0—— 后Hadoop时代大数据的核心技术
刘汪根,孙元浩

Big Data 3.0—The Key Technologies of Big Data in Post-Hadoop Era
Wanggen Liu,Yuanhao Sun
表2 Transwarp StreamSQL示例
Table 2 A Sample of Transwarp StreamSQL
USE APPLICATION cep_example;
CREATE STREAM robotarm_2(armid STRING, location STRING) tblproperties(
"topic"="arm_t2",
"kafka.zookeeper"="localhost:2181",
"kafka.broker.list"="localhost:9092"
);
CREATE TABLE coords_miss(armid STRING, location STRING);
INSERT INTO coords_miss
SELECT e1.armid, e1.location
FROM PATTERN(
-- 当机械臂经过位置A后未经过位置B,则预警
e1=robotarm_2[e1.location='A'] NOTNEXT
e2=robotarm_2[e2.armid=e1.armid AND e2.location='B'] ) WITHIN ('1' minute);