You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@drill.apache.org by "Chun Chang (JIRA)" <ji...@apache.org> on 2015/04/02 19:53:56 UTC
[jira] [Commented] (DRILL-2197) hit no applicable constructor error
running outer join involving list of maps
[ https://issues.apache.org/jira/browse/DRILL-2197?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14393035#comment-14393035 ]
Chun Chang commented on DRILL-2197:
-----------------------------------
verified:
{code}
0: jdbc:drill:schema=dfs.drillTestDirComplexJ> select a.id, b.oooi.oa.oab.oabc, b.ooof.oa.oab from `complex.json` a left outer join `complex.json` b on a.soa[2].fl=b.soa[2].fl order by a.id limit 20;
+------------+------------+------------+
| id | EXPR$1 | EXPR$2 |
+------------+------------+------------+
| 1 | null | {} |
| 2 | null | {"oabc":2.5678} |
| 3 | null | {"oabc":3.5678} |
| 4 | null | {"oabc":4.5678} |
| 5 | null | {"oabc":5.5678} |
| 6 | 6 | {"oabc":6.5678} |
| 7 | null | {} |
| 8 | 8 | {} |
| 9 | null | {} |
| 10 | 10 | {"oabc":10.5678} |
| 11 | null | {"oabc":11.5678} |
| 12 | null | {} |
| 13 | null | {} |
| 14 | null | {} |
| 15 | null | {} |
| 16 | null | {"oabc":16.5678} |
| 17 | null | {"oabc":17.5678} |
| 18 | null | {} |
| 19 | 19 | {} |
| 20 | null | {} |
+------------+------------+------------+
20 rows selected (3.971 seconds)
0: jdbc:drill:schema=dfs.drillTestDirComplexJ> select * from sys.version;
+------------+----------------+-------------+-------------+------------+
| commit_id | commit_message | commit_time | build_email | build_time |
+------------+----------------+-------------+-------------+------------+
| 1b0c52f91dbe2284438e2ef7aa839cb9c6717f65 | DRILL-2280: Refactor ValueVector interface & add an abstract ValueVector implementation | 31.03.2015 @ 17:11:39 PDT |
{code}
> hit no applicable constructor error running outer join involving list of maps
> -----------------------------------------------------------------------------
>
> Key: DRILL-2197
> URL: https://issues.apache.org/jira/browse/DRILL-2197
> Project: Apache Drill
> Issue Type: Bug
> Components: Execution - Data Types
> Affects Versions: 0.8.0
> Reporter: Chun Chang
> Assignee: Parth Chandra
> Priority: Critical
> Fix For: 0.9.0
>
> Attachments: DRILL-2197-patch.diff
>
>
> #Mon Feb 09 15:58:57 EST 2015
> git.commit.id.abbrev=3d863b5
> Dataset can be downloaded from
> https://s3.amazonaws.com/apache-drill/files/complex.json.gz
> Following query caused the error:
> {code}
> 0: jdbc:drill:schema=dfs.drillTestDirComplexJ> select a.id, b.oooi.oa.oab.oabc, b.ooof.oa.oab from `complex.json` a left outer join `complex.json` b on a.soa[2].fl=b.soa[2].fl order by a.id limit 20;
> Query failed: RemoteRpcException: Failure while running fragment., Line 109, Column 32: No applicable constructor/method found for actual parameters "int, int, org.apache.drill.exec.vector.complex.MapVector"; candidates are: "public void org.apache.drill.exec.vector.NullableTinyIntVector.copyFromSafe(int, int, org.apache.drill.exec.vector.NullableTinyIntVector)", "public void org.apache.drill.exec.vector.NullableTinyIntVector.copyFromSafe(int, int, org.apache.drill.exec.vector.TinyIntVector)" [ 73387a1a-1c50-4b1e-862e-e03772e7a291 on qa-node119.qa.lab:31010 ]
> [ 73387a1a-1c50-4b1e-862e-e03772e7a291 on qa-node119.qa.lab:31010 ]
> Error: exception while executing query: Failure while executing query. (state=,code=0)
> {code}
> physical plan:
> {code}
> 0: jdbc:drill:schema=dfs.drillTestDirComplexJ> explain plan for select a.id, b.oooi.oa.oab.oabc, b.ooof.oa.oab from `complex.json` a left outer join `complex.json` b on a.soa[2].fl=b.soa[2].fl order by a.id limit 20;
> +------------+------------+
> | text | json |
> +------------+------------+
> | 00-00 Screen
> 00-01 Project(id=[$0], EXPR$1=[$1], EXPR$2=[$2])
> 00-02 SelectionVectorRemover
> 00-03 Limit(fetch=[20])
> 00-04 SingleMergeExchange(sort0=[0 ASC])
> 01-01 SelectionVectorRemover
> 01-02 TopN(limit=[20])
> 01-03 HashToRandomExchange(dist0=[[$0]])
> 02-01 Project(id=[$0], EXPR$1=[$3], EXPR$2=[$4])
> 02-02 HashJoin(condition=[=($1, $2)], joinType=[left])
> 02-04 HashToRandomExchange(dist0=[[$1]])
> 03-01 Project(id=[$1], $f5=[ITEM(ITEM($0, 2), 'fl')])
> 03-02 Scan(groupscan=[EasyGroupScan [selectionRoot=/drill/testdata/complex_type/json/complex.json, numFiles=1, columns=[`id`, `soa`[2].`fl`], files=[maprfs:/drill/testdata/complex_type/json/complex.json]]])
> 02-03 Project($f50=[$0], ITEM=[$1], ITEM2=[$2])
> 02-05 HashToRandomExchange(dist0=[[$0]])
> 04-01 Project($f5=[ITEM(ITEM($0, 2), 'fl')], ITEM=[ITEM(ITEM(ITEM($2, 'oa'), 'oab'), 'oabc')], ITEM2=[ITEM(ITEM($1, 'oa'), 'oab')])
> 04-02 Scan(groupscan=[EasyGroupScan [selectionRoot=/drill/testdata/complex_type/json/complex.json, numFiles=1, columns=[`soa`[2].`fl`, `oooi`.`oa`.`oab`.`oabc`, `ooof`.`oa`.`oab`], files=[maprfs:/drill/testdata/complex_type/json/complex.json]]])
> {code}
> log:
> {code}
> 2015-02-09 17:16:17,736 [BitServer-1] INFO o.a.drill.exec.work.foreman.Foreman - State change requested. RUNNING --> FAILED
> org.apache.drill.exec.rpc.RemoteRpcException: Failure while running fragment., Line 109, Column 32: No applicable constructor/method found for actual parameters "int, int, org.apache.drill.exec.vector.complex.MapVector"; candidates are: "public void org.apache.drill.exec.vector.NullableTinyIntVector.copyFromSafe(int, int, org.apache.drill.exec.vector.NullableTinyIntVector)", "public void org.apache.drill.exec.vector.NullableTinyIntVector.copyFromSafe(int, int, org.apache.drill.exec.vector.TinyIntVector)" [ 73387a1a-1c50-4b1e-862e-e03772e7a291 on qa-node119.qa.lab:31010 ]
> [ 73387a1a-1c50-4b1e-862e-e03772e7a291 on qa-node119.qa.lab:31010 ]
> at org.apache.drill.exec.work.foreman.QueryManager.statusUpdate(QueryManager.java:95) [drill-java-exec-0.8.0-SNAPSHOT-rebuffed.jar:0.8.0-SNAPSHOT]
> at org.apache.drill.exec.rpc.control.WorkEventBus.status(WorkEventBus.java:75) [drill-java-exec-0.8.0-SNAPSHOT-rebuffed.jar:0.8.0-SNAPSHOT]
> at org.apache.drill.exec.work.batch.ControlHandlerImpl.handle(ControlHandlerImpl.java:82) [drill-java-exec-0.8.0-SNAPSHOT-rebuffed.jar:0.8.0-SNAPSHOT]
> at org.apache.drill.exec.rpc.control.ControlServer.handle(ControlServer.java:60) [drill-java-exec-0.8.0-SNAPSHOT-rebuffed.jar:0.8.0-SNAPSHOT]
> at org.apache.drill.exec.rpc.control.ControlServer.handle(ControlServer.java:38) [drill-java-exec-0.8.0-SNAPSHOT-rebuffed.jar:0.8.0-SNAPSHOT]
> at org.apache.drill.exec.rpc.RpcBus.handle(RpcBus.java:58) [drill-java-exec-0.8.0-SNAPSHOT-rebuffed.jar:0.8.0-SNAPSHOT]
> at org.apache.drill.exec.rpc.RpcBus$InboundHandler.decode(RpcBus.java:194) [drill-java-exec-0.8.0-SNAPSHOT-rebuffed.jar:0.8.0-SNAPSHOT]
> at org.apache.drill.exec.rpc.RpcBus$InboundHandler.decode(RpcBus.java:173) [drill-java-exec-0.8.0-SNAPSHOT-rebuffed.jar:0.8.0-SNAPSHOT]
> at io.netty.handler.codec.MessageToMessageDecoder.channelRead(MessageToMessageDecoder.java:89) [netty-codec-4.0.24.Final.jar:4.0.24.Final]
> {code}
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)