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)
