Uploaded image for project: 'Apache Drill'
  1. Apache Drill
  2. DRILL-4173

Query did not return all documents if collection using a hashed shard key

    XMLWordPrintableJSON

    Details

    • Type: Bug
    • Status: Open
    • Priority: Major
    • Resolution: Unresolved
    • Affects Version/s: 1.3.0
    • Fix Version/s: None
    • Component/s: Storage - MongoDB
    • Labels:
      None
    • Environment:

      Windows 2012

      Description

      MongoDB 3.0.6

      If a collection used a hashed shard key (

      { "shardkey": "hashed" }

      ), queries like "select * from ..." may not return all documents which should be returned from the collection.

      Test Case:
      Create 3 mongos, 3 config, 3 replicaset each with 3 mongod.
      Create one collection with hashed shard key.
      Insert 6 documents to this collection with shard key value 1,2,3,4,5,6
      Do a query select * from ....
      Only 2,3,4 will be returned.

        Attachments

          Activity

            People

            • Assignee:
              jaltekruse Jason Altekruse
              Reporter:
              ITDonald Yuqing Tang
            • Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

              • Created:
                Updated: