它是否支持使用相同存储插件的mysql内部联接

Question

运行apache-drill-1.14.0

存储插件1:myplugin

SELECT t1.id FROM myplugin.db.t1, myplugin.db.t2 WHERE t1.id = t2.id AND t2.id = 12345 GROUP BY t1.id ORDER BY t1.id;

与同一数据库中另一个表的内部联接返回-错误：系统错误：断言错误：关系表达式

创建另一个存储插件2：myplugin2(插件1的副本(

SELECT t1.id FROM myplugin.db.t1, myplugin2.db.t2 WHERE t1.id = t2.id AND t2.id = 12345 GROUP BY t1.id ORDER BY t1.id;

工作良好

Answer 1

看起来它是在https://issues.apache.org/jira/browse/DRILL-6850
请查看Drill master分支(请参阅帮助(或等待新的1.15.0 Drill版本。

mysql> select t1.`PersonId` from testdb.`mscIdentities3` t1 join testdb.`mscIdentities3` t2 on t1.`PersonId` = t2.`PersonID` where t1.`PersonID` = 10;
+----------+
| PersonId |
+----------+
|       10 |
+----------+
1 row in set (1.00 sec)
0: jdbc:drill:zk=local> select t1.`PersonId` from mysql.testdb.`mscIdentities3` t1 join mysql.testdb.`mscIdentities3` t2 on t1.`PersonId` = t2.`PersonID` where t1.`PersonID` = 10;
+-----------+
| PersonId  |
+-----------+
| 10        |
+-----------+
1 row selected (1.166 seconds)