GET_PROJECTIONS
Returns contextual and projection information about projections of the specified anchor table.
Contextual information |
|
Projection data |
For each projection, specifies:
|
You can also use GET_PROJECTIONS
to monitor the progress of a projection data refresh.
Syntax
GET_PROJECTIONS ( '[[database.]schema-name.]table' )
Parameters
[database.]schema
|
Specifies a schema, by default myschema.thisDbObject If you specify a database, it must be the current database. |
table |
Anchor table of the projections to list. |
Privileges
None
Examples
The following example gets information about projections for VMart table store.store_dimension
:
=> SELECT GET_PROJECTIONS('store.store_dimension'); -[ RECORD 1 ]---+ GET_PROJECTIONS | Current system K is 1. # of Nodes: 3. Table store.store_dimension has 2 projections. Projection Name: [Segmented] [Seg Cols] [# of Buddies] [Buddy Projections] [Safe] [UptoDate] [Stats] ---------------------------------------------------------------------------------------------------- store.store_dimension_b1 [Segmented: Yes] [Seg Cols: "store.store_dimension.store_key"] [K: 1] [store.store_dimension_b0] [Safe: Yes] [UptoDate: Yes] [Stats: RowCounts] store.store_dimension_b0 [Segmented: Yes] [Seg Cols: "store.store_dimension.store_key"] [K: 1] [store.store_dimension_b1] [Safe: Yes] [UptoDate: Yes] [Stats: RowCounts]