drill-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "B Anil Kumar (JIRA)" <j...@apache.org>
Subject [jira] [Created] (DRILL-1692) select * on mongo join returns invalid results
Date Wed, 12 Nov 2014 06:10:34 GMT
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)

Mime
View raw message