它是否支持mysql内部连接和相同的存储插件

8aqjt8rx 于 2021-06-18 发布在 Mysql

关注(0)|答案(1)|浏览(299)

运行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;

与同一数据库中的另一个表的内部联接返回-error:system error:assertionerror:relational expression
创建另一个存储插件2:myplugin2（plugin1的副本）

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;

工作正常

mysql apache-drill

来源：https://stackoverflow.com/questions/53607993/apache-drill-does-it-support-mysql-inner-join-with-same-storage-plugin

1条答案

按热度按时间

trnvg8h31#

看起来是在…的范围内解决的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)

赞(0）回复(0）举报 2021-06-18

我来回答

它是否支持mysql内部连接和相同的存储插件

1条答案

相关问题

热门标签

最新问答