setting an administrator

2017-05-04 Thread Knapp, Michael
Hi, I am trying to set drill administrators but it’s just not working. I have setup a custom authenticator that uses a backend database for authentication, and that is working. The only problem is I am a “user” not an administrator, leaving me essentially powerless and drill useless. First,

Re: Drill query are stuck in ENQUEUED mode

2017-05-04 Thread Paul Rogers
Hi All, Looks like queues are enabled. The numbers used for the queue are cost which are only very lightly related to your row count. Cost is in what I call “planning units”: units that make sense to produce good plans, but which don’t directly map to real-world unit such as rows, memory or tim

Re: Drill query are stuck in ENQUEUED mode

2017-05-04 Thread Kunal Khatua
What does the jstack command (located in the same dir as the java executable) say when a query is hung? Also, what is the JStack when the Drillbit is running with the exec.queue.enable=FALSE ? From: jasbir.s...@accenture.com Sent: Thursday, May 4, 2017 5:52:43

RE: Drill query are stuck in ENQUEUED mode

2017-05-04 Thread jasbir.sing
Hi, Thanks for the updates. Just want to update you that we are already following this parameter. Value of below parameters are - 1. exec.queue.enable = TRUE 2. exec.queue.large = 10 (Default) 3. exec.queue.small = 100 (Default) 4. exec.queue.threshold = 3000(Default) Exec.queue.timeout_mil

Re: Parquet, Arrow, and Drill Roadmap

2017-05-04 Thread John Omernik
I've created a JIRA on this request. The idea here being some higher level descriptions of these projects (I included Calcite in the JIRA too), what they do for the project, what the current state of integration is, what options we have for future states, and what benefits those future states bring

AW: Quoting queries

2017-05-04 Thread Lane David (ST-ESS/MKP3.2)
Hi Kunal, wow I never thought of that with the comments but it makes perfect sense. Thanks! I looked for a similar setting in intellij but couldn't find one so have filed a bug. I think it would be helpful to others to put the info below onto the page https://drill.apache.org/docs/using-jdbc-wi