We need to make the [Include Table Storage] option available for nCluster version 4.6 and greater in order to allow the user to script the storage & partition information.
Option added to version 15, 16, and trunk.
You can create this table with partition information and use it as a base to recreate the table and make sure partition information is created via the schema object generator tool:
CREATE FACT TABLE trans( id int, country varchar, ts timestamp )
DISTRIBUTE BY HASH(id)
PARTITION BY RANGE(ts) (
PARTITION oldrecords( END '2011-01-01' ), -- everything pre-2011
PARTITION jan01_2011( END '2011-01-02' ),
PARTITION jan02_2011( END '2011-01-03' ),
PARTITION jan03_2011( END '2011-01-04' ))
You can create this table with partition information and use it as a base to recreate the table and make sure partition information is created via the schema object generator tool:
CREATE FACT TABLE trans( id int, country varchar, ts timestamp )
DISTRIBUTE BY HASH(id)
PARTITION BY RANGE(ts) (
PARTITION oldrecords( END '2011-01-01' ), -- everything pre-2011
PARTITION jan01_2011( END '2011-01-02' ),
PARTITION jan02_2011( END '2011-01-03' ),
PARTITION jan03_2011( END '2011-01-04' ))
Issue #13193 |
Closed |
Fixed |
Resolved |
Completion |
No due date |
No fixed build |
No time estimate |
Option added to version 15, 16, and trunk.