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, wrote:
> Hi,
>
> I want to
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?
Re