[
https://issues.apache.org/jira/browse/DRILL-4064?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Nathan Griffith updated DRILL-4064:
-----------------------------------
Description:
Querying works as intended if the database is unsharded.
In my scenarios the database's shard key is not hashed, and is set to mongo's
"_id" key.
Queries work correctly on a sharded database imported from 268M of tweet JSON,
but fail to return rows on a sharded database imported from 218M of data
structured like:
{code}
{
"data0":"an entry",
"data1":"another entry",
"data2":"whoah another"
}
{
"data0":"an entry",
"data1":"another entry",
"data2":"whoah another"
}
{
"data0":"an entry",
"data1":"another entry",
"data2":"whoah another"
}
{
"data0":"an entry",
"data1":"another entry",
"data2":"whoah another"
}
{code}
was:
Querying works as intended if the database is unsharded.
In my scenarios the database's shard key is not hashed, and is set to mongo's
"_id" key.
> Querying a sharded MongoDB database sometimes returns zero rows
> ---------------------------------------------------------------
>
> Key: DRILL-4064
> URL: https://issues.apache.org/jira/browse/DRILL-4064
> Project: Apache Drill
> Issue Type: Bug
> Components: Storage - MongoDB
> Affects Versions: 1.3.0
> Environment: Linux cluster
> Reporter: Nathan Griffith
> Labels: cluster, database, mongodb, sharding
>
> Querying works as intended if the database is unsharded.
> In my scenarios the database's shard key is not hashed, and is set to mongo's
> "_id" key.
> Queries work correctly on a sharded database imported from 268M of tweet
> JSON, but fail to return rows on a sharded database imported from 218M of
> data structured like:
> {code}
> {
> "data0":"an entry",
> "data1":"another entry",
> "data2":"whoah another"
> }
> {
> "data0":"an entry",
> "data1":"another entry",
> "data2":"whoah another"
> }
> {
> "data0":"an entry",
> "data1":"another entry",
> "data2":"whoah another"
> }
> {
> "data0":"an entry",
> "data1":"another entry",
> "data2":"whoah another"
> }
> {code}
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
