drill-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Alexander Holy (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (DRILL-3976) Join fails when one table is from JDBC
Date Fri, 27 Nov 2015 11:15:11 GMT

    [ https://issues.apache.org/jira/browse/DRILL-3976?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15029772#comment-15029772
] 

Alexander Holy commented on DRILL-3976:
---------------------------------------

One more example using a simple 2-table join on an integer column.
One side is JSON, the other side is SQL Server JDBC:

SELECT l.mediatype, m.SID_MediaType
FROM dfs.`D:\DataExport\Azure\PageImpression\2015\09\11` l
INNER JOIN sqldwh.dbo.DimMediaType m ON l.mediatype = m.SID_MediaType
LIMIT 10

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 2:0 [Error Id: e1c0b266-522b-4d27-b6b4-a99a701c6680 on ...:31010]

> 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)

Mime
View raw message