flink- Interval Joins

1. 实验用数据

俩列： op固定值：

每隔5s往kafka 写一条数据

2. 实验用sql

select a.op , a.ts, b.ts  from source_table a  left join  source_table b on  a.op=b.op  and  a.ts between b.ts -INTERVAL '6' second  and  b.ts +INTERVAL '0' second 

3. 实验结果

+----+--------------------------------+-------------------------+-------------------------+
| op |                             op |                      ts |                     ts0 |
+----+--------------------------------+-------------------------+-------------------------+
| +I |                   10.10.28.240 | 2024-04-19 17:21:09.242 | 2024-04-19 17:21:09.242 |
| +I |                   10.10.28.240 | 2024-04-19 17:21:09.242 | 2024-04-19 17:21:14.251 |
| +I |                   10.10.28.240 | 2024-04-19 17:21:14.251 | 2024-04-19 17:21:14.251 |
| +I |                   10.10.28.240 | 2024-04-19 17:21:19.252 |