Hi Arina, Thanks for your reply. I got that it can work like this also.
But how to use it with Java collection, Array List which has records ranging from 5000 - 100,000. For every different hit, I will be creating a different temporary table. Regards, Jasbir Singh -----Original Message----- From: Arina Yelchiyeva [mailto:[email protected]] Sent: Wednesday, April 05, 2017 11:42 PM To: user <[email protected]> Cc: [email protected] Subject: 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, <[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 > ________________________________ 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
