You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@drill.apache.org by "Bhallamudi Venkata Siva Kamesh (JIRA)" <ji...@apache.org> on 2015/10/24 06:17:27 UTC
[jira] [Commented] (DRILL-1752) Drill cluster returns error when
querying Mongo shards on an unsharded collection
[ https://issues.apache.org/jira/browse/DRILL-1752?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14972362#comment-14972362 ]
Bhallamudi Venkata Siva Kamesh commented on DRILL-1752:
-------------------------------------------------------
Rebased patch and updated in the RB : [39618|https://reviews.apache.org/r/39618/].
[~jnadeau] could you please review this and can it be targeted for 1.3.0?
> Drill cluster returns error when querying Mongo shards on an unsharded collection
> ---------------------------------------------------------------------------------
>
> Key: DRILL-1752
> URL: https://issues.apache.org/jira/browse/DRILL-1752
> Project: Apache Drill
> Issue Type: Bug
> Components: Storage - MongoDB
> Affects Versions: 0.6.0, 0.7.0
> Environment: Drill cluster on nodes with Mongo Shards
> Reporter: Andries Engelbrecht
> Priority: Minor
> Fix For: Future
>
> Attachments: DRILL-1752.patch
>
>
> Query fails on a large unsharded collection in MongoDB sharded cluster with drillbits on each node with Mongo shards.
> Error message:
> 0: jdbc:drill:se0:5181> select * from unshard limit 2;
> Query failed: Failure while setting up query. Incoming endpoints 1 is greater than number of chunks 0 [cb2121f7-eb3e-48cd-8530-474ca76c598d]
> Error: exception while executing query: Failure while trying to get next result batch. (state=,code=0)
> 0: jdbc:drill:se0:5181> explain plan for select * from unshard limit 2;
> +------------+------------+
> | text | json |
> +------------+------------+
> | 00-00 Screen
> 00-01 SelectionVectorRemover
> 00-02 Limit(fetch=[2])
> 00-03 Scan(groupscan=[MongoGroupScan [MongoScanSpec=MongoScanSpec [dbName=review_syn, collectionName=unshard, filters=null], columns=[SchemaPath [`*`]]]])
> | {
> "head" : {
> "version" : 1,
> "generator" : {
> "type" : "ExplainHandler",
> "info" : ""
> },
> "type" : "APACHE_DRILL_PHYSICAL",
> "options" : [ ],
> "queue" : 0,
> "resultMode" : "EXEC"
> },
> "graph" : [ {
> "pop" : "mongo-scan",
> "@id" : 3,
> "mongoScanSpec" : {
> "dbName" : "review_syn",
> "collectionName" : "unshard",
> "filters" : null
> },
> "storage" : {
> "type" : "mongo",
> "connection" : "mongodb://se4.dmz:27017",
> "enabled" : true
> },
> "columns" : [ "`*`" ],
> "cost" : 625000.0
> }, {
> "pop" : "limit",
> "@id" : 2,
> "child" : 3,
> "first" : 0,
> "last" : 2,
> "initialAllocation" : 1000000,
> "maxAllocation" : 10000000000,
> "cost" : 625000.0
> }, {
> "pop" : "selection-vector-remover",
> "@id" : 1,
> "child" : 2,
> "initialAllocation" : 1000000,
> "maxAllocation" : 10000000000,
> "cost" : 625000.0
> }, {
> "pop" : "screen",
> "@id" : 0,
> "child" : 1,
> "initialAllocation" : 1000000,
> "maxAllocation" : 10000000000,
> "cost" : 625000.0
> } ]
> } |
> +------------+------------+
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)