GET_PROJECTIONS
Returns information about projections that are anchored to the specified table, as follows:
Contextual information | Projection data |
---|---|
|
For each projection anchored to this table:
|
You can use GET_PROJECTIONS
to monitor the progress of a projection data refresh.
Syntax
GET_PROJECTIONS ( '[schema-name.]table' )
Parameters
schema |
Specifies a schema. If multiple schemas are defined in the database, include the schema name. For example: myschema.thisDbObject |
table |
The table whose projections you want to list. |
Privileges
None
Examples
The following example gets information about the store_dimensio
n table in the VMart schema:
=> SELECT GET_PROJECTIONS('store.store_dimension'); GET_PROJECTIONS ---------------------------------------------------------------------------------------------------- Current system K is 1. # of Nodes: 3. Table store.store_dimension has 3 projections. Projection Name: [Segmented] [Seg Cols] [# of Buddies] [Buddy Projections] [Safe] [UptoDate] [Stats] ---------------------------------------------------------------------------------------------------- store.store_dimension_unseg [Segmented: No] [Seg Cols: ] [K: 2] [store.store_dimension_unseg] [Safe: Yes] [UptoDate: Yes] [Stats: Yes] store.store_dimension_p_b1 [Segmented: Yes] [Seg Cols: "store.store_dimension.store_key"] [K: 1] [store.store_dimension_p_b0] [Safe: Yes] [UptoDate: Yes] [Stats: Yes] store.store_dimension_p_b0 [Segmented: Yes] [Seg Cols: "store.store_dimension.store_key"] [K: 1] [store.store_dimension_p_b1] [Safe: Yes] [UptoDate: Yes] [Stats: Yes] (1 row)