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, <[email protected]> wrote: > Hi, > > I want to create temporary table in Apache Drill at runtime and want to > insert few uuid's which user select. It could range from 5000 to 100,000. > Using CTTAS if I do it requires data from some file whereas here I want to > store it using a collection. > > Is this possible using Apache Drill? > > Regards, > Jasbir Singh > > ________________________________ > > This message is for the designated recipient only and may contain > privileged, proprietary, or otherwise confidential information. If you have > received it in error, please notify the sender immediately and delete the > original. Any other use of the e-mail by you is prohibited. Where allowed > by local law, electronic communications with Accenture and its affiliates, > including e-mail and instant messaging (including content), may be scanned > by our systems for the purposes of information security and assessment of > internal compliance with Accenture policy. > ____________________________________________________________ > __________________________ > > www.accenture.com >
