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

MongoDB _id is returned as null when t.*, t._id is used in the projection

    XMLWordPrintableJSON

    Details

    • Type: Bug
    • Status: Resolved
    • Priority: Minor
    • Resolution: Fixed
    • Affects Version/s: 1.1.0
    • Fix Version/s: 1.3.0
    • Component/s: Storage - MongoDB
    • Labels:
      None
    • Environment:

      Drill 1.1 Stand alone
      Java 8 OSX
      MongoDB 3.0.4

      Description

      By default, and choice of implementation the _id is not visible when using

      select * from mongo.db.collection c
      

      and this is OK

      However, if I want to return the _id I need to specify it in the projection

      select c._id , c.name from mongo.db.collection c
      

      but if I want "all the column" I would like to be able to write:

      select c._id , c.* from mongo.db.collection c
      

      but this return "NULL" for the _id column

        Attachments

          Activity

            People

            • Assignee:
              Unassigned
              Reporter:
              tgrall Tugdual Grall
            • Votes:
              0 Vote for this issue
              Watchers:
              4 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: