table add-columns

Prev Next

This command creates a VAST database table.

Usage

table create --name TABLE
             --schema-name SCHEMA
             --arrow-schema COLUMNS
             --database-name DATABASE 

Required Parameters

--name TABLE

Enter the name of the table where you want to add more columns.

--schema-name SCHEMA

Enter the name of the schema where the table resides.

--arrow-schema COLUMNS

Enter a comma-separated list of columns to be added.

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.

--database-name DATABASE

Enter the name of the database where the table resides.

Example

This example shows adding a column named age to table cats:

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