HDI Plug-in Type for GLOBAL TEMPORARY TABLE

[former_member122654]

Hi,

My questions are:

Do GLOBAL TEMPORARY TABLE need a specific plug-in?

What is the syntax for creating a global temporary table at design-time?

Using the SQL console at runtime, it works without any problems:

CREATE GLOBAL TEMPORARY TABLE T (C1 INT, C2 INT) ON COMMIT PRESERVE ROWS;

My attempts to create it at design time have unfortunately failed.

I first assumed that the HDI plug-in for GLOBAL TEMPORARY TABLE is the same as creating a persistent DB table .hdbtable.

I tried the following:

/src/GTT.hdbtable


GLOBAL TEMPORARY ROW TABLE "GTT" ( "C1" INT, "C2" INT );

The error is:

Error: com.sap.hana.di.table: "GLOBAL TEMPORARY ROW": unsupported table type; only the "ROW" and "COLUMN" table types can be used [8250017]

Turther attempts did not work either.

Many Thanks,

Fouad

[thomas_jung · Accepted solution]

You use the extension/plugin hdbdropcreatetable:

Tables (.hdbtable and .hdbdropcreatetable) - SAP Help Portal

• You must specify the table type; permitted table types are ROW and COLUMN. The drop-create-table plug-ins also support global temporary tables with the types GLOBAL TEMPORARY ROW and GLOBAL TEMPORARY COLUMN.