[jira] [Updated] (DRILL-1752) Drill cluster returns error when querying Mongo shards on an unsharded collection

2015-11-01 Thread Jacques Nadeau (JIRA) 

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

Jacques Nadeau updated DRILL-1752:
--
Fix Version/s: (was: Future)
   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: 1.3.0
>
> 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-00Screen
> 00-01  SelectionVectorRemover
> 00-02Limit(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" : 100,
> "maxAllocation" : 100,
> "cost" : 625000.0
>   }, {
> "pop" : "selection-vector-remover",
> "@id" : 1,
> "child" : 2,
> "initialAllocation" : 100,
> "maxAllocation" : 100,
> "cost" : 625000.0
>   }, {
> "pop" : "screen",
> "@id" : 0,
> "child" : 1,
> "initialAllocation" : 100,
> "maxAllocation" : 100,
> "cost" : 625000.0
>   } ]
> } |
> +++



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

[jira] [Updated] (DRILL-1752) Drill cluster returns error when querying Mongo shards on an unsharded collection

2015-07-02 Thread Jason Altekruse (JIRA) 

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

Jason Altekruse updated DRILL-1752:
---
Assignee: Jacques Nadeau  (was: Jason Altekruse)

> 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
>Assignee: Jacques Nadeau
>Priority: Minor
> Fix For: 1.2.0
>
> 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-00Screen
> 00-01  SelectionVectorRemover
> 00-02Limit(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" : 100,
> "maxAllocation" : 100,
> "cost" : 625000.0
>   }, {
> "pop" : "selection-vector-remover",
> "@id" : 1,
> "child" : 2,
> "initialAllocation" : 100,
> "maxAllocation" : 100,
> "cost" : 625000.0
>   }, {
> "pop" : "screen",
> "@id" : 0,
> "child" : 1,
> "initialAllocation" : 100,
> "maxAllocation" : 100,
> "cost" : 625000.0
>   } ]
> } |
> +++



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

[jira] [Updated] (DRILL-1752) Drill cluster returns error when querying Mongo shards on an unsharded collection

2015-05-05 Thread Jacques Nadeau (JIRA) 

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

Jacques Nadeau updated DRILL-1752:
--
Fix Version/s: (was: 1.0.0)
   1.2.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
>Assignee: Jason Altekruse
>Priority: Minor
> Fix For: 1.2.0
>
> 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-00Screen
> 00-01  SelectionVectorRemover
> 00-02Limit(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" : 100,
> "maxAllocation" : 100,
> "cost" : 625000.0
>   }, {
> "pop" : "selection-vector-remover",
> "@id" : 1,
> "child" : 2,
> "initialAllocation" : 100,
> "maxAllocation" : 100,
> "cost" : 625000.0
>   }, {
> "pop" : "screen",
> "@id" : 0,
> "child" : 1,
> "initialAllocation" : 100,
> "maxAllocation" : 100,
> "cost" : 625000.0
>   } ]
> } |
> +++



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

[jira] [Updated] (DRILL-1752) Drill cluster returns error when querying Mongo shards on an unsharded collection

2015-04-15 Thread Jason Altekruse (JIRA) 

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

Jason Altekruse updated DRILL-1752:
---
Fix Version/s: (was: 0.9.0)
   1.0.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
>Assignee: Jason Altekruse
>Priority: Minor
> Fix For: 1.0.0
>
> 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-00Screen
> 00-01  SelectionVectorRemover
> 00-02Limit(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" : 100,
> "maxAllocation" : 100,
> "cost" : 625000.0
>   }, {
> "pop" : "selection-vector-remover",
> "@id" : 1,
> "child" : 2,
> "initialAllocation" : 100,
> "maxAllocation" : 100,
> "cost" : 625000.0
>   }, {
> "pop" : "screen",
> "@id" : 0,
> "child" : 1,
> "initialAllocation" : 100,
> "maxAllocation" : 100,
> "cost" : 625000.0
>   } ]
> } |
> +++



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

[jira] [Updated] (DRILL-1752) Drill cluster returns error when querying Mongo shards on an unsharded collection

2015-04-01 Thread Chris Westin (JIRA) 

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

Chris Westin updated DRILL-1752:

Fix Version/s: (was: Future)

> 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
>Assignee: Jason Altekruse
>Priority: Minor
> Fix For: 0.9.0
>
> 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-00Screen
> 00-01  SelectionVectorRemover
> 00-02Limit(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" : 100,
> "maxAllocation" : 100,
> "cost" : 625000.0
>   }, {
> "pop" : "selection-vector-remover",
> "@id" : 1,
> "child" : 2,
> "initialAllocation" : 100,
> "maxAllocation" : 100,
> "cost" : 625000.0
>   }, {
> "pop" : "screen",
> "@id" : 0,
> "child" : 1,
> "initialAllocation" : 100,
> "maxAllocation" : 100,
> "cost" : 625000.0
>   } ]
> } |
> +++



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

[jira] [Updated] (DRILL-1752) Drill cluster returns error when querying Mongo shards on an unsharded collection

2015-01-26 Thread Jason Altekruse (JIRA) 

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

Jason Altekruse updated DRILL-1752:
---
Fix Version/s: 0.9.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: 0.9.0, 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-00Screen
> 00-01  SelectionVectorRemover
> 00-02Limit(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" : 100,
> "maxAllocation" : 100,
> "cost" : 625000.0
>   }, {
> "pop" : "selection-vector-remover",
> "@id" : 1,
> "child" : 2,
> "initialAllocation" : 100,
> "maxAllocation" : 100,
> "cost" : 625000.0
>   }, {
> "pop" : "screen",
> "@id" : 0,
> "child" : 1,
> "initialAllocation" : 100,
> "maxAllocation" : 100,
> "cost" : 625000.0
>   } ]
> } |
> +++



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

[jira] [Updated] (DRILL-1752) Drill cluster returns error when querying Mongo shards on an unsharded collection

2015-01-11 Thread Bhallamudi Venkata Siva Kamesh (JIRA) 

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

Bhallamudi Venkata Siva Kamesh updated DRILL-1752:
--
Attachment: DRILL-1752.patch

Attaching the patch for this issue. Tested the patch in the following scenarios
- Unsharded collection in a shared database in sharded environment.
- Unsharded database in sharded environment.

Please review the patch.

> 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
> 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-00Screen
> 00-01  SelectionVectorRemover
> 00-02Limit(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" : 100,
> "maxAllocation" : 100,
> "cost" : 625000.0
>   }, {
> "pop" : "selection-vector-remover",
> "@id" : 1,
> "child" : 2,
> "initialAllocation" : 100,
> "maxAllocation" : 100,
> "cost" : 625000.0
>   }, {
> "pop" : "screen",
> "@id" : 0,
> "child" : 1,
> "initialAllocation" : 100,
> "maxAllocation" : 100,
> "cost" : 625000.0
>   } ]
> } |
> +++



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

[jira] [Updated] (DRILL-1752) Drill cluster returns error when querying Mongo shards on an unsharded collection

2015-01-04 Thread Jacques Nadeau (JIRA) 

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

Jacques Nadeau updated DRILL-1752:
--
Fix Version/s: Future
 Priority: Minor  (was: Major)

> 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
> Environment: Drill cluster on nodes with Mongo Shards
>Reporter: Andries Engelbrecht
>Priority: Minor
> Fix For: Future
>
>
> 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-00Screen
> 00-01  SelectionVectorRemover
> 00-02Limit(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" : 100,
> "maxAllocation" : 100,
> "cost" : 625000.0
>   }, {
> "pop" : "selection-vector-remover",
> "@id" : 1,
> "child" : 2,
> "initialAllocation" : 100,
> "maxAllocation" : 100,
> "cost" : 625000.0
>   }, {
> "pop" : "screen",
> "@id" : 0,
> "child" : 1,
> "initialAllocation" : 100,
> "maxAllocation" : 100,
> "cost" : 625000.0
>   } ]
> } |
> +++



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)