1.16 is slated to come out in a couple of months. But if the feature makes it in sooner, you can always build Drill from the master branch if you cnanot wait until the release.
~ Kunal On 2/11/2019 5:32:55 PM, Nai Yan. <zhaon...@gmail.com> wrote: Thank you for you information. That's great. Hope for v 1.16. By the way, when will it come out? Nai Yan From: Kunal Khatua Date: 2019-02-12 01:56 To: dev@drill.apache.org Subject: Re: Performance issue when query from web console. Hi Nai Yan The issue you are seeing is because when interacting through the WebUI, there is an added step of converting your query's resultset into a JSON document and that needs to be then sent back to your browser for rendering as a table.Of course, browsers themselves are usually single threaded (per tab), so that will also consume time in rendering the JSON as a table. If response time is critical, using a JDBC driver-based tool like SQuirreL or DBeaver is recommended. If you prefer the web-browser, a good question to ask yourself is whether you REALLY need the entire, say 10,000 records, when all you will actually go through on the browser is 1000 or so. If you don't intend to read all of the data, a simple way is to wrap your query with a 'LIMIT' clause. We're currently working on adding a feature that would do this for you automatically, so that WebUI's get more responsive and will be part of 1.16. ~ Kunal On 2/11/2019 6:51:32 AM, Charles Givre wrote: I would definitely recommend updating to the latest version. — C > On Feb 11, 2019, at 09:48, Nai Yan. wrote: > > Thanks, Charles. > If there's any SIGNIFICANT improvement since v 1.14 (versus v 1.15)? I have > been thinking it's a configuration issue. > > Thanks again! > > > > Nai Yan > > > From: Charles Givre > Date: 2019-02-11 10:21 > To: dev > Subject: Re: Performance issue when query from web console. > Hi Nai, > First of all, Drill is up to version 1.15. There have been SIGNIFICANT > improvements in Drill’s performance since v 1.4 and I would strongly > recommend you upgrade to the most current version before you start trying to > debug. > Best, > — C > > >> On Feb 10, 2019, at 20:37, Nai Yan. wrote: >> >> Greetings, >> When we are trying Drill, we have encountered performance issue when query >> from web console. From backend, the resultset already returned (to foreman), >> however, it will take unreasonable time (in general need to take 5 ~ 10 >> seconds more) to display on the web. We are using Drill 1.4 and embeded mode. >> Any advice is appreciated! >> >> >> >> Nai Yan >> >
