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

Querying a sharded MongoDB database sometimes returns zero rows

    XMLWordPrintableJSON

    Details

      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:

      {
        "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"
      }
      

        Attachments

          Activity

            People

            • Assignee:
              Unassigned
              Reporter:
              ngriffith Nathan Griffith
            • Votes:
              1 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

              • Created:
                Updated: