跨引擎查询不支持Hierarchical Query。
GBase UP 产品手册 5 数据库管理指南
文档版本04(2021-04-21) 南大通用数据技术股份有限公司 781
示例中用到的表及数据:
CREATE TABLE h1(a INT, b INT, c INT) ENGINE='HIVE';
CREATE TABLE r1(a INT, b INT, c INT) ENGINE='EXPRESS' REPLICATED;
INSERT INTO h1 VALUES(1, 2, 1), (2, 3, 2), (3, 3, 3);
INSERT INTO r1 VALUES(1, 2, 1), (2, 3, 3), (4, 3, 4);
示例1:跨引擎查询不支持Hierarchical Query:
gbase> SELECT r1.b FROM r1 WHERE r1.a IN (SELECT a FROM h1) CONNECT BY r1.b START WITH
r1.b = r1.c;
ERROR 1149 (42000): (GBA-02SC-1001) Cross Engine Join syntax error, Hierarchical Query
isn't supported yet.