[Drill 1.12.0] : Suggestions on Downgrade to 1.11.0  & com.mysql.jdbc.exceptions.jdbc4.CommunicationsException

Hi All, We are getting a lot of different type of issues/error post upgrading from Drill 1.10.0 to 1.12.0 which i am asking on forum as well so just wanted to know whether downgrading to Drill 1.11.0 will help or not? This time we got exception related to mysql connection storage and please note

Re: [Drill 1.12.0] : Suggestions on Downgrade to 1.11.0  & com.mysql.jdbc.exceptions.jdbc4.CommunicationsException

Hi All, We checked our MySQL max number of connections which is set to 200 and i think this might be due to exceeding max number of connections only as right now i can see 89 connections to MySQL. I want to know community's thoughts on this whether i am heading in right direction or not. On

Re: Participate in the Apache Drill Poll on Twitter

Did it. On Mar 16, 2018 5:37 AM, "Saurabh Mahapatra" wrote: > Participate in the Apache Drill Poll and have your voice heard through ONE > vote: https://lnkd.in/gfWWXGd > > >

Re: hive connection as generic jdbc

Hi Asim, You can refer to section 'Modifying and Submitting a Physical Plan to Drill' in https://drill.apache.org/docs/query-plans/. explain plan for select * from `hivejdbc`.`testdb`.`test` { "head" : { "version" : 1, "generator" : { "type" : "ExplainHandler", "info" : "" }, "type" :

Re: hive connection as generic jdbc

Hi Kunal/Arjun, Yeah I tried from view as well but no luck. I need to learn how to execute the physical plan, if any easy way please let me know else I can go through documentation. Thanks to both of you for solving the connection issue though. It will be great if you can update in the same

Re: [Drill 1.9.0] : [CONNECTION ERROR] :- (user client) closed unexpectedly. Drillbit down?

On Fri, Mar 16, 2018 at 8:10 PM, Anup Tiwari wrote: > Hi All, > I was just going through this post and found very good suggestions. > But this issue is still there in Drill 1.12.0 and i can see > https://issues.apache.org/jira/browse/DRILL-4708 is now marked as >

Re: [Drill 1.9.0] : [CONNECTION ERROR] :- (user client) closed unexpectedly. Drillbit down?

Hi All, I was just going through this post and found very good suggestions. But this issue is still there in Drill 1.12.0 and i can see https://issues.apache.org/jira/browse/DRILL-4708 is now marked as resolved in "1.13.0" so i am hoping that this will be fixed in drill 1.13.0. Few things i want

Re: How to get mongo data into saiku using apache drill

For security reasons, the user mailing lists don't allow attachments. You could upload the image to some online file sharing services like GoogleDrive/Dropbox and share the link in the mailing list, along with a description of the setup, etc. On Fri, Mar 16, 2018 at 3:10 AM, Sonu Kumawat

Re: Participate in the Apache Drill Poll on Twitter

Nice. We should have some polls conducted for what Drill is being used for by the community as well. On Thu, Mar 15, 2018 at 9:37 PM, Saurabh Mahapatra < saurabhmahapatr...@gmail.com> wrote: > Participate in the Apache Drill Poll and have your voice heard through ONE > vote:

Re: [Drill 1.12.0] : RESOURCE ERROR: Not enough memory for internal partitioning and fallback mechanism for HashAgg to use unbounded memory is disabled

If you've already set the limit at 4GB, there might be something else going on. We'll take a look at this in more detail, but you shouldn't expect a solution soon. (probably 1.14.0, since 1.13.0 is already on its way out for release). For now, bumping up the limit as you've done, reducing the

Re: Storage plugin for GraphQL

What is the data format? If you have a JDBC driver for that, you should be able to query it. On 2/24/2018 9:01:43 PM, Bremner-Stokes, Glen wrote: Hello all, Not sure if I am posting this correctly so please redirect me if necessary. I have a GraphQL server that

Re: How to get mongo data into saiku using apache drill

There is a video that was released recently: https://www.youtube.com/watch?v=91uufmvnigY I believe that Tom Barber from Spicule is on this mailing list and should be able to help. Thanks, Saurabh On Fri, Mar 16, 2018 at 2:09 PM, Kunal Khatua wrote: > For security reasons,

Re: Storage plugin for GraphQL

Its actually quite interesting, providing an alternative to REST: http://graphql.org/ On Fri, Mar 16, 2018 at 4:02 PM, Kunal Khatua wrote: > What is the data format? > > If you have a JDBC driver for that, you should be able to query it. > > On 2/24/2018 9:01:43 PM,

Re: [Drill 1.12.0] : Suggestions on Downgrade to 1.11.0 & com.mysql.jdbc.exceptions.jdbc4.CommunicationsException

Anyone have any suggestion on this? Makes me wonder if anything changed? On Fri, Mar 16, 2018 at 1:15 AM, Anup Tiwari wrote: > Hi All, > We checked our MySQL max number of connections which is set to 200 and i > think > this might be due to exceeding max number of

Re: [Drill 1.12.0] : RESOURCE ERROR: Not enough memory for internal partitioning and fallback mechanism for HashAgg to use unbounded memory is disabled

Hi Kunal, First of all, thanks for such a good explanation, it really helped me understanding few things.But as you have mentioned that in case of failure "Drillbits capped at around 1.2GB" and suggested to "increase the memory-per-query-per-node from the current 2GB to a higher level". Are you

How to get mongo data into saiku using apache drill

Hi, I am trying to get data from mongo using apache drill in Saiku tool. Right now I am able to get tables from mongo using apache drill but tables are empty. For better understanding please see attached image. Please help me out of this problem ASAP. Thank you