projectioncolumn list

This command lists the columns in a VAST Database table projection.

Usage

projectioncolumn list --database-name DATABASE
                      --schema-name SCHEMA
                      --table-name TABLE
                     [--name PROJECTION]
                     [--page PAGE]
                     [--page-size PAGE_SIZE]
                     [--name-startswith PREFIX]

Required Parameters

`--database-name DATABASE`	Specifies the name of the database containing the table.
`--schema-name SCHEMA`	Specifies the name of the schema containing the table.
`--table-name TABLE`	Specifies the name of the table containing the columns.

Options

`--page PAGE`	Specifies the specific page in the output list, by its number. This parameter is used only if `page-size` is set. Default is the first page.
`--page-size PAGE_SIZE`	Specifies the maximum number of columns to list per output page. Default: 100.
`--name COLUMN_NAME`	Specifies the name of a specific column.
`--name-startswith PREFIX`	Specifies a prefix to filter the column names.

Example

vcli: admin> projectioncolumn list --database-name tabular --schema-name vastagoda --table-name agoda --projection-name myProj2
+------------+---------------+-----------+---------------+-------------+------------+-----------------+
| Name       | Raw-field     | Is-sorted | Database-name | Schema-name | Table-name | Projection-name |
+------------+---------------+-----------+---------------+-------------+------------+-----------------+
| id         | string        | True      | tabular       | vastagoda   | agoda      | myProj2         |
| logtime    | timestamp[ns] | True      | tabular       | vastagoda   | agoda      | myProj2         |
| user_id    | string        | True      | tabular       | vastagoda   | agoda      | myProj2         |
| currency   | string        | True      | tabular       | vastagoda   | agoda      | myProj2         |
| session_id | string        | False     | tabular       | vastagoda   | agoda      | myProj2         |
| is_nha     | bool          | False     | tabular       | vastagoda   | agoda      | myProj2         |
| language   | string        | False     | tabular       | vastagoda   | agoda      | myProj2         |
| member_id  | int64         | False     | tabular       | vastagoda   | agoda      | myProj2         |
+------------+---------------+-----------+---------------+-------------+------------+-----------------+