What you are looking for is run-time partition pruning instead of compile-time partition pruning. AFAIK Drill currently supports compile-time partition pruning.
On Thu, Jul 12, 2018 at 5:06 PM, Gauri Srinivas <[email protected]> wrote: > Hi, > > I'm trying to use drill on data partitioned by day. As I understand it, the > performance tuning works by only querying the directories specified in the > where clause - in this case a query specifying the date. > > Is there a performant way to query the partitioned data based on the > results of a join? > > When I explain the query plan, it seems to be still querying all > directories rather than just the day from the output of the joined table. >
