Re: Unable to setup hive plugin in Drill 1.11.0

2018-02-12 Thread Anup Tiwari
Also forgot to mention that we are using Drill 1.10 with 2.1 on our one of clusters and it is working properly. Just the change is in Hadoop Version and we are using MySQL community version 5.7.16. Please find below details :- Apache Drill Version : 1.10.0MySQL Community :5.7.16Apache Hive :

Re: Unable to setup hive plugin in Drill 1.11.0

2018-02-12 Thread Anup Tiwari
Hi Sorabh, Thanks for reply. We are using below combination :- Apache Drill Version : 1.11.0MySQL Percona : 5.6.35-81.0Apache Hive : 2.1.1 Apache Hadoop : 2.8.0 As you have mentioned that Drill 1.11 with hive 2.1 combination is not supported so do we have any link from where i can get an idea of

Re: Drill on AWS

2018-02-12 Thread Francis McGregor-Macdonald
Hi Brandon, I created a quick gist, hopefully it comes across clearly. https://gist.github.com/fmcmac/a35738376d111fdca45057bd0fb4c79e Any improvements greatly appreciated and happy to update it based on feedback. Regards, Francis On Tue, Feb 13, 2018 at 11:11 AM, Brandon Gmail

Re: Drill on AWS

2018-02-12 Thread Brandon Gmail
Hey Francis, Yes please! That option will work. I would appreciate any documentation you might have. > On Feb 12, 2018, at 2:51 PM, Francis McGregor-Macdonald > wrote: > > Hi Brandon, > > I recently went through this challenge and found it easier in the end to > install

Re: Drill on AWS

2018-02-12 Thread Francis McGregor-Macdonald
Hi Brandon, I recently went through this challenge and found it easier in the end to install SSM with a bootstrap and then use ssm.send_command with AWS-RunRemoteScript once the cluster was in place. This way I can use the AWS installed Zookeeper. The remote script is pretty much a facsimile of

Re: Documentation Update for Drill-4286

2018-02-12 Thread Bridget Bevens
Hi John, I have not documented this feature yet, but it's on my to-do list. I believe there is still some testing in progress. I'll be sure to include the content in the Configure section. If time permits, I'll work on creating an Administer Drill section. Thanks, Bridget

Re: Documentation Update for Drill-4286

2018-02-12 Thread John Omernik
Ah cool. Thanks for the update! On Mon, Feb 12, 2018 at 3:14 PM, Kunal Khatua wrote: > This made it into Drill 1.12, but there is some additional work to be > done. We are hoping to have it completed in time for 1.13 release, along > with documentation. > > -Original

RE: Documentation Update for Drill-4286

2018-02-12 Thread Kunal Khatua
This made it into Drill 1.12, but there is some additional work to be done. We are hoping to have it completed in time for 1.13 release, along with documentation. -Original Message- From: John Omernik [mailto:j...@omernik.com] Sent: Monday, February 12, 2018 12:44 PM To: user

Documentation Update for Drill-4286

2018-02-12 Thread John Omernik
I see in 1.12 this feature was added("Have an ability to put server in quiescent mode of operation") https://issues.apache.org/jira/browse/DRILL-4286 Was the documentation updated? I couldn't find it. Perhaps we need a new section on the Drill Docs page "Administrate Drill" for this and other

Drill on AWS

2018-02-12 Thread Brandon Gmail
Does anyone have an updated bootstrap script for drill on AWS EMR? Their repository is over 3 years old, and I’m flailing at figuring this out on my own. Any help would be appreciated. Thanks, Brandon

Re: Unable to setup hive plugin in Drill 1.11.0

2018-02-12 Thread Sorabh Hamirwasia
Hi Anup, >From the stack trace which you have shared it looks like you are trying to use >Hive2.1 with drill-1.11.0. This s not a supported combination[1]. There is a >PR[2] open for it in 1.13 though. Also from the stack trace it's pointing towards an invalid field in HiveConf

Re: Unable to setup hive plugin in Drill 1.11.0

2018-02-12 Thread Anup Tiwari
I don't know where to look for logs as i have tried multiple time creating hive plugin. But one time i can see below stack is printed in drillbit.log(i don't know if it came due to plugin creation or not as i have tried multiple time but nothing got printed in drillbit.log except below which is

Unable to setup hive plugin in Drill 1.11.0

2018-02-12 Thread Anup Tiwari
Hi All, Please find below information :- Apache Drill Version : 1.11.0MySQL Percona : 5.6.35-81.0Apache Hive : 2.1.1 mysql-connector-java-5.1.44-bin.jar is present in 3rdparty jar Hive Plugin info :- {"type" : "hive","enabled" : true,"configProps" : {   "hive.metastore.uris" :