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]> 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]> > 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]> > 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 > >> > >> > > > >
