drill-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Jacques Nadeau (JIRA)" <j...@apache.org>
Subject [jira] [Resolved] (DRILL-1752) Drill cluster returns error when querying Mongo shards on an unsharded collection
Date Mon, 02 Nov 2015 02:57:27 GMT

     [ https://issues.apache.org/jira/browse/DRILL-1752?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]

Jacques Nadeau resolved DRILL-1752.
-----------------------------------
    Resolution: Fixed

Fixed in ce593eb4c1dc5388787f0896f8845c9b0bc5d2e8

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

Mime
View raw message