projection list

This command shows the projections for a specific VAST Database table.

Usage

projection list --database-name DATABASE 
                --schema-name SCHEMA 
                --table-name TABLE 
               [--page PAGE]
               [--page-size PAGE_SIZE]
               [--name PROJECTION]
               [--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.

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 projections to list per output page. Default: 100.
`--name PROJECTION`	Specifies the name of a projection.
`--name-startswith PREFIX`	Specifies a prefix to filter the projection names.

Examples

vcli: admin> projection list --database-name tabular --schema-name vastagoda --table-name agoda
+-----------+---------------+-------------+------------+------------+------------+---------------+
| Name      | Database-name | Schema-name | Table-name | Properties | Num-rows   | Size          |
+-----------+---------------+-------------+------------+------------+------------+---------------+
| agodaproj | tabular       | vastagoda   | agoda      | None       | 9569577211 | 2077351076539 |
| myProj    | tabular       | vastagoda   | agoda      | None       | 9377687803 | 936625528087  |
| myProj2   | tabular       | vastagoda   | agoda      | None       | 9377687803 | 1364574579040 |
+-----------+---------------+-------------+------------+------------+------------+---------------+