断言错误:关系表达式

Question

运行apache-drill-1.14.0

在mysql上测试了这个查询，并在0.02秒的中得到结果

在drill cli中运行查询失败，出现AssertionError

查询：

product_id是BIGINT

SELECT test50.customername, test50.color, test50.age, test50.city,  
test50.product_id, test50.price FROM myplugin.sampler.test50 JOIN 
myplugin.sampler.test52 ON test50.product_id = test52.product_id WHERE 
test50.product_id = 759216 GROUP BY test50.customername, test50.color,
test50.age, test50.city, test50.product_id, test50.price ORDER BY
test50.customername;

错误：

Error: SYSTEM ERROR: AssertionError: Relational expression
rel#873:DrillFilterRel.JDBC.myplugin.ANY([]).
[](input=rel#83:JdbcTableScan.JDBC.myplugin.ANY([]).[](table=[myplugin, 
sampler, test50]),condition=OR(=($18, 759216), =($18, 494636))) has  
calling-convention JDBC.myplugin but does not implement the required interface 
'interface org.apache.calcite.adapter.jdbc.JdbcRel' of that convention

如果我需要一些额外的配置，需要帮助吗？

感谢

Answer 1

你能检查一下当前的主机吗？看起来它是在DRILL-6850中修复的。