combining the results of two queries (union) before grouping (derived grouping / re-grouping)

2015-07-20 Thread Stefán Baxter
Hi, Does Drill support grouping on "post union" result sets (derived)? I'm fetching data from two sources and currently all groups, that can be found in both sets, are twice, understandably with different counts etc., in the final output. Regards, -Stefan

Re: combining the results of two queries (union) before grouping (derived grouping / re-grouping)

2015-07-20 Thread Stefán Baxter
Hi, I used the With clause to achieve this, thanks. -Stefan On Mon, Jul 20, 2015 at 8:34 PM, Stefán Baxter wrote: > Hi, > > Does Drill support grouping on "post union" result sets (derived)? > > I'm fetching data from two sources and currently all groups, that can be > found in both sets, ar