//如下方式创建是非分片的临时表
CREATE TEMP TABLE temp_table (
column1 INTEGER,
column2 CHAR(10)
) WITH NO LOG;
//如果数据库有多个tmpdbs,则如下方式创建的临时表默认是分片在多个tmpdbs上的分片临时表:
SELECT * FROM table1 INTO TEMP temp_table WITH NO LOG;
也可以按照如下方式创建临时表:
CREATE TEMP TABLE temp_table ( column1 INTEGER, column2 CHAR(10))
WITH NO LOG FRAGMENT BY ROUND ROBIN IN tempdbs1, tempdbs2, tempdbs3;
CREATE TEMP TABLE temp_table ( column1 INTEGER, column2 CHAR(10))
WITH NO LOG FRAGMENT BY EXPRESSION
column1 < 1000 in tempdbs1,
column1 < 2000 in tempdbs2,
column1 >= 2000 in tempdbs3;