[
https://issues.apache.org/jira/browse/DRILL-3976?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Ivan Pavlov updated DRILL-3976:
-------------------------------
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]
{code:sql}
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
{code}
The dfs plugin is a plain file system, the sqlite is jdbc to sqlite.
Attached is the generated execution plan for the failed query.
was:
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]
{code:sql}
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
{code}
The dfs plugin is a plain file system, the sqlite is jdbc to sqlite.
> Join fails when one table is from JDBC
> --------------------------------------
>
> Key: DRILL-3976
> URL: https://issues.apache.org/jira/browse/DRILL-3976
> Project: Apache Drill
> Issue Type: Bug
> Components: Storage - Other
> Affects Versions: 1.2.0
> Reporter: Ivan Pavlov
> Labels: JDBC
> Attachments: jdbc_join_fail.txt
>
>
> 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]
> {code:sql}
> 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
> {code}
> The dfs plugin is a plain file system, the sqlite is jdbc to sqlite.
> Attached is the generated execution plan for the failed query.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
