Re: [HANGOUT] Topics for 2017-02-21

2017-02-20 Thread Charles Givre
I was also wondering what is the status of the ElasticSearch plugin? Thanks, — C > On Feb 20, 2017, at 14:49, Shankar Mane wrote: > > any plans to support Hive 2.x line? > > On 21-Feb-2017 12:40 AM, "Paul Rogers" wrote: > >> Hi All, >> >> Our

Re: [HANGOUT] Topics for 2017-02-21

2017-02-20 Thread Shankar Mane
any plans to support Hive 2.x line? On 21-Feb-2017 12:40 AM, "Paul Rogers" wrote: > Hi All, > > Our bi-weekly hangout is tomorrow (2017-02-21, 10 AM PT). Please respond > with suggested topics. We will also ask for additional topics at the > beginning of the hangout. > > One

RE: Query on performance using Drill and Amazon s3.

2017-02-20 Thread Chetan Kothari
My query is generic What I am asking is that does drill fire query on target data store and only fetch result or does it fetch data and then fire query ?   Regards Chetan   -Original Message- From: Nitin Pawar [mailto:nitinpawar...@gmail.com] Sent: Monday, February 20, 2017 8:14 PM

RE: Query on performance using Drill and Amazon s3.

2017-02-20 Thread Shankar Mane
1. how much memory have u configured for drill? 2. what about network bandwidth between your s3 and cluster? On 20-Feb-2017 8:14 PM, "Nitin Pawar" wrote: > Hi chetan, > > Projjwal has the issue. Me too asked the same question > > On Feb 20, 2017 7:56 PM, "Chetan

RE: Query on performance using Drill and Amazon s3.

2017-02-20 Thread Nitin Pawar
Hi chetan, Projjwal has the issue. Me too asked the same question On Feb 20, 2017 7:56 PM, "Chetan Kothari" wrote: > Hi Nitin > > > > Where does the query execute? > > Does Drill execute query on AWS and fetch results to be displayed? > > > > Regards > > Chetan > > >

RE: Query on performance using Drill and Amazon s3.

2017-02-20 Thread Chetan Kothari
Hi Nitin   Where does the query execute? Does Drill execute query on AWS and fetch results to be displayed?   Regards Chetan   -Original Message- From: Nitin Pawar [mailto:nitinpawar...@gmail.com] Sent: Monday, February 20, 2017 6:19 PM To: user@drill.apache.org Subject: Re: Query

Google Interactive Charts

2017-02-20 Thread Sanjiv Kumar C
-- Thanks & Regards * Sanjiv Kumar*

Re: Query on performance using Drill and Amazon s3.

2017-02-20 Thread Nitin Pawar
how are you doing select * .. using drill UI or sqlline? where are you running it from ? is the drill hosted in aws or on your local machine? I think majority of the time is spent on displaying the result set instead of querying the file if the drill server is on aws. If the drill server is local

Query on performance using Drill and Amazon s3.

2017-02-20 Thread PROJJWAL SAHA
Hello all, I am using 1GB data in the form of .tsv file, stored in Amazon S3 using Drill 1.8. I am using default configurations of Drill using S3 storage plugin coming out of the box. The drill bits are configured on a 5 node cluster with 32GB RAM and 4VCPU. I see that select * from xxx; query