Redis 维表 Join

具体 JOIN 语法如下:

SELECT {<other_view_name>.<column_name> [AS <alias_name>]}[, ...n],

`GET`.v 

FROM  <other_view_name>  

LEFT JOIN  <redis_catalog_name>.`default`.`GET`   

FOR SYSTEM_TIME AS OF <other_view_name>.<proctime_column_name> 

ON <other_view_name>.<column_name> = `GET`.k;

跟 JDBC 维表 JOI N的语法相比,redis 维表 JOIN 的语法简单的多,这是因为我们将底层的逻辑都进行了封装,让用户更易用。下面依旧上例子:

SELECT V3.proctime,V3.id, V3.os, V3.seqno,
`GET`.v
FROM V3
LEFT  JOIN redis_95_test.`default`.`GET`
FOR SYSTEM_TIME AS OF V3.proctime
ON V3.id = `GET`.k;