It seems, all the time is being spent on query's start, not the execution.
On Sun, Feb 28, 2016 at 8:54 PM, Rifat Mahmud wrote:
> Here is the json profile of the query: http://pastebin.com/tqang1Y0
> Attached the screen shot of the query profile web view too.
> I am using everything in default c
Here is the json profile of the query: http://pastebin.com/tqang1Y0
Attached the screen shot of the query profile web view too.
I am using everything in default configuration for apache-drill-1.5.0, just
changed the MongoDB location from localhost to the remote IP in the storage
configuration.
On
Can you share what the profile looks like? Where is the time being spent?
Unless something is really wrong (or these are gigabyte sized records), I'm
guessing there is a configuration issue or bug you are hitting.
--
Jacques Nadeau
CTO and Co-Founder, Dremio
On Sun, Feb 28, 2016 at 12:04 AM, Rif
I am running embedded drill on a single 8 core, 16 GB RAM machine. I am
performing a join query(select * from t1, t2 where t1.a = t2.b) on a remote
MongoDB database. The tables(collections) contain 2 and 4 rows(documents)
only. The query is taking 27 seconds.
Can the query be made faster by using d
