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 Sun, Feb 28, 2016 at 3:16 PM, Jacques Nadeau <[email protected]> wrote: > 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, Rifat Mahmud <[email protected]> wrote: > > > 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 drill with Zookeeper cluster? And > if > > the answer is yes, by how many factors? Please, elaborate about the > > real-timeliness of Apache Drill. > > >
