Re: [Drill-Questions] Speed difference between GZ and BZ2

Ok so query planning took less than one second in both the aggregate queries. Looks like most of the time is getting spent in query execution. On Thu, Aug 4, 2016 at 5:13 PM, Shankar Mane wrote: > Please find the query plan for both queries. FYI: I am not seeing >

Re: Distributed Mode In Window Operating System

As far as I know, all of our deployments of Drill are on Linux platform. The following blog shows how to deploy Drill on Azure, which may provide some insights: https://blogs.msdn.microsoft.com/data_otaku/2016/05/27/deploying-apache-drill-on-azure/ On Thu, Aug 4, 2016 at 12:25 AM,

Re: [Drill-Issues] Drill-1.6.0: Drillbit not starting

Can you check if there are any errors in the drillbit.out file? This file should be in the same directory as the log file. Thank you, Sudheesh > On Aug 4, 2016, at 4:25 AM, Shankar Mane wrote: > > I am getting this error infrequently. Most of the time drill starts

Re: S3 bucket configuration security error on the storage plugin

Also if you want to put the key in the plugin config the syntax is as follows "config": { "fs.s3a.access.key": "", "fs.s3a.secret.key": "" }, --Andries > On Aug 4, 2016, at 7:55 AM, Andries Engelbrecht > wrote: > > You have to put the actual ID and

Re: S3 bucket configuration security error on the storage plugin

You have to put the actual ID and KEY in the storage plugin (not recommended per se if you don't have the WebUI secured). Or you can edit the core-site.xml file in the drill conf directory to add the s3a ID and KEY there. Also use s3a not s3 in the later versions of Drill.

Re: Drill on Azure

Thanks Neerja. On Aug 3, 2016 9:12 AM, "Santosh Kulkarni" wrote: > That's great! Thanks Neeraja. > > On Tue, Aug 2, 2016 at 6:18 PM, Neeraja Rentachintala < > nrentachint...@maprtech.com> wrote: > > > Just happened to see this great set of comprehensive

Re: [Drill-Questions] Speed difference between GZ and BZ2

Please find the query plan for both queries. FYI: I am not seeing any planning difference between these 2 queries except Cost. / Query on GZ / 0: jdbc:drill:> explain plan for select channelid, count(serverTime) from

[Drill-Issues] Drill-1.6.0: Drillbit not starting

I am getting this error infrequently. Most of the time drill starts normally and sometimes this gives below error. I am running drill 1.6.0 in cluster mode. ZK has also setup. Could some one please explain where the issue is ? 2016-08-04 03:45:15,870 [main] INFO

Re: [Drill-Questions] Speed difference between GZ and BZ2

Can you please do an explain plan over the two aggregate queries. That way we can know where most of the time is being spent, is it in the query planning phase or is it query execution that is taking longer. Please share the query plans and the time taken for those explain plan statements. On

Distributed Mode In Window Operating System

Hello        I am using Latest version of Apache Drill (1.7). I am using Window 10 OS. I want to start drill in Distributed Mode Window. Please tell me how to use Drill in Distributed Mode?. What are the changes required to change in Drill-config file.? Where to get cluster-id? and the command

S3 bucket configuration security error on the storage plugin

Hi, I am trying to configure an s3 bucket and I am getting this error. Can any one help me org.apache.drill.common.exceptions.UserRemoteException: SYSTEM ERROR: IllegalArgumentException: AWS Access Key ID and Secret Access Key must be specified as the username or password (respectively) of a