[DRILL-3976] Join fails when one table is from JDBC

• Type: Bug
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Affects Version/s: 1.2.0
• Component/s: Storage - Other
• Labels: JDBC
• Assignee: Unassigned
• Reporter: Ivan Pavlov
• Created: 26/Oct/15 11:28
• Updated: 31/Dec/15 09:03

Description

The following simple 3-table join fails when one table is from JDBC.
The exception is:

org.apache.drill.common.exceptions.UserRemoteException: SYSTEM ERROR: IllegalStateException: Already had POJO for id (java.lang.Integer) [com.fasterxml.jackson.annotation.ObjectIdGenerator$IdKey@3372bbe8] Fragment 3:0 [Error Id: b22c087f-787e-4d52-8bce-6a330e197cdc on drill:31010]

select ps1.ps_partkey,min(ps1.ps_supplycost)
from 
    dfs.data.Partsupp_0 ps1, 
    dfs.data.Supplier_0 s1, 
    sqlite.Nation n1
where
s1.s_suppkey = ps1.ps_suppkey
and s1.s_nationkey = n1.n_nationkey
and n1.n_regionkey=1
group by ps1.ps_partkey

The dfs plugin is a plain file system, the sqlite is jdbc to sqlite.

Attached is the generated execution plan for the failed query.