[
https://issues.apache.org/jira/browse/DRILL-3505?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14974628#comment-14974628
]
ASF GitHub Bot commented on DRILL-3505:
---------------------------------------
Github user asfgit closed the pull request at:
https://github.com/apache/drill/pull/210
> MongoDB _id is returned as null when t.*, t._id is used in the projection
> --------------------------------------------------------------------------
>
> Key: DRILL-3505
> URL: https://issues.apache.org/jira/browse/DRILL-3505
> Project: Apache Drill
> Issue Type: Bug
> Components: Storage - MongoDB
> Affects Versions: 1.1.0
> Environment: Drill 1.1 Stand alone
> Java 8 OSX
> MongoDB 3.0.4
> Reporter: Tugdual Grall
> Priority: Minor
> Fix For: Future
>
>
> By default, and choice of implementation the _id is not visible when using
> {code}
> select * from mongo.db.collection c
> {code}
> and this is OK
> However, if I want to return the _id I need to specify it in the projection
> {code}
> select c._id , c.name from mongo.db.collection c
> {code}
> but if I want "all the column" I would like to be able to write:
> {code}
> select c._id , c.* from mongo.db.collection c
> {code}
> but this return "NULL" for the _id column
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
