What about the QueryType.LOGICAL parameter of the submit_plan script? Is this broken as well?
-- Piotr Sokólski On Friday 29 May 2015 at 00:29, Jason Altekruse wrote: > Currently Drill does not allow submission of logical plans. I think that > the web interface is out of date and claims you can submit a logical plan, > but this is not correct. We would like to allow for modification of plans > at the logical level, but we just haven't implemented the feature currently. > > Taking a closer look at the code it looks like we have some old code that > will do a very basic conversion from a logical plan to a physical one, but > it sidesteps the standard and maintained physical planning/optimization > process entirely. This will be removed ASAP, because there are planning > changes that take place at the physical planning level that will introduce > a risk of inconsistencies if we run plans submitted through this path. > Hopefully we will be able to add it back soon with proper integration and > the physical planning steps still applying to the logical plan. > > You can try to take a crack at modifying the physical plan, although it is > a little more complexity to manage. > > On Thu, May 28, 2015 at 9:57 AM, Rajkumar Singh <[email protected] > (mailto:[email protected])> wrote: > > > I am looking to optimize the logical query plan so that I can resubmit it > > through the DRILL UI and see the results. > > > > Thanks > > > On May 28, 2015, at 10:23 PM, Sudheesh Katkam <[email protected] > > > (mailto:[email protected])> > > > > wrote: > > > > > > Hi Rajkumar, > > > > > > Here are some links: > > > http://drill.apache.org/docs/performance-tuning-introduction/ < > > > > > > > http://drill.apache.org/docs/performance-tuning-introduction/> > > (Performance Tuning Guide) > > > http://drill.apache.org/docs/query-plans/ < > > > > http://drill.apache.org/docs/query-plans/> > > > > > > Did you mean optimize physical plan? > > > > > > Thanks, > > > Sudheesh > > > > > > > On May 27, 2015, at 11:14 PM, Rajkumar Singh <[email protected] > > > > (mailto:[email protected])> > > wrote: > > > > > > > > Hi > > > > > > > > I am looking for some measures/params to looked upon to optimize the > > drill logical query plan if i want to resubmit it through the Drill UI, > > Could you please points me some docs so that I can go through it. > > > > > > > > Rajkumar Singh > > > > MapR Technologies > > > > > > > > > > > > > >
