drill-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Piotr Sokólski...@pyetras.com>
Subject Re: Drill logical plan optimization
Date Thu, 28 May 2015 23:11:18 GMT
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 <rsingh@maprtech.com (mailto:rsingh@maprtech.com)>
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 <skatkam@maprtech.com (mailto:skatkam@maprtech.com)>
> >  
> > 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 <rsingh@maprtech.com (mailto:rsingh@maprtech.com)>
> > 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
> > > >  
> > >  
> >  
> >  
>  
>  
>  



Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message