Managing Table Columns via VAST Web UI
With VAST Web UI, you can add, modify and remove columns in VAST database tables.
From the left navigation menu, choose DataBase -> VAST DataBase.
In the VAST DataBase page, navigate to the table you want to modify by clicking the database, the schema and the table name in the database tree.
In the table page that opens, manage table columns as necessary:
To add one or more columns:
Click + Add Column.
In the Add Column popup that opens, specify a name for the column in the Name field and select a data type from the Column Type dropdown.
Column naming requirements are the same as for S3 object names.
Depending on the data type you selected, you may need to complete additional fields as follows:
For the Decimal 128 data type, specify the (the number of significant digits in a decimal) and the Scale (the number of digits after the decimal point).
For the Timestamp data type, specify the time Unit.
For the List data type, select a data type for the list items from the Item Type dropdown.
For the Map data type, select a data type for the key from the Key Type dropdown and for the value from the Value Type dropdown.
For the Struct data type, use the + Add Struct Column button to add as many nested columns as you need.
Note
For information about data types supported by VAST Database, see Supported Data Types.
If necessary, add more columns with the + Add Column button.
Click Create.
To rename a column, select it and click the Edit button in the Actions column. In the Column name field that appears above the list of columns, type a new name for the column and click Save.
To delete a column, select it and click the Delete button in the Actions column.
Managing Table Columns via VAST CLI
Use the following commands to manage columns in VAST database tables:
Action | Command |
|---|---|
List table columns | |
Add one or more columns | |
Rename a column | |
Delete a column | |
Show details for a column |