1
Create
GLOBAL
TEMPORARY
TABLE
<
table_name
>
(
2 < column_name > < column_datatype > ,
3 < column_name > < column_datatype > ,
4 … )
5 ON COMMIT [ PRESERVE|DELETE ] ROWS
6 [ NOT LOGGED|LOGGED ] ON ROLLBACK [ PRESERVE|DELETE ] ROWS
7 DISTRIBUTE BY HASH ( col1,..)
8 IN < tspace - name > ;
9
2 < column_name > < column_datatype > ,
3 < column_name > < column_datatype > ,
4 … )
5 ON COMMIT [ PRESERVE|DELETE ] ROWS
6 [ NOT LOGGED|LOGGED ] ON ROLLBACK [ PRESERVE|DELETE ] ROWS
7 DISTRIBUTE BY HASH ( col1,..)
8 IN < tspace - name > ;
9