[jira] [Commented] (DRILL-1692) select * on mongo join returns invalid results

["Jacques Nadeau (JIRA)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/DRILL-1692?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14271206#comment-14271206 ] 

Jacques Nadeau commented on DRILL-1692:
---------------------------------------

There is a bug in * handling in the MongoDB plugin.  Right now, if you query the mongo data:

Data
{code}
{a: 4, b:6}
{code}

Currently
{code}
select * from mongo;
|*|
|{a: 4, b:6}|
{code}

should be:
{code}
select * from mongo;
|a|b|
|4|6|

The first level document map should be translated into the first level of columns in the Drill record.  See the JSONReader to see how it handles the top level of the record.

> select * on mongo join returns invalid results
> ----------------------------------------------
>
>                 Key: DRILL-1692
>                 URL: https://issues.apache.org/jira/browse/DRILL-1692
>             Project: Apache Drill
>          Issue Type: Bug
>          Components: Storage - MongoDB
>    Affects Versions: 0.6.0
>         Environment: select * queries on mongo joins
>            Reporter: B Anil Kumar
>            Assignee: B Anil Kumar
>            Priority: Critical
>             Fix For: 0.8.0
>
>
> select * on mongo joins gives improper results. Need to modify the schema handling logic in the case of 'select *' logic in MongoRecordReader.
> For example when we fire a below query on mongo.employee.`join1` table, the results are as below.
> SELECT  * FROM mongo.employee.`join1` t1 JOIN  mongo.employee.`join1` t2 ON  t1.`employee_id` = t2.`employee_id`
> sample documents in mongo.employee.`join1` table:
> { "employee_id" : 1 , "first_name" : "Anil"} 
> { "employee_id" : 2 , "first_name" : "Kamesh"}
> Results:
> {noformat}
> { "employee_id" : 1 , "first_name" : "Anil"}	{ "employee_id" : 1 , "first_name" : "Anil"}
> { "employee_id" : 1 , "first_name" : "Anil"}	{ "employee_id" : 2 , "first_name" : "Kamesh"}
> { "employee_id" : 2 , "first_name" : "Kamesh"}	{ "employee_id" : 1 , "first_name" : "Anil"}
> { "employee_id" : 2 , "first_name" : "Kamesh"}	{ "employee_id" : 2 , "first_name" : "Kamesh"}
> {noformat}



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)