Re: Temporary table issue

gt; From: Arina Yelchiyeva [mailto:arina.yelchiy...@gmail.com] > Sent: Wednesday, April 05, 2017 11:42 PM > To: user <user@drill.apache.org> > Cc: d...@drill.apache.org > Subject: Re: Temporary table issue > > HI Jasbir, > > may be union all and values(1) can help you. > >

RE: Temporary table issue

- From: Arina Yelchiyeva [mailto:arina.yelchiy...@gmail.com] Sent: Wednesday, April 05, 2017 11:42 PM To: user <user@drill.apache.org> Cc: d...@drill.apache.org Subject: Re: Temporary table issue HI Jasbir, may be union all and values(1) can help you. Example: create temporary table t1 as

Re: Temporary table issue

HI Jasbir, may be union all and values(1) can help you. Example: create temporary table t1 as select i1, i2 from ( select 0 as i1, 5 as i2 from (values(1)) union all select 5 as i1, 10 as i2 from (values(1))); Kind regards Arina On Wed, Apr 5, 2017 at 7:31 PM,