drill-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Rifat Mahmud (JIRA)" <j...@apache.org>
Subject [jira] [Updated] (DRILL-4462) Slow JOIN Query On Remote MongoDB
Date Wed, 02 Mar 2016 05:00:20 GMT

     [ https://issues.apache.org/jira/browse/DRILL-4462?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]

Rifat Mahmud updated DRILL-4462:
--------------------------------
    Description: 
Regardless of the number of collections in the MongoDB database, simple join query, like select
* from t1, t2 where t1.a=t2.b is taking on and around 27 seconds from drill-embedded running
on a single machine.
Here are the profiles:
https://drive.google.com/open?id=0B-J_8-KYz50mZ1NjSzlUUjR3Q0U
https://drive.google.com/open?id=0B-J_8-KYz50mcTFpRmxKOWdfak0

  was:
Regardless of the number of collections in the MongoDB database, simple join query, like select
* from t1, t2 where t1.a=t2.b is taking on and around 27 seconds.
Here are the profiles:
https://drive.google.com/open?id=0B-J_8-KYz50mZ1NjSzlUUjR3Q0U
https://drive.google.com/open?id=0B-J_8-KYz50mcTFpRmxKOWdfak0


> Slow JOIN Query On Remote MongoDB
> ---------------------------------
>
>                 Key: DRILL-4462
>                 URL: https://issues.apache.org/jira/browse/DRILL-4462
>             Project: Apache Drill
>          Issue Type: Bug
>          Components: Client - CLI, Storage - MongoDB
>    Affects Versions: 1.5.0
>            Reporter: Rifat Mahmud
>
> Regardless of the number of collections in the MongoDB database, simple join query, like
select * from t1, t2 where t1.a=t2.b is taking on and around 27 seconds from drill-embedded
running on a single machine.
> Here are the profiles:
> https://drive.google.com/open?id=0B-J_8-KYz50mZ1NjSzlUUjR3Q0U
> https://drive.google.com/open?id=0B-J_8-KYz50mcTFpRmxKOWdfak0



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

Mime
View raw message