Legacy Schema Inference
Warning
Legacy documentation: This documentation applies to Legacy Deephaven Enterprise only and does not apply to Core+.
Deephaven provides schema generation tools to facilitate schema creation. Schemas can only be inferred from Deephaven tables in Legacy. For other data sources, see the Core+ Schema Inference guide.
Tables
The SchemaService can infer a schema from the column names and types of a Deephaven table and deploy the schema to the system. The commands in this guide must be run in a Legacy Groovy console.
SchemaServiceFactory.getDefault() returns a SchemaService that supports write operations and System tables.
The namespace must be defined before deploying the schema using the SchemaService.
Note
This command will fail if the namespace is already defined as a user namespace. To change an existing namespace to a system namespace, you must delete all tables in the namespace and then delete the namespace itself. See the dhconfig documentation for instructions on deleting schemas.
Define a partitioning column, then create the schema from the table definition:
For information on TableDefinition.STORAGETYPE_NESTEDPARTITIONEDONDISK and the other storage types available, see Basic Table Attributes.
Finally, to deploy the schema: