Re: Mongo query speed

2015-05-05 Thread Hanifi Gunes
I know there was recently a patch around Mongo slowness with regards to a bug in the reader; however, the querying is still fairly slow when compared to Mongo's aggregation framework itself (in our tests 5-10 times slower). - What kind of queries are you running? I would not be surprised if Drill w

Re: Reset/delete storage plugins (file)?

2015-05-05 Thread Abhishek Girish
Hey Minnow, I'm not sure what caused the corruption (if any). You could take a look at the logs and double check if it is indeed a storage plug-in issue. Storage plugins are persisted in ZooKeeper. If you'd like to take a look, navigate inside your ZooKeeper install location and run the following

Mongo query speed

2015-05-05 Thread Adam Gilmore
Hi guys, I know there was recently a patch around Mongo slowness with regards to a bug in the reader; however, the querying is still fairly slow when compared to Mongo's aggregation framework itself (in our tests 5-10 times slower). My guess is this is due to the fact we serialize BSON to JSON an

Reset/delete storage plugins (file)?

2015-05-05 Thread Minnow Noir
After upgrading to 0.9 today and then later editing my storage plugins, I have been unable to start drill. I was able to use drill 0.9 for several hours, but then used the web app to edit the storage plugins to point to a new directory. The update button did nothing when I clicked it, despite try

Re: How to deploy Drill to achieve optimal performance

2015-05-05 Thread Steven Phillips
It would be helpful if you could post the profile for the query somewhere, or send it directly to me as an attachment (since attachments won't post to the mailing list). To get the profile, go to the profile page in the Web UI: http://drill.apache.org/docs/monitoring-and-canceling-queries-in-the-

Hangout happening now!

2015-05-05 Thread Jason Altekruse
If you have some time, join us for our weekly hangout to talk about what is happening in the Drill comminity, everyone is welcome. Stop in to introduce yourself! https://plus.google.com/hangouts/_/event/ci4rdiju8bv04a64efj5fedd0lc

Cassandra backend

2015-05-05 Thread Michael Andrews
Is it possible to use a Cassandra keyspace/table as a data source for Drill? If so, could you please point me to the documentation on how to configure it?

Re: How to deploy Drill to achieve optimal performance

2015-05-05 Thread Ted Dunning
George, That sounds much too slow. Can you provide some samples of the data and queries? How about actual data counts? Millioins? hundreds of millions? On Tue, May 5, 2015 at 8:54 AM, George Lu wrote: > Hi all, > > These days, I am trying Drill to see whether Drill fits the realtime/nea

Re: Questions on drill execution

2015-05-05 Thread Ted Dunning
Cool! On Tue, May 5, 2015 at 3:39 AM, Tomer Shiran wrote: > http://drill.apache.org/docs/drill-introduction/#videos > > > > > On May 4, 2015, at 3:10 PM, Ted Dunning wrote: > > > > Is that video linked from the web site? Looks like a really great > resource. > > > > > > > >> On Mon, May 4, 2

Re: Questions on drill execution

2015-05-05 Thread George Lu
Thanks all! George Lu On Tue, May 5, 2015 at 10:39 AM, Tomer Shiran wrote: > http://drill.apache.org/docs/drill-introduction/#videos > > > > > On May 4, 2015, at 3:10 PM, Ted Dunning wrote: > > > > Is that video linked from the web site? Looks like a really great > resource. > > > > > > > >>

How to deploy Drill to achieve optimal performance

2015-05-05 Thread George Lu
Hi all, These days, I am trying Drill to see whether Drill fits the realtime/near realtime interactive queries requirement. I have a HBase server, underlying HDFS contains three data nodes, and I deployed 7 Drill nodes within the cluster. I have several million records in the HBase table and I iss