sqldremio

how to create a temp table in Dremio

I would like to create a temporary table as below in dremio

Select ABC into #temp_table

any advise?

Solution

  • I don't think DREMIO explicitly supports temporary tables. However, it does have the ability to create tables on the fly from the results of the query using create table as (CTAS):

    create table temp_table as
    select ABC;