table create

This command creates a VAST database table.

Usage

table create --name TABLE
             --schema-name SCHEMA
             --arrow-schema COLUMNS
             --database-name DATABASE 
            [--tenant-id TENANT]   
            [--sorted-column-names SORT_COLUMNS]

Required Parameters

`--name TABLE`	Specifies the name for the table being created. The name must meet the requirements for S3 object names.
`--schema-name SCHEMA`	Speciies the name of the schema where the table is to be created.
`--arrow-schema COLUMNS`	Specifies the columns columns for the new table, as a comma-separated list. The columns are specified using the Arrow format, for example: `col1-int8,col2-string,col3-int8` Note Complex data types are not supported on this command. To add a column with a complex data type, use VAST Web UI.Managing Table Columns
`--database-name DATABASE`	Specifies the name of the database where the table's schema is created.

Options

--tenant-id TENANT

Specifies the ID of the tenant where the database resides

If omitted, the default tenant is assumed.

--sorted-column-names SORT_COLUMNS

Specifies a comma-separated list of up to four columns, that are used to sort the table. Sorting is done according to the order of the names as they appear in the list.

Example --sorted-column-names col1,col2, col3, col4

Example

This example shows adding a table named cats to schema schema1 in database vastdb:

vcli: admin> table create --name cats --schema-name schema1 --arrow-schema name-string,age-int8 --database_name vastdb