[DRILL-8058] NPE: Cannot invoke "org.apache.calcite.rel.core.TableScan.getTable()" because "scan" is null

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 1.19.0
• Fix Version/s: 1.20.0
• Component/s: Storage - Iceberg
• Labels: iceberg storage
• Assignee: Vova Vysotskyi
• Reporter: Vitalii Diravka
• Created: 29/Nov/21 20:22
• Updated: 27/Jan/22 14:57
• Resolved: 27/Jan/22 14:57

Description

Checked in Drill embedded the query form TestE2EUnnestAndLateral#testMultipleBatchesLateral_WithLimitInParent  test case:

SELECT customer.c_name, avg(orders.o_totalprice) AS avgPrice FROM 
dfs.`/{custom_path}/drill/exec/java-exec/target/org.apache.drill.exec.physical.impl.lateraljoin.TestE2EUnnestAndLateral/root/lateraljoin/multipleFiles` 
customer, LATERAL (SELECT t.ord.o_totalprice as o_totalprice FROM UNNEST(customer.c_orders) t(ord) 
WHERE t.ord.o_totalprice > 100000 LIMIT 2) orders GROUP BY customer.c_name; 

But it gives the following error:

Caused by: java.lang.NullPointerException: Cannot invoke "org.apache.calcite.rel.core.TableScan.getTable()" because "scan" is null
at org.apache.drill.exec.planner.common.DrillRelOptUtil.getDrillTable(DrillRelOptUtil.java:691)
at org.apache.drill.exec.store.iceberg.plan.IcebergPluginImplementor.canImplement(IcebergPluginImplementor.java:101)
at org.apache.drill.exec.store.plan.rule.PluginConverterRule.matches(PluginConverterRule.java:64)
at org.apache.calcite.plan.volcano.VolcanoRuleCall.matchRecurse(VolcanoRuleCall.java:263)
at org.apache.calcite.plan.volcano.VolcanoRuleCall.match(VolcanoRuleCall.java:247)
at org.apache.calcite.plan.volcano.VolcanoPlanner.fireRules(VolcanoPlanner.java:1566)
at org.apache.calcite.plan.volcano.VolcanoPlanner.registerImpl(VolcanoPlanner.java:1840)
at org.apache.calcite.plan.volcano.VolcanoPlanner.register(VolcanoPlanner.java:848)
at org.apache.calcite.plan.volcano.VolcanoPlanner.ensureRegistered(VolcanoPlanner.java:864)
at org.apache.calcite.plan.volcano.VolcanoPlanner.ensureRegistered(VolcanoPlanner.java:92)
at org.apache.calcite.rel.AbstractRelNode.onRegister(AbstractRelNode.java:329) 

 

Issue Links

• is duplicated by: DRILL-8060 Avoid the NPE in the Filter of Iceberg Implementor