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

Attach filesAttach ScreenshotAdd voteVotersWatch issueWatchersCreate sub-taskLinkCloneUpdate Comment AuthorReplace String in CommentUpdate Comment VisibilityDelete Comments
    XMLWordPrintableJSON

Details

    • Bug
    • Status: Open
    • Major
    • Resolution: Unresolved
    • 1.3.0
    • None
    • Storage - MongoDB
    • None
    • 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

          This comment will be Viewable by All Users Viewable by All Users
          Cancel

          People

            jaltekruse Jason Altekruse
            ITDonald Yuqing Tang

            Dates

              Created:
              Updated:

              Slack

                Issue deployment