how much memory have you set for planner ? On Fri, Mar 3, 2017 at 5:06 PM, PROJJWAL SAHA <proj.s...@gmail.com> wrote:
> Hello all, > > I am quering select * from dfs.xxx where yyy (filter condition) > > I am using dfs storage plugin that comes out of the box from drill on a > 1GB file, local to the drill cluster. > The 1GB file is split into 10 files of 100 MB each. > As expected I see 11 minor and 2 major fagments. > The drill cluster is 5 nodes cluster with 4 cores, 32 GB each. > > One observation is that the query plan time is more than 30 seconds. I ran > the explain plan query to validate this. > The query execution time is 2 secs. > total time taken is 32secs > > I wanted to understand how can i minimise the query plan time. Suggestions > ? > Is the time taken described above expected ? > Attached is result from explain plan query > > Regards, > Projjwal > > -- Nitin Pawar