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

["B Anil Kumar (JIRA)" <ji...@apache.org>]

B Anil Kumar created DRILL-1692:
-----------------------------------

             Summary: 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


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)