Easily find issues by searching: #<Issue ID>
Example: #1832
Easily find members by searching in: <username>, <first name> and <last name>.
Example: Search smith, will return results smith and adamsmith
| Dev |
|
| QA |
|
| Priority | Low |
| Complexity | Unknown |
| Component | Tools - Schema Script Gen |
| Version | 15.0 |
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.